Description

You will manage and maintain our mission-critical Postgres database infrastructure.

Responsibilities

• Administer and troubleshoot daily database operations, focusing on performance issues like locks, blocking, and long-running SQLs.
• Execute database upgrades for minor and major PostgreSQL versions.
• Implement and manage database replication and point-in-time recovery strategies.
• Perform routine maintenance tasks on large, multi-terabyte databases.
• Build and maintain large database infrastructure supporting high-volume transactions.

Required Skills

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

Key Skills

Education

Any Gradute