Senior Mainframe DB2 Systems Programmer (Hybrid)

PTR Global; Chandler (AZ); Hybrid; USD 90,000 - 96,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401K contributions

PTO

Job summary

PTR Global seeks a seasoned Mainframe DB2 System Programmer to install, configure, and support DB2 for z/OS subsystems in a mission-critical enterprise environment. The role emphasizes tuning, troubleshooting, and high-availability planning.

The candidate will manage DB2 data sharing, sysplex, buffer pools, logs, and DR strategies, while working with JCL/TSO/SDSF and related tools. Hybrid onsite schedule applies across multiple locations in the U.S.

Qualifications

• 7–12+ years of mainframe experience.
• 3–5+ years of DB2 systems programming or administration experience.
• Strong experience with DB2 for z/OS.
• Proficiency with DB2 replication products (QRep, SQLRep, or CDC).
• Knowledge of ZPARMs, buffer pools, logs, BSDS, catalog, and directory.
• Experience with DB2 Data Sharing, Sysplex, Coupling Facility, HA, and DR.
• Strong troubleshooting skills for DB2 subsystem and performance issues.
• Proficiency with JCL, TSO/ISPF, and SDSF.
• Preferred experience with SMP/E, DB2 utilities, and performance tools.
• Familiarity with OMEGAMON or MainView, Endevor or ISPW, and z/OS Connect.
• Experience with BMC DB2 tools, ADABAS, and Natural.
• Knowledge of REXX, SQL, JIRA, RACF, TCP/IP, network certificates, and Splunk.
• Working knowledge of CICS, IMS, and MQ.

Responsibilities

• Install, configure, and maintain DB2 for z/OS subsystems.
• Perform tuning and optimization of DB2 systems for high performance.
• Support DB2 replication products, including QRep, SQLRep, or CDC.
• Manage DB2 software installation, upgrades, maintenance, testing, and documentation.
• Configure and manage ZPARMs, buffer pools, logs, BSDS, catalog, and directory.
• Handle DB2 Data Sharing, Sysplex, Coupling Facility, High Availability (HA), and Disaster Recovery (DR).
• Troubleshoot DB2 subsystem, performance, and connectivity issues.
• Utilize JCL, TSO/ISPF, and SDSF for system operations.
• Work onsite three days per week as required.

Skills

Mainframe DB2

DB2 for z/OS

JCL/TSO/ISPF

SDSF

DB2 replication (QRep/SQLRep/CDC)

ZPARMs/buffer pools/BSDS

DB2 Data Sharing/Sysplex/HA/DR

Troubleshooting DB2 subsystems

SMP/E

OMEGAMON/MainView

Endevor/ISPW

RACF/TCP-IP/Splunk

CICS/IMS/MQ

Tools

SMP/E

Endevor/ISPW

OMEGAMON/MainView

DB2 utilities

SAS or SPLUNK

DB2 tools (BMC)

Job description

PTR Global seeks a seasoned Mainframe DB2 System Programmer to install, configure, and support DB2 for z/OS subsystems in a mission-critical enterprise environment. The role emphasizes tuning, troubleshooting, and high-availability planning.

The candidate will manage DB2 data sharing, sysplex, buffer pools, logs, and DR strategies, while working with JCL/TSO/SDSF and related tools. Hybrid onsite schedule applies across multiple locations in the U.S.