{"schemaVersion":"jobsearcher.job.v1","id":"779f2a5c2868a0d6d53291bc","url":"https://jobsearcher.com/jobs/779f2a5c2868a0d6d53291bc","canonicalUrl":"https://jobsearcher.com/jobs/779f2a5c2868a0d6d53291bc","title":"Mainframe DB2 Systems Programmer","description":"Mainframe DB2 Systems ProgrammerPhoenix, AZ (Hybrid)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 & ConfigurationInstall, configure, and maintain DB2 for z/OS subsystemsPerform version upgrades, patching (PTFs/APARs), and system maintenanceManage subsystem configuration and initialization parametersMaintain core DB2 components:ZPARMs (DSNZPARM)Buffer poolsLogs and BSDSCatalog and directoryPerformance & Capacity ManagementMonitor and tune DB2 system-level performance (CPU, memory, I/O)Optimize:Buffer poolsLocking and concurrencyThread and connection performanceSupport capacity planning and performance analysis using DB2 and system toolsHigh Availability & Data SharingManage and support:DB2 Data Sharing environments (Sysplex)Coupling Facility integrationWorkload balancing and failoverEnsure DB2 availability and resilience through DR strategiesSystem Maintenance & TroubleshootingAnalyze and resolve:Subsystem failuresDumps, logs, and abendsConnectivity issues affecting DB2 operationsPerform root cause analysis and implement preventive actionsSupport interaction with:Batch (JCL)CICSIMSMQ and distributed systemsRequired Qualifications:7–12+ years of mainframe experience3–5+ years in DB2 Systems Programming / AdministrationExperience 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 testingDeep knowledge of:ZPARMs and subsystem configurationBuffer pools, logs, BSDS, catalog/directoryStrong troubleshooting skills for:System-level DB2 issuesPerformance and connectivity problemsProficiency in:JCL, TSO/ISPF, SDSFSMP/E (preferred)Preferred Qualifications:Familiarity with:DB2 utilities and performance toolsMonitoring tools (OMEGAMON, MainView)Knowledge of:DevOps tools for mainframe (Endevor, ISPW, etc.)Exposure to:Cloud integration or hybrid architecturesExperience with:Large-scale DB2 upgrades or migrationsPerformance optimization initiativesKnowledge 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 productsProgramming experience with REXXWorking knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, SplunkWorking knowledge of other Mainframe Subsystems (CICS, IMS, MQ)","company":"Ipolarity","rawCompany":"ipolarity","city":"Phoenix","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-07-01T09:34:03.017Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1244.00","title":"Network and Computer Systems Administrators","slug":"network-and-computer-systems-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Mainframe DB2 Systems Programmer","description":"Mainframe DB2 Systems ProgrammerPhoenix, AZ (Hybrid)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 & ConfigurationInstall, configure, and maintain DB2 for z/OS subsystemsPerform version upgrades, patching (PTFs/APARs), and system maintenanceManage subsystem configuration and initialization parametersMaintain core DB2 components:ZPARMs (DSNZPARM)Buffer poolsLogs and BSDSCatalog and directoryPerformance & Capacity ManagementMonitor and tune DB2 system-level performance (CPU, memory, I/O)Optimize:Buffer poolsLocking and concurrencyThread and connection performanceSupport capacity planning and performance analysis using DB2 and system toolsHigh Availability & Data SharingManage and support:DB2 Data Sharing environments (Sysplex)Coupling Facility integrationWorkload balancing and failoverEnsure DB2 availability and resilience through DR strategiesSystem Maintenance & TroubleshootingAnalyze and resolve:Subsystem failuresDumps, logs, and abendsConnectivity issues affecting DB2 operationsPerform root cause analysis and implement preventive actionsSupport interaction with:Batch (JCL)CICSIMSMQ and distributed systemsRequired Qualifications:7–12+ years of mainframe experience3–5+ years in DB2 Systems Programming / AdministrationExperience 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 testingDeep knowledge of:ZPARMs and subsystem configurationBuffer pools, logs, BSDS, catalog/directoryStrong troubleshooting skills for:System-level DB2 issuesPerformance and connectivity problemsProficiency in:JCL, TSO/ISPF, SDSFSMP/E (preferred)Preferred Qualifications:Familiarity with:DB2 utilities and performance toolsMonitoring tools (OMEGAMON, MainView)Knowledge of:DevOps tools for mainframe (Endevor, ISPW, etc.)Exposure to:Cloud integration or hybrid architecturesExperience with:Large-scale DB2 upgrades or migrationsPerformance optimization initiativesKnowledge 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 productsProgramming experience with REXXWorking knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, SplunkWorking knowledge of other Mainframe Subsystems (CICS, IMS, MQ)","datePosted":"2026-07-01T09:34:03.017Z","dateModified":"2026-07-01T09:34:03.017Z","hiringOrganization":{"@type":"Organization","name":"Ipolarity","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Phoenix","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"779f2a5c2868a0d6d53291bc"},"url":"https://jobsearcher.com/jobs/779f2a5c2868a0d6d53291bc"}}