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

8 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
8 Hours Ago
In-Office or Remote
CA, USA
168K-297K Annually
Senior level
168K-297K Annually
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Leads complex third-party security assessments, reviewing vendor controls, certifications, penetration tests, integrations, data handling, identity systems, and cloud deployments. Documents risks, recommends mitigations, coordinates reassessments and incident responses, escalates exceptions, improves assurance processes, and mentors teammates while partnering with Procurement, Security, Privacy, Legal, and business stakeholders.
Top Skills: APIsCisaCismCisspCloud ComputingCriscCybersecurity Risk ManagementGripIamIso 27001JIRANistOauthOnetrustOpenid ConnectPci DssSAMLSoc 2SsoZip
8 Hours Ago
Easy Apply
Remote
Easy Apply
101K-151K Annually
Entry level
101K-151K Annually
Entry level
Big Data • Fintech • Mobile • Payments • Financial Services
Develop and scale backend systems and streaming infrastructure for event-driven architecture. Collaborate with engineering teams and stakeholders, write well-tested and extensible code, debug large codebases, participate in code reviews, and contribute to system reliability and team growth. The role uses technologies such as Kafka, Flink, Spark, AWS, MySQL, Kubernetes, and Python or Kotlin.
Top Skills: AWSFlinkKafkaKotlinKubernetesMySQLPythonSnsSpark

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account