.NET Application Developer
*Local to Annville, PA only please
*This is a hybrid position with a 50-50 schedule
*We are not considering Corp-to-Corp (C2C) arrangements for this position
Description:
- The awarded contractor shall provide on-site information technology programming services to support the Accountability System utilized for payroll processing tracking and mission support.
- The Accountability System is utilized to support missions and emergencies executed by the Pennsylvania National Guard through the JEOC.
- The on-site services shall include 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.
- The awarded contractor will work closely with JEOC staff to make enhancements to the system and develop new functionality.
- This includes presenting ideas for system improvement and upgrades testing the product in controlled simulations prior to go-live preparing training manuals for users and maintenance of the system.
- The awarded contractor will be required to provide services during state activated emergencies to ensure the system is fully operational.
- The Accountability System is currently housed and is operating on MVC App and MS Power Apps.
- The selected candidate should have extensive knowledge of C# ASP.NET Core MVC with solid knowledge on SQL
- The awarded contractor shall provide proof of three 7 years experience in C# ASP.NET Core MVC.
- The awarded contractor shall be responsible for proficient in create deploy and migrate Power Apps and Power Automate solutions across environments.
- The awarded contractor shall be 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
- The awarded contractor shall provide comparable classification shall assist in the department in troubleshooting supporting and advancing the departments .Net Applications AIM and SQL databases.
- The awarded contractor shall review for efficiencies interface options workflow meta-data application permissions and overall review of agency databases.
- The awarded contractor shall be proficient in SQL SSIS SSRS and SQL administrative function. ASP.Net C# VB.Net JavaScript XML Webservices IIS HTML CSS InfoPath
- The awarded contractor shall be proficient in writing complex SQL queries Stored Procedures Triggers Views Cursors Joins.
- The awarded contractor shall have strong DBA/Development Skills writing T-SQL Scripts.
- The awarded contractor shall be responsible for data modeling creating databases and technologies. Ensure architecture and design of the solution is in alignment with overall enterprise architecture
- The awarded contractor shall provide technical expertise in the diagnosis and resolution of an issue including the determination and provision of workaround solutions. Ensures delivered solutions meets technical and functional/non-functional performance requirements within the agency.
- The awarded contractor shall 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.
- The awarded contractor shall recommend and/or develop a catalog active databases structure and owners to include system documentation and procedures.
- Travel to the agency may be required.
- The awarded contractor may be required to travel to the agency headquarters located at Fort Indiantown Gap Annville to attend training and meetings.
Minimum Requirements:
- Demonstrates proven extensive knowledge and success in designing and implementing database solutions including the following:
Skills/Knowledge/Experience:
- 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 20162019
- Knowledge and experience with Microsoft 360 Access Word Excel PowerPoint
- 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
- Minimum Degree Required: Bachelor’s degree from an accredited college or university
Required Skills/Knowledge/Experience:
- Experience writing and debugging SQL queries using tolls like SQL Developer, Required 7 Years
- Experience with SQL Server Management Studio, Required
- Experience in C#, ASP.NET Core, MVC, .NET, MS SQL Server, Required 7 Years
- Experience with Azure DevOps – such as Azure Repos and Azure Boards, Required 4 Years
- Experience working in Power Apps, Power Automate, Highly desired 5 Years
- Experience with Microsoft 360 (Access, Word, Excel, PowerPoint), Highly desired
- Experience in a public government IT environment, Highly desired 4 Years
- Experience in a client-facing role in a consulting environment with mid-level to senior leadership, Highly desired
- Active Federal Security Clearance (Secret), Desired
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC