Senior Software Engineer – Distributed PostgreSQL Engine, Aurora DSQL, Aurora Distributed SQL Query Processing

Job description

Amazon Aurora DSQL is a serverless, distributed SQL database that combines the performance and scalability of cloud-native architecture with the familiarity and ecosystem of PostgreSQL. Aurora DSQL automatically scales compute and storage, delivers high availability across regions, and eliminates operational overhead—while remaining compatible with PostgreSQL applications and tooling. We are seeking PostgreSQL internals experts to advance Aurora DSQL’s query processing capabilities. This is a deep systems engineering role focused on ensuring semantic, functional, and behavioral parity with PostgreSQL while extending its architecture to run efficiently in a distributed, elastic environment. As part of the core database engine team, you will work across the PostgreSQL planner, executor, and other subsystems to evolve Aurora DSQL’s hybrid execution model. The ideal candidate understands PostgreSQL internals—from parser to executor—and thrives on solving hard problems at the intersection of distributed systems, concurrency control, and database correctness. 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…