AWS Data Migration Engineer/Architect

Who You'll Work With
As a modern technology company, we've never met a technical challenge we didn't like. We enable our clients to learn from their data, create incredible digital experiences, and make the most of new technologies. We blend design, engineering, and analytics expertise to build the future. We surround our technologists with interesting challenges, innovative minds, and emerging technologies.

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 will focus on modernizing on-premises database systems by architecting high-performance, secure, and reliable AWS-hosted solutions.

As a key technical leader, you will work closely with data engineers, cloud architects, and business stakeholders to define data strategies, lead complex database migrations, build out ETL pipelines, and optimize performance across legacy and cloud-native environments.

What You'll Do

• Design and optimize database solutions on AWS, including Amazon RDS, EC2-hosted instances, and advanced configurations like SQL Server Always On or Oracle RAC (Real Application Clusters).
• 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 (HA/DR) strategies including Always-On, Failover Clusters, Log Shipping, and Replication, tailored to each RDBMS.
• Ensure security best practices are followed including IAM-based access control, encryption, and compliance with industry standards.
• Collaborate with DevOps teams to implement Infrastructure-as-Code (IaC) using tools like Terraform, CloudFormation, or AWS CDK.
• Monitor performance using tools such as AWS CloudWatch, 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.
• Up to 30% regional travel may be required.

What You'll Bring

• 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 of the following 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 tools such as 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.

Nice to Have

• AWS certifications such as AWS Certified Database – Specialty or AWS Certified Solutions Architect – Professional.
• Experience with NoSQL 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.

About Us
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 bring powerful customer experiences, innovative ways of working, and new products and services to life. We are trusted by leaders across the Global 1000, many successful enterprise and mid-market companies, and 500+ public sector organizations to improve operations, drive growth, and create value. At Slalom, we believe that together, we can move faster, dream bigger, and build better tomorrows for all.

Compensation And Benefits
Slalom prides itself on helping team members thrive in their work and life. As a result, Slalom is proud to invest 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, & vision coverage, adoption and fertility assistance, and short/long-term disability. We also offer yearly $350 reimbursement account for any well-being-related expenses, as well as discounted home, auto, and pet insurance.

Slalom is committed to fair and equitable compensation practices. For this position, the base salary pay range is $125,000 to $170,000 for Senior Consultant level and is $139,000 to $188,000 for Principal level. In addition, individuals may be eligible for an annual discretionary bonus. Actual compensation will depend upon an individual's skills, experience, qualifications, location, and other relevant factors. The salary pay range is subject to change and may be modified at any time.

EEO and Accommodations
Slalom is an equal opportunity employer and is committed to attracting, developing and retaining highly qualified talent who empower our innovative teams through unique perspectives and experiences. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans' status, or any other characteristic protected by federal, state, or local laws. Slalom will also consider qualified applications with criminal histories, consistent with legal requirements. Slalom welcomes and encourages applications from individuals with disabilities. Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require accommodations during the interview process.