Database Engineer, AWS DMS

Amazon Inc.; Dublin; Hybrid; EUR 90,000 - 130,000; Full time

Job summary

Amazon Development Centre Ireland Limited seeks a highly skilled AWS DMS Database Engineer to diagnose complex replication and migration failures, guide customers through production incidents, and design scalable migration strategies.

You will work cross-functionally with SDEs, data engineers, and support teams to improve tooling and resilience across PostgreSQL, Oracle, SQL Server, MySQL, and DB2 environments.

Qualifications

• Experience diagnosing complex replication and migration failures across heterogeneous databases.
• Ability to design data validation schemes for large migrations.
• Strong debugging and root-cause analysis skills in production environments.

Responsibilities

• Diagnose and resolve escalations involving heterogeneous database migration and replication.
• Perform root cause analysis on production incidents and identify source of issues.
• Design and validate migration strategies for large-scale engagements.
• Develop test scenarios for migration paths and parameter combinations.
• Collaborate with engineers to reproduce customer edge cases in code and tests.
• Contribute to pre-migration assessment rules to detect misconfigurations.
• Enhance AI-powered diagnostic tools to speed troubleshooting.
• Author runbooks and knowledge articles for support teams.

Skills

PostgreSQL

Oracle

SQL Server

MySQL

DB2

CDC

Logical replication

SQL optimization

Python

Bash

Perl

C/C++

Java

Data validation

Root cause analysis

Tools

AWS DMS

RDS

Aurora

CloudWatch

Meshclaw

Oncall Agent

Job description

Job ID: 10425494 | Amazon Development Centre Ireland Limited

AWS Database Migration Service (DMS) - Database Engineer

AWS Database Migration Service has migrated more than 1.5 million workloads to AWS, helping enterprises move from commercial databases (Oracle, SQL Server, DB2) to open-source Aurora and RDS (PostgreSQL, MySQL).

As a DMS Database Engineer, you are the front line for customer success. You diagnose complex replication and migration failures, propose database-specific workarounds, 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.

What you'll do:

• Diagnose and resolve complex customer escalations involving heterogeneous database migration and replication (Oracle CDC, SQL Server log reading, PostgreSQL logical decoding, MySQL binlog parsing).
• Perform root cause analysis on production incidents - analyzing core dumps, task logs, metrics, and database behavior to identify whether issues originate in the source, target, or DMS engine.
• Design and validate migration strategies for large-scale customer engagements, including data validation approaches, performance tuning, and cutover planning.
• Develop and maintain database-specific test scenarios for our Scalable Test Platform (STP), improving coverage across migration paths and parameter combinations.
• Collaborate with SDEs to refine migration and replication engine behavior - translating customer-observed database edge cases into reproducible test cases and code fixes.
• Contribute to Pre-Migration Assessment (PMA) rules that proactively detect configuration issues before customers begin migrations.
• Leverage and improve AI-powered diagnostic tools (DMS Oncall Agent, Meshclaw) to accelerate troubleshooting and reduce time-to-resolution.
• Author runbooks, knowledge base articles, and escalation documentation that enable support teams and fellow engineers to resolve issues without service team engagement.
• Participate in on-call rotation, triaging Sev-2/Sev-3 tickets and providing database-expert guidance to support engineers.

AWS DMS is a part of AWS Utility Computing (UC) which provides product innovations - from foundational services such as Amazon’s Simple Storage Service (S3) and Amazon Elastic Compute Cloud (EC2), to consistently released new product innovations that continue to set AWS’s services and features apart in the industry. As a member of the UC organization, you’ll support the development and management of Compute, Database, Storage, Internet of Things (Iot), Platform, and Productivity Apps services in AWS, including support for customers who require specialized security solutions for their cloud services.

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.

A day in the life

• 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-on-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 Dublin, Poland, and the US. 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.

Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice ( https://www.amazon.jobs/en/privacy_page ) to know more about how we collect, use and transfer the personal data of our candidates.

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.

Posted: September 22, 2026 (Updated 10 days ago)

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.