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.
- Other info: Exciting projects and a chance to work with cutting-edge technologies.
- 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.
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 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 High Wycombe 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 fosters a flexible work-life balance, while our commitment to cutting-edge technology and collaborative culture ensures that you will thrive in your role. With competitive salaries and opportunities for professional advancement, we are dedicated to creating a rewarding environment for our employees.
StudySmarter Expert Advice🤫
We think this is how you could land DB2 Database Administrator (DBA) in High Wycombe
✨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 DB2 Database Administrator (DBA) in High Wycombe
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 Cipher7. 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 Cipher7
✨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 Cipher7 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 — Cipher7 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 Cipher7's culture.
