AWS Data Migration Engineer​/Architect

AWS Data Migration Engineer/Architect role at Slalom

We are seeking an experienced Cloud Data Migration Architect with deep expertise in SQL Server, Oracle, DB2, or a combination of these platforms to lead the design, migration, and optimization of scalable database solutions in the AWS cloud. This role focuses on modernizing on‑premises database systems by architecting high‑performance, secure, and reliable AWS‑hosted solutions.

As a modern technology company, we are never short of technical challenges. We enable our clients to learn from their data, create remarkable digital experiences, and adopt new technologies. Our technologists collaborate with interesting challenges, innovative minds, and emerging technologies across design, engineering, and analytics expertise.

• Design and optimize database solutions on AWS, including Amazon RDS, EC2‑hosted instances, and advanced configurations such as SQL Server Always On or Oracle RAC.
• Lead and execute cloud database migrations using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and custom automation tools.
• Architect high‑performance database schemas, indexing strategies, partitioning models, and query optimization techniques.
• Optimize complex SQL queries, stored procedures, functions, and views to ensure performance and scalability in the cloud.
• Implement high‑availability and disaster recovery strategies such as Always‑On, Failover Clusters, Log Shipping, and Replication tailored to each RDBMS.
• Ensure security best practices, including IAM‑based access control, encryption, and compliance with industry standards.
• Collaborate with Dev Ops teams to implement Infrastructure‑as‑Code using Terraform, Cloud Formation, or AWS CDK.
• Monitor performance using tools such as AWS Cloud Watch, Performance Insights, Query Store, Dynamic Management Views (DMVs), or Oracle‑native tools.
• Work with software engineers and data teams to integrate cloud databases into enterprise applications and analytics platforms.
• Travel regionally up to 30% as required.

• 8+ years of experience in database architecture, design, and administration with at least one of the following: SQL Server, Oracle, or DB2.
• Expertise in one or more RDBMS platforms:
  Microsoft SQL Server, Oracle, DB2.
• Hands‑on experience with AWS database services (RDS, EC2‑hosted databases).
• Strong understanding of HA/DR solutions and cloud database design patterns.
• Experience with ETL development and data integration using SSIS, AWS Glue, or custom solutions.
• Familiarity with AWS networking components (VPCs, security groups) and hybrid cloud connectivity.
• Strong troubleshooting and analytical skills to resolve complex database and performance issues.
• Ability to work independently and lead database modernization initiatives in collaboration with engineering and client stakeholders.

• AWS certifications such as AWS Certified Database – Specialty or AWS Certified Solutions Architect – Professional.
• Experience with No
  
  SQL databases or hybrid data architectures.
• Knowledge of analytics and big data tools (e.g., Snowflake, Redshift, Athena, Power BI, Tableau).
• Familiarity with containerization (Docker, Kubernetes) and serverless technologies (AWS Lambda, Fargate).
• Experience with DB2 on‑premise or cloud‑hosted environments.

Slalom is a fiercely human business and technology consulting company that leads with outcomes to bring more value in all ways, always. From strategy through delivery, our agile teams across 52 offices in 12 countries collaborate with clients to build powerful customer experiences, innovative ways of working, and new products and services to life.

Slalom invests in benefits that include meaningful time off and paid holidays, parental leave, 401(k) with a match, a range of choices for highly subsidized health, dental, and vision coverage, adoption and fertility assistance, and short/long‑term disability. We also offer a yearly $350 reimbursement account for well‑being expenses and discounted home, auto, and pet insurance.

Base salary ranges vary by location and level:

• Consultant: $96,000–$135,000 (wide markets) or…