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: $40.00 - $45.00 per hour
Work Location: Hybrid remote in Phoenix, AZ 85074