12 Contract, Tech / Digital / IT jobs in Camden Town, Greater London

Job Description - DB2 DBA

• Strong experience in migrating databases from AIX to Linux using various DB2-supported methods.
• In-depth knowledge of DB2 EXPORT and LOAD utilities for efficient data migration.
• Hands-on experience with DB2MOVE and LOAD FROM CURSOR for structured schema and data transfer.
• Good understanding and practical experience with Q Replication for near Real Time data replication.
• Expertise in setting up and managing HADR (High Availability Disaster Recovery) with multiple standby systems.
• Skilled in capturing real workloads from the source database and replaying them on the target for performance testing and right-sizing DB2 VMs.
• Excellent understanding of DB2 Process and Memory Architecture.
• Proficient in performance tuning using DBM configurations, database parameters, and registry variables.
• Strong experience with data movement utilities like db2move, EXPORT, IMPORT, and LOAD.
• Hands-on experience in DB2 Federation for querying across heterogeneous data sources.
• Comfortable working with and understanding complex Shell Scripts; able to automate routine DBA tasks effectively.
• Good experience in performing DB2 Restores and Redirected Restores in both non-DPF and DPF (Database Partitioning Feature) environments.
• Excellent knowledge of managing DB2 DPF systems, ensuring high scalability and performance.
• Proficient in handling large tables using table partitioning for improved query performance.
• Capable of setting up and configuring DB2 environments from scratch based on IBM best practices, including:
+ OS-level tuning (Kernel parameters, memory/I/O optimization) + DB2 database configuration (buffer pools, sort memory, logging, parallelism)
• Solid hands-on DB2 administration skills across multiple platforms.
  
  Strong experience in migrating databases from AIX to Linux using various DB2-supported methods.
• In-depth knowledge of DB2 EXPORT and LOAD utilities for efficient data migration.
• Hands-on experience with DB2MOVE and LOAD FROM CURSOR for structured schema and data transfer.
• Good understanding and practical experience with Q Replication for near Real Time data replication.
• Expertise in setting up and managing HADR (High Availability Disaster Recovery) with multiple standby systems.
• Skilled in capturing real workloads from the source database and replaying them on the target for performance testing and right-sizing DB2 VMs.
• Excellent understanding of DB2 Process and Memory Architecture.
• Proficient in performance tuning using DBM configurations, database parameters, and registry variables.
• Strong experience with data movement utilities like db2move, EXPORT, IMPORT, and LOAD.
• Hands-on experience in DB2 Federation for querying across heterogeneous data sources.
• Comfortable working with and understanding complex Shell Scripts; able to automate routine DBA tasks effectively.
• Good experience in performing DB2 Restores and Redirected Restores in both non-DPF and DPF (Database Partitioning Feature) environments.
• Excellent knowledge of managing DB2 DPF systems, ensuring high scalability and performance.
• Proficient in handling large tables using table partitioning for improved query performance.
• Capable of setting up and configuring DB2 environments from scratch based on IBM best practices, including:
+ OS-level tuning (Kernel parameters, memory/I/O optimization) + DB2 database configuration (buffer pools, sort memory, logging, parallelism)
• Solid hands-on DB2 administration skills across multiple platforms.