Job description

SQL Database Administrator job at Confidential. Irvine, CA. We are looking for an experienced, hands-on SQL 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. Salary range: $140,000-$145,000 • 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. Job Type: Full-time Pay: $140,000.00 - $145,000.00 per year Benefits: • 401(k) • 401(k) matching • Employee assistance program • Life insurance • Vision insurance Schedule: • 8 hour shift • Monday to Friday Experience: • Microsoft SQL Server DBA: 6 years (Required) • Snowflake DBA: 4 years (Required) Ability to Commute: • Irvine, CA 92618 (Required) Work Location: In person

Requirements