Principal Software Engineer, AWS Distributed SQL

Amazon Web Services (AWS)

Seattle (WA)

On-site

USD 200,000 - 271,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
401(k) matching
Paid time off
Parental leave

Job summary

Amazon Web Services (AWS) is seeking Principal/Sr Principal Engineers to lead query processing for Redshift and Aurora DSQL. You will own core query processing architecture, drive multi-year optimization strategies, and build high-performance execution engines for multi-petabyte scale workloads.

Join one of three teams and mentor senior engineers while collaborating with customers on adoption and roadmap, with a strong focus on scale, reliability, and performance.

Qualifications

  • 10+ years of professional software development experience
  • 10+ years of leading design or architecture of systems
  • Deep experience in database internals or query processing and distributed systems
  • Proficiency in C++, Rust, Java or similar systems languages
  • Experience as a technical leader driving strategy across orgs
  • Experience mentoring engineers or leading engineering teams

Responsibilities

  • Set and execute a multi-year technical strategy for query optimization and execution.
  • Own core query processing architecture including parsing, planning, statistics, and execution.
  • Build high-performance execution engines for analytical and transactional workloads.
  • Advance optimization over Iceberg/Parquet data lakes and heterogeneous storage.
  • Turn customer requirements into concrete projects and own end-to-end delivery.
  • Collaborate with AWS Databases teams on product vision and customer adoption.
  • Raise engineering bar through design reviews and code standards; mentor engineers.

Skills

Software development
System design
Database internals
C++/Rust/Java
Technical leadership
Mentoring engineers

Education

Masters or PhD in databases or distributed systems

Job description

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.

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.

Base salary ranges:

  • 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

Company: Amazon Web Services, Inc.

Job ID: A10602681

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Principal Software Engineer, AWS Distributed SQL
Principal Software Engineer, AWS Distributed SQL

Amazon Web Services (AWS) • New York (NY)

On-site
USD 220,000 - 298,000
Principal, Senior Principal and Distinguished Engineer, AWS Database Services
Principal, Senior Principal and Distinguished Engineer, AWS Database Services

Amazon Web Services (AWS) • Bellevue (WA)

On-site
USD 200,000 - 271,000
Principal, Senior Principal and Distinguished Engineer, AWS Database Services
Principal, Senior Principal and Distinguished Engineer, AWS Database Services

Amazon Web Services (AWS) • East Palo Alto (CA)

On-site
USD 230,000 - 311,000
Health insurance
RSUs
401(k) matching
+1
Principal, Senior Principal and Distinguished Engineer, AWS Database Services
Principal, Senior Principal and Distinguished Engineer, AWS Database Services

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 200,000 - 311,000
Health insurance
401(k) matching
Paid time off
Senior Software Dev Engineer, Amazon Aurora DSQL
Senior Software Dev Engineer, Amazon Aurora DSQL

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 168,000 - 227,000
Comprehensive benefits
RSU eligibility
Senior Manager, Software Development, Aurora DSQL
Senior Manager, Software Development, Aurora DSQL

Amazon Web Services • Seattle (WA)

On-site
USD 220,000 - 298,000
Health insurance
RSUs
Paid time off
Senior PMT-ES, Amazon Aurora
Senior PMT-ES, Amazon Aurora

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 152,000 - 206,000
Health insurance
401(k) matching
Paid time off
+1
Database Engineer Intern Summer 2027
Database Engineer Intern Summer 2027

Amazon Inc. • Seattle (WA)

On-site
USD 91,000 - 111,000
Mentorship
Career growth
Work-life balance
Software Dev Engineer, Amazon Aurora DSQL
Software Dev Engineer, Amazon Aurora DSQL

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 144,000 - 194,000
Health insurance
401(k) matching
Paid time off
+1
Software Dev Engineer III, AWS Distributed SQL
Software Dev Engineer III, AWS Distributed SQL

Amazon Web Services (AWS) • Seattle (WA)

On-site
USD 168,000 - 227,000
Health insurance
401(k) matching
Paid time off
+1