Mainframe DB2 Systems Programmer-Hybrid

About the role

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.

Responsibilities

• Manage and support DB2 for z/OS subsystems
• Install, configure, and maintain DB2 for z/OS and Replication products (Qrep, SQLrep and CDC)
• Ensure high availability, security, and optimal performance of DB2 subsystems
• Troubleshoot system-level DB2 issues and performance/connectivity problems
• Perform buffer pool management, log administration, and catalog/directory operations
• Use JCL, TSO/ISPF, SDSF, and SMP/E (preferred)

Requirements

• 7+ years of mainframe experience
• 3+ years in DB2 Systems Programming/Administration
• Experience with IBM DB2 for z/OS and Replication products
• Deep knowledge of ZPARMs and subsystem configuration
• Buffer pools, logs, BSDS, catalog/directory
• Strong troubleshooting skills for system-level DB2 issues and performance/connectivity problems
• Proficiency in JCL, TSO/ISPF, SDSF, and SMP/E (preferred)
• Familiarity with DB2 utilities and performance tools
• Monitoring tools (OMEGAMON, MainView)
• Knowledge of DevOps tools for mainframe (Endevor, ISPW, etc.)
• Experience with cloud integration or hybrid architectures
• Experience with large-scale DB2 upgrades or migrations
• Performance optimization initiatives
• Knowledge of 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)

Qualifications

• 7+ years of mainframe experience
• 3+ years in DB2 Systems Programming/Administration
• Experience with IBM DB2 for z/OS and Replication products
• Deep knowledge of ZPARMs and subsystem configuration
• Buffer pools, logs, BSDS, catalog/directory
• Strong troubleshooting skills for system-level DB2 issues and performance/connectivity problems
• Proficiency in JCL, TSO/ISPF, SDSF, and SMP/E (preferred)
• Familiarity with DB2 utilities and performance tools
• Monitoring tools (OMEGAMON, MainView)
• Knowledge of DevOps tools for mainframe (Endevor, ISPW, etc.)
• Experience with cloud integration or hybrid architectures
• Experience with large-scale DB2 upgrades or migrations
• Performance optimization initiatives
• Knowledge of 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)