Database Management

Manage the availability, performance, and security of PostgreSQL databases across Data Center and Disaster Recovery environments.

Implement and maintain High Availability (HA) and Disaster Recovery (DR) solutions including replication and failover.

Perform database backup, recovery, and Point-in-Time Recovery (PITR) with regular restore testing.

Monitor database health and performance using tools such as Prometheus and Grafana, and resolve performance issues.

Optimize database performance through query tuning, indexing, partitioning, and parameter optimization.

Collaborate with application and development teams to manage database schema changes and deployments.

Ensure database security, access control, encryption, and audit logging are properly implemented

Minimum 2 years of experience managing PostgreSQL databases in production environments.

Strong knowledge of PostgreSQL administration, replication, backup, and recovery.

Experience with database performance tuning and query optimization.

Familiar with monitoring tools (Prometheus, Grafana) and backup tools such as pgBackRest, Barman, or similar.

Comfortable working in Linux environments and basic scripting (Bash or Python).

Experience with connection pooling and routing tools such as PgBouncer or HAProxy.

Strong understanding of SQL, relational database concepts, and transaction management.

Good documentation, problem-solving, and communication skills.