IBM DB2 Administrator

Job Scope

1. Install, configure, upgrade, and patch IBM DB2 database systems (LUW and/or z/OS).
2. Monitor and tune overall database performance, including detailed SQL query optimization and indexing strategies.
3. Analyze and optimize slow-running queries to improve application performance.
4. Manage backup and recovery strategies using DB2 native tools or third-party solutions.
5. Implement and maintain database security, including access control and auditing.
6. Support data migration, replication, and integration efforts.
7. Troubleshoot and resolve database-related issues, including performance, availability, and data integrity.
8. Collaborate with developers to design efficient schemas and optimize SQL used in applications.
9. Maintain documentation for all DB2 database environments, including configurations, procedures, and standards.
10. Participate in disaster recovery planning and testing.

Requirement:
1. Strong expertise in DB2 LUW and/or z/OS.
2. Proficiency in SQL performance tuning and optimization techniques.
3. Experience with HADR, replication, and clustering technologies.
4. Familiarity with monitoring tools like IBM Data Studio, Tivoli, or other relevant platforms.
5. Knowledge of database design, normalization, and indexing.
6. Comfortable with OS platforms (AIX, Linux, Windows) and their integration with DB2.
7. Experience with DevOps tools, automation, or Infrastructure as Code is a plus.