Description

You will administer and maintain IBM Db2 databases across LUW or z/OS environments.

Responsibilities

• Troubleshoot and maintain multiple IBM Db2 databases, resolving issues like locking conflicts, buffer pool problems, and catalog inconsistencies.
• Monitor Db2 databases using tools such as Db2 Monitoring Console, db2pd, and db2top, checking for deadlocks and utilization issues.
• Manage Db2 tablespaces, containers, storage groups, and transaction logs, including log archiving and recovery configurations.
• Configure and manage Db2 logins, roles, and privileges using built-in security or external systems like LDAP/Kerberos.
• Optimize Db2 performance by tuning indexes, running RUNSTATS, and adjusting configuration parameters.

Required Skills

• 5+ years of experience as a Database Administrator.
• Expertise with IBM Db2.
• Experience with Db2 utilities and monitoring tools (db2pd, db2top).
• Proficiency in Db2 performance tuning, including index design and buffer pool adjustments.
• Experience managing Db2 security models (roles, privileges, LDAP/Kerberos).
• Knowledge of Db2 log management and recovery configurations (LOGARCHMETH1/2).

Key Skills

Education

Any Gradute