Role & responsibilities

Role Summary

Job Title: DB2 Database Administrator / DB2 DBA
Primary Skill: IBM DB2
Experience: Typically suitable for 6 years of DB2 DBA experience, depending on the client requirement.

Mandatory Skills

- IBM DB2 LUW Linux / UNIX / Windows
- DB2 Database Administration
- DB2 Instance & Database Configuration
- Tablespaces & Storage Groups
- Buffer Pools
- Schemas, Tables, Indexes, Views
- DB2 Logs & Transaction Management
- Package Cache & Memory Management
- DB2 HADR
- Failover & Switchover
- Backup & Recovery
- Performance Tuning
- SQL Execution Plans
- Query & Index Optimization
- Locking, Blocking & Deadlock Troubleshooting
- Database Monitoring
- User & Privilege Management
- RBAC
- Database Encryption
- SSL/TLS
- Auditing & Compliance
- Disaster Recovery / Business Continuity

Positive-to-Have / Additional Skills

- DB2 PureScale
- Replication technologies
- DR drills
- RPO / RTO
- Archived log management
- Production database support




- Infrastructure/application team coordination

Key Responsibilities

1. Database Administration
- Install, configure and upgrade DB2.
- Create/manage database objects.
- Configure instances, storage and environments.

- Performance Tuning

- Analyze DB2 performance.
- Review SQL execution plans.
- Tune queries, indexes and database parameters.
- Resolve locks, blocks and deadlocks.

- Backup & Recovery

- Implement backup strategies.
- Perform restoration and recovery.
- Manage archived logs.
- Conduct recovery testing.

- HADR / DR

- Configure and maintain DB2 HADR.
- Perform failover/switchover.
- Participate in DR drills.
- Support RPO/RTO requirements.

- Security

- Manage DB2 users and privileges.
- Implement authentication and authorization.
- Configure encryption and SSL/TLS.
- Support audits and access reviews.

📌 Database Administrator (Bengaluru)
🏢 Cerebra
📍 Bengaluru