Database Administrator - SQL Server / Azure / ETL | Lansing, MI

Shiro Technologies
Lansing, MI, United States
5 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Microsoft Azure Databases Data Governance Extract Transform Load (ETL) Data Systems Data Warehousing Database Design Database Schema Disaster Recovery Microsoft SQL Server SQL Azure
+9 more
Performance Tuning Windows PowerShell Scrum Methodology SQL Stored Procedures SQL Databases Transact-SQL Cloud Platform System Database Performance Data Pipelines

Job description

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., 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.

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…