Senior Database Administrator (Database Administrator 4)
Location: Lansing, MI
Duration: 12 Months
Experience Required: 12+ Years
Job Summary
We are seeking an experienced Senior Database Administrator to support a large-scale Statewide Longitudinal Data System (SLDS) modernization initiative. The ideal candidate will serve as a Subject Matter Expert (SME) for enterprise data warehouse environments, with strong expertise in Microsoft SQL Server, Azure Database Services, SQL data modeling, and ETL development.
The role involves managing complex database environments, designing and maintaining data pipelines, optimizing database performance, implementing security standards, and supporting the migration of ETL processes from on-premises infrastructure to cloud-based environments.
Candidates should have strong knowledge of Common Education Data Standards (CEDS), database architecture, data administration, and enterprise data management practices.
Key Responsibilities
-
Design, develop, implement, and maintain scalable ETL processes and data pipelines.
-
Perform data extraction, transformation, loading, data preparation, analysis, and reporting.
-
Provide technical troubleshooting, root cause analysis, and support for ETL processes.
-
Design, maintain, and optimize logical and physical database models, data dictionaries, and database structures.
-
Perform SQL development, database administration, performance tuning, and query optimization.
-
Establish database parameters and create database objects using SQL, DDL, and DCL.
-
Monitor database performance, storage utilization, memory allocation, and server infrastructure.
-
Manage database security, access controls, backup, recovery, and disaster recovery procedures.
-
Support database modernization initiatives, including transitioning ETL processes from on-premises environments to Azure cloud services.
-
Ensure data integrity, minimize redundancy, and maintain enterprise data management standards.
-
Collaborate with application developers, business stakeholders, and technical teams to deliver reliable data solutions.
-
Evaluate and incorporate new data requirements into existing shared database environments.
-
Provide technical guidance and expertise on database architecture, data modeling, and data management practices.
Required Technical Skills
-
8-10 years of experience with T-SQL and Microsoft SQL Server.
-
6-8 years of experience in ETL development and data pipeline management.
-
5 years of experience with PowerShell scripting.
-
5 years of experience with Azure DevOps.
-
5 years of experience working in Scrum/Agile environments.
Top 3 Required Skills
-
Azure Database Services
-
SQL Data Modeling and Database Structure
-
Extensive ETL Development Experience
Additional Qualifications
-
Strong experience with enterprise SQL Server database environments.
-
Knowledge of Common Education Data Standards (CEDS).
-
Experience with data warehouse architecture and database modernization.
-
Expertise in logical and physical data modeling.
-
Experience with database security, backup, recovery, and performance monitoring.
-
Strong analytical, troubleshooting, communication, and problem-solving skills.
Minimum Experience: 12+ years of relevant professional experience.
