PostgreSQL Database Admin

Responsibility -

1. 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

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

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

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

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

8. Performance monitoring and tuning

9. Hardening of databases

10.DB object creation / modification / deletion / updating and Data Sync

11.Review SRs and Incidents

12.Review of database activities done on daily basis

13.Review reports for backups/health/resources

14.Improvement plan for performance

15.Performance analysis and reporting

16.Preparing and review SOPs for all activities

17.Patch Management

18.DR shifting activity

19.SLA Compliance

20.Replication Setup and Configuration

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.