Job Title: DB2 System Programmer / DB2 for z/OS Specialist
Location
Sheffield, UK
Work Model
Hybrid – 2 to 3 Days Work from Office Weekly
Contract Type
Inside IR35
Experience Required
Minimum 12+ Years
Job Overview
We are looking for an experienced DB2 System Programmer / DB2 for z/OS Specialist to join the DB2 Support Team supporting large-scale DB2 subsystems across multiple mainframe environments and geographies.
The ideal candidate will be responsible for ensuring the performance, integrity, security, maintenance, and availability of the DB2 database environment while providing L2/L3 production support for mission-critical applications.
Key Responsibilities
• Manage and support DB2 for z/OS environments across enterprise mainframe systems.
• Monitor database performance, tuning, integrity, availability, and security.
• Install, configure, test, and maintain supported DB2 versions and monitoring tools.
• Provide Level 2 and Level 3 support for DB2-based applications and environments.
• Support highly responsive OLTP (CICS) DB2 environments.
• Develop, manage, and test backup, recovery, disaster recovery, and archiving procedures.
• Perform capacity planning and ensure optimal database performance.
• Manage distributed DB2 connections and troubleshoot database-related issues.
• Work closely with application, technical, and operations teams to ensure database stability and security.
• Ensure compliance with data security and information governance standards including GDPR.
Required Skills & Experience
• Strong experience as a z/OS Systems Specialist with expertise in DB2 administration and support.
• Extensive hands-on experience in DB2 production support and maintenance.
• Strong DB2 performance tuning and troubleshooting experience.
• Experience supporting DB2 application environments.
• Knowledge of OLTP/CICS DB2 environments.
• Experience with DB2 backup, recovery, and disaster recovery procedures.
• Familiarity with database security, storage, and archiving processes.
• Understanding of database design principles and data manipulation languages.
• Exposure to REXX and/or COBOL programming is preferred.
• Knowledge of GDPR and data governance standards.
Soft Skills
• Excellent analytical and problem-solving skills
• Strong communication and stakeholder management skills
• Ability to work under pressure and meet tight deadlines
• Strong teamwork and collaboration abilities
• Flexible, adaptable, and proactive mindset
• Commitment to continuous learning and professional development
Mandatory Requirements
• Minimum 12 years of experience
• Strong DB2 for z/OS expertise
• Ability to work from Sheffield office 2–3 days per week
• Experience in enterprise/mainframe production support environments
Preferred Skills
• Experience with distributed DB2 connectivity
• Exposure to automation/scripting using REXX or COBOL
• Experience working in large enterprise banking or financial services environments