Mainframe DB2 Systems Programmer

Tasks

• Install, configure, maintain, and upgrade DB2 for z/OS subsystems.
• Perform PTF/APAR maintenance, version upgrades, and subsystem configuration.
• Manage ZPARMs (DSNZPARM), buffer pools, logs, BSDS, catalog, and directory.
• Monitor and optimize DB2 performance, CPU utilization, I/O, locking, and concurrency.
• Support DB2 Data Sharing environments, Sysplex, Coupling Facility integration, and failover.
• Troubleshoot subsystem failures, dumps, abends, and connectivity issues.
• Perform root cause analysis, disaster recovery testing, and preventive maintenance.
• Support DB2 replication technologies, including Q Replication, SQL Replication, and IBM CDC.
• Collaborate with Batch/JCL, CICS, IMS, MQ, and distributed systems teams.
• Maintain operational documentation and support certification testing.

Requirements

• 7–12+ Years
• 3–5+ Years in DB2 Systems Programming / Administration
• 7–12+ years of mainframe experience.
• 3–5+ years of DB2 Systems Programming / Administration experience.
• Strong hands-on experience with IBM DB2 for z/OS.
• Experience with Q Replication, SQL Replication, and Change Data Capture (CDC).
• Expertise in DB2 subsystem configuration, ZPARMs, buffer pools, logs, and BSDS.
• Proficiency in JCL, TSO/ISPF, and SDSF.
• Experience with software installation, upgrades, maintenance, and disaster recovery testing.
• Strong troubleshooting and system performance analy

Schedule

• Hybrid – Onsite 3 Days/Week

How to apply

• Please mention Visa status and location.

Location

• Phoenix, AZ