Site Reliability Engineer: Postgres

View full description

Requirements:

• Experience in designing multi-tenant database solutions, designing for failover, fault-tolerance, and disaster recovery
• Experience with orchestrating stateful workloads at scale or having used a Postgres operator like the ones from Zalando or Crunchy is a plus
• Experience with tools in the Postgres ecosystem like pgbackrest, barman, Patroni, Stolon, etc
• 5+ years experience in SRE/DevOps/Cloud Infrastructure
• 3+ years of experience in building with Golang
• Experience in managing large deployments on AWS
• Knowledge of networking
• Experience with Infrastructure as Code tools

Responsibilities:

• Help build the Supabase Postgres offering.
• Focus on improving the reliability of database backups and recovery
• Implement high availability with minimal downtime failover
• Help operationalize database management for our users by implementing maintenance windows, blue-green deployments as part of database upgrades, etc.
• Help users self serve debug their databases by improving database observability
• Improve the performance of provisioned Postgres databases and expose knobs for our users to further tune their database performance
• Improve our system architecture to reduce costs while balancing security and performance.
• Design CI/CD systems to speed up deployments with proper change and release management processes.
• Escalated storage support tickets and sharing the on-call responsibility for the storage service.