Db2 Dba

Db2 Dba

Posted 1 week ago by Workforce - Today

Apply
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Apply
Database Partitioning IBM DB2 Linux Management Memory Architecture Oracle Database Administration (DBA) Oracle Linux Performance Tuning

Summary: The role of DB2 DBA requires a professional with 5-8 years of experience in managing and migrating databases, particularly from AIX to LINUX. The candidate should possess expertise in DB2 processes, performance tuning, and managing HADR systems, along with a solid understanding of data movement utilities and complex shell scripts. The position is based in the London Area, United Kingdom, and focuses on ensuring optimal database performance and reliability.

Key Responsibilities:

  • Migrate databases from AIX to LINUX using various methods.
  • Manage and set up HADR with multiple standbys.
  • Capture real workloads from source databases and replay them in target databases for testing.
  • Optimize DB2 performance through tuning and configuration parameters.
  • Utilize data movement utilities such as db2move, Export, Import, and Load.
  • Work with DB2 Federation and automate routine tasks using shell scripts.
  • Perform DB2 restores and redirected restores in non-DPF and DPF setups.
  • Manage DB2 DPF systems effectively.

Key Skills:

  • DB2 LUW expertise.
  • Experience in database migration from AIX to LINUX.
  • Knowledge of Q replication.
  • HADR management skills.
  • Understanding of DB2 process and memory architecture.
  • Performance tuning experience.
  • Proficiency in data movement utilities.
  • Experience with DB2 Federation.
  • Ability to understand and automate complex shell scripts.
  • Experience with DB2 restores in various setups.
  • Knowledge of managing DB2 DPF systems.

Salary (Rate): undetermined

City: London Area

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

JD for DB2 DBA

Mandatory Skills: Db2 LUW. Experience: 5-8 Years

  • Good experience or knowledge in migrating Databases from AIX to LINUX using different methods.
  • Good knowledge on Q replication.
  • Expertise in setting up and managing HADR with multiple standbys.
  • Capturing real workloads from the Source database and replaying in the Target database for testing the workloads to right-size the DB2 VMs.
  • Excellent knowledge on DB2 Process and Memory Architecture.
  • Expertise on performance tuning of the Databases using different DBM, Database configuration parameters and registry variables.
  • Good experience in data movement utilities like db2move,Export,Import and Load.
  • Good experience on DB2 Federation.
  • Good experience in understanding complex Shell scripts and automating the routine tasks.
  • Good experience in performing DB2 Restores and Redirected restores in non-DPF and DPF setups. (DPF - Multi-partition Database partitioning database).
  • Excellent knowledge and good experience in managing DB2 DPF systems.
Apply
Similar Jobs
Loading data...