✦ Luna Orbit — Database Administration

Database Administrator Lead Consultant - Hybrid- Chicago, IL Hybrid

at Allstate

📍 Chicago River Point Hybrid Posted March 13, 2026
Apply Now → ← Browse All Jobs

Position Details

Type Not Specified
Experience senior
Exp. Years 10+ years
Education Not specified
Category Database Administration

About this role

This role involves leading the transformation of Allstate's data infrastructure from on-premises SQL Server to cloud-based solutions using Azure and AWS, ensuring optimal performance, security, and compliance.

Key Responsibilities

  • Lead data transformation from on-prem SQL Server to cloud
  • Mentor DBA team
  • Optimize database performance
  • Implement security and compliance
  • Collaborate with engineering teams

Technical Overview

The position requires expertise in SQL Server, cloud platforms (Azure and AWS), modern data architectures, and tools like Microsoft Fabric, OneLake, Delta Lake, and Parquet, with a focus on migration, performance tuning, and security.

Ideal Candidate

The ideal candidate is a senior database administrator with over 10 years of experience, strong expertise in SQL Server, and extensive cloud platform knowledge in Azure and AWS. They should have a proven track record of leading large-scale database migrations, optimizing performance, and ensuring security and compliance in hybrid cloud environments.

Must-Have Skills

10+ years in database administration3+ years in Azure and/or AWS cloud platformsExperience with SQL ServerDatabase performance tuningHigh availabilityDisaster recoverySecurity and compliance in cloud environments

Nice-to-Have Skills

Oracle experienceMicrosoft FabricOneLakeExperience with Delta Lake and modern data architectures

Tools & Platforms

Microsoft AzureAmazon Web ServicesMicrosoft FabricOneLakeDelta LakeParquet

Required Skills

SQL ServerMicrosoft AzureAWScloud migrationdatabase performance tuninghigh availabilitydisaster recoverysecurity and complianceMicrosoft FabricOneLakeDelta LakeParquet

Hard Skills

SQL ServerMicrosoft AzureAmazon Web ServicesAWSAzureMicrosoft FabricOneLakeDelta LakeParquetDatabase performance tuningHigh availabilityDisaster recoverySecurity and compliance in cloud environments

Soft Skills

communicationstakeholder managementstrategic thinkingleadershipmentoringcollaboration

Industry & Role

Industry Insurance
Job Function Lead cloud-based database migration and management for enterprise data infrastructure

Keywords for Your Resume

Database AdministratorSQL ServerMicrosoft AzureAWSAmazon Web Servicescloud platformsdatabase migrationsperformance tuninghigh availabilitydisaster recoverysecurity and complianceMicrosoft FabricOneLakeDelta LakeParquetAzureDatabase performance tuningHigh availabilityDisaster recoverySecurity and compliance

Deal Breakers

Less than 10 years of database administration experience, No experience with SQL Server or cloud platforms, Lack of cloud migration experience, No familiarity with security and compliance in cloud

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile