DB2 Migration Lead - Oracle-to-DB2 & Tuning

Ratesthe Opportunitywe; Etwall CP; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

We are seeking an experienced Database Administrator (DB2) to support a major enterprise technology transformation programme in Derby. This hybrid role (2 days on site) focuses on DB2 administration, Oracle-to-DB2 migration, performance tuning, security, and operational support during a large-scale upgrade and migration project.

The successful candidate will manage migration activities, optimise DB2 environments, implement backup/recovery strategies, and ensure compliance and governance across

Qualifications

• Proven experience delivering Oracle-to-DB2 database migrations.
• Strong DB2 administration experience within enterprise environments.
• Experience with DB2 installation, configuration, and ongoing support.
• Strong performance tuning and optimisation skills.
• Experience planning and executing backup, recovery, and disaster recovery processes.
• Expertise in database security, access controls, and compliance requirements.
• Experience converting or refactoring Oracle PL/SQL procedures for DB2 environments.
• Strong troubleshooting and root cause analysis capabilities.
• Experience supporting business-critical production database platforms.

Responsibilities

• Lead Oracle-to-DB2 migration activities, ensuring smooth transition and minimal business disruption.
• Install, configure, administer and support DB2 database environments.
• Refactor and migrate Oracle PL/SQL stored procedures for DB2 compatibility.
• Develop and execute database migration strategies, plans, and validation activities.
• Perform performance monitoring, tuning, and optimisation of DB2 environments.
• Design and manage database backup, recovery, and disaster recovery solutions.
• Support database security, compliance, and governance requirements.
• Troubleshoot database issues and provide root cause analysis.
• Collaborate with application, infrastructure, and project teams throughout migration and deployment activities.
• Ensure database standards, operational procedures, and documentation are maintained.

Skills

DB2 administration

Oracle-to-DB2 migration

Performance tuning

Security & compliance

Backup & DR

Troubleshooting

Root cause analysis

Tools

DB2

Oracle

PL/SQL

Job description

We are seeking an experienced Database Administrator (DB2) to support a major enterprise technology transformation programme in Derby. This hybrid role (2 days on site) focuses on DB2 administration, Oracle-to-DB2 migration, performance tuning, security, and operational support during a large-scale upgrade and migration project.

The successful candidate will manage migration activities, optimise DB2 environments, implement backup/recovery strategies, and ensure compliance and governance across