Mainframe DB2 Systems Programmer

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)