DB2 DBA - 400 GBP - Inside IR35 - 3 Days Onsite
Posted 1 week ago by Infoplus Technologies UK Limited
Negotiable
Inside
Onsite
London Area, United Kingdom
Summary: The role of DB2 DBA involves extensive experience in migrating databases from AIX to LINUX, managing HADR with multiple standbys, and performance tuning of databases. The position requires expertise in DB2 processes, memory architecture, and data movement utilities, along with the ability to automate routine tasks through shell scripting. The candidate will also be responsible for capturing real workloads for testing and managing DB2 DPF systems.
Key Responsibilities:
- Migrate databases from AIX to LINUX using various methods.
- Manage and set up HADR with multiple standbys.
- Capture real workloads from the source database and replay in the target database.
- Optimize DB2 VMs based on workload testing.
- Utilize DB2 process and memory architecture knowledge.
- Perform database performance tuning using DBM, configuration parameters, and registry variables.
- Utilize data movement utilities like db2move, Export, Import, and Load.
- Work with DB2 Federation.
- Understand and automate complex shell scripts for routine tasks.
- Perform DB2 restores and redirected restores in non-DPF and DPF setups.
- Manage DB2 DPF systems effectively.
Key Skills:
- Experience in migrating databases from AIX to LINUX.
- Knowledge of Q replication.
- Expertise in HADR management.
- Ability to capture and replay workloads.
- Excellent knowledge of DB2 process and memory architecture.
- Performance tuning skills for databases.
- Experience with data movement utilities.
- Understanding of DB2 Federation.
- Proficiency in shell scripting.
- Experience with DB2 restores and DPF systems.
Salary (Rate): 400 GBP daily
City: London
Country: United Kingdom
Working Arrangements: on-site
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
1. Good experience or knowledge in migrating Databases from AIX to LINUX using different methods.
2. Good knowledge on Q replication.
3. Expertise in setting up and managing HADR with multiple standbys.
4. Capturing real workloads from the Source database and replaying in the Target database for testing the workloads to right-size the DB2 VMs.
5. Excellent knowledge on DB2 Process and Memory Architecture.
6. Expertise on performance tuning of the Databases using different DBM, Database configuration parameters and registry variables.
7. Good experience in data movement utilities like db2move,Export,Import and Load.
8. Good experience on DB2 Federation.
9. Good experience in understanding complex Shell scripts and automating the routine tasks.
10.Good experience in performing DB2 Restores and Redirected restores in non-DPF and DPF setups. (DPF - Multi-partition Database partitioning database).
11. Excellent knowledge and good experience in managing DB2 DPF systems.