DB2 System Programmer (Sysprog)
Location: Remote
Contract Duration: 3 months initial (very likely to extend)
Working Pattern: Remote
Outside IR35.
Role Overview
A DB2 System Programmer (Sysprog) who needs to support in migration from CA products to Non CA like IBM or other ISV products and needs to be responsible for installing, customizing, maintaining, and supporting the IBM DB2, subsystems, and associated software products to ensure 24/7 availability and optimal performance. They manage hardware configurations, apply security patches, and tune system performance, often managing 24/7 operations in high-stakes sectors.
System Administration & Operations
Install, configure, migrate, upgrade and maintain Db2 for z/OS subsystems and data sharing groups.
Apply Db2 and related product maintenance using SMP/E and controlled change procedures.
Manage subsystem parameters, DSNZPARMs, buffer pools, logs, BSDS, active and archive log configurations and system databases.
Engineer and support Db2 data sharing, group buffer pools, Coupling Facility structures and resilience configurations.
Monitor subsystem health, thread activity, locking, logging, buffer pool efficiency and system resource consumption.
Diagnose subsystem outages, abends, log issues, attachment failures and performance degradation using traces, dumps and monitoring data.
Support connections from CICS, IMS, DDF, batch and distributed applications.
Plan and execute start, stop, restart, recovery, subsystem cloning and disaster recovery activities.
Manage DDF configuration, connectivity, security integration, TLS and certificate requirements.
Support utilities, stored procedures, system-level objects and vendor tools used by DBA and application teams.
Coordinate version upgrades, function-level activation, compatibility planning and deprecated feature remediation.
Maintain build documents, subsystem standards, recovery procedures and configuration baselines.
Provide technical leadership during critical incidents and participate in on-call support.
Installation & Configuration & Upgrade Management
Install and maintain system software using SMP/E all Products.
Configuration of the Products
Apply patches, upgrades, and ensure software currency
Incident & Change Management
Provide L2/L3 production support and resolve incidents within SLA
Perform root cause analysis and implement preventive actions
Participate in CAB and support change deployments
Disaster Recovery & Resilience
Support DR drills, system recovery, and failover activities
Ensure systems meet RTO/RPO objectives
Vendor & Stakeholder Coordination
Work with vendors for issue resolution, upgrades, and support
Coordinate with cross-functional teams (CICS, DB2, MQ, Storage)
Required Skills & Qualifications
IBM Db2 for z/OS subsystem administration
Data sharing, Coupling Facility and group buffer pools
DSNZPARMs, logs, BSDS, DDF and attachment facilities
SMP/E and z/OS systems programming fundamentals
Db2 traces, IFCIDs, OMEGAMON or BMC AMI monitoring
Security integration, TLS, certificates and audit controls
Backup, restart, recovery and disaster recovery concepts
JCL, TSO/ISPF, SDSF and REXX