Remote Senior DB Architect - AWS Data Warehouse & AI

Foley; Kansas City (MO); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) with company match

Paid time off and holidays

Wellness programs

Employee assistance program

Job summary

Foley is seeking a senior Database Operations Engineer to own and optimize our production database environments, including Microsoft SQL Server and AWS Redshift. You will drive HA/DR design, performance tuning, security, and AWS data warehouse operations while collaborating with Product, Engineering, and Analytics teams.

Ideal candidates have 7+ years of experience managing production DBs, strong AWS data warehouse skills, and a track record of automation and AI-enabled reliability improvements.

Qualifications

• 7+ years of experience in managing production database environments.
• Deep expertise in Microsoft SQL Server, including performance tuning, indexing, and HA/DR.
• Strong hands-on experience with AWS data warehouse technologies, including Amazon Redshift.
• Proven experience managing database security, access controls, and permissions in regulated or security-conscious environments.
• Comfortable working cross-functionally with Product, Infrastructure, Engineering, and leadership teams.
• Demonstrated AI fluency and curiosity, with experience using automation or AI-enabled tools to improve reliability, monitoring, or efficiency.
• Experience with additional AWS services (RDS, EC2, S3, IAM, monitoring/logging tools)
• Exposure to data engineering pipelines or analytics platforms.

Responsibilities

• Own database reliability, performance, and availability.
• Lead administration, monitoring, tuning, and optimization of SQL Server and Redshift environments.
• Design and maintain high availability, backup, and disaster recovery strategies.
• Lead data warehouse operations in AWS.
• Partner with Data and Analytics teams to support reporting and AI use cases.
• Manage database security and access controls; ensure compliance with internal and external requirements.
• Collaborate cross-functionally with Product, Engineering, Infrastructure, and Analytics teams.

Skills

SQL Server

Redshift

AWS

Data security

Automation

Cross-functional

AI tooling

Tools

RDS

EC2

S3

IAM

Monitoring

Logging

Job description

Foley is seeking a senior Database Operations Engineer to own and optimize our production database environments, including Microsoft SQL Server and AWS Redshift. You will drive HA/DR design, performance tuning, security, and AWS data warehouse operations while collaborating with Product, Engineering, and Analytics teams.

Ideal candidates have 7+ years of experience managing production DBs, strong AWS data warehouse skills, and a track record of automation and AI-enabled reliability improvements.