Database Engineer Intern

About the Role

As a Database Engineering Intern on the Amazon Redshift team, you will have the opportunity to work alongside experienced database and software engineers to solve challenging problems in cloud database technology. You will gain hands-on experience with database systems, data warehousing, performance analysis, automation, and distributed computing while contributing to projects that impact AWS customers.

Key Responsibilities

• Assist with database design, data modeling, and SQL development
• Write and optimize SQL queries involving multiple tables and large datasets
• Analyze database workloads and help identify opportunities for performance improvements
• Participate in performance benchmarking and testing of database workloads
• Develop scripts and software tools to automate repetitive engineering tasks
• Learn about distributed database architectures, query processing, and database system internals
• Investigate technical issues and work with engineers to identify and evaluate potential solutions
• Participate in design discussions and technical reviews
• Document technical findings and communicate results clearly to team members
• Collaborate with engineers to build reliable, scalable, and easy-to-use database solutions

Requirements & Tech Stack

• Currently have, or be in the process of obtaining, a Bachelor's degree or above in computer science, computer engineering, or related field
• Experience in one of the following programming languages: Java, Python, Ruby, Node.js, C#, or C
• Knowledge of database systems and SQL
• Knowledge of computer science fundamentals in data structures, algorithm design, and problem solving
• Experience that includes strong analytical skills, attention to detail, and effective communication abilities, or experience in technical support
• Experience with written and verbal communication and presentation
• Experience collaborating and influencing multiple teams across multiple organizations
• Are 18 years of age or older

Qualifications

• Experience in advanced SQL & ability to write complex queries from scratch from multiple tables
• Experience scripting in one or more language (e.g. Bash, Python, Perl, Ruby), or experience in development or technical support
• Familiarity with database concepts such as indexing, query optimization, transactions, or data modeling
• Coursework, projects, or internship experience involving databases, distributed systems, data analytics, or cloud computing
• Familiarity with data warehousing or large-scale data processing
• Interest in database systems, cloud computing, or large-scale data infrastructure
• Experience analyzing or benchmarking software or database performance