We are looking for an experienced, hands-on Senior Database Administrator with deep expertise in Microsoft SQL Server, Snowflake, and AWS RDS to lead a team of database engineers. The ideal candidate will have a strong background in designing and managing Snowflake data warehouses and data lakes, configuring high-availability SQL Server environments, and supporting data development initiatives alongside light operational DBA responsibilities. Reporting to the Senior Director of Business Intelligence, this role is key to our data strategy, driving optimization, reliability, and robust business intelligence capabilities across the organization. This role is ideal for a seasoned database professional seeking to apply their technical expertise and leadership skills in a collaborative, data-driven organization focused on innovation and growth.

Essential Duties and Responsibilities

• Architect, develop, and maintain Snowflake data warehouses and data lakes with a focus on data governance, security, and performance optimization.
• Lead the design, management, and optimization of Microsoft SQL Server databases, including Always-On availability groups, clustered environments, replication services, and performance monitoring.
• Manage and optimize database solutions within AWS RDS and support additional Azure SQL environments.
• Build and optimize ETL pipeline processes, reporting solutions, and data workflows using SSRS, SSAS, SSIS, and/or Azure Data Factory.
• Proficiency in SQL Server tools (SSMS, Profiler, Query Store, Redgate, etc.).
• Perform light DBA operational tasks, including regular database maintenance, performance tuning, backup & restore, and disaster recovery.
• Collaborate with IT and DevOps teams using platforms like Azure DevOps for project and code management.
• Support organizational data development projects, working closely with the Business Intelligence and Data Analytics teams.
• Supervise and mentor a team of database engineers, fostering collaboration and development.
• Ensure database security, integrity, and compliance following industry best practices.
• Configure and manage data integration platforms and business intelligence tools, ideally including Power BI, Tableau, Power Automate, and scripting languages like Python or R.

Qualifications

• 10+ years hands-on experience working as Microsoft SQL Server Administrator, with hands-on experience configuring and managing always-on clustered environments.
• 5+ years hands-on DBA experience working with Snowflake data warehouses and data lake environments.
• Proven mastery of Microsoft SQL Server, including t-SQL and experience managing database solutions within AWS RDS; experience with Azure SQL is preferred.
• Hands-on experience developing databases, pipelines, and reporting solutions using BI Reporting & ETL tools such as Power BI, SSRS, SSAS, SSIS, Azure Data Factory, and other similar industry tool sets.
• Familiarity with Azure DevOps or similar platforms for code and project management.
• Exposure to MySQL and experience with tools for data integration, troubleshooting, and optimization.
• Proficiency with scripting and automation, including PowerShell; experience with Python or R is a plus.
• Experience with, and knowledge of, data integration and analytic tools such as Boomi, Redshift, or Databricks is desirable.
• Excellent communication and organizational skills.
• Leadership ability to guide, mentor, and develop a high-performing team.

Education and/or Experience

• Bachelor or master's degree in computer science, Information Systems, Data Sciences, or equivalent experience.