We are seeking an experienced Database Administrator 4 to support the State of Michigan's Center for Educational Performance and Information (CEPI) database environment, primarily focused on the Statewide Longitudinal Data System (SLDS) modernization and 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.
Key Responsibilities
Design, develop, implement, and maintain ETL processes and data pipelines.
Manage and support multiple SQL Server instances and database environments.
Perform database design, logical and physical data modeling, and performance tuning.
Develop and maintain SQL scripts, stored procedures, and database objects using T-SQL, DDL, and DCL.
Support data warehouse modernization and migration of ETL processes from on-premises to cloud environments.
Monitor database performance, security, availability, and infrastructure.
Perform troubleshooting, root cause analysis, backup, recovery, and disaster recovery activities.
Maintain data integrity, security, and database standards.
Collaborate with developers, business analysts, and technical teams to deliver reliable data solutions.
Support Azure DevOps and Agile/Scrum development practices.
Required Skills & Experience
12+ years of overall IT experience.
8–10 years of 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.
Strong experience with Azure Database Services.
Strong SQL data modeling and database architecture skills.
Extensive experience in ETL development and data warehousing.
Microsoft SQL Server database administration experience.
Top 3 Must-Have Skills
Azure Database Services
SQL Data Modeling / Database Structure
Extensive ETL Development Experience
