IBM Db2 Database Administrator (Onsite) || Albany NY

DMS Vision • Frisco, NY

13h • Onsite

About The Position

The IBM Db2 Database Administrator maintains and troubleshoots multiple IBM Db2 databases, including LUW or z/OS environments. The role involves monitoring database health, managing storage and transaction logs, handling user access and security, tuning performance, implementing backup and recovery strategies, and maintaining technical and compliance documentation. The position is onsite in Albany, New York; relocation is acceptable.

Responsibilities

• Perform maintenance and troubleshoot multiple IBM Db2 databases (LUW or z/OS), diagnosing and resolving utility failures, locking conflicts, buffer pool problems, and catalog inconsistencies.
• Monitor Db2 databases using tools such as Db2 Monitoring Console, db2pd, db2top, and system views; check for lock escalations, deadlocks, long-running applications, failed updates, and tablespace utilization.
• Manage Db2 tablespaces, containers, storage groups, and transaction logs, including log growth, log archiving, and recovery configurations (LOGARCHMETH1/2).
• Manage Db2 logins, roles, and privileges, and configure authentication and authorization using Db2 security or external systems such as LDAP and Kerberos.
• Tune performance through index design, buffer pool tuning, RUNSTATS, REORG, package and application tuning, and configuration parameter adjustments.
• Implement and manage Db2 backup and recovery strategies using online backups, rollforward recovery, or HADR environments.
• Maintain documentation of Db2 configurations, maintenance routines, troubleshooting history, and compliance procedures.

What This Job Offers

• Education Level: No Education Listed