Mainframe DB2 Systems Programmer
*URGENT HIRING – Mainframe DB2 Systems Programmer*
*Location:* Phoenix, AZ / Plano, TX / Charlotte, NC
*Work Model:* Hybrid – 3 Days/Week Onsite
*Experience:* 10+ Years
*Work Authorization:* Any Visa
Top Skills
* *IBM DB2 for z/OS – Systems Programming & Administration*
* *DB2 Installation, Configuration, Upgrades & PTF/APAR Maintenance*
* *DB2 Performance Tuning & Capacity Management*
* ZPARMs / DSNZPARM
* Buffer Pools, Logs, BSDS, Catalog & Directory
* DB2 Data Sharing / Sysplex & Coupling Facility
* Q Replication / SQL Replication / CDC
* JCL, TSO/ISPF & SDSF
* SMP/E
Responsibilities
* Install, configure, maintain, and support *DB2 for z/OS* subsystems in mission-critical environments.
* Perform DB2 version upgrades, PTF/APAR maintenance, certification testing, and system maintenance.
* Manage subsystem configuration including *ZPARMs, buffer pools, logs, BSDS, catalog, and directory*.
* Monitor and tune DB2 system-level performance across CPU, memory, I/O, locking, concurrency, threads, and connections.
* Support capacity planning, performance analysis, and optimization initiatives.
* Manage DB2 Data Sharing environments, Sysplex, Coupling Facility integration, workload balancing, and failover.
* Support disaster recovery strategies and high-availability requirements.
* Troubleshoot subsystem failures, dumps, logs, abends, and DB2 connectivity issues.
* Perform root cause analysis and implement preventive actions.
* Support integration with *JCL/Batch, CICS, IMS, MQ, and distributed systems*.
* Support installation, upgrades, maintenance, documentation, and DR testing for DB2 replication products.
Preferred Experience
* OMEGAMON / MainView & DB2 performance tools
* BMC DB2 Tools
* IBM z/OS Connect
* ADABAS / Natural
* REXX Programming
* RACF, TCP/IP, Network Certificates & Splunk
* Endevor / ISPW & Mainframe DevOps
* SMP/E
* z/OS Connect, APIs & Hybrid Cloud Integration
* Large-scale DB2 upgrades / migrations
* Mainframe modernization initiatives
* Experience with CICS, IMS & MQ subsystems
Pay: $45.00 - $48.00 per hour
Expected hours: 40.0 per week
Work Location: Hybrid remote in Phoenix, AZ 85074