Supabase Logo

Supabase

Software Engineer - Postgres Tooling

Posted Yesterday
In-Office or Remote
Hiring Remotely in United Kingdom
Senior level
In-Office or Remote
Hiring Remotely in United Kingdom
Senior level
Maintain and lead pg-delta, Supabase’s PostgreSQL schema diff and migration engine. Responsibilities include fixing dependency-ordering and correctness bugs, preventing destructive or privilege-unsafe migrations, expanding PostgreSQL version and extension coverage, reviewing contributions, developing tests, writing technical strategy, collaborating across teams, and participating in on-call support. The role requires deep PostgreSQL internals knowledge, strong TypeScript skills, production software ownership, and experience leading technical projects.
The summary above was generated by AI
About Supabase

Supabase is the Postgres development platform, built by developers for developers. We provide a complete backend solution including Database, Auth, Storage, Edge Functions, Realtime, and Vector Search. All services are deeply integrated and designed for growth.


About the Role

We’re looking for a Software Engineer, Postgres Tooling to join our CLI team and help build the open-source tools developers use to change their Postgres schemas safely. You’ll join as a co-maintainer of pg-delta, our schema diff and migration engine, and grow into leading it.

Given two databases, or a database and a folder of SQL files describing the schema you want, pg-delta works out the differences and generates the migration to get from one to the other. It powers supabase db diff, db pull, and declarative schemas, and it runs underneath Supabase’s platform, branching, and AI agent workflows. Every migration it generates is verified on a throwaway clone before it’s trusted, and it’s tested against 331 scenarios on PostgreSQL 14–18. We’re now working toward a stable, standalone 1.0 release for any Postgres developer, on Supabase or not.

This is a correctness-first role. The SQL this tool generates runs against production databases, so privilege safety and avoiding data loss are non-negotiable. It’s a great fit for someone who loves Postgres at the catalog level, enjoys compiler-style problems, and thrives in async, fast-paced environments.

What You’ll Be Responsible For

In this role, you’ll:

  • Co-maintain pg-delta: review and merge changes, including PRs written by AI agents, and grow into its lead maintainer.

  • Own correctness: triage bug reports from GitHub and support, fix diff and dependency-ordering bugs, and extend test coverage across Postgres versions.

  • Make sure generated migrations are privilege-safe and never silently lose data, by detecting destructive changes and rewriting them into safe equivalents where possible.

  • Help take pg-delta to a stable 1.0: a public API with a semver contract, documentation, and broader coverage of Postgres extensions.

  • Work with the open-source community: triage issues, review outside contributions, and say no gracefully when a request doesn’t fit.

  • Work with the teams across Supabase that build on pg-delta, so migrations are generated and run the same way everywhere.

  • Write the design docs and technical strategy that set the tool’s direction, working async across teams.

  • Share the CLI team’s on-call rotation. Weekdays are covered follow-the-sun, and because we ship packaged software that users can roll back, pages are rare.

You Might Be a Good Fit If You

Must have:

  • Have 8+ years of experience as a software engineer, including deep, hands-on work with PostgreSQL.

  • Know Postgres internals at the catalog level: pg_catalog, pg_depend, object ownership, grants and default privileges, RLS policies, and extension membership.

  • Understand DDL and migration semantics: which changes take locks, which can’t run inside a transaction, how dependencies determine ordering, and how to spot a destructive change.

  • Treat a migration that silently loosens access as a top-severity bug.

  • Write strong TypeScript, and design tests for correctness, such as differential, property-based, or corpus testing across multiple Postgres versions.

  • Are comfortable with compiler-style problems: dependency graphs, topological ordering, cycle handling, and diffing.

  • Can confidently review complex changes in an intricate codebase, including AI-generated PRs.

  • Have owned software in production with users in the loop: staged rollouts, error monitoring, and triaging real bug reports.

  • Have led a technical project across several teams, from an ambiguous start to production.

  • Communicate clearly in writing and thrive in async, globally distributed teams.

