Hiring: DB2 Database Administrator | 4-8 Years Experience
Location: Hyderabad
Experience: 4-8 Years
Shift Timings: Rotational Shifts
Work Mode: Work from Office (as applicable)
Roles & Responsibilities:
- Provide 24/7 production support for IBM Db2 LUW databases, ensuring high availability and reliability.
- Monitor database health, performance, and availability, and handle incidents, service requests, and problem management.
- Perform backup and recovery operations, including full, incremental, and point-in-time recovery.
- Execute server-to-server database restore activities ensuring data consistency and minimal downtime.
- Manage and support HADR (High Availability Disaster Recovery) environments (Primary/Standby).
- Perform planned and unplanned failover / takeover activities with minimal business impact.
- Troubleshoot HADR issues such as log gaps, replay delay, and synchronization problems.
- Analyze and resolve performance issues, including high CPU usage, I/O bottlenecks, and memory constraints.
- Identify and tune long-running and high-cost SQL queries for optimal performance.
- Perform index creation and optimization based on query requirements.
- Monitor and resolve locking, blocking, and deadlock situations.
- Execute regular database maintenance tasks, including RUNSTATS and REORG (table/index).
- Perform space management and storage optimization activities.
- Handle data movement utilities such as EXPORT, IMPORT, and LOAD.
- Develop and maintain automation scripts for routine database tasks and scheduling activities.
- Monitor db2diag logs and system metrics to detect issues proactively.
- Perform root cause analysis (RCA) and implement preventive measures for recurring issues.
- Support application teams with query tuning, performance improvements, and data-related issues.
- Coordinate with cross-functional teams during critical production incidents.
- Maintain documentation, runbooks, and standard operating procedures (SOPs) for database operations.