DB2 DBA

DB2 DBA

Full-Time 43200 - 72000 £ / year (est.) No home office possible
L

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

At Persistent, we pride ourselves on being an exceptional employer, particularly for the DB2 DBA role located in the vibrant Harbour Exchange Square, London. Our culture is centred around talent development, offering competitive salaries, comprehensive benefits, and opportunities for professional growth through company-sponsored education and certifications. With a focus on employee engagement and a hybrid work model, we foster a collaborative environment that empowers our team to thrive while working with cutting-edge technologies.
L

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

DB2 Database Administration
Data Maintenance
Backup and Recovery Activities
24x7 Production Support
Troubleshooting Skills
Monitoring and Maintenance
Logical and Physical Database Partitioning
Disaster Recovery Planning
DB2 V10 Upgrade Experience
Database Object Creation (tables, views, indexes)
HADR Configuration
User Access Management
DB2 Tools Proficiency (db2top, db2advise, etc.)
Incident Management
Change Management
Customer Focused Approach
Team Collaboration

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.

L
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>