PostgreSQL Dba (Bhopal)

We are seeking a highly skilled and motivated PostgreSQL Database Administrator to manage our PostgreSQL database instances and related infrastructure. The DBA will be responsible for monitoring, maintaining, and optimizing PostgreSQL database performance, focusing on leveraging PostgreSQL statistics and other tools to ensure optimal performance and uptime. Key Responsibilities: - Database Management: - Oversee the installation, configuration, and management of multiple PostgreSQL database instances. - Manage database clusters across various servers, ensuring high availability, fault tolerance, and redundancy. - Performance Monitoring: - Regularly monitor PostgreSQL system performance using tools like pg_stat_activity, pg_stat_statements, and other PostgreSQL system views. - Monitor key performance indicators (KPIs) such as query execution time, disk I/O, CPU utilization, memory usage, and cache hit ratios. - Optimization: - Identify slow queries, bottlenecks, and performance issues by analyzing system statistics. - Optimize database performance through query tuning, indexing strategies, partitioning, and configuration adjustments (e.g., adjusting shared buffers, work_mem, maintenance_work_mem, etc.). - Propose and implement index optimization, table partitioning, and other techniques to enhance performance. - Maintenance and Upgrades: - Manage routine maintenance tasks such as database backups, restores, vacuuming, and reindexing. - Ensure databases are regularly vacuumed and analyzed to prevent bloat and maintain statistics accuracy. - Plan and perform PostgreSQL version upgrades and patches. - Security and Compliance: - Ensure database security by managing access controls, user permissions, and roles. - Monitor for unauthorized access and ensure compliance with data protection regulations. - Implement and maintain data encryption, replication, and disaster recovery strategies. - Automation and Scripting: - Automate database monitoring and maintenance tasks using .