DB2 DBA

Educational Qualification : BE / B.Sc / M.Sc / Any Graduate

Desirable : IBM DB2 , PostgreSQL expertise

Business/ Technical Skills Sets

Essential :

1. DB2, PostgreSQL Additional - Mongo and MS SQL . Project Management Database (DB2/MSSQL/PostgreSQL/mongoDB)

2. Administration: Key Skills :

3. IBM DB2 Database, PostgreSQL, MS SQL , MongoDB Administration

4. Troubleshooting and L3 level support

5. Database Performance Tuning and Optimization

6. Backup and Recovery Strategies

7. Database Security and Access Control

8. High Availability and Disaster Recovery

9. SQL Query Optimization

10. Capacity Planning and Resource Management

11. Shell Scripting (Bash, PowerShell)

12. Monitoring and Alerting Tools (e.g., I, DB2 Performance Monitor)

13. Project Planning and Management

14. Risk Management and Mitigation

Desirable : Knowledge for AIX, Linux, Scripting, storage etc

Job Profile Responsibility

1. Review of database architecture and configuration parameters. Monitor the database buffer cache, hit ratio, cpu utilization, and memory utilization.

2. Identify bad performing queries and give it to the Application team for tuning.

3. Responsible for routine database maintenance tasks such as index rebuilds, statistics updates, and table reorganizations to improve performance. Additional, Make necessary recommendations to improve overall performance.

4. capacity planning and resource forecasting to support future growth and scalability needs.

5. Worked closely with development teams to optimize SQL queries and improve application performance.

6. Responsible to achieve maximum uptime for production Database server and reduce unplanned downtime.

7. Monitoring the database for capacity availability w.r.t. Disk capacity, tablespace capacity etc.

8. Implementation of service packs and hot fixes for security and performance improvement.

9. DR readiness and drills.

10. VAPT , CIS Hardening , Patches management

11. High availability , Sync and Asyn logs based replication , etc.

12. Troubleshoot and resolve database-related issues L3 level support