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
Database Administration
Install, configure and upgrade DB2.
Create/manage database objects.
Configure instances, storage and settings.
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