Supabase Logo

Supabase

Software Engineer - Postgres Tooling

Posted 7 Hours Ago
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

Senior level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Coordinates game asset production across creative and technical teams, maintaining schedules, task lists, dependencies, priorities, approvals, reviews, and milestone deliverables. The role tracks progress and issues in project tools, facilitates communication across disciplines, supports QA and development follow-up, escalates risks, and improves production workflows and pipelines. It requires extensive game production or asset coordination experience and regular work from the Montreal office.
Top Skills: ConfluenceGitJIRAMiroPerforce
9 Hours Ago
Remote
United States
130K-180K Annually
Senior level
130K-180K Annually
Senior level
Artificial Intelligence • Fintech • Information Technology • Marketing Tech • Payments • Social Impact • Software
Leads and builds Donorbox’s product marketing function, owning positioning, messaging, product-led growth, launches, enablement, competitive intelligence, and performance measurement. Partners with Product, Sales, Customer Success, and Marketing to drive acquisition, conversion, retention, and expansion. Manages one direct report, establishes scalable processes and KPIs, influences roadmap priorities, and presents data-driven insights to executive leadership.
Top Skills: Product-Led Growth (Plg)SaaS
9 Hours Ago
Remote or Hybrid
175K-218K Annually
Senior level
175K-218K Annually
Senior level
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Leads the Solutions Architecture team’s transition to building reusable integrations on Workato. Owns integration strategy, roadmap, capacity planning, delivery standards, inherited third-party integrations, support models, pricing, SOWs, and operational metrics. Partners with Product, Engineering, Partnerships, Presales, Sales, and Support; hires and develops a globally distributed technical team; oversees technical discovery, handoffs, security, privacy, monitoring, and high-risk escalations.
Top Skills: AWSBoomiErpGCPGraphQLHrisJIRAJitterbitLmsLxpAzureMulesoftRestSdlcSoapSQLSsoTray.IoWorkato

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account