At a Glance
- Tasks: Manage and support DB2 for z/OS environments, ensuring performance and security.
- Company: Leading enterprise in financial services with a focus on innovation.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Collaborative environment with a commitment to continuous learning.
- Why this job: Join a dynamic team and make an impact in mission-critical applications.
- Qualifications: 12+ years of DB2 experience and strong problem-solving skills.
The predicted salary is between 60000 - 80000 £ per year.
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.
System Programmer in Sheffield employer: Pyramid Consulting, Inc
Join a leading organisation in Sheffield that values innovation and excellence, offering a dynamic work culture where collaboration and continuous learning are at the forefront. As a DB2 System Programmer, you will benefit from a hybrid work model, competitive remuneration, and opportunities for professional growth within a supportive team environment dedicated to maintaining high standards of database performance and security. With a commitment to employee development and a focus on work-life balance, this company stands out as an exceptional employer in the tech industry.
StudySmarter Expert Advice🤫
We think this is how you could land System Programmer in Sheffield
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even local tech events. The more people you know, the better your chances of landing that DB2 System Programmer gig.
✨Show Off Your Skills
Don’t just talk about your experience; demonstrate it! Create a portfolio or a personal project showcasing your DB2 expertise. This can really set you apart when you're chatting with potential employers.
✨Ace the Interview
Prepare for those tricky interview questions by practising your responses. Focus on your problem-solving skills and how you've tackled challenges in past roles. Remember, confidence is key!
✨Apply Through Us!
We’ve got your back! Check out our website for the latest job openings and apply directly. It’s a great way to get noticed and show your enthusiasm for joining the team.
We think you need these skills to ace System Programmer in Sheffield
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the DB2 System Programmer role. Highlight your 12+ years of experience and any specific skills related to DB2 for z/OS, performance tuning, and production support. We want to see how your background fits with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your experience aligns with our needs. Be sure to mention your familiarity with OLTP/CICS environments and any relevant projects you've worked on.
Showcase Your Problem-Solving Skills:In your application, don’t forget to highlight your analytical and problem-solving skills. Give examples of how you've tackled challenges in past roles, especially in DB2 environments. We love seeing candidates who can think on their feet!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts and submit your materials!
How to prepare for a job interview at Pyramid Consulting, Inc
✨Know Your DB2 Inside Out
Make sure you brush up on your DB2 for z/OS knowledge. Be ready to discuss your hands-on experience with performance tuning, troubleshooting, and maintenance. Prepare specific examples of how you've managed DB2 environments in the past.
✨Showcase Your Problem-Solving Skills
Since this role requires excellent analytical skills, think of a few challenging situations you've faced in previous jobs. Be prepared to explain how you approached these problems and what solutions you implemented, especially in high-pressure scenarios.
✨Communicate Clearly and Confidently
Strong communication is key! Practice explaining complex technical concepts in simple terms. This will help you connect with interviewers who may not have a deep technical background but need to understand your expertise.
✨Demonstrate Your Team Spirit
This role involves collaboration with various teams, so be ready to share examples of how you've worked effectively in a team setting. Highlight your flexibility and adaptability, as well as any experiences where you contributed to a team's success.
