About the Role :

We are seeking an experienced and detail-oriented PostgreSQL Database Administrator (DBA) with over 7 years of hands-on experience in managing PostgreSQL database environments.

The ideal candidate will be responsible for the performance, integrity, and security of our databases, as well as involved in planning and development, troubleshooting, and ensuring 24/7 availability of critical systems.

Key Responsibilities :

- Design, install, configure, and maintain PostgreSQL databases in production and development environments.

- Perform routine database maintenance tasks including backups, restores, upgrades, and patching.

- Monitor database performance and implement tuning recommendations to optimize queries and overall system efficiency.

- Ensure high availability and disaster recovery using tools like streaming replication, logical replication, and failover mechanisms.

- Implement database security and access controls in alignment with industry best practices.

- Conduct performance analysis and capacity planning to support business growth.

- Collaborate with application development teams to support schema design, indexing, and query optimization.

- Automate database tasks using scripting languages (e.g., Shell, Python, Ansible).

- Create and maintain comprehensive documentation related to system architecture, processes, and procedures.

- Support and troubleshoot database-related issues in a timely manner, including on-call support.

Required Skills & Qualifications :

- Bachelors degree in Computer Science, Information Technology, or related field.

- 7+ years of experience as a PostgreSQL DBA in a production environment.

- Deep understanding of PostgreSQL internals, replication, partitioning, and indexing.

- Proficient in writing complex SQL queries, PL/SQL functions, and stored procedures.

- Experience with backup and recovery tools such as basebackup, dump, BackRest, or Barman.

- Hands-on experience with monitoring tools like stat statements, Prometheus, Grafana, or ELK stack.

- Strong knowledge of Linux/Unix environments and shell scripting.

- Familiarity with cloud platforms such as AWS, Azure, or GCP, especially RDS and managed PostgreSQL services.

- Experience with automation and configuration management tools (e.g., Ansible, Terraform) is a plus.

- Excellent analytical and problem-solving skills.

- Strong communication and collaboration abilities