Senior DB Architect — Remote | AI-Driven Data Warehouse

Foley; Boston (MA); Hybrid; USD 120.000 - 180.000; Vollzeit

Benefits dieser Stelle

Medical coverage

Dental coverage

Vision coverage

401(k) with company match

Paid time off and holidays

Wellness program

Employee assistance program

Zusammenfassung

Foley is seeking a seasoned Database Reliability Engineer to own SQL Server and Redshift environments, leading HA/DR, performance tuning, and Agile collaboration across product, engineering, and infrastructure teams.

You will design scalable AWS data warehouse architectures, apply automation to reduce manual work, and support analytics and AI use cases while ensuring security and regulatory compliance. Remote-friendly with EST hours.

Qualifikationen

• 7+ years managing production database environments
• Expertise SQL Server performance tuning, indexing, and high availability
• Experience with AWS data warehouse technologies (Redshift) and data pipelines
• Ability to design backup, recovery, and security controls for regulated environments
• Proven track record of cross-functional collaboration with Product, Infra, and Analytics teams
• Familiarity with automation or AI-enabled tooling to improve reliability and efficiency

Aufgaben

• Own database reliability, performance, and availability
• Lead admin, monitoring, tuning, and optimization of SQL Server and Redshift
• Design and maintain HA, backup, and disaster recovery strategies meeting SLAs
• Lead data warehouse operations in AWS
• Own AWS-based data warehouse architecture for performance, scalability, and cost efficiency
• Partner with Data & Analytics teams to support reporting, analytics, and AI use cases
• Manage database security and access controls across platforms
• Collaborate with Infrastructure and Security teams to ensure compliance
• Identify and mitigate risks related to data access, integrity, and availability
• Drive automation and operational excellence using scripting and AI-enabled tools
• Communicate risks, tradeoffs, and recommendations to leadership

Kenntnisse

Microsoft SQL Server

AWS Redshift

HA/DR

Data warehouse operations

Database security

Automation/AI tooling

Cross-functional collaboration

Tools

AWS EC2

S3

IAM

Jobbeschreibung

Foley is seeking a seasoned Database Reliability Engineer to own SQL Server and Redshift environments, leading HA/DR, performance tuning, and Agile collaboration across product, engineering, and infrastructure teams.

You will design scalable AWS data warehouse architectures, apply automation to reduce manual work, and support analytics and AI use cases while ensuring security and regulatory compliance. Remote-friendly with EST hours.