← Back to jobs

Remote job

Software Engineer - Postgres Tooling

Backend Full-time Freelance Worldwide

Job details

Not specified Salary
Worldwide Eligibility
Lead Experience
Full-time Employment

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.

Skills detected in the listing

TypeScriptGoSQLPostgreSQL
Detected Nov 19, 2026
Last verified Nov 19, 2026

Hidden Jobs Access

Unlock application links

Read the full job details for free. An active Hidden Jobs Access subscription is required to open the original application link.

Weekly

$6.99 /week
  • Original application links
  • Full access to all MCP features
  • Cancel anytime

Monthly

$35.99 $17.99 /month
  • Original application links
  • Full access to all MCP features
  • 35% cheaper than weekly

Lifetime

$99.99 $49.99 /forever
  • Original application links
  • Full access to all MCP features
  • One-time payment
Hidden Jobs gives subscribers direct access to original application links