Description

You will manage and optimize large-scale PostgreSQL database infrastructure in a mission-critical environment.

Responsibilities

• Install, configure, and manage PostgreSQL on AWS Cloud infrastructure, including EC2 and RDS instances.
• Execute replication, switchover, and failover tasks using various replication tools.
• Perform backups, restores, and Point-in-Time Recovery (PITR) operations.
• Manage database maintenance including vacuuming and analyzing to improve query response times.
• Handle minor and major version upgrades and troubleshoot operational issues like CPU load, locking, long-running SQL, and disk space.

Required Skills

• 5+ years of experience working with PostgreSQL.
• Hands-on experience with AWS Cloud infrastructure, specifically EC2 and RDS.
• Deep understanding of PostgreSQL architecture, including memory components and internal processes.
• Experience managing high-volume transaction environments.
• Proficiency in SQL.
• Proficiency in Shell or Python scripting.
• Experience monitoring AWS clients using CloudWatch.
• Ability to manage large database infrastructure.

Preferred Skills

• Experience with MySQL or SingleStore.

Key Skills

Education

Any Graduate