Senior Database Administrator - DB2

About the Role :

We are seeking an experienced Senior Database Administrator (DB2 LUW) to manage, maintain, and optimize enterprise-grade database environments. The ideal candidate should have strong expertise in DB2 LUW administration, database upgrades, high availability, disaster recovery, performance tuning, and cloud database management.

This role requires close collaboration with application teams, infrastructure teams, and business stakeholders to ensure database reliability, security, and scalability.

Key Responsibilities :

- Install, configure, patch, and upgrade DB2 LUW databases (v9.7 to v11.5) across Linux/Unix/Windows environments.

- Manage and support high availability and disaster recovery solutions including :

1. HADR

2. TSA

3. HACMP

4. Pacemaker clustering

Design and implement robust backup and recovery strategies :

1. Online/Offline backups

2. Point-in-Time Recovery (PITR)

3. Disaster Recovery planning/testing

Perform database performance tuning :

1. SQL query optimization

2 Index tuning

3. Execution plan analysis

4. Memory and storage optimization

5. Monitor database health, availability, and performance using DB2 monitoring tools.

- Troubleshoot production issues, deadlocks, locking/contention, replication issues, and performance bottlenecks.

- Manage database migrations, refreshes, and environment cloning activities.

- Support AWS cloud database infrastructure :

1. AWS RDS

2. EC2

3. Redshift

- Perform capacity planning, database housekeeping, reorg, runstats, and maintenance activities.

- Automate routine DBA tasks using Shell scripting and Linux tools.

- Collaborate with development teams for release deployments, schema changes, and production support.

- Maintain database security, user access controls, audit readiness, and compliance standards.

Required Skills :

- 8+ years of experience as a DB2 LUW DBA.

Strong expertise in :

- DB2 LUW 9.711.5

- Database installation/configuration/upgrades

- HADR, TSA, HACMP, Pacemaker

- Backup & Recovery strategies

- SQL tuning and optimization

Hands-on experience with DB2 utilities :

1. db2pd

2. db2diag

3. db2advisor

4. db2look

5. db2move

- Strong Linux/Unix administration knowledge.

- Proficiency in Shell scripting.

- Experience with AWS cloud services (RDS, EC2, Redshift).

- Strong troubleshooting and production support skills.

- Knowledge of Incident, Problem, and Change Management processes.