Principal Software Engineer, AWS Distributed SQL

Amazon

  • Seattle, WA ; New York, NY ; East Palo Alto, CA
  • On-site
  • Staff/Principal level
  • 10+ yrs experience
  • Backend Engineering
  • Visa: not specified
  • $200k–$311k

The role in 30 seconds

Principal Software Engineers are sought to lead query processing for key database engines like Amazon Redshift and Amazon Aurora DSQL. The role involves setting multi-year technical strategy, owning core query processing architecture, and building high-performance execution engines. This position requires driving complex projects, mentoring engineers, and raising the engineering bar within Amazon.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • B2B infrastructure / API / developer tools
  • Software, SaaS & AI Platform
  • Database Platform
  • Enterprise-scale
  • Growth-stage

Workable stretch

  • B2B enterprise platform / workflow software
  • Data platform / ML pipeline
  • Startup / greenfield

Harder transition

  • Internal tooling / back-office systems
  • B2C consumer-facing application
  • Marketplace / multi-sided platform
  • Embedded systems / hardware-adjacent

Industry: Software, SaaS & AI Platform. See your personal match score

What they're really screening for

Must-haves

  • CORE 10+ years of non-internship professional software development experience
  • CORE 10+ years of leading design or architecture (design patterns, reliability, and scaling) of new and existing systems
  • CORE Deep experience in database internals or query processing (query optimization, execution engines, or both) and in distributed systems
  • CORE Proficiency in C++, Rust, Java, or a similar systems language, building and operating mission-critical, highly available systems
  • CORE Experience as a technical leader driving strategy and complex, high-impact projects across organizational boundaries
  • CORE Experience mentoring engineers or leading engineering teams

Nice-to-haves

  • PLUS Masters or PhD in databases, distributed systems, or a closely related field
  • CORE 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)
  • CORE Expert knowledge of execution engines: vectorized execution, operator pipelines, memory management, and code generation
  • PLUS Deep understanding of the PostgreSQL query engine
  • PLUS Experience optimizing queries over data lake formats (Iceberg, Parquet, Hudi) and federated sources
  • PLUS Publications or active involvement in the database research community (SIGMOD, VLDB)

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • AWS Databases
  • Distributed SQL
  • SQL
  • Amazon Redshift
  • Amazon Aurora DSQL
  • C++
  • Rust
  • Java
  • Iceberg
  • Parquet
  • Hudi
  • PostgreSQL
  • SIGMOD
  • VLDB
  • Databricks

Concepts & phrases

  • Principal Software Engineer
  • AWS Distributed SQL
  • query processing
  • database engines
  • Amazon Redshift
  • cloud data warehouse
  • Amazon Aurora DSQL
  • serverless, distributed SQL
  • multi-year technical strategy
  • query optimization and execution
  • Databricks, Snowflake, Google BigQuery
  • cloud databases
  • core query processing architecture
  • parsing and semantic analysis
  • cost-based planning

Words that count as the same thing: "AWS Distributed SQL" ≈ distributed SQL databases, serverless distributed SQL, Aurora DSQL · "price-performance" ≈ cost-effectiveness, performance per dollar · "data lakes" ≈ data lake storage, lakehouse formats · "federated sources" ≈ data federation, querying external data sources · "operations" ≈ operating systems, system operation, production support

Check my résumé against these keywords

Hiring at Amazon

All Amazon hiring data

Open senior roles RoleStack tracks right now, posted in the last 30 days.

More open roles at Amazon

Full job description from Amazon

From Amazon's posting. View the original

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.

Show full description Show less

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

FAQ

How much does a Principal Software Engineer, AWS Distributed SQL at Amazon make?

The posted pay for this role is $200k–$311k a year.

How much experience do you need?

The posting asks for 10+ years in software development. It is a staff/principal-level role.

Does Amazon sponsor visas for this role?

The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.

Is this role remote?

It is an on-site role.

What tools and technologies does the posting mention?

AWS Databases, Distributed SQL, SQL, Amazon Redshift, Amazon Aurora DSQL, C++, Rust, Java, Iceberg, Parquet, Hudi, PostgreSQL, SIGMOD, VLDB, Databricks.