Mainframe DB2 Systems Programmer

xaxis solutionsScottsdale, AZ

4 days ago

Occupations

Database Administrators Network and Computer Systems Administrators Computer Systems Engineers/Architects

Industries

Computer Systems Design Services Custom Computer Programming Services Other Computer Related Services

APPLY NOW

About the role

Title: Mainframe DB2 Systems Programmer

Location: Phoenix, AZ; Plano, TX & Charlotte, NCExp – 10+ Mandate

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.* This role requires employees to live in or around the Phoenix, AZ area. You will be responsible to be onsite 3 days a week. We will consider candidates who are willing to relocate to the area.

Responsibilities:

DB2 Installation & Configuration
Install, configure, and maintain DB2 for z/OS subsystems
Perform version upgrades, patching (PTFs/APARs), and system maintenance
Manage subsystem configuration and initialization parameters
Maintain core DB2 components:
ZPARMs (DSNZPARM)
Buffer pools
Logs and BSDSCatalog and directory
Performance & Capacity Management
Monitor and tune DB2 system-level performance (CPU, memory, I/O)

Optimize: Buffer pools Locking and concurrency Thread and connection performance Support capacity planning and performance analysis using DB2 and system tools High Availability & Data Sharing Manage and support: DB2 Data Sharing environments (Sysplex) Coupling Facility integration Workload balancing and failover Ensure DB2 availability and resilience through DR strategies System Maintenance & Troubleshooting Analyze and resolve: Subsystem failures Dumps, logs, and abends Connectivity issues affecting DB2 operations Perform root cause analysis and implement preventive actions Support interaction with: Batch (JCL)CICSIMSMQ and distributed systems

Required Qualifications: 7–12+ years of mainframe experience3–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:

ZPARMs and subsystem configuration
Buffer pools, logs, BSDS, catalog/directory
Strong troubleshooting skills for:
System-level DB2 issues
Performance and connectivity problems
Proficiency in:
JCL, TSO/ISPF, SDSFSMP/E (preferred)

Preferred Qualifications: Familiarity with:

DB2 utilities and performance tools
Monitoring tools (OMEGAMON, MainView)
Knowledge of:
DevOps tools for mainframe (Endevor, ISPW, etc.)Exposure to:
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 REXXWorking knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, Splunk
Working knowledge of other Mainframe Subsystems (CICS, IMS, MQ)

Matching similar jobs

JOB OVERVIEW

Experience level

Senior

Location

Scottsdale, AZ

Occupation

Database Administrators

Industry

Computer Systems Design Services

Posted

4 days ago

Tired of running searches?

Rank the roles you'd take once, and matches like these arrive on their own.

CREATE PROFILE