Description

You will manage and maintain mission-critical PostgreSQL database infrastructure, ensuring high availability and performance for large-scale, multi-terabyte systems.

This role is on-site.

Responsibilities

• Administer and troubleshoot daily database operations, resolving performance issues such as locks, blocking, and long-running SQL queries.
• Execute database upgrades for minor and major PostgreSQL versions across production environments.
• Implement and manage database replication and point-in-time recovery strategies to ensure data durability.
• Perform routine maintenance tasks on large, multi-terabyte databases supporting high-volume transactions.

Required Skills

• 5+ years of experience administering large-scale PostgreSQL databases.
• Strong knowledge of PostgreSQL architecture and configuration parameters.
• Hands-on experience with backup, restore, and high-availability solutions including Repmgr and Pgpool.
• Experience deploying and managing PostgreSQL in cloud environments (AWS RDS/EC2, GCP).
• Proficiency with Kubernetes or other containerization technologies.
• Expertise in monitoring load average, locks, and blocking within PostgreSQL.
• Familiarity with common PostgreSQL system tables and multi-terabyte database administration.

Key Skills

Education

Any Gradute