At a Glance
- Tasks: Manage and support DB2 databases, ensuring smooth operations and user access.
- Company: Join Infinity Quest, a dynamic company in the tech industry based in Watford.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: Be part of a collaborative team, tackling exciting challenges in database management.
- Qualifications: 7+ years as a DB2 DBA with Unix/Linux skills; certification preferred.
- Other info: Must be available for 24/7 operational support and troubleshooting.
The predicted salary is between 36000 - 60000 £ per year.
Location: Watford, Hertfordshire, United Kingdom
Job Category: Other - EU work permit required: Yes
Key points:
- People not more on Db2 mainframe, but need Unix/Linux skills with DBA
Requirements:
- 7+ years of experience as a DB2 Database Administrator involved in Development, Enhancements, and Production Support.
- Certified IBM DB2 DBA or equivalent experience.
- Hands-on experience in DBA activities like Data Maintenance, Authorization and privileges for DB2 access, Backup and Recovery.
- Experience in 24x7 operational support, troubleshooting, monitoring, and maintenance.
- Result-oriented, customer-focused, with good team relationships.
- 2 years of experience as DB2 DBA on Mainframes.
Skills:
- Operating Systems: Windows XP, Linux, AIX, AWS EC2
- Database: DB2 on open systems
- Database Tools: db2top, db2advise, db2pd, db2dart, db2look, db2support, SPUFI, QMF, QREP, DB2 Admin tool, Log analyzer
Responsibilities:
- Providing 24/7 production support.
- Providing solutions to application teams.
- Working on logical and physical partitioning databases.
- Data refresh in development regions.
- Involved in DB2 V10 upgrade.
- Participated in quarterly disaster recovery activities.
- Performing database restorations and redirect restorations.
- Responsible for backups and recovery in standalone and DPF environments.
- Creating DB2 objects like databases, tablespaces, tables, views, indexes.
- Supporting Windows applications like Philbert, WinSQL, NLP.
- Involved in disaster recovery exercises.
- Cataloging mainframe databases for open systems access.
- Resolving user issues related to databases.
- Managing user access permissions.
- Working with partitioned tables, materialized query tables, and views.
- Performing business-driven restorations.
- Supporting table space level backups and restorations.
- Supporting DB2 tools like IBM Data Studio, Rational Manager, Installation Manager.
- Working with Q Replication.
- Incident and change management using HPSM.
Db2 Data Base Administrator employer: JR United Kingdom
Contact Detail:
JR United Kingdom Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Db2 Data Base Administrator
✨Tip Number 1
Make sure to highlight your Unix/Linux skills during any conversations or interviews. Since the role requires these skills alongside DB2 expertise, demonstrating your proficiency in these areas can set you apart from other candidates.
✨Tip Number 2
Familiarise yourself with the specific DB2 tools mentioned in the job description, such as db2top and db2advise. Being able to discuss your hands-on experience with these tools will show that you're well-prepared for the responsibilities of the role.
✨Tip Number 3
Prepare to discuss your experience with 24/7 operational support and troubleshooting. This is a key aspect of the job, so having concrete examples ready will demonstrate your capability to handle the demands of the position.
✨Tip Number 4
Network with current or former DB2 Database Administrators, especially those who have worked in similar environments. They can provide insights into the company culture and expectations, which can be invaluable during your application process.
We think you need these skills to ace Db2 Data Base Administrator
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your 7+ years of experience as a DB2 Database Administrator. Emphasise your Unix/Linux skills and any relevant certifications, such as IBM DB2 DBA.
Craft a Strong Cover Letter: In your cover letter, explain how your hands-on experience in DBA activities aligns with the job requirements. Mention specific tools and technologies you have used, like db2top and QMF.
Showcase Relevant Experience: Detail your experience in 24/7 operational support and troubleshooting. Provide examples of how you've managed user access permissions and resolved database-related issues.
Highlight Team Collaboration: Since the role requires good team relationships, include examples of how you've worked collaboratively with application teams to provide solutions and support during disaster recovery exercises.
How to prepare for a job interview at JR United Kingdom
✨Showcase Your Technical Skills
Make sure to highlight your experience with DB2 and Unix/Linux systems during the interview. Be prepared to discuss specific projects where you utilised these skills, as well as any relevant certifications you hold.
✨Demonstrate Problem-Solving Abilities
Since the role involves troubleshooting and providing 24/7 support, be ready to share examples of how you've resolved complex database issues in the past. This will show your potential employer that you can handle high-pressure situations effectively.
✨Emphasise Team Collaboration
The job requires good team relationships, so be sure to mention your experience working in teams. Discuss how you’ve collaborated with application teams and other stakeholders to deliver solutions, as this is crucial for the role.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your practical knowledge of DB2 operations, such as backup and recovery processes or managing user access permissions. Practising these scenarios beforehand can help you respond confidently.