- Role: DB2 System Programmer
- Location: UK (Remote)
- Engagement Type: 1-Year Contract (Outside IR35)
Position Overview
We are seeking a DB2 System Programmer (Sysprog) to lead and support the migration from CA products to non-CA solutions, including IBM and other ISV software. The successful candidate will be responsible for installing, customizing, maintaining, and supporting IBM DB2 subsystems and related software products to ensure continuous 24/7 availability and optimal operational performance. Key duties include managing hardware configurations, implementing security patches, and tuning system performance within high-stakes, mission-critical environments.
Key Responsibilities
- System Administration & Operations: Install, configure, migrate, upgrade, and maintain Db2 for z/OS subsystems and data sharing groups. Oversee subsystem parameters (DSNZPARMs), buffer pools, active/archive logs, BSDS, and system databases. Manage DDF connectivity, security integration, TLS, and certificate requirements.
- Maintenance & Software Currency: Apply Db2 and associated product maintenance using SMP/E following strict change control procedures. Coordinate software upgrades, function-level activations, compatibility planning, and remediation of deprecated features.
- Performance Tuning & High Availability: Monitor subsystem health, thread activity, locking mechanisms, and resource usage. Engineer and support Db2 data sharing, group buffer pools, and Coupling Facility structures to maximize resilience.
- Incident & Change Management: Deliver L2/L3 production support, diagnose complex outages and performance degradation, perform root-cause analysis, and fulfill SLAs. Participate in CAB reviews and support change deployments.
- Disaster Recovery & Subsystem Integration: Plan and execute subsystem cloning, start/stop/recovery routines, and DR exercises to satisfy RTO/RPO requirements. Support integrations with CICS, IMS, DDF, batch processes, and distributed applications.
- Vendor & Stakeholder Collaboration: Work closely with software vendors and internal cross-functional teams (CICS, DB2, MQ, Storage) to resolve incidents, implement upgrades, and maintain updated technical baselines and runbooks.
Required Qualifications & Technical Skills
- Extensive experience with IBM Db2 for z/OS subsystem administration, data sharing, Coupling Facility, and group buffer pools.
- In-depth knowledge of DSNZPARMs, logs, BSDS, DDF, and attachment facilities.
- Strong z/OS systems programming foundation, including SMP/E, JCL, TSO/ISPF, SDSF, and REXX scripting.
- Proficiency in monitoring and diagnostic tools such as Db2 traces, IFCIDs, OMEGAMON, or BMC AMI.
- Solid understanding of security integrations, TLS, digital certificates, and audit controls.
- Proven capability in managing backup, restart, recovery, and disaster recovery procedures.
Randstad Technologies is acting as an Employment Business in relation to this vacancy.
...