Database Engineer, AWS DMS

Amazon.com Inc

Boston, MA

JOB DETAILS
SKILLS
Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Automation, Bash Scripting, Bug Tracking Software, C Programming Language, C++ Programming Language, Centers for Disease Control and Prevention (CDC), Code Reviews, Cross-Functional, Customer Relations, Data Collection, Data Migration, Data Quality, Database Programming, Database Replication, Database Technology, Ecosystems, IBM DB2, Identify Issues, Java, Knowledge Base, Mentoring, Metrics, Microsoft SQL Server, MySQL, On Call, Oracle Database, Perl Programming Language, PostgreSQL, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Replication and Remote Mirroring, Resolve Customer Issues, Root Cause Analysis, SQL (Structured Query Language), Sales/Support Engineering (SE), Scripting (Scripting Languages), Software Architecture, Software Engineering, Startup, Technical Writing
LOCATION
Boston, MA
POSTED
24 days ago

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.

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 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.

About the Company

A

Amazon.com Inc

At Amazon, we don’t wait for the next big idea to present itself. We envision the shape of impossible things and then we boldly make them reality. So far, this mindset has helped us achieve some incredible things. Let’s build new systems, challenge the status quo, and design the world we want to live in. We believe the work you do here will be the best work of your life.

Wherever you are in your career exploration, Amazon likely has an opportunity for you. Our research scientists and engineers shape the future of natural language understanding with Alexa. Fulfillment center associates around the globe send customer orders from our warehouses to doorsteps. Product managers set feature requirements, strategy, and marketing messages for brand new customer experiences. And as we grow, we’ll add jobs that haven’t been invented yet.

It’s Always Day 1
At Amazon, it’s always “Day 1.” Now, what does this mean and why does it matter? It means that our approach remains the same as it was on Amazon’s very first day – to make smart, fast decisions, stay nimble, invent, and stay focused on delighting our customers. In our 2016 shareholder letter, Amazon CEO Jeff Bezos shared his thoughts on how to keep up a Day 1 company mindset. “Staying in Day 1 requires you to experiment patiently, accept failures, plant seeds, protect saplings, and double down when you see customer delight,” he wrote. “A customer-obsessed culture best creates the conditions where all of that can happen.” You can read the full letter here

Our Leadership Principles
Our Leadership Principles help us keep a Day 1 mentality. They aren’t just a pretty inspirational wall hanging. Amazonians use them, every day, whether they’re discussing ideas for new projects, deciding on the best solution for a customer’s problem, or interviewing candidates. To read through our Leadership Principles from Customer Obsession to Bias for Action, visit https://www.amazon.jobs/principles
COMPANY SIZE
10,000 employees or more
INDUSTRY
Retail
FOUNDED
1994
WEBSITE
http://Amazon.com/militaryroles