Description

We are looking for talented database performance engineers that are passionate about data and databases to help scale performance for Amazon Aurora. We are innovating with the largest scaling cloud relational database to make it easier for customers to migrate their legacy enterprise databases and applications to cloud native AWS relational database as a service compatible with PostgreSQL or MySQL. 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, new database versions and new database features and help customers adopt this exciting leader in scale relational database product. You should have a forward-looking attitude and a penchant for digging deep to attack difficult and complex performance problems.

Open to: Palo Alto

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

A day in the life

• Work with SDEs, SDMs on bottleneck analysis and identifying options to fix and scale performance issues

• Work with SDEs to develop automated performance regression test suites that will test new hardware, new database versions, new features

• Work with database engineers and customers on operational performance issues of scaling

About the team

Amazon Aurora is one of the fastest growing AWS services, providing and managing relational databases as a service. We take relational open source databases like PostgreSQL and MySQL to their limits - our customers rely on Amazon Aurora databases for their business and due to our scale, we solve challenges no other database environment sees.

Basic Qualifications

• Experience with performance bottleneck analysis, system design for scaling

• Experience with one or more of database internals, server/operating system internals, storage system internals and performance scaling for these

• Experience implementing automated performance regression test suites for databases, new server/storage system hardware and new database features, replication, backup, snapshots, clones

• 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, recovery paths)

• Knowledge of database internals such as system catalogs

• Working knowledge of at least one at least one stored procedure language (T-SQL, pl/sql, or PL/pgSQL), at least one scripting language (Powershell, Python, or Perl), and at least one application programming language (Java, C#, or Ruby)

• Experience analyzing issues holistically, from the application tier through the database

• Experience working directly with internal or external customers, resolving issues and providing architecture leadership

Preferred Qualifications

• Experience migrating legacy on-prem code to cloud native stacks

• Experience migrating application code from commercial database engines to open source engines

• Experience building application and database systems with PostgreSQL or MySQL

• Software performance analysis and bottleneck identification, scaling, automation experience

• Published papers, articles, blogs on performance at industry events, benchmark results or academic events

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 $96,000/year in our lowest geographic market up to $194,200/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. This position will remain posted until filled. Applicants should apply via our internal or external career site.