Mainframe DB2 Systems Programmer

Experience with IBM DB2 for z/OS and Replication products (Qrep, SQLrep and CDC) - software installation, version upgrades and maintenance, certification testing, documentation of operational procedures, disaster recovery testing. This role is responsible for installation, configuration, performance tuning, and overall health of DB2 subsystems, ensuring high availability, security, and optimal performance.

Mainframe DB2 Systems Programmer

Onsite in Phoenix, AZ(Primary), Plano, TX, Charlotte, NC, Richmond, VA, Jacksonville, FL, Pennington, NJ, Chicago, IL

12+ month

Video Interview

Open for W2 only

We are seeking a highly skilled Mainframe DB2 Systems Administrator to manage and support DB2 for z/OS subsystems in a mission-critical enterprise environment.

This role is responsible for installation, configuration, performance tuning, and overall health of DB2 subsystems, ensuring high availability, security, and optimal performance.

Required Qualifications:

7 10+ years of mainframe experience

3 5+ years in DB2 Systems Programming / Administration

Experience with IBM DB2 for z/OS and Replication products (Qrep, SQLrep and CDC) - software installation, version upgrades and maintenance, certification testing, documentation of operational procedures, disaster recovery testing

Deep knowledge of:

o ZPARMs and subsystem configuration

o Buffer pools, logs, BSDS, catalog/directory

Strong troubleshooting skills for:

o System-level DB2 issues

o Performance and connectivity problems

Proficiency in:

o JCL, TSO/ISPF, SDSF

o SMP/E (preferred)

Preferred Qualifications:

Familiarity with:

o DB2 utilities and performance tools

o Monitoring tools (OMEGAMON, MainView)

Knowledge of:

o DevOps tools for mainframe (Endevor, ISPW, etc.)

Exposure to:

o Cloud integration or hybrid architectures

Experience with:

o Large-scale DB2 upgrades or migrations

o Performance optimization initiatives

o Modernization tools (z/OS Connect, APIs)

Experience with software support for BMC for DB2 Tools, IBM z/OS Connect, Software AG ADABAS and Natural products

Programming experience with REXX

Working knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, Splunk

Working knowledge of other Mainframe Subsystems (CICS, IMS, MQ)