DB2 Database Administrator

TieTalent; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

A leading technology solutions provider is seeking a skilled DB2 Database Administrator in London. The role involves managing data integrity, operational support, and enhancements across mainframe and open systems. Candidates should have extensive experience in DBA tasks, troubleshooting, and relevant certifications. This is an excellent opportunity for professionals looking to advance in a dynamic environment.

Qualifications

• Over 7 years of experience in DB2 development and production support.
• Hands-on experience in database management tasks.
• 2 years of experience specifically on Mainframes.

Responsibilities

• Providing solutions and managing databases for application teams.
• Participating in DB2 upgrades and disaster recovery activities.
• Managing backups and recovery in multi-environment settings.

Skills

DBA activities

Data maintenance

Troubleshooting

Monitoring

Education

Certified IBM DB2 DBA

Tools

db2top

db2advise

db2pd

db2dart

db2look

db2support

SPUFI

QMF

QREP

IBM Data Studio

Job description

Partner Job Qualient Technology Solutions UK Limited

We are seeking a DB2 Database Administrator with over 7 years of experience involved in development, enhancements, and production support.

Qualifications:

• Certified IBM DB2 DBA or equivalent experience.
• Hands-on experience in DBA activities such as data maintenance, authorization, privileges, backup, and recovery.
• Experience in operational 24x7 support, troubleshooting, monitoring, and maintenance.
• 2 years of experience as a 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 tools, Log analyzer

Responsibilities:

• Providing solutions to application teams.
• Managing logical and physical partitioned databases.
• Data refreshes in development regions.
• Participating in DB2 V10 upgrade and quarterly disaster recovery activities.
• Restoring databases and redirect restorations.
• Responsible for backups and recovery in both standalone and DPF environments.
• Creating database objects: databases, tablespaces, tables, views, indexes.
• Supporting Windows applications like Philbert, WinSQL, and NLP.
• Involved in disaster recovery exercises.
• Cataloging mainframe databases for open systems access.
• Resolving user issues related to databases, managing user access.
• Working with partitioned tables, materialized query tables, and views.
• Performing frequent restorations based on business needs.
• Supporting DB2 tools like IBM Data Studio, Rational Manager, Installation Manager.
• Working with Q Replication.
• Managing incidents and changes using HPSM.

This job posting is active and not expired.