Senior Application Architect (.NET and SQL Server expertise)

Apollo Technology Solutions LLC
  • Harrisburg, PA
  • Quick Apply
30+ days ago

Job Description

Title: Senior Application Architect (.NET and SQL Server expertise)
Location: Harrisburg, PA

Duration: 11 Months

Either Web Cam or In Person Interview

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

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[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.
Required/Desired Skills:
  • 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

Numbers & Facts

LocationHarrisburg, PA

Skills

  • ADO.NET Entity Frameworkunmatched
  • Application Programming Interface (API)unmatched
  • Artificial Intelligence (AI)unmatched
  • Authenticationunmatched
  • Best Practicesunmatched
  • Coding Standardsunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Computer Securityunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Modelingunmatched
  • Design Patterns Programming Methodologiesunmatched
  • Documentationunmatched
  • Emerging Technologyunmatched
  • Enterprise Architectureunmatched
  • Enterprise Protectionunmatched
  • Environmental Managementunmatched
  • GitHubunmatched
  • Governmentunmatched
  • IBM Product Familyunmatched
  • Identity Data Managementunmatched
  • Information Technology & Information Systemsunmatched
  • Javaunmatched
  • Mentoringunmatched
  • Microsoft .NETunmatched
  • Microsoft ASP.NET (Active Server Page)unmatched
  • Microsoft Active Server Page (ASP)unmatched
  • Microsoft C# (C Sharp)unmatched
  • Microsoft Product Familyunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Microsoft Windows Azureunmatched
  • Migration Strategyunmatched
  • Performance Tuning/Optimizationunmatched
  • Project Estimatesunmatched
  • Project Planningunmatched
  • REST (Representational State Transfer)unmatched
  • Refactoringunmatched
  • SQL (Structured Query Language)unmatched
  • Software Designunmatched
  • Software Development Lifecycle (SDLC)unmatched
  • Software Engineeringunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • Stored Proceduresunmatched
  • System Integration (SI)unmatched
  • Technical Analysisunmatched
  • Technical Leadershipunmatched
  • Technical Strategyunmatched
  • Technical/Engineering Designunmatched
  • Web Content Accessibility Guidelines (WCAG)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder