Software Engineer - Postgres Tooling
Jobgether
Posted Nov 20, 2026
- Full-time
- Remote
- Security & IT
- Software Engineer jobs in Netherlands
Job description
**This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Software Engineer – Postgres Tooling based in Netherlands.** As a Software Engineer specializing in PostgreSQL tooling, you will play a key role in building and maintaining open-source tools that help developers manage database schemas and migrations safely and efficiently. You will contribute to the evolution of a powerful schema comparison and migration engine, ensuring the accuracy, reliability, and security of generated SQL. Working at the intersection of database internals, software engineering, and compiler-style problem-solving, you will tackle complex technical challenges involving dependency management, permissions, and data integrity. You will collaborate with globally distributed engineering teams and open-source contributors to improve developer workflows and establish robust tooling standards. The role offers the opportunity to take technical ownership of a widely used project and help drive it toward a stable, standalone release. You will thrive in an asynchronous, open-source-first environment that values technical excellence, independent thinking, and engineering precision. ### 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`. - Open-source project maintenance experience, including managing public APIs, semantic versioning, technical documentation, and community contributions. - Knowledge of PostgreSQL extensions such as pg_cron, pgmq, pg_partman, vault, pg_net, pgvector, or PostGIS. - Experience with Go programming language. - Contributions to PostgreSQL itself or experience developing and maintaining PostgreSQL extensions. - Previous experience working with PostgreSQL-based products or managed database platforms. ## Benefits: - Fully Remote Work: Work from anywhere in India within a globally distributed team, with no mandatory office attendance. - Co-working Support: Access to a WeWork membership or co-working allowance to support a productive remote working environment. - Equity Ownership (ESOP): Employee stock ownership opportunities, allowing team members to share in the company's long-term growth and success. - Technology Allowance: Dedicated budget to purchase equipment and improve your workspace, including laptops, monitors, headphones, and other essential tools. - Health Benefits: Comprehensive health insurance covering 100% of employee premiums and 80% of dependent premiums, subject to applicable plan terms and local eligibility. - Annual Team Off-Sites: Opportunities to connect and collaborate with colleagues during company-wide gatherings in different cities around the world. - Flexible Working Arrangements: Asynchronous work culture that encourages autonomy, flexibility, and ownership of your schedule. - Professional Development: Annual learning and education allowance for courses, books, conferences, and other professional growth opportunities. - International Collaboration: Opportunity to work alongside a globally distributed engineering team representing more than 60 countries and 20 languages. - Open-Source Innovation: Work on impactful developer tools, contribute to the open-source ecosystem, and help shape the future of PostgreSQL development.