> Markdown version of [/jobs/ext/3065740-mainframe-db2-systems-programmer-db2-systems-administrator](https://www.wearedevelopers.com/jobs/ext/3065740-mainframe-db2-systems-programmer-db2-systems-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Mainframe DB2 Systems Programmer / DB2 Systems Administrator - **Company:** Coolsoft LLC - **Location:** United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Customer Information Control System (CICS), Data Sharing, IBM DB2, Disaster Recovery, Distributed Systems, Failover, IBM Parallel Sysplex, Job Control Language (JCL), Mainframes, Performance Tuning, SQL Databases, Subsystems, System Programming, Z/OS, Tso/ispf, System Availability, Software Troubleshooting - **Published:** September 25, 2026 - **Apply:** https://www.dice.com/job-detail/324cbd2b-571b-4a5d-b1c6-06ab0d52779d ## About the Role We are seeking an experienced Mainframe DB2 Systems Programmer / DB2 Systems Administrator to manage, support, and optimize IBM DB2 for z/OS subsystems within a mission-critical enterprise environment. The ideal candidate will have strong hands-on experience with DB2 systems programming, subsystem installation and configuration, performance tuning, Data Sharing/Sysplex, replication technologies, troubleshooting, and system maintenance. Candidates must be located in or around the Phoenix, AZ metro area and able to work onsite 3 days per week. Relocation candidates willing to move to the Phoenix area will also be considered., * 7 12+ years of overall Mainframe experience. * 3 5+ years of hands-on DB2 Systems Programming / DB2 Administration experience. * Strong experience with IBM DB2 for z/OS. * Hands-on experience with DB2 installation, configuration, upgrades, maintenance, and troubleshooting. * Strong knowledge of: + ZPARMs / DSNZPARM + Buffer pools + DB2 logs and BSDS + DB2 catalog and directory + DB2 subsystem configuration * Experience with DB2 Data Sharing / Sysplex environments. * Experience with DB2 replication products, preferably QRep, SQL Replication, and CDC. * Strong troubleshooting and performance-tuning capabilities. * Proficiency with: + JCL + TSO/ISPF + SDSF * Experience with SMP/E is preferred. * Strong understanding of mainframe system interactions with CICS, IMS, and MQ. ## Description DB2 Installation & Configuration * Install, configure, upgrade, and maintain IBM DB2 for z/OS subsystems. * Perform DB2 version upgrades, PTF/APAR implementation, patching, and system maintenance. * Configure and maintain DB2 subsystem parameters and initialization settings. * Manage and maintain: + ZPARMs / DSNZPARM + Buffer pools + DB2 logs and BSDS + DB2 catalog and directory * Support certification testing and document operational procedures. Performance & Capacity Management * Monitor and troubleshoot DB2 system-level performance involving CPU, memory, and I/O. * Tune and optimize: + Buffer pools + Locking and concurrency + Threads and connections + DB2 system resources * Perform performance analysis and capacity planning using DB2 and mainframe monitoring tools. * Support performance optimization initiatives across large-scale environments. DB2 Data Sharing & High Availability * Administer and support DB2 Data Sharing environments within z/OS Sysplex. * Work with Coupling Facility integration. * Support workload balancing, failover, and high-availability solutions. * Participate in disaster recovery planning and testing. * Support large-scale DB2 upgrades, migrations, and resiliency initiatives. Troubleshooting & System Support * Diagnose and resolve: + DB2 subsystem failures + Dumps, logs, and system abends + DB2 connectivity issues + Performance and availability problems * Perform root-cause analysis and implement preventive solutions. * Support integration with other mainframe subsystems, including: + CICS + IMS + MQ + Batch/JCL environments + Distributed systems DB2 Replication & Tools * Support IBM DB2 replication technologies, including: + Q Replication (QRep) + SQL Replication + CDC * Perform installation, upgrades, maintenance, testing, and DR activities for replication products. * Provide operational documentation and production support. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [System Resilience: Surviving the Software Storm](https://www.wearedevelopers.com/videos/874-system-resilience-surviving-the-software-storm) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Goodbye Microservices, Hello Self-Contained Systems](https://www.wearedevelopers.com/videos/100009-goodbye-microservices-hello-self-contained-systems) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [10 Highest Paying Programming Languages 2025](https://www.wearedevelopers.com/magazine/150-10-highest-paying-programming-languages-2025) - [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025) - [Software Developer Salary in Switzerland [2023]](https://www.wearedevelopers.com/magazine/215-software-developer-salary-in-switzerland-2023)