Web 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 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 Microsofts Core MVC stack with Oracle19c database services generates PDF documents with iText7 and is authenticated through an Oracle Cloud Infrastructure (OCI) API Gateway. The developed application must be productiongrade highly secure and fully accessible (WCAG 2.1 A and AA compliant).

Sample Tasks

• Develop 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 iText7 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 applications 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 States Project Manager and IT Project Lead.
• Provide knowledge transfer to State staff.
• Perform other related duties as assigned.

Desired Qualifications

• Experience in fullstack web development Core MVC and C# 8 architecture using Microsoft Visual Studio 2022 at a senior developer level.
• Experience working with Oracle19c or later designing schemas writing efficient SQL creating views and indexes and authoring complex stored procedures/triggers.
• Experience with handson PDF creation iText7 APIs dynamic content and templating.
• Experience using Git/GitHub or equivalent branching strategies and pullrequest 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 alttext and other accessibility testing tools.
• Experience writing unit and integration tests and maintaining highcoverage codebase.
• Experience ensuring applications are resilient to common security threats and perform well under load.