Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Provide 24/7 support for DB2 databases and deliver innovative solutions.
- Company: Dynamic tech firm in London with a hybrid work culture.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Why this job: Join a leading team and enhance your skills in a fast-paced environment.
- Qualifications: 7+ years as a DB2 DBA with strong Unix/Linux skills required.
- Other info: Exciting projects and a chance to work with cutting-edge technology.
The predicted salary is between 60000 - 90000 £ per year.
Job Title: DB2 Database Administrator (DBA) – Permanent
Location: London City
Mode: Hybrid (2–3 days in office)
Experience: 7 – 15 years
Budget: £75,000
About the Role:
We are seeking an experienced DB2 Database Administrator with strong Unix/Linux skills. This role focuses on both production support and development activities for DB2 databases on open systems, with some exposure to mainframes.
Key Requirements:
- 7+ years of experience as a DB2 DBA in development, enhancements, and production support.
- Certified IBM DB2 DBA or equivalent experience.
- Hands-on experience with implementing data maintenance, managing authorizations/privileges, and performing regular backup and recovery activities.
- Experience in operational 24×7 support, troubleshooting, monitoring, and maintenance.
- Minimum 2 years of experience as a DB2 DBA on Mainframes.
- Strong Unix/Linux skills required; DB2 mainframe expertise is desirable but not primary.
Technical Skills:
Operating Systems: Windows XP, Linux, AIX, AWS EC2
Database: DB2 on open systems
DB2 Tools: db2top, db2advise, db2pd, db2dart, db2look, db2support, SPUFI, QMF, QREP, DB2 Admin tool, Log Analyzer
Others: IBM Data Studio, IBM Rational Manager, IBM Installation Manager
Roles & Responsibilities:
- Provide 24/7 production support for DB2 databases.
- Deliver solutions to application teams.
- Manage both logical and physical partitioning databases.
- Perform data refreshes in development regions.
- Participate in DB2 V10 upgrades and quarterly disaster recovery exercises.
- Handle database restoration and redirect restorations.
- Responsible for database backups and recovery in stand-alone and DPF environments.
- Create and manage DB2 objects: databases, tablespaces, tables, views, indexes, etc.
- Configure HADR between servers.
- Support various Windows applications like Philbert, WinSQL, and NLP.
- Catalog mainframe databases for open systems users.
- Resolve user database issues, manage access (grant/revoke privileges).
- Monitor databases using tools like db2top, db2pd, snapshots, etc.
- Work with partitioned tables, materialized query tables, and views.
- Perform restorations based on business requirements, including tablespace-level backups.
- Support DB2-based tools such as IBM Data Studio, IBM Rational Manager, and IBM Installation Manager.
- Work with Q Replication.
- Participate in incident and change management using HPSM.
DB2 Database Administrator (DBA) employer: Cipher7
Contact Detail:
Cipher7 Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land DB2 Database Administrator (DBA)
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even local tech events. You never know who might have the inside scoop on a DB2 DBA role that’s not even advertised yet.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share your hands-on experience with DB2 databases and Unix/Linux skills. Use real examples from your past roles to demonstrate how you’ve tackled challenges and delivered solutions.
✨Tailor Your Approach
Before any interview, do your homework! Research the company and understand their DB2 environment. Tailor your answers to show how your experience aligns with their needs, especially around production support and database management.
✨Apply Through Us!
Don’t forget to check out our website for the latest job openings! Applying through StudySmarter gives you a better chance of landing that dream job as a DB2 Database Administrator. We’re here to help you every step of the way!
We think you need these skills to ace DB2 Database Administrator (DBA)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the DB2 Database Administrator role. Highlight your 7+ years of experience, especially in production support and development activities. We want to see your Unix/Linux skills shine!
Showcase Your Skills: Don’t just list your skills; demonstrate them! Include specific examples of how you've implemented data maintenance or managed authorisations. This helps us see your hands-on experience in action.
Craft a Compelling Cover Letter: Your cover letter is your chance to tell us why you’re the perfect fit for this role. Share your passion for DB2 databases and any relevant projects you've worked on. Make it personal and engaging!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and keep track of it. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at Cipher7
✨Know Your DB2 Inside Out
Make sure you brush up on your DB2 knowledge, especially the tools mentioned in the job description like db2top and db2advise. Be ready to discuss your hands-on experience with database management, backup, and recovery processes.
✨Show Off Your Unix/Linux Skills
Since strong Unix/Linux skills are a must, prepare to demonstrate your proficiency. You might be asked about specific commands or scenarios where you've used these skills to troubleshoot or maintain databases.
✨Prepare for Real-World Scenarios
Think of examples from your past experiences that showcase your ability to handle 24/7 production support and incident management. Be ready to explain how you resolved issues and improved database performance.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions! Inquire about the team dynamics, the types of projects you'll be working on, or how they handle disaster recovery exercises. This shows your genuine interest in the role and helps you gauge if it's the right fit for you.