At a Glance
- Tasks: Manage and support DB2 databases, ensuring smooth operations and troubleshooting issues.
- Company: Join Infinity Quest, a dynamic company focused on innovative database solutions.
- Benefits: Enjoy flexible working options and a collaborative team environment.
- Why this job: Be part of a crucial role in data management with opportunities for growth and learning.
- Qualifications: 7+ years as a DB2 DBA, Unix/Linux skills, and relevant certifications required.
- Other info: Must have EU work permit; 24/7 operational support experience is essential.
The predicted salary is between 36000 - 60000 £ per year.
Key points:
- People not more on Db2 mainframe but need Unix/Linux skills with DBA DB2.
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, privileges for DB2 access, Backup and Recovery activities.
- Experience in operational 24x7 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 redirects.
- Managing DB backups and recovery in both standalone and DPF environments.
- Creating databases, tablespaces, tables, views, and 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 restorations based on business needs.
- Managing tablespace backups and restorations.
- Supporting DB2 tools like IBM Data Studio, Rational Manager, IBM Installation Manager.
- Working with Q Replication.
- Handling 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 operating systems 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 examples of your past experiences in providing 24/7 production support. Be ready to discuss how you've handled troubleshooting and maintenance in high-pressure situations, as this is a key aspect of the job.
✨Tip Number 4
Network with current or former DB2 Database Administrators to gain insights into the role and the company culture. This can provide you with valuable information that you can use to tailor your approach when applying through our website.
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. Focus on your hands-on experience with DBA activities, especially in Unix/Linux environments, and mention any relevant certifications like IBM DB2 DBA.
Craft a Strong Cover Letter: In your cover letter, emphasise your customer-focused approach and ability to work in a team. Mention specific projects or experiences that demonstrate your skills in providing 24/7 production support and troubleshooting.
Highlight Relevant Skills: Clearly list your technical skills related to the job description, such as your experience with DB2 tools (like db2top and db2advise), operating systems (Linux, AIX), and any disaster recovery activities you've participated in.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role involving database management.
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. Be prepared to discuss specific projects where you utilised these skills, especially in areas like data maintenance, backup, and recovery.
✨Demonstrate Problem-Solving Abilities
Employers are looking for candidates who can troubleshoot effectively. Prepare examples of past incidents you've resolved, particularly in a 24/7 support environment, to illustrate your problem-solving capabilities.
✨Emphasise Team Collaboration
Since the role requires good team relationships, be ready to talk about how you've worked with application teams or other departments. Share experiences that showcase your ability to collaborate and communicate effectively.
✨Prepare for Scenario-Based Questions
Expect questions that assess your response to real-world scenarios, such as managing database restorations or handling user access permissions. Practising these scenarios can help you articulate your thought process during the interview.