Nice to have, roughly in order of how much they’d help:

  • Have built or maintained schema diff or migration tooling (such as migra, pg-schema-diff, Atlas, pgroll, sqitch, Prisma Migrate, or Flyway/Liquibase), or worked with pg_dump internals.

  • Open-source maintainer experience: API contracts, semver, documentation, and community triage.

  • Familiarity with Postgres extensions such as pg_cron, pgmq, pg_partman, vault, pg_net, pgvector, or PostGIS.

  • Experience with Go.

  • Contributions to Postgres itself, or authorship of a Postgres extension.

  • Experience with Supabase or another managed Postgres platform.

What We Offer
  • Fully Remote

    We hire globally. We believe you can do your best work from anywhere. There are no Supabase offices, but we provide a WeWork membership or co-working allowance you can use anywhere in the world.

  • ESOP

    Every team member receives ESOP (equity ownership) in the company. We want everyone to share in the upside of what we’re building together.

  • Tech Allowance

    Use this budget to set up your ideal work environment—laptop, monitor, headphones, or whatever helps you do your best work.

  • Health Benefits

    Supabase covers 100% of health insurance for employees and 80% for dependents, wherever you are. Your wellbeing and your family’s health are important to us.

  • Annual Off-Sites

    Once a year, the entire company gathers in a new city for a week of connection, collaboration, and fun. It’s a highlight of our year.

  • Flexible Work

    We operate asynchronously and trust you to manage your own time. You know what needs to be done and when.

  • Professional Development

    Every team member receives an annual education allowance to spend on learning—courses, books, conferences, or anything that supports your growth.

About the Team

Supabase was born-remote and open-source-first. We believe our globally distributed team is our secret weapon in building tools developers love.

  • ~400 team members

  • 60+ countries

  • 20+ languages spoken

  • Over $1B raised (including our $500M Series F)

  • 540,000+ community members

We move fast, build in public, and use what we ship. If it’s in your project, we probably use it in ours too. We believe deeply in the open-source ecosystem and strive to support—not replace—existing tools and communities.

Similar Jobs

54 Minutes Ago
Easy Apply
Remote or Hybrid
Easy Apply
Mid level
Mid level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Leads project-based customer adoption engagements for Samsara’s technical products, APIs, integrations, and AI capabilities. The role researches customer workflows, designs practical solutions, manages milestones, troubleshoots complex issues, and communicates technical concepts to diverse audiences. It also enables Account Managers through training and documentation, collaborates with Support, Product, and Engineering, and creates scalable playbooks. Candidates need 3–5+ years in customer-facing technical roles, strong project management and communication skills, and familiarity with Salesforce, Gainsight, Gong, or similar tools.
Top Skills: AIAPIsGainsightGongIntegrationsIotSaaSSalesforce
59 Minutes Ago
Easy Apply
Remote
Easy Apply
Entry level
Entry level
Big Data • Fintech • Mobile • Payments • Financial Services
Build and maintain customer-facing refund features, backend services, APIs, and data foundations. Collaborate with engineers and stakeholders to deliver reliable, well-tested software, balance speed and quality, communicate risks, participate in code reviews, debug large codebases, and support work from design through on-call. Contribute to team development and continuous learning.
Top Skills: KotlinPythonReactVue
An Hour Ago
Remote or Hybrid
Senior level
Senior level
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Lead risk-based third-party security assessments from scoping through evidence review, risk analysis, documentation, and recommendations. Evaluate vendors, products, integrations, data handling, access controls, cloud and on-premises deployments, and AI features. Review SOC 2, ISO 27001, penetration testing, and questionnaire evidence; identify gaps, coordinate mitigations, triage incidents, and escalate risks. Improve assurance processes, reporting, automation, and playbooks while mentoring teammates and collaborating with Security, Privacy, Legal, Procurement, and business stakeholders.
Top Skills: APIsCloud ComputingGripIdentity And Access ManagementIso 27001JIRANistOauthOnetrustOpenid ConnectPci DssSAMLService AccountsSoc 2 Type IiSsoZip

What you need to know about the Edinburgh Tech Scene

From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account