Application Architect (806704)
Dauphin County, PA - USA
Job Summary
- The PA PUC seeks an Application Architect with and SQL Server expertise to design and modernise 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.
- Architect secure (C#/) 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 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 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 PUCs long-term technology strategy.
- Provide technical leadership during project planning estimation POCs and architecture review sessions.
- Software engineering
- Application/Solution Architect on and SQL Server projects in complex environments.
- Expert-level C# Core Entity Framework Core Web API and practices (clean architecture minimal APIs DI async/await patter
- Advanced SQL Server: complex T-SQL optimization execution plans indexing strategies security (RLS DDM) and Always On availability groups.
- Daily professional experience with GitHub Copilot /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
- Bachelors in Computer Science Information Systems or equivalent
Required Skills:
Software engineering Application/Solution Architect on and SQL Server projects in complex environments. Expert-level C# Core Entity Framework Core Web API and practices (clean architecture minimal APIs DI async/await patter Advanced SQL Server: complex T-SQL optimization execution plans indexing strategies security (RLS DDM) and Always On availability groups. Daily professional experience with GitHub Copilot /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 Bachelors in Computer Science Information Systems or equivalent
Required Education:
Bachelors degree in information systems Computer Science or equivalent experience