DB2 System DBA – Mainframe

About the Role

We are seeking an experienced Mainframe Db2 System DBA / Systems Programmer to support our large-scale, 24x7 production environment. You will install, upgrade, migrate, and tune Db2 for z/OS (v12 and v13), manage the Db2 tooling stack, and play a key role in migrating third-party Db2 tools to their IBM equivalents.

Key Responsibilities

System DBA

• Install, upgrade, migrate, consolidate, and configure Db2 systems, services, settings, and storage in line with standards and project or operational requirements.
• Maintain installation and configuration procedures.
• Lead the migration of CA Db2 tools to IBM Db2 tools: Log Analysis, Db2 Administration Tool, Db2 Query Monitor, OMEGAMON for Db2, High Performance Unload, and Sort products (Db2 Sort / Syncsort).
• Convert CA Log Analyzer report jobs to IBM Db2 Log Analysis Tool report jobs.
• Support incident management: respond to alerts, perform root cause analysis, repair and recover from hardware or software failures, and take part in the 24x7x365 on-call rota.
• Coordinate and communicate with application support and the Technical Operations Centre during incidents.

Maintenance

• Apply database patches and upgrades regularly and upgrade database administration tools and utilities.
• Configure and add services as needed to maintain control, security, and stability.
• Assist in the deployment, roll-out, and maintenance of applications per project or operational needs.
• Perform ongoing performance tuning and resource optimization.
• Configure database memory, disk, and I/O as required.

Mandatory Skills

• Strong knowledge of Mainframe Db2 v12 and v13 system programming and administration
• z/OS, SMP/E, SMS
• Db2 tooling: Db2 Administration Tool, Db2 Log Analysis Tool, OMEGAMON for Db2 Performance Expert, Db2 High Performance Unload, Db2 Query Monitor, Db2 Sort, Syncsort, DB2 Connect
• Experience migrating CA Db2 tools to IBM Db2 tools, including converting CA Log Analyzer report jobs
• 24x7 support experience in a large production environment
• Experience working in an SLA-driven environment
• Excellent verbal and written communication and good interpersonal skills
• Ability to work in a flexible, team-oriented, and constantly changing environment

Good-to-Have Skills

• Working knowledge of IT processes: Change & Configuration, Problem, Incident, and Service Readiness management, plus other established team procedures
• ITIL V3 certification