Performance Engineer, Amazon Aurora

Company:  Amazon
Location: East Palo Alto
Closing Date: 20/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description

DescriptionWe 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 AltoKey job responsibilitiesWork 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 proceduresCollaborate with engineers, database engineers, solution architects, product management to design new functionalityWork with software developers to implement performance regression automated testingBuild and run automation and benchmark tests to improve quality, performance, and scalabilityRun database benchmark workloadsAnalyze new designs for performance and scalingResearch issues experienced by customers and find or invent solutionsA day in the lifeWork with SDEs, SDMs on bottleneck analysis and identifying options to fix and scale performance issuesWork with SDEs to develop automated performance regression test suites that will test new hardware, new database versions, new featuresWork with database engineers and customers on operational performance issues of scalingAbout the teamAmazon 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 QualificationsExperience with performance bottleneck analysis, system design for scalingExperience with one or more of database internals, server/operating system internals, storage system internals and performance scaling for theseExperience implementing automated performance regression test suites for databases, new server/storage system hardware and new database features, replication, backup, snapshots, clonesExperience 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 applicationsWorking knowledge of operating system internals and/or relational database internals (locking, consistency, serialization, recovery paths)Knowledge of database internals such as system catalogsWorking 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 databaseExperience working directly with internal or external customers, resolving issues and providing architecture leadershipPreferred QualificationsExperience migrating legacy on-prem code to cloud native stacksExperience migrating application code from commercial database engines to open source enginesExperience building application and database systems with PostgreSQL or MySQLSoftware performance analysis and bottleneck identification, scaling, automation experiencePublished papers, articles, blogs on performance at industry events, benchmark results or academic eventsAmazon 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 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 This position will remain posted until filled. Applicants should apply via our internal or external career site.

Apply Now
An error has occurred. This application may no longer respond until reloaded. Reload 🗙