Back to search

DB2 System DBA – Mainframe

The role involves Mainframe Db2 System DBA and Systems Programming duties for a 24x7 production environment, focusing on installation, upgrade, migration, and tuning of Db2 for z/OS.

  • Full-time
  • Posted Nov 7, 2026
INDUSTRYSoftware & InternetIT Support & Networking

Responsibilities

  • Install, upgrade, migrate, consolidate, and configure Db2 systems, services, settings, and storage
  • Maintain installation and configuration procedures
  • Lead the migration of CA Db2 tools to IBM Db2 tools
  • Convert-t CA Log Analyzer report jobs to IBM Db2 Log Analysis Tool report jobs
  • Support incident management, respond to alerts, perform root cause analysis, and participate in 24x7x365 on-call rota
  • Coordinate with application support and the Technical Operations Centre
  • Apply database patches and upgrades and upgrade database administration tools and utilities
  • Configure and add services to maintain control, security, and stability
  • Assist in deployment, roll-out, and maintenance of applications
  • Perform ongoing performance tuning and resource optimization
  • Configure database memory, disk, and I/O

Requirements

Nice to have: Change & Configuration, Problem management, Incident management, Service Readiness management, ITIL V3 certification

Skills

Mainframe Db2 v12 and v13 system programming and administrationz/OSSMP/ESMSDb2 Administration ToolDb2 Log Analysis ToolOMEGAMON for Db2 Performance ExpertDb2 High Performance UnloadDb2 Query MonitorDb2 SortSyncsortDB2 ConnectMigrating CA Db2 tools to IBM Db2 tools24x7 support experienceSLA-driven environment experience

Full description

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

DB2 System DBA – Mainframe at Cognizant | Referso Jobs