Job Description

Job Title:

PostgreSQL Database Administrator (DBA)

Location:

Delhi

Job Type:

Full-Time

Experience Required:

3-5 Years

Job Summary:

We are looking for a talented and experienced

PostgreSQL DBA

to join our growing IT team. The ideal candidate will be responsible for the performance, integrity, and security of our PostgreSQL databases. This role involves development support, performance tuning, backup strategies, and ensuring high availability and disaster recovery capabilities.

Key Responsibilities:

Install, configure, upgrade, and maintain PostgreSQL database servers. Monitor database performance and implement tuning strategies. Ensure high availability and disaster recovery using tools like replication, backup, and clustering. Perform regular database backups and recovery tests. Manage database security, including user roles, permissions, and auditing. Optimize queries and indexes to enhance application performance. Automate routine database tasks using scripting (Bash, Python, etc.). Work closely with development and DevOps teams to support CI/CD workflows. Troubleshoot and resolve database-related issues in a timely manner. Document database configurations, processes, and best practices.

Required Skills and Qualifications:

3-5 years of hands-on experience as a PostgreSQL DBA. Strong knowledge of PostgreSQL internals, performance tuning, and query optimization. Experience with backup and recovery strategies (pg_dump, pg_basebackup, etc.). Familiarity with PostgreSQL replication (streaming, logical, etc.). Strong SQL skills and experience with stored procedures/functions. Experience in database monitoring tools (like pg_stat_statements, pgBadger, or similar). Working knowledge of Linux/Unix systems. Experience with scripting languages like Bash, Python, or Perl. Proficiency in Git and version control systems.

Preferred Qualifications:

Experience with cloud-based PostgreSQL (e.g., AWS RDS, Azure Database for PostgreSQL, Google Cloud SQL). Familiarity with containerized environments (Docker, Kubernetes). Exposure to automation/configuration tools (Ansible, Terraform, etc.). Knowledge of other databases (MySQL, MongoDB, etc.) is a plus. Experience working in Agile/Scrum environments.
Job Type: Full-time

Schedule:

Day shift Morning shift
Work Location: In person