Principal Software Engineer, AWS Distributed SQL

Amazon • East Palo Alto, CA • 17min ago

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.

Key job responsibilities

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.

Basic Qualifications

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

Preferred Qualifications

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)

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

Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness and professionalism, and safeguard business operations and the Company's reputation. Pursuant to the Los Angeles County Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

USA, CA, East Palo Alto - 230,100.00 - 311,200.00 USD annually

USA, NY, New York - 220,100.00 - 297,700.00 USD annually

USA, WA, Seattle - 200,100.00 - 270,600.00 USD annually

Amazon

Go to Apply

Share this job

Similar Jobs

Software Engineer, Agentic Model Serving, Robotics, DeepMind

Google • Mountain View, CA • 16min ago

IT & Engineering

Software Engineer, Agentic Model Serving, Robotics, DeepMind Share Software Engineer, Agentic Model Serving, Robotics, DeepMind corporatefare_ DeepMind place Mountain View, CA, USA Share Software Engineer, Agentic Model...

16min ago

Go to Apply

Lead Principal Software Engineer, Core Infrastructure

Oracle • Santa Clara, CA • 16min ago

IT & Engineering

Job Description Oracle Cloud Infrastructure (OCI) Compute delivers bare metal and virtual machine instances - CPU and GPU -at global scale. We are hiring a Lead Principal Engineer to provide hands-on technical leadership...

16min ago

Go to Apply

Systems Software Engineer - Human Interface Devices

Apple • Sunnyvale, CA • 18min ago

IT & Engineering

Role Number: 200693935-3956 Summary Our Human Interface Devices Software team delivers high-quality drivers, frameworks and tools supporting sensing technologies across all Apple products. Primarily supporting the multi-...

18min ago

Go to Apply

Senior Scientific Software Engineer, Analytics and Workflows

Genentech • South San Francisco, CA • 18min ago

IT & Engineering

The Position We're passionate about delivering on Our Promise to improve the lives of patients and create healthier communities for all. We foster a culture of inclusivity, integrity and creativity while boldly pursuing...

18min ago

Go to Apply

Staff Software Engineer, Search and Shopping ProxyBidder

Google • Mountain View, CA • 18min ago

IT & Engineering

Staff Software Engineer, Search and Shopping ProxyBidder Share Staff Software Engineer, Search and Shopping ProxyBidder corporatefare_ Google place New York, NY, USA; Mountain View, CA, USA Advanced Experience owning out...

18min ago

Go to Apply

Staff Software Engineer, AI Data Safety

Google • Mountain View, CA • 18min ago

IT & Engineering

Staff Software Engineer, AI Data Safety Share Staff Software Engineer, AI Data Safety corporatefare_ Google place Mountain View, CA, USA Advanced Experience owning outcomes and decision making, solving ambiguous problems...

18min ago

Go to Apply

Director, Software Engineering, Global Network Operations

Google • Sunnyvale, CA • 18min ago

IT & Engineering

Director, Software Engineering, Global Network Operations Share Director, Software Engineering, Global Network Operations corporatefare Google place Thornton, CO, USA; Atlanta, GA, USA; +2 more; +1 more barchart Director...

18min ago

Go to Apply

Principal Software Engineer, Core Infrastructure

Oracle • Santa Clara, CA • 18min ago

IT & Engineering

Job Description Leads development and begins architecting components of scalable, elastic distributed systems. Defines and enforces scalability requirements for owned components; optimizes code and data paths for high‑th...

18min ago

Go to Apply

Senior Software Engineer, Apple Ads

Apple • Cupertino, CA • 18min ago

IT & Engineering

Weekly Hours: 40 Role Number: 200694095-0836 Summary Apple is where we use the power of technology to enrich people's lives. Every new product we build, service we create, or Apple Store experience we deliver is the resu...

18min ago

Go to Apply

Senior Software Engineer, SecNI Infrastructure Engineer

Google • Sunnyvale, CA • 19min ago

IT & Engineering

Senior Software Engineer, SecNI Infrastructure Engineer Share Senior Software Engineer, SecNI Infrastructure Engineer corporatefare_ Google place Sunnyvale, CA, USA Mid Experience driving progress, solving problems, and...

19min ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)