Senior Application Architect (.NET and SQL Server expertise)

Apollo
Harrisburg, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Harrisburg, United States of America

Tech stack

ASP.NET
Java
.NET
Multitier Architecture
API
Artificial Intelligence
Applications Architecture
User Authentication
Azure
C Sharp (Programming Language)
Information Systems
Databases
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
T-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
REST
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