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 that values talent development and cutting-edge technology.
- 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 insurance coverage.
The predicted salary is between 43200 - 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:
- 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.
- 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.”
DB2 DBA employer: LinkedIn
Contact Detail:
LinkedIn 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 IBM Data Studio. 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 valuable insights into the company culture and expectations, which can help you tailor your approach 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 ability to work under pressure.
✨Tip Number 4
Research Persistent as a company and understand their focus on digital engineering and enterprise modernisation. This knowledge will allow you to align your answers with their values and demonstrate your genuine interest in contributing to their mission.
We think you need these skills to ace DB2 DBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your relevant experience as a DB2 Database Administrator. Focus on your 7+ years of experience, specific DBA activities you've performed, and any certifications you hold, such as IBM DB2 DBA.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for the role and the company. Mention your hands-on experience with DB2, your ability to provide 24/7 production support, and how you can contribute to Persistent's goals.
Highlight Technical Skills: In your application, emphasise your technical skills related to DB2, including your familiarity with various operating systems and database tools mentioned in the job description. This will demonstrate your fit for the role.
Showcase Problem-Solving Abilities: Include examples in your application that illustrate your problem-solving skills, particularly in troubleshooting and maintaining databases. This aligns with the company's focus on providing solutions to application teams.
How to prepare for a job interview at LinkedIn
✨Showcase Your Technical Expertise
Make sure to highlight your extensive experience with DB2, especially your hands-on skills in database administration activities. Be prepared to discuss specific projects where you implemented data maintenance, backups, and recovery processes.
✨Demonstrate Problem-Solving Skills
Since the role involves providing 24/7 production support, be ready to share examples of how you've successfully troubleshot issues in the past. Discuss your approach to monitoring and maintaining databases, and how you ensure minimal downtime.
✨Familiarise Yourself with the Company Culture
Research Persistent's values and culture, particularly their focus on talent development and employee engagement initiatives. This will help you align your answers with what they value in their employees, showing that you're a good fit for their team.
✨Prepare Questions for Your Interviewers
Have a list of insightful questions ready to ask during the interview. Inquire about the team's current challenges, the technologies they are using, and how they measure success in the DB2 DBA role. This shows your genuine interest in the position and the company.