Full Job Description
We are seeking an experienced **Database Administrator 4** to support the Center for Educational Performance and Information (CEPI) database environment, primarily focusing on the Statewide Longitudinal Data System (SLDS) modernization aligned 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.
**Key Responsibilities**
- Design, implement, maintain, and optimize data pipelines and ETL processes.
- Perform data extraction, transformation, loading, preparation, analysis, and reporting.
- Provide SQL Server database administration, troubleshooting, and performance tuning.
- Develop and maintain logical and physical database models, data dictionaries, and relational database structures.
- Create and manage database objects using T-SQL, DDL, and DCL.
- Support database security, backup, recovery, and disaster recovery procedures.
- Monitor and maintain SQL Server infrastructure across Development, QA, Pre-Production, and Production environments.
- Support the migration and modernization of on-premises ETL processes to cloud-based Azure environments.
- Collaborate with developers, business teams, and stakeholders to ensure data integrity and quality.
- Provide technical expertise in data modeling, database architecture, and CEDS standards.
**Qualifications**
- Minimum 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 Microsoft SQL Server database administration.
- Experience with data warehousing, database performance tuning, and data modeling.
- Knowledge of Common Education Data Standards (CEDS) preferred.
**Top 3 Required Skills**
1. Azure Database Services
2. SQL Data Modeling / Database Structure
3. Extensive ETL Development Experience
**Additional Information**
- **Candidates must be local to Michigan and reside within 90-100 miles of Lansing, MI.**
- Must be available to work onsite from Day 1.
- Mandatory onsite days: Wednesday and Thursday.
- C2C candidates are welcome.
