Software Engineer - Postgres Tooling
- Opened · 30d
- +9,009
- Closed · 30d
- −6,122
- Signal
- ▲ Expanding+2,887 net
- Opened · 7d
- +3,64410% of open
- All software engineering
- 75,116open
Accountabilities:
- Co-maintain and progressively take technical ownership of an open-source PostgreSQL schema comparison and migration engine, reviewing contributions and eventually growing into its lead maintainer.
- Review, evaluate, and merge code contributions, including AI-generated pull requests, while ensuring high standards of correctness, maintainability, and security.
- Investigate and resolve reported issues related to schema differences, dependency ordering, migration generation, and PostgreSQL compatibility.
- Expand automated testing and validation coverage across multiple PostgreSQL versions to ensure consistent and reliable behavior.
- Ensure generated database migrations are safe, privilege-aware, and designed to prevent unintended data loss or security regressions.
- Identify potentially destructive schema changes and implement mechanisms to detect them and generate safer alternatives wherever possible.
- Contribute to the development of a stable 1.0 release, including defining public APIs, establishing semantic versioning contracts, improving documentation, and expanding PostgreSQL extension support.
- Engage with the open-source community by managing issue reports, reviewing external contributions, providing technical guidance, and maintaining constructive discussions with contributors.
- Collaborate with internal engineering teams to ensure consistent migration generation and execution across products, platform services, database branching, and AI-powered workflows.
- Write technical design documents, define architectural direction, and establish engineering strategies for the continued evolution of the tooling.
- Participate in the engineering team's on-call rotation, helping investigate and resolve production-related issues while supporting reliable software delivery.
Requirements
- At least 8 years of professional software engineering experience, including extensive hands-on experience with PostgreSQL.
- Deep understanding of PostgreSQL internals, particularly system catalogs such as pg_catalog and pg_depend, object ownership, permissions, grants, default privileges, Row-Level Security (RLS) policies, and extension membership.
- Strong knowledge of PostgreSQL DDL operations and database migration semantics, including locking behavior, transactional limitations, dependency management, and the identification of potentially destructive changes.
- A security-conscious engineering mindset, with particular attention to preventing unauthorized privilege changes, accidental access exposure, and unintended data loss.
- Strong proficiency in TypeScript and the ability to develop reliable, maintainable, and well-tested software.
- Experience designing advanced testing strategies for correctness, including differential testing, property-based testing, and test corpus validation across multiple PostgreSQL versions.
- Familiarity with compiler-style engineering challenges, including dependency graphs, topological sorting, cycle detection, and schema comparison algorithms.
- Ability to review and understand complex code changes within sophisticated codebases, including contributions generated with AI-assisted development tools.
- Proven experience owning and maintaining production software, including staged releases, error monitoring, incident investigation, and responding to real-world user feedback.
- Demonstrated ability to lead complex technical initiatives across multiple teams, from initial problem definition and architectural planning through production implementation.
- Excellent written communication skills and the ability to document technical decisions clearly.
- Ability to work independently, manage priorities effectively, and collaborate successfully within asynchronous, globally distributed engineering teams.
Nice to Have:
- Previous experience developing or maintaining database schema comparison and migration tools such as migra, pg-schema-diff, Atlas, pgroll, sqitch, Prisma Migrate, Flyway, or Liquibase.
- Familiarity with PostgreSQL backup and schema extraction internals, particularly pg_dump.
How Jobgether works
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Why Apply Through Jobgether?
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1