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

Lansing, MI, US β€’ Posted 6 hours ago β€’ Updated 3 hours ago
Contract Independent
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Scoreβ„’

πŸ”’ Crunching numbers...

Job Details

Skills

  • Data Modeling
  • Backup
  • Cloud Computing
  • Collaboration
  • Data Analysis
  • Data Integrity
  • Data Management
  • Extract
  • Transform
  • Load
  • Management
  • Marketing Intelligence
  • Development Testing
  • Disaster Recovery
  • Database Design
  • Database Security
  • Database Administration
  • Data Warehouse
  • Database
  • Database Architecture
  • Root Cause Analysis
  • SQL Azure
  • Scrum
  • Production Support
  • RDBMS
  • Recovery
  • SQL
  • Microsoft SSRS
  • Performance Tuning
  • Stored Procedures
  • Microsoft SQL Server
  • Microsoft SQL Server DBA
  • DevOps
  • IaaS
  • Transact-SQL
  • MI
  • Microsoft Azure
  • Migration
  • Agile
  • RADIUS
  • Windows PowerShell

Summary

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.

Employers have access to artificial intelligence language tools (β€œAI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10481525
  • Position Id: 9135333
  • Posted 6 hours ago
Contact the job poster
AP

Alex Pesci

Seasoned Recruiting Manager with a Passion for Talent Acquisition @ Shiro Technologies

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.