Position Title: MNIT/DOC Database Migration Administrator 95189- must have 14 plus years of experienceWork Location: St. Paul, MN 55108
Work Mode: Hybrid
Project Schedule:
Anticipated Project Start Date: July 8, 2024
Anticipated End Date: July 7, 2025
Interview Type: Webcam interview
Event Number: MNSITE-3091
Complete Description:
The Minnesota Department of Information Technology Services (MNIT) partnering with the Department of Corrections (DOC) is seeking a Database Administrator (DBA) who will be a member to the Infrastructure Team, will need to work closely with the Server System Engineers, and collaborate with other MNIT DOC and Enterprise teams.
The resource will help migrate to new versions of SQL and ensure the availability and optimization of the current MSSQL 2008 2022 databases. The resource may occasionally work with other database platforms such as Oracle. This position will need to have experience in ETL processes and have knowledge of Azure SQL Database and Managed Instances. For additional details on the request such as qualifications, tasks, and evaluation criteria, see the attachments found in the Buyer Attachment section of the Event.
The work is expected to be done in a hybrid manner. The on-site work location is at 1450 Energy Park Drive, St. Paul, MN 55108.
Tasks
Support SQL server applications
Supporting SQL Server components, including SSIS and SSRS
Maintaining and troubleshooting ETL (Extract, Transform and Load) processes
Performing SQL backups and Disaster Recovery
Performing database migrations & upgrades
Working with Azure SQL technologies
Documenting work and processes
Provide mentorship to other DBAs on the team
Provide knowledge transfer
Desired Skills
Experience with SQL server applications and supporting components, including SSIS and SSRS.
Experience maintaining and troubleshooting ETL (Extract, Transform, and Load) processes.
Experience in mmentoring IT staff and database design
Experience in assessing and introducing new technologies to improve the operation of database infrastructure.
Experience as a lead worker in a team of subject matter experts of varying capacities
Experience in Microsoft Azure SQL technologies.
Experience with AlwaysOn and other High Availability SQL technologies