> Markdown version of [/jobs/ext/4693416-principal-software-engineer-aws-distributed-sql](https://www.wearedevelopers.com/jobs/ext/4693416-principal-software-engineer-aws-distributed-sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Principal Software Engineer, AWS Distributed SQL

- **Company:** Amazon.com, Inc.
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Salary:** $230,100 - $311,200
- **Contract:** Internship / Graduate position
- **Skills:** Java (Programming Language), Amazon Web Services, C++ (Programming Language), Code Generation, Databases, Software Design Patterns, Distributed Systems, Memory Management, PostgreSQL, Query Optimization, Software Engineering, SQL Databases, Database Engines, Rust (Programming Language), Parquet, Snowflake, Data Lakes, Google Bigquery, Serverless Computing, Amazon Redshift, Databricks
- **Published:** November 12, 2026
- **Apply:** https://dejobs.org/x/x/D5B9C6E60E544F18A66C198CF0B8B5F2/job/

## About the Role

* 10+ years of non-internship professional software development experience
 * 10+ years of leading design or architecture (design patterns, reliability, and scaling) of new and existing systems
 * Deep experience in database internals or query processing (query optimization, execution engines, or both) and in distributed systems
 * Proficiency in C++, Rust, Java, or a similar systems language, building and operating mission-critical, highly available systems
 * Experience as a technical leader driving strategy and complex, high-impact projects across organizational boundaries
 * Experience mentoring engineers or leading engineering teams, * Masters or PhD in databases, distributed systems, or a closely related field
 * Expert knowledge of optimizer frameworks: cost-based optimization, join enumeration, plan-space exploration, rewrite rules, cardinality estimation, and statistics (histograms, sampling, feedback-driven re-optimization)
 * Expert knowledge of execution engines: vectorized execution, operator pipelines, memory management, and code generation
 * Deep understanding of the PostgreSQL query engine
 * Experience optimizing queries over data lake formats (Iceberg, Parquet, Hudi) and federated sources
 * Publications or active involvement in the database research community (SIGMOD, VLDB)

## Description

AWS Databases is hiring Principal/Sr Principal Engineers to lead query processing for two of its key database engines. Amazon Redshift is a petabyte-scale cloud data warehouse used by tens of thousands of customers. Amazon 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., * 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.

 * Own core query processing architecture, including parsing and semantic analysis, query rewriting, cost-based planning, statistics and cardinality estimation, plan caching, and physical execution.
 * Build high-performance execution engines (vectorized and pipelined operators, memory management, code generation, massively parallel and distributed execution) that serve analytical and transactional workloads.
 * 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.
 * Turn ambiguous customer and business requirements into concrete projects, and personally own design, code, deployment, and operations from end to end.
 * Partner across AWS Databases on product vision and integration with the broader database portfolio. Work directly with customers on adoption and roadmap.
 * Raise the engineering bar through design reviews, coding standards, and operational excellence. Mentor senior engineers, and help hire and grow a strong team.