Description

You will administer and optimize production PostgreSQL environments, ensuring high availability and performance.

This role is on-site.

Responsibilities

• Manage database performance tuning and query optimization for production systems.
• Implement and maintain backup and recovery procedures, including Point-in-Time Recovery (PITR).
• Configure and manage replication setups (Streaming/Logical) and High Availability (HA) failover.
• Administer Linux operating systems supporting PostgreSQL instances.
• Monitor database health and performance using relevant tools.

Required Skills

• 5–8 years of hands-on experience as a PostgreSQL Administrator managing production environments.
• Expertise in PostgreSQL Administration, Database Performance Tuning, and Query Optimization.
• Proficiency in setting up and managing Replication (Streaming/Logical) and HA/Failover.
• Experience with Linux Administration.
• Familiarity with monitoring tools like pgAdmin or pgBadger.
• Experience with Shell or Python for scripting and automation.
• Experience with PostgreSQL database migration.

Preferred Skills

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Familiarity with Prometheus and Grafana for monitoring and alerting.
• Knowledge of database security, auditing, and compliance.

Key Skills

Education

Any Gradute