AWS SQL Architect

Slalom; Denver (CO); Remote; USD 131,000 - 237,000; Full time

Job summary

Slalom is seeking a Cloud Data Migration Architect specialized in SQL and AWS to lead the migration and optimization of database solutions. This remote position involves collaborating with engineers and stakeholders on data strategies, while ensuring high performance of SQL Server databases. Candidates must have over eight years of relevant experience and strong proficiency in AWS services.

Benefits

401(k) with match

Health, dental, and vision coverage

Parental leave

Well-being reimbursement

Paid holidays and meaningful time off

Qualifications

• 8+ years of experience in SQL Server database architecture.
• Expertise with AWS RDS and MSSQL instances.
• Strong knowledge of high-availability solutions.

Responsibilities

• Design and optimize SQL Server solutions on AWS.
• Migrate MSSQL databases to AWS with a focus on performance and security.
• Implement high-availability and disaster recovery solutions.

Skills

SQL Server architecture

AWS database services

Database performance tuning

ETL development

Security best practices

Infrastructure-as-Code

Troubleshooting skills

Education

Bachelor's degree in Computer Science or related field

Tools

AWS Database Migration Service

Terraform

AWS CloudFormation

Job description

Join to apply for the Cloud Data Migration Architect (SQL/AWS) role at Slalom

2 weeks ago Be among the first 25 applicants

Join to apply for the Cloud Data Migration Architect (SQL/AWS) role at Slalom

*Remote position with flexibility to be based outside of the locations listed*

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 AWS SQL Architect with expertise in Microsoft SQL Server (MSSQL) to design, implement, and optimize scalable database solutions in the AWS cloud. This role will focus on architecting and migrating MSSQL databases to AWS while ensuring high performance, security, and reliability.

As a key technical leader, you will work closely with data engineers, cloud architects, and business stakeholders to define data strategies, database migrations, ETL pipelines, and performance optimization solutions. This is an excellent opportunity for a data professional with deep expertise in SQL Server, AWS cloud services, and database architecture best practices to shape the foundation of a cloud-first data ecosystem.

What You’ll Do

• Design and optimize SQL Server solutions on AWS, including Amazon RDS for SQL Server, EC2-hosted MSSQL, and AWS SQL Server Always On Availability Groups.
• Experience performing\leading server migrations to AWS using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and custom automation scripts.
• Design high-performance database schemas, indexing strategies, partitioning, and query optimization techniques for SQL Server workloads as well as optimizing complex SQL queries, stored procedures, views, and functions to improve database performance.
• Implement high-availability and disaster recovery (HA/DR) solutions, including Always on Failover Clusters, Log Shipping, and Replication.
• Establish and enforce data security best practices, including encryption, IAM-based access control, and compliance with industry standards.
• Work closely with DevOps teams to implement Infrastructure-as-Code (IaC) solutions using Terraform, CloudFormation, or AWS CDK.
• Monitor SQL Server performance using tools like CloudWatch, Performance Insights, Query Store, and Dynamic Management Views (DMVs).
• Collaborate with software engineers and data teams to integrate AWS-hosted SQL Server databases with enterprise applications and analytics platforms.
• Travel expectations: up to 10% regional travel
  
  

What You’ll Bring

• 8+ years of experience in SQL Server database architecture, design, and administration.
• Strong expertise in Microsoft SQL Server (MSSQL) and query performance tuning.
• Hands-on experience with AWS database services, including Amazon RDS for SQL Server and EC2-hosted MSSQL instances.
• Strong understanding of SQL Server high-availability solutions, such as Always-On, Availability Groups, Failover Clustering, and Replication.
• Experience in ETL development and data integration using SSIS, AWS Glue, or other pipeline tools.
• Familiarity with AWS networking, VPCs, security groups, and hybrid cloud connectivity.
• Hands-on experience with DevOps and Infrastructure-as-Code (IaC) tools, such as Terraform, CloudFormation, or Ansible.
• Strong troubleshooting and analytical skills with the ability to resolve complex database performance issues.
• Familiarity with containerization (Docker, Kubernetes) and serverless computing (AWS Lambda, Fargate).
  
  

Nice To Have

• AWS certifications such as AWS Certified Database – Specialty or AWS Certified Solutions Architect – Professional.
• Experience with Oracle, NoSQL databases and hybrid cloud database architectures.
• Knowledge of big data and analytics technologies (Redshift, Athena, Snowflake, Power BI, Tableau).
  
  

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 includemeaningful 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 $131,000 to $186,000 for Senior Consultant level and is $145,000 to $206,000 for Principal level and is $167,000 to $237,000 for Senior 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 inclusion, diversity, and equity in the workplace. 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.

We will accept applications until June 26, 2025.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at Slalom by 2x

Sign in to set job alerts for “Data Architect” roles.

Commerce City, CO $60,000.00-$60,000.00 2 months ago

Denver, CO $150,000.00-$180,000.00 4 months ago

Boulder, CO $147,000.00-$216,000.00 1 week ago

Solutions Architect, Retail, Google Cloud

Boulder, CO $147,000.00-$216,000.00 2 days ago

AI Architect II, Go-To-Market Applied AI, Google Cloud

Boulder, CO $149,000.00-$218,000.00 4 hours ago

AI Architect III, Go-To-Market Applied AI, Google Cloud

Boulder, CO $180,000.00-$267,000.00 4 hours ago

Zoho Platform & Applications Architect - Remote

Boulder, CO $90,000.00-$120,000.00 1 week ago

Louisville, CO $120,000.00-$160,000.00 7 hours ago

Centennial, CO $189,761.00-$260,922.00 2 hours ago

Delivery Solutions Architect - Data & AI

Data Solutions Architect – Federal Program

Englewood, CO $119,765.00-$154,990.00 1 minute ago

Denver, CO $140,000.00-$160,000.00 6 hours ago

Data Architect - Business and Go-To-Market Data Architecture

(USA) Senior Manager, Software Engineering - Data

Denver, CO $121,000.00-$242,000.00 6 days ago

Denver, CO $90,000.00-$105,000.00 3 days ago

Denver Metropolitan Area $125,000.00-$170,000.00 4 days ago

Principal Architect, Data Center Engineering

Denver, CO $200,000.00-$250,000.00 20 hours ago

Senior Architect - Food & Beverage (Multiple Locations)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.