Db2 Dba
Posted 1 week ago by Infoplus Technologies UK Limited
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
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 data movement utilities, along with a strong understanding of HADR and DB2 DPF systems. 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 like db2move, Export, Import, and Load.
- Implement and manage DB2 Federation.
- Understand and automate complex Shell scripts for routine tasks.
- Perform DB2 restores and redirected restores in both non-DPF and DPF setups.
- Manage DB2 DPF systems effectively.
Key Skills:
- 5-8 years of experience with DB2 LUW.
- Knowledge of database migration from AIX to LINUX.
- Expertise in Q replication.
- Strong understanding of DB2 Process and Memory Architecture.
- Experience in performance tuning of databases.
- Proficiency in data movement utilities.
- Experience with DB2 Federation.
- Ability to understand and automate Shell scripts.
- Experience in performing 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
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.