DB2 Database Administrator (DBA)
Canary Wharf, UK
Hybrid (2 days a week)
Full Time
Job Summary:
We are seeking a highly motivated and experienced DB2 Database Administrator (DBA) with strong expertise in IBM DB2 on Linux . The ideal candidate will be responsible for day-to-day operational support, issue resolution, performance tuning, and incident management of DB2 databases in a 24x7 production environment. The candidate should have a deep understanding of Linux environments, DB2 internals, and database troubleshooting.
Key Responsibilities:
• Provide L2 support for IBM DB2 databases running on Linux platforms .
• Monitor database performance and proactively identify and resolve issues.
• Manage database incidents, service requests, and change management processes.
• Perform regular database health checks, backup/recovery, reorgs, and runstats.
• Work with development and application teams for query optimization and tuning.
• Analyze and resolve space, locking, and connectivity-related issues.
• Participate in database maintenance activities such as patching, upgrades, and migrations.
• Collaborate with infrastructure and storage teams for performance and capacity planning.
• Maintain documentation of DB configurations, procedures, and troubleshooting steps.
• Ensure adherence to SLAs, security policies, and compliance standards.
Required Skills:
• 5–8 years of hands-on experience as a DBA supporting IBM DB2 databases .
• Experience with DB2 LUW (Linux, Unix, Windows) database administration.
• Strong working knowledge of Linux OS , particularly in performance and process management.
• Hands-on experience in backup/recovery strategies , HADR/Replication , and disaster recovery .
• Proficient in SQL scripting , shell scripting , and automation tools for DB tasks.
• Experience with monitoring tools (e.g., IBM Data Studio, Toad, Nagios, OEM).
• Familiarity with incident and change management tools like ServiceNow or Remedy.
• Ability to work in 24x7 support environment including rotational on-call duties.
