Amazon

Principal Software Engineer, AWS Distributed SQL

Amazon
Apply
1 day ago
East Palo Alto, CA, USA +2 moreStaff+
H1B sponsor

Base Salary

$200k - $311k/yr

Responsibilities

  • Set and execute multi-year technical strategy for query optimization and execution across Amazon Redshift and Aurora DSQL.
  • Own query-processing architecture spanning parsing, semantic analysis, query rewriting, cost-based planning, statistics, cardinality estimation, plan caching, and physical execution.
  • Build high-performance vectorized and pipelined execution engines with memory management, code generation, and massively parallel distributed execution.
  • Advance optimization over Iceberg, Parquet, heterogeneous storage, data lakes, and federated sources, including adaptive runtime execution.
  • Own designs, code, deployment, and operations end to end while translating customer and business requirements into projects.
  • Partner across AWS Databases on product vision, portfolio integration, customer adoption, and roadmap development.
  • Mentor senior engineers, support hiring and team growth, and raise engineering standards through design reviews and operational practices.

Requirements

  • 10+ years of non-internship professional software development experience.
  • 10+ years leading the design or architecture of new and existing systems, including reliability and scaling.
  • Deep experience in database internals or query processing and distributed systems.
  • Proficiency in C++, Rust, Java, or a similar systems language for mission-critical, highly available systems.
  • Experience driving technical strategy and complex, high-impact projects across organizational boundaries.
  • Experience mentoring engineers or leading engineering teams.
  • Preferred: master's or PhD in databases, distributed systems, or a related field.
  • Preferred: expert knowledge of cost-based optimization, join enumeration, plan-space exploration, rewrite rules, cardinality estimation, statistics, and execution-engine design.
  • Preferred: deep understanding of the PostgreSQL query engine and experience optimizing Iceberg, Parquet, Hudi, and federated-source queries.
  • Preferred: publications or active involvement in the database research community, including SIGMOD or VLDB.

Benefits

  • Comprehensive medical, dental, vision, prescription, life, AD&D, employee assistance, mental health, medical advice, flexible spending, adoption, and surrogacy benefits.
  • 401(k) matching, paid time off, and parental leave.
  • Sign-on payments and restricted stock units may be included in the Amazon compensation package.
  • The role is listed in East Palo Alto, California; New York, New York; and Seattle, Washington.

Tech Stack

Amazon RedshiftAWSC++DatabricksGoogle BigQueryJavaPostgreSQLRustSnowflake

Categories

Amazon

About Amazon

10,000+ employees

Amazon builds and operates a global e-commerce marketplace, logistics network, and consumer devices, and provides cloud computing via AWS for businesses and developers. The company earns revenue from online retail, third‑party seller services, subscriptions like Prime, advertising, and AWS usage. Founded in 1994 and headquartered in Seattle, it is publicly traded on NASDAQ (AMZN) and serves customers in dozens of countries.

Contact me