In short
Database administrator in Hyderabad providing 24/7 production support for IBM Db2 LUW databases: monitoring health and performance, running backups and point-in-time recoveries, managing HADR primary/standby failovers, tuning SQL, and automating routine DB tasks on rotational shifts from the office.
About the role
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.