Web Application / .NET Developer

Title: Web Application / .NET Developer Location: Saint Paul, MN (Remote) Duration: 7 Months   Description of Engagement The Minnesota Department of Information Technology Services (MNIT), partnering with Minnesota Management and Budget (MMB), is seeking one (1) full-time staff augmentation resource to perform .NET developer duties to develop a new Legislative Initiative web application. The State has a need for a new web application to support executive branch policy proposals and pre-enrolled bill review process. The resource under this engagement will develop an application that integrates Microsoft’s ASP.NET Core MVC stack with Oracle 19c database services, generates PDF documents with iText 7, and is authenticated through an Oracle Cloud Infrastructure (OCI) API Gateway. The developed application must be production‑grade, highly secure, and fully accessible (WCAG 2.1 A and AA compliant). Sample Tasks Develop ASP.NET Core MVC (C#) application in Microsoft Visual Studio 2022.Design the Oracle 19c database schema - create tables, foreign keys, indexes, and ER diagram + SQL DDL scripts. Build Oracle views that aggregate data for reporting and PDF generation.Create View definitions (SQL).Write SQL stored procedures, e.g., total calculations, business rule enforcement, etc. Create iText 7 PDF templates for reports, using the layout API. Develop a PDF generation service that pulls data from Oracle, feeds it into the template, and streams the PDF to the client. Perform an accessibility audit and fix any WCAG 2.1 A and AA violations in the MVC view. Integrate Oracle OCI IAM as an OAuth2 provider for the application’s authentication layer. Configure OCI API Gateway to authenticate and request validation. Profile and tune performance - analyze slow Oracle queries and C# code, add indexes, rewrite logic, or implement caching. Perform unit testing of developed code and resolve any bugs found.Perform security scans - review the code for security related vulnerabilities, e.g. enforce parameterized queries to prevent SQL injection, etc. Check out and check in code changes in source control (GitHub).Handle production incidents - diagnose issues, patch the root cause, and deploy fixes.Provide weekly status reports to State’s Project Manager and IT Project Lead.Provide knowledge transfer to State staff.Perform other related duties as assigned. Desired Qualifications Experience in full‑stack web development, ASP.NET Core MVC and C#, and .NET 8+ architecture using Microsoft Visual Studio 2022, at a senior developer level. Experience working with Oracle 19c or later, designing schemas, writing efficient SQL, creating views and indexes, and authoring complex stored procedures/triggers.Experience with hands‑on PDF creation, iText 7 APIs, dynamic content, and templating.Experience using Git/GitHub or equivalent, branching strategies, and pull‑request reviews.Experience implementing authentication services securely through Oracle Cloud infrastructure and integrating with web applications.Experience building WCAG 2.1 A and AA compliant UIs, including experience with WAVE web accessibility evaluation tools, keyboard navigation, contrast ratios, alt‑text, and other accessibility testing tools.Experience writing unit and integration tests and maintaining high‑coverage codebase.Experience ensuring applications are resilient to common security threats and perform well under load.