Sr. SQL Server DBA Platform Administrator

SILAC Insurance Company
Salt Lake City, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Salt Lake City, United States of America

Tech stack

Computing Platforms
Azure
Databases
Continuous Integration
Data Architecture
Information Engineering
Data Infrastructure
ETL
Data Transformation
Data Retention
Database Development
Database Security
DevOps
Disaster Recovery
Python
Microsoft Data Access Components
Microsoft SQL Server
SQL Azure
Performance Tuning
Query Optimization
Power BI
Azure
SQL Stored Procedures
SQL Server Reporting Services
SQL Server Integration Services
Data Streaming
T-SQL
Scripting (Bash/Python/Go/Ruby)
Azure
System Availability
Database Optimization
Software Troubleshooting
HybridCloud
Database Migration
Infrastructure Automation Frameworks
Real Time Data
Data Management
Cloud Migration
Cloud Integration
SQL Server Management Studio (SSMS)
Data Delivery
Stream Processing
Data Pipelines

Job description

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.

Job Details

SQL Server Administration & Operations

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

Security & Compliance

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

Performance Optimization

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

Data Engineering & Cloud Integration

  • Support engineering teams with:
  • Database migrations
  • Data transformations
  • Schema changes
  • 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.

Collaboration & Support

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

Requirements

Do you have experience in Technical troubleshooting support?, * 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.

Desired

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

Technical Environment

  • SQL Server 2022 Enterprise
  • Always On Availability Groups (AG)
  • Azure SQL
  • Azure Data Factory (ADF)
  • Azure Data Lake
  • Microsoft BI / Power BI
  • Python (preferred)
  • Hybrid On-Prem / Azure Cloud Data Platform

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • Parental leave
  • 401(k)
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Life insurance

Apply for this position