Job ID: NC-749557 (97591022)
Onsite/Local .Net Developer (15+) with VB6, VBScript, C#, T-SQL, PL/SQL, ASP.net, Core, ADO.net, Entity, SQL Management Studio, design patterns, ETL, SSIS, BCP.exe, Bulk Load, SQL Agent, GIT, jQuery, React, Oracle APEX experience
Location: Raleigh, NC(NCDPI)
Duration: 12 Months
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
Job Description:
You 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 and Duties
· 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.
Job Requirements
· Minimum 5 years of programming experience.
· Proficient in programming languages such as VB6, VBScript, C#, T-SQL, and PL/SQL
· Experienced in ASP.NET development (.NET Framework and .NET Core) with Entity Framework and/or ADO.NET.
· Experienced with Visual Studio and SQL Management Studio development environments.
· Solid understanding of design patterns and database normalization.
· Proven experience with extract, transform, and load (ETL) processing and SQL Server tools such as Integration Services, BCP.exe, and T-SQL Bulk Load.
· Working knowledge of scheduled jobs including SQL Agent and Windows Scheduled Tasks.
· Experienced with GIT source control management.
· Strong understanding of browser side development including HTML, CSS, JavaScript
· Familiar with JavaScript libraries for building user interface such as jQuery and React
· Oracle APEX and PL/SQL experience is a plus.
· Bachelor’s degree in computer science, other related degrees, or equivalent application development experience.