Software Engineer - Postgres Tooling
Core
Build and maintain open-source PostgreSQL schema comparison and migration tools, ensuring accuracy, reliability, and security of generated SQL for developers.
Role type
Senior IC software engineer (database tooling)
Builds
Open-source schema comparison and migration engine
Domain
Database internals, software engineering, compiler-style problem solving
Required skills
PostgreSQL internals, TypeScript, compiler-style engineering, automated testing strategies, security-conscious engineering, technical leadership, asynchronous collaboration
Preferred skills
Experience with migration tools (migra, pg-schema-diff, Atlas, pgroll, sqitch, Prisma Migrate, Flyway, Liquibase), Go programming, PostgreSQL extensions, open-source project maintenance
Technologies
TypeScript, PostgreSQL, Go
Responsibilities
Co-maintain and take technical ownership of an open-source PostgreSQL schema comparison and migration engine; Review, evaluate, and merge code contributions including AI-generated pull requests; Investigate and resolve issues related to schema differences and migration generation; Expand automated testing and validation coverage across multiple PostgreSQL versions; Ensure generated database migrations are safe and privilege-aware; Identify potentially destructive schema changes and implement detection mechanisms; Contribute to the development of a stable 1.0 release; Engage with the open-source community by managing issue reports and reviewing contributions; Collaborate with internal engineering teams to ensure consistent migration generation; Write technical design documents and define architectural direction; Participate in the engineering team's on-call rotation.
Seniority
Senior, hands-on IC
