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.