MNITDOC Database Administrator 95189

Note: it is 100% Onsite role at Saint Paul MN.

Description of Project

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 MSSQLdatabases. 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 onsite work location is at 1450 Energy Park Drive St. Paul MN 55108.

Resource Need

This request is for one fulltime staff augmentation resource. Each vendor is allowed to submit one resource for consideration.

Incumbent (Currently holding the position while this Event is posted.)

No. There is no incumbent for this Event.

Mode of Interview

The State will conduct interviews. The State reserves the right to remove a resource from consideration if the resource is unavailable for interview as requested by the State. Interviews will be conducted via Microsoft Teams.

Project Schedule

• Anticipated Project Start Date: July 8 2024
• Anticipated End Date: July 7 2025

The State retains the option to extend the work order in increments determined by the State.

The following document contains the samples tasks and qualifications for this MNSITE 2.0 Event.

• 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

• Experience with SQL server applications and supporting components including SSIS and SSRS.
• Experience maintaining and troubleshooting ETL (Extract Transform and Load) processes.
• Experience in mentor IT staff and database design
• Experience in assessing and introducing new technologies to improve 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