Skywalk Global · 2 days ago
Senior .NET Application & Database Architect - Locals only
PA
Full-time
Hybrid
Senior Level
7+ years expSkywalk Global is seeking a Senior .NET Application & Database Architect to provide on-site IT programming services for the Pennsylvania National Guard's Accountability System. The role involves system reviews, enhancements, and ongoing support, along with developing new functionalities and ensuring operational readiness during state emergencies.
Information Technology
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Provide on-site information technology programming services to support the Accountability System utilized for payroll processing, tracking and mission support
Review of the current system, system changes to improve the performance of the current system, repair programming issues with the current system and on-going support
Work closely with JEOC staff to make enhancements to the system and develop new functionality
Presenting ideas for system improvement and upgrades
Testing the product in controlled simulations prior to go-live
Preparing training manuals for users
Maintenance of the system
Provide services during state activated emergencies to ensure the system is fully operational
Provide proof of three (7+) years’ experience in C#, ASP.NET Core, MVC
Proficient in create, deploy and migrate Power Apps and Power Automate solutions across environments
Proficient in version Azure Repos control using Git, including branching strategies (like GitFlow), pull requests, and code reviews and Azure Boards: Using Agile tools for project management, backlogs, and sprint planning
Assist in the department in troubleshooting, supporting, and advancing the departments .Net Applications (AIM) and SQL databases
Review for efficiencies, interface options, workflow, meta-data, application permissions and overall review of agency databases
Proficient in SQL, SSIS, SSRS, and SQL administrative function
Proficient in writing complex SQL queries, Stored Procedures, Triggers, Views, Cursors, Joins
Strong DBA/Development Skills writing T-SQL Scripts
Responsible for data modeling, creating databases and technologies
Ensure architecture and design of the solution is in alignment with overall enterprise architecture
Provide technical expertise in the diagnosis and resolution of an issue, including the determination and provision of workaround solutions
Ensure delivered solutions meets technical and functional/non-functional performance requirements within the agency
Collaborate with the departments Information Technology Office and Office of Administration Deputy to compile, suggest, and present obtainable solutions to enhance the agencies database and reporting needs
Recommend and/or develop a catalog active databases, structure, and owners to include system documentation and procedures
Travel to the agency may be required
May be required to travel to the agency headquarters located at Fort Indiantown Gap, Annville to attend training and meetings
Qualification
Required
7+ years' Experience writing and debugging SQL queries using tools such as SQL Developer
SQL Server - SQL Server 2018 studio - Microsoft Management Studio, SQL Server, Integration Services, Performance Tools (Database Engine Tuning Advisor & SQL Profiler)
7+ years' Experience in C#, ASP.NET Core, MVC, .NET (VB) coding and classic ASP.NET Database - Oracle v 12, 19c, MS-SQL Server 2012, 2016,2019
5+ Years working in previous versions of Power Apps, Power Automate
4+ Years Azure DevOps Core Skills such as Azure Repos, Azure Boards
Client-facing experience in a consulting environment among mid-level to senior leadership
4+ years' Experience with Government IT environment
Effective analytical, conceptual, and problem-solving skills
Ability to manage multiple parallel assignments and meet specified milestones
Advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines
Bachelor's degree from an accredited college or university
Experience writing and debugging SQL queries using tools like SQL Developer
Experience with SQL Server Management Studio
Experience in C#, ASP.NET Core, MVC, .NET, MS SQL Server
Experience with Azure DevOps - such as Azure Repos and Azure Boards
Preferred
Experience working in Power Apps, Power Automate
Experience with Microsoft 360 (Access, Word, Excel, Powerpoint)
Experience in a public government IT environment
Experience in a client-facing role in a consulting environment with mid-level to senior leadership
Active Federal Security Clearance (Secret)
Company
Skywalk Global
Skywalk Global offers IT consulting, application development, testing, and enterprise solutions.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase