.NET/SQL Developer

Mbi Llc; Harrisburg (Dauphin County); On-site; USD 120,000 - 160,000; Full time

Job summary

Commonwealth of Pennsylvania Public Utility Commission is seeking an Application Architect with deep .NET and SQL Server expertise to design and modernize PUC applications and provide enterprise solution architecture across platforms. This role leads AI-augmented development while ensuring security, accessibility, and regulatory compliance.

The candidate will architect secure .NET applications, develop enterprise data models, and drive modernization roadmaps across Microsoft and IBM

Qualifications

• 8+ years in software engineering.
• 4+ years as Application/Solution Architect on enterprise .NET/SQL Server.
• Expert-level C#, ASP.NET Core, EF Core, Web API, and modern .NET practices.
• Advanced SQL Server: T-SQL, indexing, security, and Always On.
• Daily experience with GitHub Copilot for .NET development.
• Experience converting legacy data to modern data models.
• Strong secure SDLC, identity management, and API security.
• Public sector/regulatory/compliance experience.
• Familiarity with IBM FileNet/BAW; Microsoft Azure Solutions Architect Expert.

Responsibilities

• Architect secure, scalable .NET and SQL Server solutions using clean architecture.
• Lead enterprise solution architectures spanning multiple apps, services, and databases.
• Design data models, T-SQL, and HA/DR strategies for high-volume systems.
• Define integration strategies across Microsoft, IBM, and third-party platforms.
• Drive Copilot adoption for .NET development and team enablement.
• Produce architecture diagrams, specs, and lead design reviews.
• Establish coding standards and reusable patterns.
• Ensure compliance with security, WCAG accessibility, and regulatory policies.
• Modernize legacy PUC apps into cloud-native solutions.

Skills

Software engineering

Application/Solution Architect

C#

ASP.NET Core

Entity Framework Core

Web API

Clean architecture

Minimal APIs

Dependency Injection

Async/await patterns

SQL Server

T-SQL optimization

Indexing strategies

Always On availability groups

GitHub Copilot for .NET

Data model modernization

Security and API authentication

Regulatory compliance

Public sector experience

IBM FileNet

Azure Solutions Architect

Bachelor's in CS/IS

Education

Bachelor’s in Computer Science, Information Systems, or equivalent

Tools

GitHub Copilot

Azure

Job description

- The PA PUC seeks an Application Architect with deep .NET and SQL Server expertise to design and modernize PUC applications and provide enterprise solution architecture across Microsoft and Java-based platforms, ensuring secure, scalable, maintainable and reusable application solutions.

- This role leads the adoption of AI-augmented development: advanced GitHub Copilot usage across teams while accelerating delivery while upholding security, WCAG accessibility, and regulatory compliance.

Key Responsibilities

- Architect secure, scalable .NET (C#/ASP.NETCore) applications and SQL Server solutions using clean architecture, DDD, and performance optimization patterns.

- Develop enterprise solution architectures that span multiple applications, services, APIs, databases and integration platforms while ensuring long-term maintainability and scalability.

- Design data models, advanced T‑SQL (stored procedures, indexing, partitioning, Query Store tuning), and HA/DR strategies for high‑volume transactional systems.

- Define integration strategies for enterprise systems including REST APIs, messaging authentication, and data exchange between Microsoft, IBM and third‑party platforms.

- Drive adoption of GitHub Copilot for .NET development), including custom instructions, prompt engineering, and AI‑assisted refactoring and automated code reviews, documentation and testing.

- Produce architecture diagrams, and technical specs; lead design reviews; mentor teams on .NET patterns and Copilot best practices.

- Establish architecture standards, coding standards, reusable design patterns, and technical best practices across development teams.

- Ensure solutions meet Commonwealth IT security policies, WCAG 2.2 accessibility, PII protection, and zero‑trust principles in a regulated utility environment.

- Lead the application modernization technical design efforts to migrate legacy PUC applications into cloud native applications.

- Develop modernization roadmaps, evaluate technical debt and recommend phased migration strategies.

- Design and implement modern software delivery practices including source control strategies, branching models, CI/CD pipelines, automated deployments, environment management and DevSecOps practices.

- Evaluate emerging technologies, frameworks and commercial software products to provide recommendations aligned with the PUC’s long‑term technology strategy.

- Provide technical leadership during project planning, estimation, POC’s and architecture review sessions.

Fill the skill matrix below:

Skill

Amount

Candidate's No. of years of experience

Software engineering

Required

8

Application/Solution Architect on enterprise .NET and SQL Server projects in complex environments.

Required

4

Expert-level C#, ASP.NET Core, Entity Framework Core, Web API, and modern .NET practices (clean architecture, minimal APIs, DI, async/await patter

Required

Advanced SQL Server: complex T-SQL optimization, execution plans, indexing strategies, security (RLS, DDM), and Always On availability groups.

Required

Daily professional experience with GitHub Copilot for .NET/C# development, including advanced configuration and team enablement.

Required

Proven hands‑on experience converted data from legacy systems to modernization application data models.

Required

Strong secure SDLC, Entra ID/managed identities, API security, and enterprise governance experience; excellent communication and stakeholder skills.

Required

Public sector, utilities, or regulated industry experience with strict compliance and accessibility mandates.

Required

Familiarity with legacy modernization, IBM FileNet/BAW; Microsoft Azure Solutions Architect Expert or equivalent certifications

Required

Bachelor’s in Computer Science, Information Systems, or equivalent

Required