DB2 DBA

DB2 DBA

City of London Full-Time 48000 - 72000 £ / year (est.) No home office possible
P

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 company-sponsored education opportunities.
  • Why this job: Be part of a culture that values talent development and cutting-edge technology.
  • Qualifications: 7+ years as a DB2 DBA with relevant certifications and hands-on experience required.
  • Other info: This is a hybrid role based in London, offering a dynamic work environment.

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:

  • 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: Persistent Systems

At Persistent, we pride ourselves on being an exceptional employer, particularly for the DB2 DBA role based in the vibrant Harbour Exchange Square, London. Our culture is deeply rooted in talent development, offering quarterly promotion cycles and support for higher education, ensuring that our employees grow alongside cutting-edge technologies. With a competitive salary, comprehensive benefits, and engaging employee initiatives, we create a rewarding environment where you can truly unleash your potential.
P

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. This is a key aspect of the role, and showcasing your problem-solving skills will set you apart.

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 show your genuine interest and fit for the team.

We think you need these skills to ace DB2 DBA

DB2 Database Administration
IBM DB2 Certification
Data Maintenance Implementation
Backup and Recovery Activities
24/7 Operational Support
Troubleshooting Best Practices
Monitoring and Maintenance
Logical and Physical Partitioning
Disaster Recovery Planning
Database Object Creation (tables, views, indexes)
HADR Configuration
User Access Management
DB2 Tools Proficiency (db2top, db2advise, etc.)
Incident Management
Change Management
Experience with Mainframe Databases
Customer Focused Approach
Team Collaboration Skills

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 operational support. Use keywords from the job description to catch the employer's attention.

Craft a Strong Cover Letter: Write a cover letter that showcases your passion for the role and the company. Mention specific experiences that align with the responsibilities listed in the job description, such as your involvement in DB2 upgrades or disaster recovery exercises.

Highlight Certifications: If you have any certifications related to IBM DB2 or equivalent experience, make sure to prominently feature them in your application. This can set you apart from other candidates and demonstrate your commitment to professional development.

Proofread Your Application: Before submitting your application, take the time to proofread it for any spelling or grammatical errors. A polished application reflects your attention to detail and professionalism, which are crucial for a technical role like this.

How to prepare for a job interview at Persistent Systems

Showcase Your DB2 Expertise

Make sure to highlight your extensive experience with DB2, especially your hands-on skills in database administration. Be prepared to discuss specific projects where you implemented data maintenance, managed backups, and resolved user issues.

Demonstrate Problem-Solving Skills

Since the role involves providing 24/7 production support, be ready to share examples of how you've tackled complex database issues in the past. Discuss your approach to troubleshooting and any best practices you follow.

Familiarise Yourself with Tools

Brush up on the DB2 tools mentioned in the job description, such as db2top, db2advise, and Q Replication. Being able to discuss these tools and how you've used them will show your technical proficiency and readiness for the role.

Emphasise Team Collaboration

Persistent values a customer-focused and collaborative environment. Prepare to talk about your experiences working within teams, how you maintain healthy relationships with colleagues, and how you contribute to a positive team dynamic.

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