Database Engineer, AWS DMS
Boston, MA - USA
Job Summary
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 youll create metrics implement automation and other improvements and resolve the root cause of software defects.
Youll 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 youre 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 were 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. Were 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 dont need our help to succeed. We leverage AI extensively: from autonomous bug-fixing to an on-call agent that cuts troubleshooting time dramatically.
- Bachelors 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.)
- Bachelors 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
- 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 for more information. If the country/region youre applying in isnt 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 MA Boston - 124700.00 - 168800.00 USD annually
Required Experience:
IC
About Company
Free shipping on millions of items. Get the best of Shopping and Entertainment with Prime. Enjoy low prices and great deals on the largest selection of everyday essentials and other products, including fashion, home, beauty, electronics, Alexa Devices, sporting goods, toys, automotive ... View more