SQL Database Administrator

Confidential • Irvine, CA

443d • $140,000 - $145,000

About The Position

The SQL Database Administrator will lead a team of database engineers, focusing on the design, management, and optimization of SQL Server and Snowflake environments. This role involves architecting data warehouses and lakes, ensuring data governance, security, and performance optimization, while also supporting data development initiatives and light operational DBA responsibilities.

Requirements

• 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.

Nice To Haves

• Experience with Azure SQL environments.
• Knowledge of data integration and analytic tools such as Boomi, Redshift, or Databricks.

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.
• 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.

Benefits

• 401(k)
• 401(k) matching
• Employee assistance program
• Life insurance
• Vision insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Bachelor's degree