✦ Luna Orbit — Software Engineering

SDE-II, Query Processing, Aurora DSQL

at Amazon.com

📍 US, WA, Seattle Unknown Posted April 14, 2026
Type Full-Time
Experience senior
Exp. Years Not specified
Education Not specified
Category Software Engineering

Builds and improves the query optimization and execution layer for Aurora DSQL. The role focuses on algorithms and architecture-level work across the database internals stack, delivering performance, durability, cost, and security improvements.

  • Design and implement query optimization algorithms
  • Develop cost-based optimization strategies
  • Improve core execution engine components
  • Design, implement, test, deploy and maintain software solutions
  • Use metrics and automation to resolve root causes of software defects

Aurora DSQL is a serverless distributed SQL database with active-active high availability and strong consistency. This role designs and implements query optimization algorithms, cost-based optimization strategies, and core execution engine improvements, with an emphasis on testing, deployment, metrics, automation, and root-cause defect resolution.

The ideal candidate is an SDE-II engineer with hands-on experience in database system internals and query optimizer architectures, specifically around query optimization and execution engine improvements. They can design, implement, test, deploy, and maintain distributed SQL features (Aurora DSQL) with an emphasis on high availability, cost-based optimization, and continuous defect/root-cause improvement.

experience with database system internalsexperience with query optimizer architecturesDesignimplementtestdeploy and maintain innovative software solutionsdesigning and implementing query optimization algorithmscost-based optimization strategiescore execution engine improvements
query optimization algorithmscost-based optimization strategiescore execution engine improvementsdatabase system internalsquery optimizer architecturesdistributed SQL databaseserverlessactive-active high availabilitysoftware designimplementationtestingdeploymentmaintenancemetricsautomationroot cause analysiscode reviewcollaboration
query optimization algorithmscost-based optimization strategiescore execution engine improvementsdatabase system internalsquery optimizer architecturesdistributed SQL databasesactive-active high availabilitydata consistencydesign and implementation of software solutionssoftware testingsoftware deploymentsoftware maintenancemetricsautomationroot cause analysis of software defectscode review
passion for innovationcollaboration across diverse teamscommunicate with internal and external stakeholdersstartup-like development environment executionresearch and experimentation mindset
Industry SaaS
Job Function Enhance Aurora DSQL query processing by advancing query optimization and execution engine architecture.
Role Subtype Platform Engineer
Tech Domains SQL / PostgreSQL
SDE-IISoftware Development Engineer IIQuery ProcessingAurora DSQLquery optimization algorithmscost-based optimizationquery optimizer architecturesdatabase system internalsexecution enginedistributed SQL databaseserverlessactive-active high availability99.99% single-Region99.999% multi-Regionhighly availablealways-ondesign discussionscode reviewmetricsautomationroot cause of software defectsalways-on products

Must have experience with database system internals, Must have experience with query optimizer architectures, Must be able to design, implement, test, deploy, and maintain execution engine and optimization components

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile