Overview
Skills
Job Details
This is an onsite Project at Raleigh NC. Interview will be inperson.
NCDPI 749557: ***This is an on-site position.
Full Stack .NET Developer to help Migrate legacy Applications.
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 programing 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.
Required / Desired Skills
| Skill | Required / Desired | Amount | of Experience | ||||
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 |