Description: Consultant will work on a small team to migrate legacy applications developed in classic ASP (ActiveX), .NET Framework, and T-SQL to full stack ASP.NET Core applications. We need a developer that can pull business logic from a code base written in VB6, classic asp, and T-SQL. Then work with business owners to ensure the rules still apply or make any necessary changes. In any given day you might be asked to upgrade T-SQL scripts, migrate dynamic SQL built in VB6 to a stored procedure, write Web API REST services, build web pages with Razor Pages/MVC, debug an ELT job, document a process. We also have Oracle databases and APEX, which is Oracle’s rapid development framework. Integration work with Oracle/APEX is possible. A good understanding of PL/SQL and APEX is a plus.

Responsibilities:

• Design and develop ASP.NET Core web applications using the .NET Core development stack.
• Work within an older code base that has been maintained by many developers over many years.
• Troubleshoot code using standard debugging tools like the Visual Studio debugger and the browser’s dev tools to resolve application errors.
• Use GIT source control management in a team environment.
• Optimize large and complicated SQL scripts.
• Collaborate and communicate effectively with business owners and team members.
• Document existing and new application features.

Required/Desired/Highly desired Skills:

• Proficient in programming languages such as VB6, VBScript, C#, T-SQL, and PL/SQL (Required 5 Years)
• Experienced in ASP.NET development (.NET Framework and .NET Core) with Entity Framework and/or ADO.NET. (Required 5 Years)
• Experienced with Visual Studio and SQL Management Studio development environments. (Required 5 Years)
• Solid understanding of design patterns and database normalization. (Required 5 Years)
• Proven experience with extract, transform, and load (ETL) processing and SQL Server tools such as Integration Services, BCP.exe, and T-SQL Bulk Load (Required 5 Years)
• Working knowledge of scheduled jobs including SQL Agent and Windows Scheduled Tasks. (Required 5 Years)
• Experienced with GIT source control management. (Required 5 Years)
• Strong understanding of browser side development including HTML, CSS, JavaScript (Required 5 Years)
• Familiar with JavaScript libraries for building user interface such as jQuery and React (Required 5 Years)
• Oracle APEX and PL/SQL experience is a plus. (Highly desired 5 Years)