DB2 Programmer

We are seeking an experienced DB2 Systems Programmer to support and maintain enterprise-scale DB2 for z/OS environments within a highly available, mission-critical mainframe infrastructure. This role will focus on DB2 subsystem administration, performance tuning, upgrades, troubleshooting, disaster recovery support, and ensuring the overall stability and availability of the DB2 environment.

This is a long-term hybrid opportunity requiring onsite presence three days per week in Phoenix, AZ. Candidates currently located in the area or willing to relocate are encouraged to apply.

Key ResponsibilitiesDB2 Installation, Configuration & Administration

• Install, configure, maintain, and support IBM DB2 for z/OS subsystems
• Perform DB2 version upgrades, software maintenance, PTF implementations, and system enhancements
• Manage subsystem configurations and initialization parameters
• Administer and maintain:
• ZPARMs (DSNZPARM)
• Buffer Pools
• Logs and BSDS
• DB2 Catalog and Directory

Performance Monitoring & Optimization

• Monitor and tune DB2 subsystem performance across CPU, memory, and I/O resources
• Optimize:
• Buffer pool utilization
• Locking and concurrency controls
• Thread and connection performance
• Conduct capacity planning and performance analysis
• Support enterprise performance improvement initiatives

High Availability & Disaster Recovery

• Support DB2 Data Sharing environments within Sysplex architectures
• Manage Coupling Facility integration and workload balancing
• Implement and support failover and resiliency strategies
• Participate in disaster recovery planning, testing, and execution

Troubleshooting & Production Support

• Diagnose and resolve:
• DB2 subsystem failures
• Connectivity issues
• Dumps, logs, and abends
• Performance bottlenecks
• Perform root cause analysis and implement preventative solutions
• Support integration and troubleshooting across:
• JCL and batch processing
• CICS
• IMS
• MQ
• Distributed systems

Replication & Systems Support

• Support DB2 replication technologies including:
• Q Replication
• SQL Replication
• CDC (Change Data Capture)
• Perform software installation, maintenance, certification testing, and documentation
• Participate in disaster recovery validation and operational readiness activities

• 7+ years of overall Mainframe Systems experience
• 3+ years of DB2 Systems Programming or DB2 Systems Administration experience
• Strong experience supporting IBM DB2 for z/OS environments
• Experience with DB2 replication technologies including Q Replication, SQL Replication, and CDC
• Deep understanding of:
• ZPARMs and subsystem configuration
• Buffer Pools
• Logs and BSDS
• Catalog and Directory structures
• Strong troubleshooting skills related to:
• DB2 performance issues
• Connectivity problems
• System-level DB2 administration
• Experience with:
• JCL
• TSO/ISPF
• SDSF
• Ability to support production and mission-critical environments

Preferred Qualifications

• Experience with SMP/E
• Knowledge of DB2 utilities and performance tuning tools
• Experience with monitoring tools such as OMEGAMON or MainView
• Familiarity with mainframe DevOps tools including Endevor and ISPW
• Experience supporting large-scale DB2 upgrades, migrations, or modernization initiatives
• Knowledge of z/OS Connect, APIs, and hybrid integration architectures
• Experience supporting:
• BMC DB2 Tools
• IBM z/OS Connect
• Software AG ADABAS
• Natural
• Programming experience with REXX
• Working knowledge of:
• SQL
• JIRA
• RACF
• TCP/IP
• Network certificates
• Splunk
• Exposure to other mainframe subsystems including CICS, IMS, and MQ