Sr. SQL Server DBA Platform Administrator

SILAC Insurance Company•Salt Lake City, UT

2d•Onsite

About The Position

We are seeking a highly skilled Senior SQL Server DBA / Data Platform Engineer to support and optimize our enterprise-grade on-premises SQL Server 2022 Always On Availability Group (AG) environment within a highly regulated and compliance-driven organization. This role requires deep expertise in core SQL Server administration, database security, performance optimization, high availability, and operational support for mission-critical systems. The ideal candidate will also have experience supporting hybrid data platforms that extend into Azure SQL, Azure Data Factory (ADF), and Azure Data Lake environments. In addition to traditional DBA responsibilities, this individual will collaborate closely with engineering and analytics teams to support database migrations, data transformations, BI reporting initiatives, and real-time data streaming pipelines.

Requirements

7+ years of hands-on SQL Server DBA experience in enterprise environments.
Strong experience with SQL Server 2019/2022
Always On Availability Groups (AG)
High Availability / Disaster Recovery (HA/DR)
SQL Server installations and upgrades
Performance tuning and optimization
Database security and compliance
Experience working in highly regulated or compliance-driven environments.
Advanced T-SQL skills including: Stored procedure optimization, Query tuning, Execution plan analysis, Index management
Experience supporting hybrid environments involving: Azure SQL, Azure Data Factory (ADF), Azure Data Lake
Familiarity with Microsoft BI technologies and dashboard support.
Strong troubleshooting and root cause analysis skills.
Excellent communication and collaboration abilities.

Nice To Haves

Experience with Python scripting for automation, ETL, or pipeline development.
Experience supporting real-time or streaming data pipelines.
Familiarity with DevOps, CI/CD, and Infrastructure-as-Code practices.
Knowledge of Power BI, SSIS, SSRS, or other Microsoft data platform technologies.
Experience with cloud migration initiatives from on-premises SQL Server to Azure.
Relevant Microsoft certifications preferred.

Responsibilities

Administer and support enterprise SQL Server 2022 environments with a focus on Always On Availability Groups (AG), high availability, and disaster recovery.
Perform SQL Server installations, configurations, upgrades, patching, and lifecycle management.
Monitor database health, storage utilization, performance metrics, and system availability.
Manage backup, restore, recovery, and maintenance strategies for mission-critical databases.
Troubleshoot database issues including blocking, deadlocks, replication, connectivity, and performance degradation.
Implement and maintain database security standards in a highly regulated environment.
Manage role-based access controls, encryption, auditing, and compliance requirements.
Ensure adherence to organizational security policies, governance frameworks, and data retention standards.
Support audit activities and remediation efforts.
Optimize SQL Server performance through indexing strategies, query tuning, execution plan analysis, and resource optimization.
Analyze and optimize stored procedures, views, functions, and ETL workloads.
Improve database scalability and operational efficiency for high-volume transactional systems.
Support engineering teams with database migrations, data transformations, schema changes, and performance tuning initiatives.
Assist with Microsoft BI and dashboard development initiatives.
Optimize and support Azure Data Factory (ADF) pipelines, including streaming and near real-time data integrations.
Support data delivery workflows into Azure Data Lake environments.
Administer and support Azure SQL databases and hybrid cloud data architecture.
Work closely with application developers, data engineers, BI teams, and infrastructure teams.
Provide operational guidance and best practices for database development and deployment.
Participate in on-call support rotations and production incident management as needed.