Mainframe DB2 Systems Programmer — Hybrid(3 onsite/2remote)

PINNACLE GROUP (Pinnacle Technical Resources); Chandler (AZ); Hybrid; USD 135,000 - 146,000; Full time

Benefits offered by this job

Medical insurance

401K contributions

PTO & sick leave

Job summary

PTR Global is seeking a skilled Mainframe DB2 System Programmer to install, configure, and optimize DB2 for z/OS in a mission-critical environment. The role requires strong DB2 administration and mainframe troubleshooting expertise.

Responsibilities include managing ZPARMs, buffer pools, logs, and catalog, with focus on performance tuning and DR readiness. Hybrid onsite schedule and client-facing delivery are expected.

Qualifications

• 7–12+ years of mainframe experience.
• 3–5+ years of DB2 systems programming/administration.
• 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.
• DB2 Data Sharing, Sysplex, Coupling Facility, HA and DR experience.
• JCL, TSO/ISPF, and SDSF proficiency.
• Preferred SMP/E, DB2 utilities and performance tools.

Responsibilities

• Install, configure, and maintain DB2 for z/OS subsystems.
• Perform tuning and optimization of DB2 systems for high performance.
• Support DB2 replication products (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, HA, and 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

DB2 for z/OS

Mainframe systems

JCL / TSO/ISPF

SDSF

DB2 replication (QRep/SQLRep/CDC)

DASD / BSDS / ZPARMs

Sysplex / Data Sharing

CICS / MQ / IMS

Rexx / SQL

JIRA / RACF / TCP/IP

Tools

DB2 for z/OS

QRep

SQLRep

CDC

SMP/E

Endevor/ISPW

z/OS Connect

OMEGAMON / MainView

BMC DB2 tools

ADABAS / Natural

Job description

PTR Global is seeking a skilled Mainframe DB2 System Programmer to install, configure, and optimize DB2 for z/OS in a mission-critical environment. The role requires strong DB2 administration and mainframe troubleshooting expertise.

Responsibilities include managing ZPARMs, buffer pools, logs, and catalog, with focus on performance tuning and DR readiness. Hybrid onsite schedule and client-facing delivery are expected.