Senior Application Architect (.NET and SQL Server expertise)

Apollo
Harrisburg, PA, United States
about 1 month ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

ASP.NET Java (Programming Language) .NET Framework Multitier Architecture Application Programming Interfaces (APIs) Artificial Intelligence Applications Architecture User Authentication Microsoft Azure C Sharp (Programming Language) Information Systems Databases
+31 more
System Configuration Software Design Patterns Electronic Data Interchange (EDI) Entity Framework IBM Software Microsoft SQL Server Commercial Software Performance Tuning Zero Trust Network Access Application Data Software Engineering SQL Stored Procedures Transact-SQL Web Content Accessibility Guidelines Enterprise Software Applications Sql Optimization GitHub Copilot Database Optimization Prompt Engineering Software Security Technical Debt Indexer Information Technology Deployment Automation Integration Frameworks Software Coding Restful APIs Software Version Control Devsecops Legacy Systems Web Api

Job description

Client 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[1]augmented development: advanced GitHub Copilot usage across teams while accelerating delivery while upholding security, WCAG accessibility, and regulatory compliance, * 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[1]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.

Requirements

  • Software engineering
  • Application/Solution Architect on enterprise .NET and SQL Server projects in complex environments
  • Expert-level C#, ASP.NET Core, Entity Framework Core, Web API, and modern .NET practices (clean architecture, minimal APIs, DI, async/await patter
  • Advanced SQL Server: complex T[1]SQL optimization, execution plans, indexing strategies, security (RLS, DDM), and Always On availability groups.
  • Daily professional experience with GitHub Copilot for .NET/C# development, including advanced configuration and team enablement.
  • Proven hands-on experience converted data from legacy systems to modernization application data models.
  • Strong secure SDLC, Entra ID/managed identities, API security, and enterprise governance experience; excellent communication and stakeholder skills.
  • Public sector, utilities, or regulated industry experience with strict compliance and accessibility mandates.
  • Familiarity with legacy modernization, IBM FileNet/BAW; Microsoft Azure Solutions Architect Expert or equivalent certifications
  • Bachelor’s in Computer Science, Information Systems, or equivalent

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

9:56 min

Expanding browser capabilities with modern web APIs

Ire Aderinokun · JS Congress

2:36 min

Analyzing limitations with PostgreSQL bitmap heap scans

Dharin Shah Dharin Shah · WWC 2025

2:52 min

Introduction to ASP.NET Core and the ABP framework

Alper Ebicoglu Alper Ebicoglu · WWC 2025

1:34 min

Pivoting careers into specialized platform engineering roles

Xavier Portilla Edo · LIVE

7:44 min

Bootstrapping a test-driven asp.net web api

Alex Banul · LIVE

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

Videos

See all

Related articles

See all