IBM Db2 Database Administrator (Onsite) || Albany NY
DMS Vision•Frisco, AL
•Onsite
About The Position
The IBM Db2 Database Administrator maintains and troubleshoots multiple IBM Db2 databases on LUW or z/OS. The role monitors database health and performance, manages storage and transaction logs, administers access and security, tunes performance, and implements backup and recovery strategies. It also maintains documentation of database configurations, maintenance routines, troubleshooting history, and compliance procedures.
Responsibilities
- Perform maintenance and troubleshoot multiple IBM Db2 databases on LUW or z/OS.
- Diagnose and resolve Db2 issues, including utility failures, locking conflicts, buffer pool problems, and catalog inconsistencies.
- Monitor 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.
- Manage log file growth, log archiving, and recovery configurations such as 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 backup and recovery strategies using online backups, rollforward recovery, or HADR environments.
- Maintain documentation of Db2 configurations, maintenance routines, troubleshooting history, and compliance procedures.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Education Level
No Education Listed
