Database Administrator (DB2)

Database Administrator (DB2)

Posted 1 week ago by Infoplus Technologies UK Limited

Apply
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Apply
Automation Business Continuity And Disaster Recovery Database Administration Database Partitioning Data Migration Disaster Recovery IBM DB2 IBM Software Linux Management Memory Architecture Oracle Database Administration (DBA) Oracle Linux Performance Testing Performance Tuning Query Performance Scalability

Summary: The Database Administrator (DB2) role requires a professional with extensive experience in migrating databases from AIX to Linux, utilizing various DB2-supported methods. The position demands in-depth knowledge of DB2 utilities for efficient data migration, performance tuning, and managing high availability systems. The candidate should also possess strong skills in automation and handling complex database environments to ensure optimal performance and scalability.

Key Responsibilities:

  • Migrate databases from AIX to Linux using various DB2-supported methods.
  • Utilize DB2 EXPORT and LOAD utilities for efficient data migration.
  • Implement DB2MOVE and LOAD FROM CURSOR for structured schema and data transfer.
  • Manage Q Replication for near real-time data replication.
  • Set up and manage HADR (High Availability Disaster Recovery) with multiple standby systems.
  • Capture real workloads from the source database and replay them on the target for performance testing.
  • Perform performance tuning using DBM configurations, database parameters, and registry variables.
  • Utilize data movement utilities like db2move, EXPORT, IMPORT, and LOAD.
  • Work with DB2 Federation for querying across heterogeneous data sources.
  • Automate routine DBA tasks using complex shell scripts.
  • Perform DB2 Restores and Redirected Restores in non-DPF and DPF environments.
  • Manage DB2 DPF systems for high scalability and performance.
  • Handle large tables using table partitioning for improved query performance.
  • Set up and configure DB2 environments based on IBM best practices.

Key Skills:

  • Strong experience in database migration from AIX to Linux.
  • In-depth knowledge of DB2 EXPORT and LOAD utilities.
  • Hands-on experience with DB2MOVE and LOAD FROM CURSOR.
  • Good understanding of Q Replication.
  • Expertise in HADR management.
  • Skilled in performance testing and right-sizing DB2 VMs.
  • Excellent understanding of DB2 Process and Memory Architecture.
  • Proficient in performance tuning.
  • Experience with data movement utilities.
  • Hands-on experience in DB2 Federation.
  • Comfortable with complex shell scripts.
  • Experience in DB2 Restores and Redirected Restores.
  • Knowledge of managing DB2 DPF systems.
  • Proficient in table partitioning.
  • Solid hands-on DB2 administration skills.

Salary (Rate): undetermined

City: London Area

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

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.
Apply
Similar Jobs
Loading data...