Software Engineer - Postgres Tooling

Jobgether

Italia

Remoto

EUR 90.000 - 110.000

Tempo pieno

48 ore fa
Candidati tra i primi

Aumenta le possibilità di ricevere una risposta da questo datore di lavoro

Il tuo curriculum e una lettera di presentazione personalizzati, che corrispondono esattamente a ciò che sta cercando.

Supera i filtri ATS

Vantaggi offerti da questo lavoro

Fully Remote
Equity (ESOP)
Tech Allowance
Health Insurance
Team Off-Sites
Professional Development

Descrizione del lavoro

Jobgether is seeking a Software Engineer specializing in PostgreSQL tooling to build and maintain open-source tools that manage database schemas and migrations safely and efficiently.

You will co-own a powerful schema comparison engine, review contributions from a distributed team, implement safer migration patterns, and contribute toward a stable 1.0 release with robust documentation and tests. This role emphasizes technical excellence and independent thinking.

Competenze

  • At least 8 years of professional software engineering experience with PostgreSQL.
  • Deep understanding of PostgreSQL internals, DDL operations, and security considerations.
  • Strong knowledge of migrations, dependencies, and data integrity.
  • Proficient in TypeScript and capable of building reliable, well-tested software.
  • Experience designing advanced testing strategies for correctness.
  • Ability to work independently in a distributed, asynchronous team.
  • Open-source project maintenance experience is a plus.

Mansioni

  • Co-maintain and progressively own an open-source PostgreSQL schema tooling project.
  • Review, evaluate, and merge code contributions, including AI-generated PRs.
  • Investigate issues related to schema differences, dependency ordering, and PostgreSQL compatibility.
  • Expand automated testing across multiple PostgreSQL versions.
  • Ensure migrations are safe, privilege-aware, and minimize data loss risk.
  • Contribute to a stable 1.0 release with public APIs and documentation.
  • Engage with the open-source community and manage external contributions.
  • Collaborate with internal teams for consistent migration generation.
  • Write technical design documents and define architectural direction.
  • Participate in on-call rotation to support production reliability.

Conoscenze

PostgreSQL
TypeScript
Go
Open-source tooling
AI-assisted development

Strumenti

migra
pg-schema-diff
Atlas
Liquibase

Descrizione del lavoro

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.
Ottieni la revisione del curriculum gratis e riservata.

o trascina qui il file.

Similar jobs

Offerte di lavoro simili che vale la pena confrontare

Data Api Engineer
Data Api Engineer

Jobgether • Italia

Remoto
EUR 70.000 - 110.000
Fully remote
Coworking support
ESOP
+8
Engineering Manager - Pipelines
Engineering Manager - Pipelines

Jobgether • Italia

Remoto
EUR 90.000 - 140.000
Fully remote
Coworking allowance
Equity ownership
+7
Senior Software Engineer (Platform Team)
Senior Software Engineer (Platform Team)

Sysdig • Trentino-Alto Adige

Remoto
EUR 50.000 - 70.000
Extra days off
Mental health support
Great compensation package
Graduate Software Engineer, Open Source and Linux, Canonical Ubuntu
Graduate Software Engineer, Open Source and Linux, Canonical Ubuntu

Jobgether • Italia

Remoto
EUR 48.000 - 72.000
Fully remote
Twice-yearly in-person sprints
Learning budget USD 2,000
+7
Senior Software Engineer (Platform Team)
Senior Software Engineer (Platform Team)

Sysdig • Macerata

Remoto
EUR 70.000 - 90.000
Extra days off
Mental health support via ModernHealth
Great compensation package
Senior Software Engineer (Platform Team)
Senior Software Engineer (Platform Team)

Sysdig • Venezia

Remoto
EUR 85.000 - 120.000
Extra days off
Mental health support via ModernHealth
Great compensation package
Senior Software Engineer (Platform Team)
Senior Software Engineer (Platform Team)

Sysdig • Ferrara

Remoto
EUR 65.000 - 85.000
Extra days off
Mental health support
Great compensation package
Senior Engineering Manager - Consumer Domain
Senior Engineering Manager - Consumer Domain

Satispay • Italia

Ibrido
EUR 87.000 - 107.000
Private health insurance
Stock options
Meal vouchers
+5
Full-Stack Engineer: Build Apps & Own AWS Infra
Full-Stack Engineer: Build Apps & Own AWS Infra

Job Mobz • Lombardia

Ibrido
EUR 27.000 - 44.000
On-Site Full-Stack Engineer: Product & Infra on AWS
On-Site Full-Stack Engineer: Product & Infra on AWS

Job Mobz • Torino

Ibrido
EUR 27.000 - 44.000