PostgreSQL Database Administrator - Installation & Maintenance

Role Overview :

We are seeking a highly experienced PostgreSQL Database Administrator who will be responsible for the end-to-end management of PostgreSQL and other RDBMS environments. The ideal candidate should have a strong foundation in database architecture, performance optimization, high availability, and data security. This is an on-site role based in Bhopal, with opportunities to work on large-scale and mission-critical systems for global clients.

Key Responsibilities :

- Set up and configure high-availability architectures (e.g., replication, clustering, failover).

- Analyze slow queries, identify performance bottlenecks, and fine-tune PostgreSQL databases.

- Optimize schema design, indexing strategies, and SQL queries to improve overall efficiency.

- Design and implement comprehensive backup and recovery strategies using tools like pg_basebackup, pg_dump, and third-party solutions.

- Ensure data integrity and availability through disaster recovery planning and testing.

- Proactively monitor database health, logs, and performance metrics.

- Utilize tools such as pgAdmin, Zabbix, Prometheus, or Nagios for proactive monitoring and alerting.

- Investigate and resolve issues related to database locks, replication lag, and deadlocks.

- Plan and execute database upgrades, migrations, and patching with minimal downtime.

- Migrate data between different RDBMS platforms (e.g., Oracle to PostgreSQL or MySQL to PostgreSQL).

- Collaborate with development, DevOps, and infrastructure teams to support application requirements.

- Create and maintain standard operating procedures, configuration documentation, and knowledge base articles.

Key Skills & Requirements :

- Proficiency in managing and tuning MSSQL, MySQL, MariaDB, and Oracle databases.

- Backup & recovery strategies

- High availability and replication (streaming, logical, etc.)

- Database security and access control

- Partitioning and indexing techniques

- Strong command of SQL, PL/pgSQL, and scripting for automation (Shell, Python).

- Experience working with large-scale databases and high-concurrency environments.

- Familiarity with tools like pgBouncer, Patroni, pgBackRest, pgAudit is a plus.

- Understanding of cloud database services (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL) is a plus.