MNIT/DOC Database Administrator

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 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. Resource Need This request is for one full-time 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. MNSITE 2.0 Request for a Staff Augmentation Event The following document contains the samples tasks and qualifications for this MNSITE 2.0 Event. Sample 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 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