Amazon Senior Software Engineer – Distributed PostgreSQL 

United States, California, East Palo Alto 

430756594

Key job responsibilities
- Analyze, adapt, and extend PostgreSQL internals (parser, planner, executor, catalog, and transaction manager) to operate correctly and efficiently in Aurora DSQL’s distributed runtime.- Build mechanisms that maintain PostgreSQL semantics (MVCC, snapshot isolation, error codes, data types, and function behavior) in a horizontally scalable environment.- Develop compatibility test frameworks to validate DSQL’s correctness against upstream PostgreSQL.- Debug complex behaviors in areas like visibility, locks, and plan caching to ensure fidelity with PostgreSQL behavior under distributed execution.- Contribute to the long-term architecture enabling Aurora DSQL to support next-generation PostgreSQL features at virtually unlimited scale.A day in the life
You’ll deep-dive into PostgreSQL internals—reasoning through planner/executor nodes, commit protocols, and system catalogs—while designing new abstractions that preserve correctness in distributed execution.
You’ll profile query behavior, validate transaction semantics across regions, and partner with engineers across compute, storage, and transaction subsystems to ensure every PostgreSQL feature “just works” on Aurora DSQL.
You’ll participate in design reviews, mentor engineers, and drive the compatibility roadmap for Aurora DSQL’s PostgreSQL layer.We are committed to mentorship, technical excellence, and shared ownership. You’ll work alongside engineers who have contributed to PostgreSQL’s planner, executor, and MVCC subsystems—and help define how Aurora DSQL evolves to support PostgreSQL workloads natively in the cloud.

- 5+ years of non-internship professional software development experience
- 5+ years of programming with at least one software programming language experience
- 5+ years of leading design or architecture (design patterns, reliability and scaling) of new and existing systems experience
- Experience as a mentor, tech lead or leading an engineering team

- 5+ years of full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations experience
- Bachelor's degree in computer science or equivalent