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