At a Glance
- Tasks: Join us as a DB2 DBA, providing 24/7 production support and database solutions.
- Company: Persistent is a leading Digital Engineering partner, working with top global organisations.
- Benefits: Enjoy competitive salary, flexible hours, and opportunities for higher education and certifications.
- Why this job: Be part of a culture focused on talent development and cutting-edge technologies.
- Qualifications: 7+ years as a DB2 DBA, with hands-on experience in database management and support.
- Other info: Hybrid work model with engaging employee initiatives and health coverage.
The predicted salary is between 48000 - 72000 £ per year.
About Persistent: We are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world including 14 of the 30 most innovative US companies, 80% of the largest banks in the US and India, and numerous innovators across the healthcare ecosystem.
About Position and details:
- Role: DB2 DBA
- Location: Harbour Exchange Square, London
- Mode: Hybrid (2 to 3 days to office)
- Experience: 6 to 15 years
- Job Type: Permanent role
Requirements:
- 7+ years of experience as a DB2 Database Administrator involved in Development, Enhancements and Production Support.
- Certified IBM DB2 DBA or equivalent experience.
- Having hands-on experience in DBA activities like Implementing Data Maintenance, Authorization and privileges for DB2 access, Regular Backup and Recovery Activities.
- Experience in operational 24x7 support, best practice troubleshooting, monitoring, and maintenance.
- Result oriented, Customer focused with healthy relationship with team members.
- 2 years of experience as DB2 DBA on Mainframes.
Skills:
- Operating Systems: Windows XP, Linux, AIX and AWS ec2
- Database: DB2 on open systems
- Database Tools: db2top, db2advise, db2pd, db2dart, db2look, db2support, SPUFI, QMF, QREP DB2 Admin tool, Log analyzer.
Roles & Responsibilities:
- Providing 24/7 Production support.
- Providing solutions to application teams.
- Working on both logical and physical partitioning databases.
- Data refresh in Development regions.
- Involved in DB2 V10 upgrade.
- Involved in Quarterly Disaster Recovery activity.
- Restorations of database and Redirect restorations.
- Responsible for DB backups and Recovery in both stand alone and DPF environments.
- Creating various db2 objects like databases, tablespaces, tables, views and indexes etc.
- Configuring HADR between servers.
- Supporting various windows applications in State Farm like Philbert, WinSQL and NLP etc.
- Involved in Disaster Recovery exercise.
- Cataloging mainframe databases in open systems to make the mainframe databases available to open systems users.
- Resolving user issues related to database.
- Granting access to users and revoking it from users.
- Monitoring Tools: top, db2top, db2pd, snapshots etc.
- Working with partitioned tables, Materialized query tables and views.
- Performing restorations frequently on basis of business requirements.
- Table space level backups and restorations based on business requirement.
- Supporting DB2 based tools like IBM Data Studio, IBM rational manager and IBM Installation Manager.
- Working with Q Replication.
- Incident management and change management using HPSM.
Benefits:
- Competitive salary and benefits package.
- Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications.
- Opportunity to work with cutting-edge technologies.
- Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards.
- Annual health check-ups.
- Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents.
Let’s unleash your full potential at Persistent - persistent.com/careers.
“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”
Contact Detail:
Persistent Systems Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land DB2 DBA
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as db2top and db2advise. Having hands-on experience with these tools will not only boost your confidence but also demonstrate your readiness for the role.
✨Tip Number 2
Network with current or former DB2 DBAs, especially those who have worked in similar environments. They can provide insights into the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Prepare to discuss your experience with 24/7 production support and how you've handled critical incidents in the past. Being able to share specific examples will show your problem-solving skills and reliability.
✨Tip Number 4
Research Persistent as a company and understand their focus on digital engineering and enterprise modernisation. Tailoring your conversation to align with their mission can set you apart from other candidates.
We think you need these skills to ace DB2 DBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as a DB2 Database Administrator. Focus on relevant skills such as data maintenance, backup and recovery activities, and any certifications you hold, like IBM DB2 DBA.
Craft a Strong Cover Letter: Write a cover letter that specifically addresses the requirements listed in the job description. Mention your hands-on experience with DB2, operational support, and your ability to work in a hybrid environment.
Showcase Relevant Experience: In your application, emphasise your 7+ years of experience in DB2 administration, particularly any involvement in production support and disaster recovery activities. Use specific examples to demonstrate your expertise.
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 Persistent Systems
✨Showcase Your DB2 Expertise
Make sure to highlight your extensive experience with DB2, especially any hands-on activities you've performed. Discuss specific projects where you implemented data maintenance, backups, and recovery processes, as these are crucial for the role.
✨Demonstrate Problem-Solving Skills
Prepare to discuss how you've tackled challenges in previous roles, particularly in 24/7 production support. Be ready to share examples of troubleshooting and monitoring that led to successful outcomes.
✨Familiarise Yourself with Tools
Since the job requires knowledge of various DB2 tools, ensure you're comfortable discussing tools like db2top, db2advise, and QMF. Mention any specific experiences you've had using these tools to solve problems or improve processes.
✨Emphasise Team Collaboration
Persistent values a customer-focused approach and healthy team relationships. Be prepared to talk about how you've worked effectively within teams, supported application teams, and maintained good communication with colleagues.