Principal Software Engineer, AWS Distributed SQL

AWS Databases is hiring Principal/Sr Principal Engineers to lead query processing for two of its key database engines. […] Redshift is a petabyte-scale cloud data warehouse used by tens of thousands of customers. […] Aurora DSQL is a serverless, distributed SQL database built for active-active availability and virtually unlimited scale.

Both engines depend on the same discipline: turning SQL into well-optimized plans and running them fast at massive scale. Depending on your depth and interests, you'll join one of three teams: Redshift Query Optimization, the Redshift Execution Engine, or Aurora DSQL Query Processing.<br/><br/>Key job responsibilities<br/>- Set and execute a multi-year technical strategy for query optimization and execution that improves price-performance against Databricks, Snowflake, Google BigQuery, and other cloud databases.<br/>- Own core query processing architecture, including parsing and semantic analysis, query rewriting, cost-based planning, statistics and cardinality estimation, plan caching, and physical execution.<br/>- Build high-performance execution engines (vectorized and pipelined operators, memory management, code generation, massively parallel and distributed execution) that serve analytical and transactional workloads.<br/>- Advance optimization over open table formats and heterogeneous storage, such as Iceberg and Parquet data lakes and federated sources. Build adaptive execution that corrects plans at runtime.<br/>- Turn ambiguous