DB2 Database Administrator (DBA)

DB2 Database Administrator (DBA)

Posted 1 week ago by Xoriant

Negotiable
Inside
Hybrid
London Area, United Kingdom

Summary: The role of DB2 Database Administrator (DBA) involves providing operational support and performance tuning for IBM DB2 databases in a 24x7 production environment. The ideal candidate will have extensive experience with DB2 on Linux and be responsible for incident management, issue resolution, and collaboration with development teams. This position requires a proactive approach to database health checks and adherence to security and compliance standards. The role is hybrid, requiring in-office presence two days a week.

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.

Key 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.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

DB2 Database Administrator (DBA) Canary Wharf, UK Hybrid (2 days a week) Inside IR35 Contract (6+ Months)

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.