Software Engineer - PostgreSQL Tooling (Remote - Worldwide)
Candidates may apply from any country; the team is globally distributed and works asynchronously. A developer-focused backend platform built on PostgreSQL is hiring a software engineer for its CLI team. The role centers on an open-source schema diff and migration engine that generates the SQL needed to move a database from one schema state to another, and that runs under the company's hosted platform and branching workflows. You will co-maintain the project, review changes, and help take it to a stable, publicly versioned 1.0 for any PostgreSQL developer.
What you'll do
- Co-maintain the open-source migration engine: review and merge changes, including pull requests generated by AI tools, and grow into lead maintainer.
- Triage bug reports from GitHub and support, fix diff and dependency-ordering bugs, and extend test coverage across multiple PostgreSQL versions.
- Ensure generated migrations are privilege-safe and never silently drop or lose data, detecting destructive changes and rewriting them into safer equivalents where possible.
- Lead work toward a stable 1.0 with a public API, a semantic versioning contract, documentation, and broader support for PostgreSQL extensions.
- Work with outside contributors: triage issues, review pull requests, and decline requests that do not fit the project's direction.
- Write design documents and technical strategy, communicating asynchronously with several teams.
- Share an on-call rotation, with weekday coverage across time zones.
What you need
- 8+ years of software engineering experience, including deep hands-on work with PostgreSQL.
- Strong knowledge of PostgreSQL internals at the catalog level, including dependency tracking, object ownership, grants, default privileges, row-level security policies, and extension membership.
- Solid understanding of DDL and migration semantics: locking behavior, statements that cannot run inside a transaction, dependency-driven ordering, and identifying destructive changes.
- Strong TypeScript skills and experience testing for correctness, such as differential, property-based, or corpus-based testing across Postgres versions.
- Comfortable with graph and compiler-style problems such as topological ordering and cycle handling.
- Proven record of owning production software with real users, including staged rollouts and error monitoring, and of leading a technical project across teams.
- Clear written communication and comfort working in a fully asynchronous, global team.
Open to applicants anywhere in the world.
How to apply
Get the free i'llTip app to see the employer's details and apply. i'llTip's AI can tailor your résumé to this job, and you'll get alerts for similar roles.
Apply on i'llTipPrefer the website? Continue on illtip.comOr get the app: Android · iPhone
🔔 Get new jobs like this first: join Tech & AI Jobs on Telegram · or get personal job alerts
More Mobile & Web Development jobs
Software Engineer II - Rust (Remote - Select Countries)
A long-established global financial trading platform is hiring a Rust engineer for its Pro team, which builds the backend of its trading products. The team owns components such as the matching engine, market data gateway…
IoT and Hardware Engineer
A project-based contract role for an experienced engineer to design, build, integrate and test connected hardware and IoT solutions. It is offered by a software development company that delivers technology solutions to i…
Lead ABAP Engineer (Remote - South Africa)
A fast-growing software company serving banks and insurers is hiring a senior technical lead to drive backend architecture for its cloud-based SaaS platform, which is built on the ABAP programming language and the S/4HAN…
Senior Software Engineer, React Native (Remote - US only)
Candidates must be authorized to work for any U.S. employer; visa sponsorship is not available. A fast-growing North American consumer sports-entertainment company is hiring a senior engineer to build and own features in…
Frontend Developer (Real-Time Data & API Integration)
A remote contract role for an experienced frontend developer in the ICT and software development sector. The work centres on connecting live data feeds from third-party services and presenting fast-changing information t…
Related job searches
Remote Software Engineer JobsSoftware Engineer jobsWork From Home jobs in NigeriaWork From Home jobs