Overview
We are seeking an experienced DB2 z/OS Systems Programmer with a strong blend of database administration and systems programming expertise to support a critical mainframe project. The contractor will provide hands-on technical support across DB2 environments, work closely with client stakeholders and technical teams, and address complex issues in a live production environment. This role demands a solid understanding of DB2 from both an administrative and system-level perspective, particularly in high-pressure situations involving critical incidents.
Responsibilities
- Provide hands-on DB2 for z/OS database administration and technical support.
- Investigate, troubleshoot and resolve complex DB2 production issues.
- Support the investigation and resolution of major incidents, including P1 incidents.
- Analyse DB2-related problems, identify root causes and implement appropriate resolutions.
- Support DB2 subsystem operations, configuration and performance troubleshooting.
- Access and analyse customer data held within DB2 tables to support incident investigations and technical queries.
- Work across database-level and system-level DB2 issues, leveraging both DBA and systems programming experience.
- Collaborate with mainframe teams and client stakeholders to resolve technical issues and maintain service delivery.
Requirements
- Strong hands-on experience with DB2 for z/OS.
- Solid background in DB2 database administration.
- Experience supporting live production mainframe environments.
- Proven experience investigating and resolving major production incidents, particularly P1 incidents.
- Good understanding of DB2 subsystem architecture, configuration and operation.
- Experience troubleshooting DB2 at database and system level.
- Strong knowledge of SQL, DB2 structures and mainframe utilities.
- Ability to analyse complex technical issues and identify root causes.
- Must be eligible to obtain UK SC security clearance.