Additional Information
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.
A day in the life
As you design and code solutions to help our team drive efficiencies in software architecture, you'll create metrics, implement automation and other improvements, and resolve the root cause of software defects.
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.
Amazon Web · Boston, MA