Supabase Logo

Supabase

Software Engineer - Postgres Tooling

Posted Yesterday
In-Office or Remote
Hiring Remotely in United States
Senior level
In-Office or Remote
Hiring Remotely in United States
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

3 Hours Ago
Easy Apply
Remote or Hybrid
Easy Apply
78K-101K Annually
Mid level
78K-101K Annually
Mid level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Manage strategic customer relationships after implementation, creating success plans, conducting executive business reviews, leading workshops, supporting French-speaking implementations, and advising customers on Samsara’s IoT platform. Collaborate with Sales, Support, Engineering, and Product to solve problems, drive adoption, remove barriers, and deliver measurable operational value. Mentor Customer Success and Support teams while promoting customer-focused company principles.
Top Skills: IotSaaSSamsara Connected Operations Cloud
3 Hours Ago
Easy Apply
Remote or Hybrid
Easy Apply
143K-185K Annually
Senior level
143K-185K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect, develop, debug, test, deploy, and support customer-facing firmware features in C/C++ and Golang for cloud-connected hardware. Build observability and rollout metrics for more than 1.5 million devices, triage customer and QA issues, and collaborate across hardware, networking, product, support, and engineering teams to deliver reliable IoT vehicle intelligence products.
Top Skills: BuildkiteC++CanCan-UtilsDatabricksGoGraphQLIotLinuxLinux DriversLteUsbWi-Fi
15 Hours Ago
Easy Apply
Remote
Easy Apply
178K-228K Annually
Senior level
178K-228K Annually
Senior level
Big Data • Fintech • Mobile • Payments • Financial Services
The Staff Software Engineer, Backend for Capacity Modeling develops scalable backend systems, maintains capacity models, and collaborates on technical strategies while ensuring system availability and high-quality code delivery.
Top Skills: AuroradbAWSDynamoDBElasticcacheKotlinKubernetesMySQLPythonSpark

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account