Home
/
Comprehensive
/
SDE Intern – High-Performance Query Processing, Query Optimization
SDE Intern – High-Performance Query Processing, Query Optimization-March 2024
East Palo Alto
Mar 28, 2026
ABOUT AMAZON
Our mission is to be the world’s most customer-centric company.
10,000+ employees
Technology
VIEW COMPANY PROFILE >>
About SDE Intern – High-Performance Query Processing, Query Optimization

  Description

  Amazon Web Services (AWS) internships are for 12 consecutive weeks during summer. By applying to this position, your application will be considered for the locations listed on this posting.

  Amazon Redshift is the world’s most popular fully managed cloud data warehouse. Tens of thousands of enterprise customers use Redshift to crunch through exabytes of data in the cloud to make business critical decisions every day. To stay ahead in such a mission critical setting, at Redshift, we must always re-invent ourselves for customers. We are always looking for the innovative engineers to help shape the future of Redshift.

  About the team

  Query Processing team is at the heart of Redshift data plane and is responsible for query analysis, query optimization and massively parallel execution engine. Query Processing team is focused on maintaining Amazon Redshift’s lead on price-performance.

  Query Processing team delivers extreme performance by uniquely combining novel techniques for distributed query planning, code generation, query compilation, query scheduling, resource-planning, and superscalar query execution with optimized data encodings accessed with high performance SIMD kernels, and hardware conscious algorithms. We also work closely with AWS platform teams in shaping requirements for next generation platforms to run database/analytics applications.

  Our team consists of industry leading innovators, with multitudes of patents and research publications in this space. We are a fun-loving team, that is passionate about ideating, designing and delivering query processing and overall database architecture towards extreme performance. We are distributed across many locations in US, Germany, and are expanding in other geographies.

  This is a unique and rare opportunity to get in on the ground floor within a fast-growing business and help shape the technology powering analytical workloads for Fortune 500 companies, startups, and everything in between. You will bring deep technical, algorithmic and coding expertise with the ability to work within a fast moving and collaborative environment in the industry leading cloud company to deliver a broad business impact. If this sounds exciting to you - come build the future with us!

  Key job responsibilities

  As a software engineer in vectorized query execution team, you will:

  • Design and implement state-of-the-art distributed data processing algorithms for the parallel execution query engine.

  • Identify opportunities for performance improvement by in-depth analysis of the query plan and query execution states.

  • Deploy and monitor new features in a highly available and fault tolerant system running in the cloud.

  We are open to hiring candidates to work out of one of the following locations:

  East Palo Alto, CA, USA | New York, NY, USA

  Basic Qualifications

  • Pursuing Master’s Degree or higher in Computer Science or related field with graduation conferral date after December 2024

  • Programming experience with C or C+• Internship, project, or academic experience in at least one of the areas: query optimization, job scheduling, resource management, query execution, data compression technologies, information theory, GPUs, or ML.

  Preferred Qualifications

  • Pursuing PhD degree with focus on Systems / Information Theory, Databases, Computer Science, Computer Engineering, or related

  • Strong knowledge of Computer Science fundamentals in object-oriented design, data structures, algorithm design, problem solving, and complexity analysis

  • Strong software development skills

  Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.

  Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $88,400/year in our lowest geographic market up to $200,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. Applicants should apply via our internal or external career site.

Comments
Welcome to zdrecruit comments! Please keep conversations courteous and on-topic. To fosterproductive and respectful conversations, you may see comments from our Community Managers.
Sign up to post
Sort by
Show More Comments
SIMILAR JOBS
Water / Wastewater Engineering Manager 6 - US Hybrid
Water / Wastewater Engineering Manager 6 - US Hybrid Date: Jan 23, 2024 Location: US Company: Black & Veatch Family of Companies Together, we own our company, our future, and our shared success.
Dispatcher
Dispatcher Location19 Natalie Way Plymouth, Massachusetts 02360 USPhone NumberCategoriesOperation SupportReq IDJR1372 Dispatcher (Open) First for a reasonFirst Student is the largest school transport
L2 Customer Technical Support Analyst - MICROS - Simphony/Ebusiness
Job Description L2 Customer Technical Support Analyst - MICROS - Simphony/Ebusiness Location: Orlando, FL or Columbia, MD highly preferred No visa sponsorship is available for this position. As a mem
Hotel Laundry Attendant
Req ID: 431582 Address: 7101 W. Sundust Rd Chandler, AZ, 85226 Welcome to Love’s! * * Where People are the Heart of Our Success * * Hotel Laundry Attendant Laundry Attendants are expected to maintain
Creative Lead / Designer II
Company Summary DISH, an EchoStar Company, is a Fortune 250 that is reimagining the future of connectivity. For over 40 years, we’ve been challenging the status quo and evolving our company to antici
Phlebotomist
Description Want to Expand your career-development potential, your ability to help donors and patients, and your access to professional opportunities? We’re growing fast. [You can, too!] There are so
Intermediate Compliance Specialist (Hybrid Work Option)
36718BR Requisition ID: 36718BR Business Unit: COR Job Description: CDM Smith is seeking an Intermediate Compliance Specialist to join our Corporate Compliance Team. This individual performs basic to
Senior Member of Technical Staff (JoinOCI-SDE)
Job Description We are seeking a strong engineer to join our team which is focused on building and maintaining a scalable software control platform for Compute Infrastructure. Major focus areas of so
Pharmacy Technician
Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced
Health Technician (Dietetic)
Summary The Dayton Veterans Affairs Medical Center (VAMC) is recruiting for a Health Technician. The Health Technician will function with in Nutrition and Food Services. The primary purpose of the po
Copyright 2023-2026 - www.zdrecruit.com All Rights Reserved