Description
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 /
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.