Senior Azure Database Administrator / SQL Server DBA (DBA 4)-(Locals Only )

Job Title: Senior Azure Database Administrator / SQL Server DBA (DBA 4)Location: Lansing, MI (Hybrid – Local Candidates Only)
Work Arrangement: Hybrid – 2 days onsite per week (Wednesday & Thursday), starting Day 1
Duration: 1 Year Contract (Possible Extension)
Visa: No OPT/CPT

Important Location Requirement: Candidates must currently reside within a 90–100 mile radius of Lansing, MI. Local candidates only. Must be available to work onsite from Day 1 every Wednesday and Thursday.

Position Overview

The State of Michigan is seeking an experienced Senior Azure Database Administrator / SQL Server DBA to support the Center for Educational Performance and Information (CEPI), primarily focusing on the modernization of the Statewide Longitudinal Data System (SLDS) and alignment with Common Education Data Standards (CEDS).

The ideal candidate will have extensive experience in Microsoft SQL Server database administration, Azure Database Services, SQL data modeling, and ETL development. This role involves managing complex database environments, developing and maintaining data pipelines, optimizing database performance, and supporting the migration of on-premises ETL processes to cloud infrastructure.

Top 3 Must-Have Skills

• Azure Database Services

• SQL Data Modeling and Database Structure

• Extensive ETL Development Experience

Required Technical Skills

• 12+ years of overall IT/database experience.

• 8–10 years of hands-on T-SQL experience.

• 6–8 years of ETL development experience.

• 5 years of PowerShell experience.

• 5 years of Azure DevOps experience.

• 5 years of Scrum/Agile experience.

Key Responsibilities

• Design, develop, implement, and maintain scalable ETL processes and data pipelines.

• Perform database administration, data analysis, database design, and performance tuning.

• Develop and maintain logical and physical data models, relational database structures, and data dictionaries.

• Manage Microsoft SQL Server database environments across Development, QA, Pre-Production, and Production.

• Support Azure database services and the migration of on-premises ETL processes to cloud environments.

• Develop and optimize complex SQL queries, stored procedures, and database objects using T-SQL.

• Monitor database performance, troubleshoot issues, and perform root cause analysis.

• Implement database security, backup, recovery, and disaster recovery procedures.

• Collaborate with developers, business teams, and stakeholders to ensure data integrity, accuracy, and consistency.

• Support data warehouse modernization and Common Education Data Standards (CEDS) implementation.

• Utilize PowerShell and Azure DevOps for automation, deployment, and database management.

• Ensure database architecture, security standards, and data management best practices are followed.

Preferred Experience

• Experience with large-scale SQL Server data warehouse environments.

• Knowledge of Statewide Longitudinal Data Systems (SLDS).

• Familiarity with Common Education Data Standards (CEDS).

• Experience with SQL Server Reporting Services (SSRS).

• Experience managing multiple SQL Server instances and large database environments.

• Experience with cloud migration and enterprise ETL modernization.