At a Glance
- Tasks: Provide advanced support for mainframe Db2, driving strategy and improvements.
- Company: A diverse and inclusive financial organisation with a commitment to innovation.
- Benefits: Generous pension, performance bonuses, share schemes, and 30 days holiday.
- Other info: Flexible working patterns and a supportive environment for all.
- Why this job: Join a team where your expertise shapes the future of mainframe technology.
- Qualifications: 10+ years as a z/OS Db2 DBA with strong leadership and communication skills.
The predicted salary is between 72702 - 80780 £ per year.
Salary: £72,702 - £80,780
Location(s): Edinburgh, Leeds or Manchester
Hours: Full-time – 35 hours per week
Working Pattern: Hybrid, at least two days per week in the chosen office.
About this opportunity
Deliver advanced technical support for mainframe Db2 and its associated tools and utilities, ensuring services meet Group standards and supporting investment work, including out‑of‑hours coverage.
What you’ll do:
- Provide support for complex mainframe environments to tight timescales.
- Help drive the strategy and design across the mainframe development and test estate.
- Own and drive the zDBA technology roadmap, and work closely with stakeholders to deliver against it.
- Implement standardisation and drive improvement initiatives in the team.
- Work collaboratively across the wider Lab and Platform teams to develop, promote, and implement process initiatives.
- Ensure processes, governance, and procedures are rigorously adhered to.
What you’ll need:
- Extensive in‑depth expertise and knowledge of Db2 on z/OS.
- Expert‑level experience of performance monitoring and optimisation of Db2, including SQL tuning, buffer pool tuning, with the ability to make targeted recommendations to improve service stability and availability.
- Expert‑level experience of governing and approving DDL changes, handling schema evolution, validating impact, and ensuring alignment to change control processes.
- Extensive experience of leading the resolution and troubleshooting of critical on‑line systems.
- Proven experience of communicating and translating complex technical concepts for Senior Leadership.
- Experience of supporting junior team members, providing coaching on Db2 fundamentals, performance tuning, utilities, and operational processes.
It would be great if you also had:
- 10+ years of experience as a z/OS Db2 DBA in a financial organisation.
About working for us
We are committed to diversity, equity and inclusion, offering reasonable workplace adjustments for colleagues with disabilities, including flexibility in office attendance, location and working patterns. As a Disability Confident Leader, we guarantee fair and proportionate interview opportunities for applicants with a disability, long‑term health or neuro‑divergent condition through the Disability Confident Scheme.
Benefits:
- A generous pension contribution of up to 15%
- An annual performance‑related bonus
- Share schemes including free shares
- Benefits you can adapt to your lifestyle, such as discounted shopping
- 30 days’ holiday, with bank holidays on top
- A range of wellbeing initiatives and generous parental leave policies
Senior Infrastructure Specialist - z Mainframe Db2 DBA employer: LLOYDS BANKING GROUP
Join a forward-thinking company that values diversity, equity, and inclusion, offering a supportive work environment in Edinburgh, Leeds, or Manchester. With a strong commitment to employee growth, you will have access to extensive training opportunities, a generous pension contribution, and a flexible working pattern that promotes work-life balance. Enjoy a culture that encourages collaboration and innovation while benefiting from competitive perks such as an annual performance-related bonus and 30 days of holiday.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Infrastructure Specialist - z Mainframe Db2 DBA
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace Senior Infrastructure Specialist - z Mainframe Db2 DBA
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to LLOYDS BANKING GROUP. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at LLOYDS BANKING GROUP
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something LLOYDS BANKING GROUP will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — LLOYDS BANKING GROUP will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with LLOYDS BANKING GROUP's culture.
