Haystack
← Back to Jobs
Technology
TE

Mainframe DB2 Systems Programmer

TechVirtue LLCJersey City, NJ🇺🇸United StatesPosted 6 Sept 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Jersey City, NJ, United States
Posted
2 days ago
SQLSplunkTCP/IPCapacity PlanningJiraPhoenixRoot Cause Analysis

Job Description

Job Title: Mainframe DB2 Systems Programmer
Location: Phoenix , AZ
Duration: Long Term Contract
 
Job Description:
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:
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 BSDS, Catalog 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: B2 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), CICS,IMS, MQ and distributed systems.
 
Required Qualifications:
  • 7–12+ years of mainframe experience.
  • 3–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, SDSF, SMP/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 REXX.
  • Working knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, Splunk.
  • Working knowledge of other Mainframe Subsystems (CICS, IMS, MQ).

 

Similar jobs

Browse related jobs

Apply now