.Net Developer

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 on next page)

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.