DB2 System Programmer

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

Position: Mainframe DB2 System Programmer

Open for W2 and C2C arrangements (W2 Folks Preferred first)

Location: Chandler, AZ; Plano, TX; Charlotte, NC; and Jersey City, NJ from Day 1 (Client prefer only local folks)

Hybrid Schedule: 3 Onsite Days & 2 Remote Days

Duration: 6+ months, extendable

Direct client opportunity

No mid layer / No Implementation partners are Involved

Mode of Interview: 2 Rounds mostly in person

Job ID: 179801

Job Overview

We are seeking a highly skilled Mainframe DB2 Systems Programmer to join our team. The ideal candidate will be responsible for installing, configuring, maintaining, tuning, and supporting DB2 for z/OS subsystems in a mission-critical enterprise environment. This role requires a strong background in mainframe systems and DB2 administration, along with excellent troubleshooting and performance optimization skills.

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.

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.

About PTR Global

PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $65/hr - $70/hr

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full‑time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at [phone]. To report any concerns, please email us at [e-mail]