Azure SQL Server

Job ID: MNSITE-3747

Hybrid/Local MN Govt Azure SQL Server/AI PM (Admin/15+) with ShareFile, Tableau, Drupal, Acquia, OnContact, networking/computing/security, ADLS Gen2/Delta Lake, Databricks, PySpark/Spark SQL, OCR, modernization experience

Location: St. Paul, MN (MNIT)
Duration: 12 Months

(Qualifications begin on next page)
Full-Time (Named) Resource Desired Qualifications
Experience in IT project management roles
Experience in IT application support roles
Experience supporting applications in Microsoft Azure and/or administering environments in Microsoft Azure
Experience in data storage optimization
Experience in database analysis
Experience in Azure modernization support
Azure administrator certification
Experience supporting and troubleshooting Microsoft SQL databases
Experience with ShareFile
Experience with Tableau
Experience with Drupal
Experience with Acquia
Experience with OnContact

Vendor (Company) Desired Qualifications
(The State desires vendors with significant company experience in the following areas as well as the ability to provide multiple resources with significant experience in the following areas.)
Cloud & Azure
Experience delivering solutions on Microsoft Azure
Experience implementing Azure networking, computing, and security best practices
Experience implementing Azure Data Lake Storage (ADLS Gen2) and Delta Lake
Experience managing Azure SQL, storage accounts, Data Lake, and Azure migration tooling
Experience using Azure Key Vault, Azure Monitor, and Log Analytics in enterprise environments
Azure Administrator-level certification and/or experience
Databricks & Enterprise Data Engineering
Experience implementing and supporting Azure Databricks (clusters, workflows, notebooks, jobs)
Experience delivering Databricks-based data engineering solutions at enterprise scale
Experience implementing PySpark and Spark SQL pipelines
Experience in large-scale data architecture and data storage analysis
PDF Extraction & Document Processing Solutions
Experience delivering document extraction solutions using Azure Document Intelligence
Experience building and/or integrating PDF ingestion pipelines using PyPDF2, pdfplumber, PDF.js, or equivalent tools
Experience implementing OCR processing of scanned PDFs
Experience in large scale PDF text pre processing, chunking, and transformation for LLM retrieval
Vector Search & Embedding Infrastructure
Experience converting unstructured document content into embeddings for downstream LLM use
Experience deploying vector search solutions using Azure AI Search
Experience implementing and managing vector databases such as Pinecone, Weaviate, or Chroma

(Vendor/Company Desired Qualifications continued on next page)
Chatbot / Generative AI Solution Delivery
Experience designing, building, and maintaining enterprise chatbots that use PDF documents as primary content sources
Experience deploying chatbots using LLMs (Azure OpenAI, OpenAI, Hugging Face, or similar platforms)
Experience implementing Retrieval Augmented Generation (RAG)
Experience designing conversational flows and performing prompt optimization at scale
Experience developing APIs or back end integrations connecting LLMs with vector stores and document repositories
Experience using frameworks such as LangChain, Semantic Kernel, or equivalent enterprise tooling
Experience monitoring, validating, and optimizing chatbot response quality
Platform & Application Support
Experience supporting Microsoft SQL Server
Experience supporting enterprise platforms such as ShareFile, Tableau, Drupal, Acquia, and OnContact
Business Analysis & Multi Division Collaboration
Experience leading requirements gathering across technical and non technical stakeholder groups
Experience working within complex, multi division organizations with diverse levels of data maturity
Experience delivering technical documentation and/or providing technical communication

As-Needed Resource Minimum Qualifications
Each as-needed resource that the vendor provides to perform work under this engagement must individually meet the minimum qualifications specified below. THE AS-NEEDED RESOURCE(S) WILL NOT BE SUBMITTED OR EVALUATED AS PART OF THE CONTRACTING PROCESS, but the State reserves the right to review such resource(s) qualifications prior to them performing work under the engagement. The State reserves the right to reject any resource(s) that do not meet the minimum qualifications, and to require that different resource(s) be provided that do meet the minimum qualifications.
Five (5) years experience in IT project management roles
Two (2) engagements lasting at least six (6) months each in IT project management roles
Two (2) engagements lasting at least six (6) months each in IT application support roles
Two (2) years combined experience supporting applications in Microsoft Azure and/or administering environments in Microsoft Azure
Two (2) years experience in data storage optimization
Two (2) years experience in database analysis
Two (2) years experience in Azure modernization support

The following document contains the sample tasks and qualifications for this MNSITE 2.0 Event.
Sample Tasks
Provide project management support
o Be accountable for creating and communicating project artifacts
o Regularly communicate scope/schedule status to stakeholders and negotiate changes to either
o Manage project dependencies and sequencing of activities
o Define project initiative and outcomes to ensure completion
Provide IT application support
o Install/configure websites, applications, and databases
o Provide 2nd level support Troubleshoot website, application, and database issues; consult with other resources and perform research to determine source of issues; resolve issues
o Manage remote access to systems
o Be responsible for the overall planning, execution, and success of complex software solutions to meet customer needs
o Provide technical direction on software applications in order to manage day-to-day operations
o Manage vendor purchase requests, subscriptions, contracts, and payment
o Manage vendor professional services
o Implement and manage chatbots
Provide data storage optimization, database analysis, and Azure modernization support
o Conduct comprehensive assessments of current data storage environments across participating divisions, including evaluation of storage capacity, performance, access patterns, bottlenecks, retention practices, and data sensitivity classifications
o Perform database analysis of legacy systems, application databases, and other structured data environments to identify dependencies, inefficiencies, scalability concerns, and modernization opportunities
o Lead structured requirements gathering sessions with business and technical stakeholders to capture current-state challenges, data usage needs, reporting requirements, and long-term operational objectives
o Translate requirements and assessment findings into detailed technical documentation and recommendations, including modernization paths such as consolidation, re architecting, or migration to Azure-based solutions
o Provide expert guidance on Azure data services (Azure SQL, storage accounts, Data Lake, and related capabilities) and propose future-state architectures that align with enterprise standards, governance requirements, and security policies
o Support the planning and design of cloud migration strategies, proof-of-concept initiatives, and phased implementation roadmaps
o Deliver current state assessment reports, detailed requirements documentation, proposed future state designs, and a migration or consolidation strategy with clearly defined risks, timelines, and resource considerations
o Provide consultation to support decision-making and ensure alignment with enterprise standards
Perform testing on websites, applications, and databases
Coordinate activities with Admin divisions, MNIT, and other consultant IT resources
Review software packages and hardware and advise selection committee of security implications and risk mitigation requirements
Provide knowledge transfer to State staff
Perform other related duties as assigned