Software Engineer – Postgres Tooling

Posted 6 hours ago

This is a fully remote position, open to applicants anywhere in the world.

📋 Description

• Co-manage pg-delta by reviewing and merging changes, including AI-agent pull requests, while progressing towards becoming its lead maintainer.

• Triage issues on GitHub and assist with bug reports.

• Resolve differences and dependency-ordering bugs, and enhance test coverage across various PostgreSQL versions.

• Ensure that generated migrations are safe from privilege issues and prevent silent data loss.

• Identify destructive changes and convert them into safer alternatives whenever feasible.

• Aid in the release of a stable pg-delta 1.0 that includes a public API, a semver contract, comprehensive documentation, and expanded coverage for PostgreSQL extensions.

• Manage open-source issues and assess contributions from external sources.

• Collaborate with Supabase teams that utilize pg-delta.

• Draft design documents and technical strategies asynchronously across teams.

• Engage in the CLI team’s weekday follow-the-sun on-call rotation.


⛳️ Requirements

• Over 8 years of experience as a software engineer, with extensive, hands-on expertise in PostgreSQL.

• In-depth knowledge of Postgres internals at the catalog level, including pg_catalog, pg_depend, object ownership, grants and default privileges, RLS policies, and extension membership.

• Understanding of DDL and migration semantics, including locking, transaction limitations, dependency ordering, and destructive changes.

• Proficient in TypeScript.

• Experience in designing correctness tests, such as differential, property-based, or corpus testing across multiple versions of Postgres.

• Familiarity with compiler-related challenges: dependency graphs, topological ordering, cycle management, and diffing.

• Capability to review complex modifications in a sophisticated codebase, including AI-generated pull requests.

• Proven experience in owning production software with users, conducting staged rollouts, monitoring errors, and performing real bug triage.

• Experience in leading a technical project across multiple teams from initial ambiguity to production readiness.

• Strong written communication skills and the ability to excel in asynchronous, globally distributed teams.

• Must be capable of working remotely and globally.

• Nice to have: experience with schema diff or migration tooling; open-source maintainer experience; familiarity with Postgres extensions; experience with Go; contributions to Postgres or authorship of a Postgres extension; experience with Supabase or managed PostgreSQL.


🏝️ Benefits

• Fully Remote.

• WeWork membership or co-working allowance applicable globally.

• Employee stock ownership plan (ESOP) for all team members.

• Tech allowance for laptop, monitor, headphones, or other necessary work equipment.

• Supabase covers 100% of health insurance costs for employees and 80% for dependents.

• Annual company off-sites.

• Flexible, asynchronous working environment.

• Annual education allowance for courses, books, conferences, or other professional development opportunities.

People also viewed

Helpware6 hours ago

Senior Principal Java Software Engineer

MX flagMexico OnlyFull-timeFull-stack Engineer
ApplyView job
Introhive6 hours ago

Software Engineer Contractor

CA flagCanada OnlyFreelanceFull-stack Engineer
ApplyView job
Boeing6 hours ago

Senior Embedded Software Engineer

US flagUnited States OnlyFull-timeFull-stack Engineer$171.7k – $232.2k/year
ApplyView job
M9 Solutions6 hours ago

HCM Technical Lead

US flagUnited States OnlyFull-timeFull-stack Engineer$225k – $260k/year
ApplyView job
Game Plan Tech6 hours ago

Product Engineer

US flagUnited States OnlyFull-timeFull-stack Engineer
ApplyView job
Airbus6 hours ago

Systems & Software Architect

DE flagGermany OnlyFull-timeFull-stack Engineer
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers