Description

Role Overview
We are looking for an experienced PostgreSQL DBA with 5–8 years of database administration experience, including 5+ years managing large-scale PostgreSQL environments. The candidate will be responsible for ensuring database availability, performance, security, scalability, and disaster recovery for mission-critical applications.
Key Responsibilities
Install, configure, upgrade, and maintain PostgreSQL databases.
Monitor and optimize database performance, query execution, and indexing strategies.
Manage backup, recovery, replication, and high-availability solutions (Streaming Replication, Patroni, PgBouncer, etc.).
Perform database capacity planning, health checks, and proactive tuning.
Troubleshoot production issues and provide L2/L3 support.
Implement database security, user access controls, and compliance standards.
Automate routine DBA activities using Shell/Python scripts.
Collaborate with application, DevOps, and infrastructure teams for deployments and performance improvements.
Support PostgreSQL deployments on cloud platforms such as AWS, Azure, or GCP.

Skills
Required Skills
Strong hands-on experience with PostgreSQL Administration (v12+).
Expertise in Performance Tuning, Query Optimization, and Index Management.
Experience with Replication, Failover, Backup & Recovery, and HA architectures.
Proficiency in SQL, PL/pgSQL, Linux Administration, and Shell Scripting.
Experience with PostgreSQL monitoring tools (pgAdmin, Prometheus, Grafana, etc.).
Knowledge of cloud-managed PostgreSQL services (AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, etc.).
Familiarity with CI/CD and containerized environments (Docker/Kubernetes) is desirable.
Preferred Qualifications
Bachelor's degree in Computer Science, IT, or related field.
PostgreSQL certification is a plus.
Experience in Banking, Financial Services, Telecom, or Enterprise-scale environments preferred

Key Skills

Education

Any Graduate