Microsoft .NET Core/ SQL Server Developer

Vector Consulting - Raleigh, NC

Full-time

Raleigh, NC

Professional, Scientific, and Technical Services

About the position

The Microsoft .NET Core/ SQL Server Developer will work on a small team to migrate legacy applications to full stack ASP.NET Core applications. The role involves extracting business logic from existing code bases and collaborating with business owners to ensure the rules are applied correctly. Daily tasks may include upgrading T-SQL scripts, migrating SQL built in VB6 to stored procedures, writing Web API REST services, and debugging jobs.

Responsibilities

• Design and develop ASP.NET Core web applications using the .NET Core development stack.
• Work within an older code base maintained by multiple developers.
• Troubleshoot code using standard debugging tools like Visual Studio debugger and browser dev tools.
• 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.

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.

Nice-to-haves

• Oracle APEX and PL/SQL experience is a plus.