Job title: DB2 DBA L3

London - Canary Wharf (100% reporting to client office)

Requirement Gathering System ID (RGS): Onsite RGS, skill should be correct, tagged to a WON 4280338/9361137
Duration of assignment: 6 months

Special working conditions: (travel, weekend, overtime, on call etc.) Weekend and on call expected as per client requirement

Role description: DB2 L3 DBA having knowledge of IBM DB2 version 10.5,11.1 Administration and knowledge of DB2 Replication Server Administration will support client DB2 databases at L3 level. Will manage databases and handle issues escalated from L2 plus issue raised by customers.

Key responsibilities

Manage database access. Adhere to best practices regarding access to and management of databases.
Perform Database Migrations using Dump/Load, In place Upgrade. Improve database performance and operational excellence.
Troubleshoot database-related application performance issues and recommend solutions
Perform Replication setup including table level/Warm Standby/MSA and tuning.
Handling Replication operation issues.

Key skills/knowledge/experience: 

Detail knowledge of IBM DB2 version 10.5,11.1 Administration.
Detailed knowledge of DB2 Replication Server Administration.
Detailed knowledge of DB2 server installations on standalone/DPF/HADR.
Install, upgrade, and manage database.
Manage database access. Adhere to best practices regarding access to and management of databases.
Perform Database Migrations using Dump/Load, In place Upgrade.
Improve database performance and operational excellence.
Troubleshoot database-related application performance issues and recommend solutions
Perform Replication setup including table level/Warm Standby/MSA and tuning.
Handling Replication operation issues.
Having knowledge on Database Maintenance task such as Dbcc, Reorg.
Collaborate with cross-functional teams to troubleshoot live issues, internally or externally reported.
Create/Modify automation for repeating database tasks.