Senior Software Engineer – Distributed PostgreSQL Engine, Aurora DSQL, Aurora Distributed SQL Q

Senior Software Engineer – Distributed Postgre

SQL Engine, Aurora DSQL, Aurora Distributed SQL Query Processing

Amazon Aurora DSQL is a serverless, distributed SQL database that combines the performance and scalability of a cloud‑native architecture with the familiarity and ecosystem of Postgre

SQL. Aurora DSQL automatically scales compute and storage, delivers high availability across regions, and eliminates operational overhead while remaining compatible with Postgre

SQL applications and tooling.

We are seeking Postgre

SQL internals experts to advance Aurora DSQL’s query processing capabilities. This deep‑systems engineering role focuses on ensuring semantic, functional, and behavioral parity with Postgre

SQL while extending its architecture to run efficiently in a distributed, elastic environment.

• Analyze, adapt, and extend Postgre
  
  SQL internals (parser, planner, executor, catalog, and transaction manager) to operate correctly and efficiently in Aurora DSQL’s distributed runtime.
• Build mechanisms that maintain Postgre
  
  SQL 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 Postgre
  
  SQL.
• Collaborate with query processing, storage, and transaction teams to integrate distributed primitives into Postgre
  
  SQL‑compatible interfaces.
• Debug complex behaviors in areas such as visibility, locks, and plan caching to ensure fidelity with Postgre
  
  SQL behavior under distributed execution.
• Contribute to the long‑term architecture enabling Aurora DSQL to support next‑generation Postgre
  
  SQL features at virtually unlimited scale.

You’ll deep‑dive into Postgre

SQL 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, partner with engineers across compute, storage, and transaction subsystems to ensure every Postgre

SQL feature “just works” on Aurora DSQL, participate in design reviews, mentor engineers, and drive the compatibility roadmap for Aurora DSQL’s Postgre

SQL layer.

We are the Aurora DSQL Query Processing team, the execution engine behind every SQL statement in Aurora DSQL. We bridge one of the world’s most advanced open‑source databases with AWS’s distributed, serverless architecture. Our engineers come from database internals backgrounds and large‑scale distributed systems teams. We value curiosity, precision, and craftsmanship—and we work in an environment where deep systems problems meet high‑scale real‑world impact.

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

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

Amazon is an equal‑opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.