DB2 Database Administrator

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.