DB2 for z/OS Systems Programmer

We are seeking an experienced DB2 for z/OS Systems Programmer to join our DB2 Support Team and provide technical leadership and operational support for a large and complex DB2 for z/OS environment.

The successful candidate will be responsible for all systems programming aspects of DB2 for z/OS, supporting a large database estate comprising 50+ DB2 subsystems across multiple mainframe platforms and geographies. This role is critical to ensuring the availability, performance, integrity, maintenance, and security of the organization's DB2 infrastructure.

You will work closely with application development, infrastructure, operations, and security teams to maintain highly available and secure DB2 environments while supporting strategic database initiatives, performance optimization, disaster recovery planning, and technology upgrades.

The ideal candidate will possess strong technical expertise, excellent troubleshooting capabilities, and the ability to operate independently within a complex enterprise environment.

In this role, You will

• Install, configure, upgrade, and maintain DB2 for z/OS environments.
• Support a large-scale enterprise DB2 infrastructure comprising multiple DB2 subsystems.
• Plan and execute DB2 version upgrades, migrations, and maintenance implementations.
• Provide Level 2 and Level 3 technical support for applications utilizing DB2.
• Ensure the stability, integrity, availability, and performance of DB2 databases and supporting infrastructure.
• Support and manage Distributed Data Facility (DDF) and distributed DB2 connectivity.
• Maintain and optimize highly responsive OLTP environments utilizing CICS and DB2.
• Monitor database performance and implement tuning recommendations to improve efficiency and throughput.
• Perform system capacity planning and growth forecasting.
• Develop, test, and maintain backup, recovery, and disaster recovery procedures.
• Ensure proper storage management, archiving, and retention processes are in place.
• Implement and manage database security controls and access governance.
• Troubleshoot and resolve complex database and infrastructure issues.
• Collaborate with application teams to support database design, deployment, and problem resolution.
• Ensure compliance with enterprise security, audit, and regulatory requirements.
• Maintain technical documentation, operational standards, and support procedures.
• Ensure all database and monitoring solutions are maintained on supported versions.

Required Qualifications

• Typically 8 to 15+ years of experience in IBM Mainframe Systems Programming with a strong focus on DB2 for z/OS administration and support.
• Proven experience supporting large-scale enterprise DB2 environments with multiple DB2 subsystems.
• Strong experience in DB2 installation, migration, maintenance, performance tuning, and troubleshooting.
• Experience working in Banking, Financial Services, Insurance, or other mission-critical enterprise environments preferred.
• Hands-on experience supporting high-volume OLTP environments utilizing CICS and DB2.

• Strong experience with:
  • DB2 for z/OS (must have)
  • z/OS Operating System
  • SMP/E
  • JCL
  • TSO/ISPF
  • SDSF
  • RACF
• Experience installing, upgrading, testing, and supporting DB2 releases.
• Experience providing Level 2 and Level 3 support for DB2-based applications.
• Strong understanding of Distributed DB2 Connectivity (DDF).
• Experience supporting high-volume OLTP environments utilizing CICS and DB2.
• Expertise in:
  • DB2 Performance Monitoring and Tuning
  • Capacity Planning
  • Backup and Recovery
  • Disaster Recovery
  • Database Security Administration
• Strong analytical and troubleshooting skills.
• Excellent written and verbal communication skills.
• Ability to work independently and manage multiple priorities within a production environment.

Desired Qualifications

• Experience working in large-scale enterprise environments with 50+ DB2 subsystems.
• Exposure to Mainframe Sysplex and Data Sharing environments.
• Experience with:
  • OMEGAMON for DB2
  • DB2 Data Sharing
  • IBM Utilities for DB2
  • DB2 Performance Expert
  • DB2 Administration Tool
• Knowledge of:
  • ACF2 Security
  • RACF Security Administration
  • CICS Integration with DB2
  • Automation and Monitoring Tools
• Experience supporting Banking and Financial Services organizations.
• Familiarity with regulatory, audit, and compliance requirements.
• Knowledge of disaster recovery solutions and resilience architectures.
• IBM DB2 for z/OS certifications preferred.

Job Expectations

• Ensure high availability, reliability, and performance of DB2 for z/OS environments.
• Maintain and support a complex enterprise database estate across multiple regions and platforms.
• Participate in software maintenance, upgrades, migrations, and implementation activities.
• Provide on-call and after-hours support for critical incidents and planned maintenance activities.
• Lead technical troubleshooting and root cause analysis for major incidents.
• Drive continuous improvement initiatives focused on automation, performance optimization, and operational excellence.
• Ensure compliance with security, governance, and audit standards.
• Collaborate effectively with infrastructure, development, security, and operational teams.
• Maintain comprehensive system documentation and operational procedures.
• Demonstrate ownership, accountability, and proactive support of critical business services.

Primary Skillset

• DB2 for z/OS Systems Programming
• DB2 Installation, Configuration & Upgrades
• DB2 Performance Monitoring & Tuning
• Distributed DB2 Connectivity (DDF)
• DB2 Data Sharing
• Backup & Recovery
• Disaster Recovery
• Capacity Planning
• SMP/E
• z/OS
• JCL
• TSO/ISPF
• RACF
• CICS-DB2 Integration
• OMEGAMON for DB2