PostgreSQL Database Administrator (DBA)

Job Title: PostgreSQL Database Administrator (DBA)

Location - GA Onsite

Duration :6-12 months

Job Summary:

We are seeking a skilled PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize our PostgreSQL database environments. The ideal candidate will ensure the availability, performance, and security of mission-critical databases across development, testing, and production environments. This role requires deep technical expertise in PostgreSQL database administration, backup and recovery, performance tuning, and high availability solutions.

Key Responsibilities:

• Install, configure, and maintain PostgreSQL database servers across environments.
• Monitor database performance, implement tuning, and optimize queries for performance.
• Set up and manage database security, including user roles and permissions.
• Perform regular backup and recovery operations, ensuring business continuity and disaster recovery.
• Implement and manage high availability (HA), replication, and failover solutions (e.g., streaming replication, Patroni).
• Develop and maintain database documentation, including ER diagrams, data dictionaries, and SOPs.
• Collaborate with development and DevOps teams to support schema design, indexing strategies, and deployment automation.
• Diagnose and troubleshoot complex database-related issues and incidents.
• Participate in capacity planning and scaling strategies for growing data needs.
• Apply PostgreSQL patches, upgrades, and maintain version control across environments.
• Support database migration initiatives (on-prem to cloud or between PostgreSQL versions).
• Ensure compliance with internal and external data privacy and security policies.

Required Skills and Qualifications:

• 5+ years of experience in PostgreSQL database administration in production environments.
• Strong knowledge of PostgreSQL internals, architecture, and administration best practices.
• Experience with backup/recovery tools (e.g., pgBackRest, Barman, WAL-G).
• Proficient in writing complex SQL and PL/pgSQL queries and scripts.
• Familiarity with monitoring tools such as pg_stat_statements, pgAdmin, or third-party solutions like Zabbix, Prometheus, or Grafana.
• Experience with Linux/Unix-based systems and shell scripting.
• Understanding of replication, clustering, and high availability frameworks (e.g., Patroni, pgpool-II).
• Familiarity with cloud platforms such as AWS RDS/Aurora, Google Cloud SQL, or Azure Database for PostgreSQL.
• Hands-on experience with version control (e.g., Git), CI/CD pipelines, and automation tools.

Preferred Qualifications:

• Bachelor s degree in Computer Science, Information Systems, or a related field.
• Experience with other databases (e.g., MySQL, Oracle, SQL Server) is a plus.
• Experience with PostgreSQL in Kubernetes or containerized environments (e.g., using Helm, CrunchyData).
• Certification in PostgreSQL (e.g., from EDB or other accredited programs).
• Familiarity with data governance, security audits, and compliance (HIPAA, GDPR, etc.).