Description

You will manage and maintain high-volume, multi-terabyte PostgreSQL database infrastructure.

Responsibilities

• Troubleshoot performance issues, including load average, locks, blocking, and long-running SQL queries.
• Perform day-to-day operational tasks and maintenance for PostgreSQL instances.
• Manage database backups, restores, and version upgrades (minor and major).
• Implement and maintain database replication and point-in-time recovery strategies.
• Build and support large database infrastructure to handle high transaction volumes.

Required Skills

• 10+ years of experience administering multi-terabyte PostgreSQL databases.
• Expert knowledge of PostgreSQL architecture and configuration parameters.
• Hands-on experience with PostgreSQL replication technologies (e.g., Repmgr, pgpool, efm).
• Experience deploying and managing PostgreSQL in cloud environments (AWS RDS/EC2 or GCP).
• Proven ability to troubleshoot database performance bottlenecks.
• Proficiency with PostgreSQL system tables and common maintenance tasks.
• Strong aptitude for independently learning new database technologies.
• Experience working across technical and business teams.

Key Skills

Education

Any Gradute