Description

Manage large-scale PostgreSQL environments, ensuring availability, performance, security, and disaster recovery for mission-critical applications.

This role is on-site.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases (v12+).
• Monitor and optimize database performance, query execution, and indexing strategies.
• Manage backup, recovery, replication, and high-availability solutions including Streaming Replication, Patroni, and PgBouncer.
• Troubleshoot production issues and provide L2/L3 support for database-related incidents.
• Automate routine DBA activities using Shell and Python scripts.

Required Skills

• 5+ years managing large-scale PostgreSQL environments.
• Expertise in performance tuning, query optimization, and index management.
• Proficiency in SQL, PL/pgSQL, Linux administration, and Shell scripting.
• Experience with PostgreSQL monitoring tools such as Prometheus and Grafana.
• Strong understanding of HA architectures, failover, and backup/recovery procedures.
• Familiarity with cloud-managed PostgreSQL services (AWS RDS/Aurora, Azure Database for PostgreSQL).

Preferred Skills

• Experience with CI/CD and containerized environments (Docker/Kubernetes).
• PostgreSQL certification.

Key Skills

Education

Any Graduate