About the job
Supabase is the ultimate Postgres development platform, crafted by developers for developers. We deliver a comprehensive backend solution encompassing Database, Authentication, Storage, Edge Functions, Realtime capabilities, and Vector Search. Our services are intricately integrated, designed to support your growth.
About the Role
We are seeking a Senior Postgres Engineer to join our dedicated Postgres Team. In this role, you will play a vital part in upholding and enhancing the stability and functionality of our hosted Postgres services. Collaborating closely with customers, partners, product teams, engineering, support, and success teams, you will help us maintain a secure, stable, and high-performance Postgres foundation.
This position is perfect for someone who thrives in asynchronous, fast-paced environments and is enthusiastic about developing tools that can scale to serve millions of users.
Your Responsibilities:
- Develop and maintain PostgreSQL extensions using C and Rust, with a thorough grasp of internal mechanisms such as the parser, planner, WAL, and MVCC.
- Identify and resolve issues in managed PostgreSQL deployments, including custom extension failures, core dump analysis, and performance bottlenecks.
- Oversee idempotent deployment pipelines across thousands of running PostgreSQL instances, including testing and rollout strategies.
- Manage complex extension ecosystems, ensuring compatibility, upgrade paths, and conflict resolution.
- Utilize PostgreSQL's background worker framework, shared memory management, and hook system to develop reliable, scalable functionality.
- Work closely with cross-functional teams to ensure a secure, stable, and performant Postgres foundation.
Qualifications:
- Extensive knowledge of PostgreSQL internals, including query planner, executor, and storage engine mechanics.
- Demonstrated experience in building PostgreSQL extensions with C and Rust.
- In-depth understanding of PostgreSQL's permission model, including RLS, roles, and grant systems.
- Experience troubleshooting issues in managed PostgreSQL environments, including custom extensions and performance bottlenecks.
- Proficient in building, testing, and managing idempotent deployments across numerous PostgreSQL instances.
- Ability to navigate and comprehend PostgreSQL source code effectively.

