Mainframe DB2 Systems Programmer
Overview:
In this role you will install, configure and maintain DB2 for z/OS, performing upgrades and routine maintenance. You will tune system performance, manage high availability, DR, and data sharing, and troubleshoot DB2-related issues. You will collaborate with Batch, CICS, IMS, MQ teams and drive modernization discussions across industries. You will grow through hands-on experience and certifications while shaping resilient mainframe environments.
Compensation / Benefitslearning and certification programsvolunteering and giving platformwell-being benefitscareer growth opportunitiesdiverse and inclusive environment
Responsibilities:
Install, configure and maintain DB2 for z/OS subsystemsPerform version upgrades and patchingManage subsystem configuration, initialization parameters and ZPARMsMaintain core DB2 components (buffers, logs, BSDS, catalog/directory) Monitor and tune system-level performance (CPU, memory, I/O) Capacity planning and performance analysis with DB2 and system toolsManage DB2 Data Sharing environments (Sysplex) and Coupling Facility integrationWorkload balancing and failover; implement DR strategiesAnalyze and resolve subsystem failures, dumps, logs and abendsTroubleshoot connectivity and operational issues; root cause analysisCollaborate with Batch (JCL), CICS, IMS, MQ and distributed systems
Key requirements7–12+ years of mainframe experience3–5+ years in DB2 systems programming/administrationExperience with IBM DB2 for z/OS and replication products (Qrep, SQLrep, CDC) Deep knowledge of ZPARMs, subsystem configuration, buffer pools, logs, BSDS, catalog/directoryStrong troubleshooting for DB2 system-level, performance and connectivity issuesProficiency in JCL, TSO/ISPF, SDSFSMP/E preferredcollaborationproblem-solvingcommunicationDB2 for z/OSReplication products: Qrep, SQLrep, CDCZPARMs and subsystem configuration