Remote job
Software Engineer - Postgres Tooling
Job details
About this role
Role overview Help develop and maintain an open-source tool that compares PostgreSQL schemas and produces database migrations. The central challenge is correctness: generated SQL must respect privileges, preserve data, and handle dependencies safely. You’ll join as a co-maintainer, with the opportunity to take on technical leadership as the tool moves toward a stable 1.0 release.
Responsibilities - Review and merge contributions, including AI-generated changes, and grow into the tool’s lead maintainer. - Investigate user reports and fix schema-diff, migration, and dependency-ordering defects. - Improve safeguards against unintended data loss and privilege changes, and expand correctness testing across PostgreSQL versions. - Help define a stable public API, compatibility policy, documentation, and support for more extensions. - Triage community issues, review outside contributions, and coordinate with teams that rely on the tool. - Write technical designs and strategy, and participate in the CLI team’s weekday on-call rotation.
Requirements - At least eight years of software engineering experience, including deep practical PostgreSQL expertise. - Knowledge of PostgreSQL catalogs, dependencies, ownership, grants, default privileges, row-level security, and extension membership. - Strong understanding of DDL and migration behavior, including locks, transaction constraints, dependency ordering, and destructive changes. - Strong TypeScript skills and experience designing rigorous tests, such as differential, property-based, or cross-version corpus tests. - Comfort with dependency graphs, topological ordering, cycle handling, and diff algorithms. - Production ownership, cross-team technical leadership, confident code review, and clear written communication in asynchronous teams.
Nice to have - Experience maintaining schema comparison or migration tools, or working with PostgreSQL dump internals. - Open-source maintenance experience, including API compatibility, versioning, documentation, and community support. - Familiarity with PostgreSQL extensions, Go, managed PostgreSQL services, or contributions to PostgreSQL or an extension.
Benefits and work setup The role is fully remote and asynchronous, with a coworking allowance or membership, equipment and professional development budgets, health coverage, equity, and annual team gatherings. The on-call rotation is described as follow-the-sun on weekdays, with infrequent pages.