Information Technology · Full-time
Direct employerSoftware Engineer - Postgres Tooling

Published by employer
About this role
This plain-English summary was prepared by work.co.ug from the original advert. Confirm all details on the source before applying.
Role overview
Supabase is hiring a full-time Software Engineer - Postgres Tooling for its remote, global CLI team. The role involves co-maintaining pg-delta and developing safe, reliable PostgreSQL schema and migration tooling. It suits an experienced engineer with deep PostgreSQL knowledge who can work effectively in a fast-paced, asynchronous team.
Read full role
What you will do
- Co-maintain pg-delta by reviewing and merging changes, including AI-generated pull requests, and progress towards leading its maintenance.
- Protect correctness by investigating bug reports, fixing schema-diff and dependency-ordering problems, and expanding tests across PostgreSQL versions.
- Ensure generated migrations preserve privileges and do not silently lose data by identifying destructive changes and, where possible, converting them into safer alternatives.
- Help prepare pg-delta for a stable standalone 1.0 release, including its public API, semantic-versioning contract, documentation and support for more PostgreSQL extensions.
- Support the open-source community by assessing issues, reviewing external contributions and declining unsuitable requests appropriately.
- Coordinate with Supabase teams that use pg-delta, and write design documents and technical strategy for the tool.
- Join the CLI team's on-call rotation, with weekday follow-the-sun coverage.
Requirements
- At least 8 years of software engineering experience, including substantial hands-on PostgreSQL work.
- Detailed knowledge of PostgreSQL catalog internals, including pg_catalog, pg_depend, object ownership, grants, default privileges, RLS policies and extension membership.
- Strong understanding of DDL and migration behaviour, including locking, operations that cannot run within a transaction, dependency-based ordering and detection of destructive changes.
- A security-first approach that treats any migration which silently weakens access controls as a top-severity defect.
- Strong TypeScript skills and the ability to design correctness tests, such as differential, property-based or corpus tests across several PostgreSQL versions.
- Confidence handling compiler-style problems, including dependency graphs, topological ordering, cycles and diffing.
- Ability to review complex changes in a detailed codebase, including pull requests produced by AI agents.
- Experience owning production software, including staged releases, error monitoring and investigation of user-reported defects.
- Experience leading a technical project across several teams from an unclear starting point through to production.
- Clear written communication and the ability to work well in an asynchronous, globally distributed team.
- Preferred: experience building or maintaining schema-diff or migration tools such as migra, pg-schema-diff, Atlas, pgroll, sqitch, Prisma Migrate or Flyway/Liquibase, or working with pg_dump internals.
- Preferred: experience maintaining open-source software, including API contracts, semantic versioning, documentation and community issue management.
- Preferred: familiarity with PostgreSQL extensions such as pg_cron, pgmq, pg_partman, vault, pg_net, pgvector or PostGIS.
- Preferred: experience with Go.
- Preferred: contributions to PostgreSQL itself or authorship of a PostgreSQL extension.
- Preferred: experience using Supabase or another managed PostgreSQL platform.
Benefits
Benefits include fully remote and flexible asynchronous work, ESOP, a technology allowance, a WeWork membership or co-working allowance, and an annual education allowance. Supabase also covers 100% of employees' health insurance and 80% for dependants, and holds a company off-site once a year.
How to apply
Apply on the employer's application page. The employer has not published a closing date.