At a Glance
- Tasks: Provide 24/7 support for DB2 databases and deliver solutions to application teams.
- Company: Join a leading tech firm in the heart of London with a hybrid work model.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Exciting projects and a collaborative environment await you!
- Why this job: Be part of a dynamic team and enhance your skills in database management.
- Qualifications: 7+ years as a DB2 DBA with strong Unix/Linux skills required.
The predicted salary is between 45000 - 105000 € 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 24x7 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) in Wolverhampton employer: Cipher7
Join a dynamic and innovative team as a DB2 Database Administrator in the heart of London City, where we prioritise employee growth and development. Our hybrid work model promotes a healthy work-life balance, while our commitment to cutting-edge technology ensures you will be at the forefront of the industry. With competitive salaries and a supportive culture that values collaboration and continuous learning, we are dedicated to providing a rewarding and meaningful career for our employees.
StudySmarter Expert Advice🤫
We think this is how you could land DB2 Database Administrator (DBA) in Wolverhampton
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join relevant online forums. You never know who might have the inside scoop on a job opening that’s perfect for you.
✨Tip Number 2
Prepare for interviews by practising common DBA scenarios. Brush up on your Unix/Linux skills and be ready to discuss your hands-on experience with DB2 databases. We want you to shine when it comes to showcasing your expertise!
✨Tip Number 3
Don’t just apply anywhere; focus on companies that excite you! Use our website to find roles that match your skills and interests. Tailor your approach to each application to show why you’re the perfect fit.
✨Tip Number 4
Follow up after interviews! A quick thank-you email can go a long way in keeping you top of mind. It shows your enthusiasm and professionalism, which are key traits for a DB2 Database Administrator.
We think you need these skills to ace DB2 Database Administrator (DBA) in Wolverhampton
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience as a DB2 DBA, especially your Unix/Linux skills. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects and achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for our team at StudySmarter. Share specific examples of your past work with DB2 databases and how you’ve tackled challenges in production support.
Show Off Your Technical Skills:We’re looking for someone with solid technical know-how. Make sure to mention your hands-on experience with DB2 tools and any relevant certifications. This will help us see your expertise right from the start!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
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 db2look. Be ready to discuss your hands-on experience with database management, backups, 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 in past roles, so have some examples ready.
✨Prepare for Scenario-Based Questions
Expect questions that put you in real-world situations, like how you'd handle a database failure or manage user access issues. Think through your past experiences and be ready to explain your thought process and actions.
✨Familiarise Yourself with the Company’s Environment
Research the company’s tech stack and any recent projects they’ve undertaken. This will not only help you tailor your answers but also show your genuine interest in the role and the organisation.
