Mainframe DB2 Systems Programmer
Role: Mainframe DB2 Systems Programmer
Location: Chandler, AZ or Plano, TX or New York, NY or Charlotte, NC (Hybrid Position)
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
- Performance & Capacity Management
- High Availability & Data Sharing
- System Maintenance & Troubleshooting
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 and Performance and connectivity problems
- Proficiency in: JCL, TSO/ISPF, SDSF, SMP/E (preferred)
Preferred Qualifications:
- Familiarity with: DB2 utilities and performance tools and 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 and 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)