Performance Engineer - Amazon Redshift, Redshift Data Management

• Experience with performance bottleneck analysis and system design for scaling
• Experience with one or more of database internals, OS internals, storage system internals and performance scaling for these
• Working knowledge of at least one at least one stored procedure language (SQL, pgSQL), at least one scripting language (Shell scripting, Python, PERL), and at least one application programming language (Java, C/C++)
• Experience working directly with internal or external customers, resolving issues and providing architecture leadership

Job summary

**The hiring team is willing to consider Palo Alto CA, Redmond WA, Boston MA, and Vancouver, Canada, as possible work locations**

Are you eager to help customers crunch through exabytes of data in the cloud to make business critical decisions? Amazon Redshift is the world’s most popular fully managed cloud data warehouse service that 10’s of thousands of customers use 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 best engineers to help shape the future of Redshift.

We are looking for Performance Engineers who are passionate about data warehousing, love to analyze data management systems and workloads to make them faster and easier to use. You will work with the service team to develop performance bottleneck analysis, analyze and recommend performance scaling inputs into new features, analyze regressions in performance, scale performance for new hardware, database versions and database features. You should have a forward-looking attitude and an inclination for digging deep to attack difficult and complex performance problems, and drive improvements to deliver industry leading price-performance for our customers.

This is a unique and rare opportunity to get in on the ground floor within a fast-growing business and help shape the technology, product and the business. You will bring deep technical, systems and analytics expertise with the ability to work within a fast moving, startup environment in the industry leading cloud company to deliver a broad business impact.

Inclusive Team Culture
Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences.

Work/Life Balance
Our team puts a high value on work-life balance. It isn’t about how many hours you spend at home or at work; it’s about the flow you establish that brings energy to both parts of your life. We believe striking the right balance between your personal and professional life is critical to life-long happiness and fulfillment. We offer flexibility in working hours and encourage you to find your own balance between your work and personal lives.

Mentorship & Career Growth
Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge sharing and mentorship. Our senior members enjoy one-on-one mentoring and thorough, but kind, code reviews. We care about your career growth and strive to assign projects based on what will help each team member develop into a better-rounded engineer and enable them to take on more complex tasks in the future.

Key job responsibilities

• Work with service team, database engineers and solution architects to analyze performance bottlenecks, make recommendations for scaling, automated performance regression testing and analysis, co-design performance into new feature developement.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures
• Collaborate with engineers, database engineers, solution architects, product management to design new functionality
• Work with software developers to implement performance regression automated testing
• Build and run automation and benchmark tests to improve quality, performance, and scalability
• Run database benchmark workloads
• Analyze new designs for performance and scaling
• Research issues experienced by customers and find or invent solutions
• Experience implementing automated performance regression test suites for databases, new server/storage systems or new database features
• Experience analyzing performance bottlenecks with application code interfacing with databases, cache layers, data storage, servers, networking, database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of operating system internals and/or relational database internals (locking, consistency, serialization, system recovery)

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.