Database Engineer, AWS DMS

Amazon Web Services (AWS); Boston (MA); On-site; USD 125,000 - 169,000; Full time

Job summary

Amazon Web Services, Inc. is seeking a DMS Database Engineer to diagnose and fix complex replication and migration failures across heterogeneous databases. You will partner with software and field engineers to analyze customer incidents involving CDC, schema migrations, and data validation.

The role emphasizes production support and automation within the AWS data services stack. You will work across PostgreSQL, Oracle, SQL Server, MySQL, and DB2, building tools to accelerate troubleshooting and

Qualifications

• 4+ years of relational database technology experience
• Experience with at least one scripting language and a procedural language for at least one database

Responsibilities

• Diagnose and resolve complex production issues across multiple database engines
• Investigate and resolve performance degradation, data corruption, replication lag, CDC failures, and schema migration edge cases
• Build automation, log analysis tools, and diagnostic scripts using SQL and scripting languages to accelerate troubleshooting
• Guide customers through migration and replication challenges using CDC, logical replication, and data validation
• Collaborate with SDEs on root cause analysis by reasoning about C/C++ or Java code in the DMS replication engine
• Operate within the AWS ecosystem (RDS, Aurora, DMS, Redshift, S3, CloudWatch) to investigate issues end-to-end
• Document findings with runbooks and knowledge base articles for teams and customers

Skills

PostgreSQL

Oracle

SQL Server

MySQL

DB2

Python

Bash

Perl

C/C++

Java

Education

Bachelor's degree in computer science, engineering, mathematics or equivalent

Bachelor's degree in computer science or equivalent

Tools

SQL

Python

Bash

Perl

Job description

As a DMS Database Engineer, you are the front line for customer success. You are a builder and partner with the software engineers in building features to simplify the migration journey for customers. You partner with field engineers in learning customer pain points and diagnosing complex replication and migration failures, and guide customers through production incidents involving CDC, schema migration, and data validation across heterogeneous database engines. You work at the intersection of deep database internals knowledge and customer-facing problem solving - turning ambiguous production failures into root causes and fixes.

Key job responsibilities

• Leverage deep expertise in database internals (storage engines, transaction logs, replication mechanisms, query optimization) across PostgreSQL, Oracle, SQL Server, MySQL, or DB2 to diagnose and resolve complex production issues.
• Investigate and resolve customer-facing database problems including performance degradation, data corruption, replication lag, CDC failures, and schema migration edge cases.
• Build automation, log analysis tools, and diagnostic scripts using SQL and scripting languages (Python, Bash, Perl) to accelerate troubleshooting and reduce manual investigation effort.
• Apply knowledge of database replication technologies - CDC (Change Data Capture), logical replication, log-based capture, and data validation - to guide customers through migration and replication challenges.
• Collaborate with SDEs on root cause analysis by reading and reasoning about C/C++ or Java code in the DMS replication engine to trace failures from customer symptoms to code-level defects.
• Operate within the AWS ecosystem (RDS, Aurora, DMS, Redshift, S3, CloudWatch) to investigate issues end-to-end across infrastructure, networking, and database layers.
• Document complex technical findings clearly — writing root cause analyses, runbooks, and knowledge base articles that enable support teams, engineering peers, and customers to resolve issues independently.

You’ll Also

• Build high-impact solutions to deliver to our large customer base.
• Participate in design discussions, code review, and communicate with internal and external stakeholders.
• Work cross-functionally to help drive business decisions with your technical input.
• Work in a startup-like development environment, where you’re always working on the most important stuff.

About The Team

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‑one mentoring and thorough, but kind, code reviews. We care about your career growth and strive to assign projects that help our team members develop your engineering expertise so you feel empowered to take on more complex tasks in the future.

The DMS engine team operates across US, Dublin, and Poland. We're a team that takes ownership of a complex system and makes it better every release - reducing crashes, closing security gaps, and making migrations reliable enough that customers don't need our help to succeed. We leverage AI extensively: from autonomous bug-fixing to an on‑call agent that cuts troubleshooting time dramatically.

Basic Qualifications

• Bachelor's degree in computer science, engineering, mathematics or equivalent, or experience with database administration
• 4+ years of relational database technology (such as Redshift, Oracle, MySQL or MS SQL) experience
• Experience with at least one scripting language (shell, Python, Perl) and a procedural language for at least one database (PL/SQL, T‑SQL etc.)
• Bachelor's degree in computer science or equivalent
• Experience in any Bigdata architecture, or experience that includes strong analytical skills, attention to detail, and effective communication abilities and experience in Linux/RHEL

Preferred Qualifications

• Knowledge of database design and implementation or equivalent
• Experience with general troubleshooting/debugging of hardware, or experience debugging, profiling, and implementing best software engineering practices in large-scale systems
• Experience with automation and any version control tools, or experience with threat modeling and penetration testing and experience in SQL Server/MySQL
• Experience in automating, deploying, and supporting large-scale infrastructure

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign‑on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, MA, Boston - 124,700.00 - 168,800.00 USD annually

Company - Amazon Web Services, Inc.

Job ID: A10440976