IBM DB2 DBA

Albany, GA - USA

Monthly Salary: Not Disclosed

Posted on: 19 hours ago

Vacancies: 1 Vacancy

Job Summary

Position: IBM DB2 DBA

Location: Albany NY*Day 1 Onsite

Duration: 1 Years

BM Db2 Database Administrator Job Details
Troubleshooting & Maintenance:
Perform maintenance and troubleshooting for multiple IBM Db2 databases (LUW or z/OS). Diagnose and resolve Db2-specific issues such as utility failures locking conflicts buffer pool problems and catalog inconsistencies.
Database Monitoring:
Regularly monitor Db2 databases using tools like Db2 Monitoring Console db2pd db2top and system views. Check for lock escalations deadlocks long-running applications failed updates and tablespace utilization.
Data & Log File Management:
Oversee Db2 tablespaces containers storage groups and transaction logs. Manage log file growth log archiving and recovery configurations (LOGARCHMETH1/2).
User Access & Security:
Manage Db2 logins roles and privileges. Configure authentication and authorization using Db2s built-in security model or external systems (LDAP Kerberos).
Performance Tuning:
Optimize Db2 performance through index design buffer pool tuning RUNSTATS REORG package/application tuning and configuration parameter adjustments.
recovery:
Implement and manage Db2 backup and recovery strategies using online/backups rollforward recovery or HADR environments.
Documentation & Compliance:
Maintain detailed documentation of Db2 configurations maintenance routines troubleshooting history and compliance procedures

Position: IBM DB2 DBA Location: Albany NY*Day 1 Onsite Duration: 1 Years BM Db2 Database Administrator Job Details Troubleshooting & Maintenance: Perform maintenance and troubleshooting for multiple IBM Db2 databases (LUW or z/OS). Diagnose and resolve Db2-specific issues such as utility fa...