Applications Systems Analyst II – Enterprise SQL & Web

NC State Highway Patrol; Raleigh (NC); On-site; USD 82,000 - 100,000; Full time

Job summary

The North Carolina State Highway Patrol is seeking two Application Systems Analysts II to join our Technical Services Unit. You will support, enhance, and optimize enterprise applications, serve as a technical resource, and work on web and database services while ensuring data security and system reliability.

This role requires strong SQL Server expertise, C#/.NET/ASP.NET skills, and experience with modern data workflows.

Qualifications

• Proficiency with SQL and relational database management using Microsoft SQL Server
• Proficiency with C#/.NET and the ASP.NET framework
• Proficiency with Entity Framework Core and LINQ
• Proficiency with jQuery for AJAX web-service calls
• CSS experience for web UI
• PowerShell for data workflows
• Experience with Drupal and the LAMP development stack
• Understanding of WAI and WCAG principles and compliance

Responsibilities

• Serve as a technical resource for assigned application and systems-development initiatives
• Configure, maintain, and support application services, including web and database servers
• Diagnose and resolve application and system failures
• Provide user support for internally developed enterprise applications
• Ensure compliance with data-security requirements for internally developed applications and systems
• Participate in system testing, validation, deployment, and post-implementation support
• Evaluate technical solutions and recommend improvements to system functionality, scalability, and performance
• Provide MS SQL Server database support, including performance tuning and complex troubleshooting
• Develop and execute advanced queries, scripts, and reports supporting operational, analytical, and mapping requirements

Skills

SQL (MS SQL Server)

C#/.NET

ASP.NET

Entity Framework Core

LINQ

jQuery

CSS

PowerShell

Drupal/LAMP

Education

Bachelor's degree in CS or IT or related field

2 years in business app consulting or development

Associate degree +3 years experience

High School +6 years experience

Equivalent combination of education/experience

Tools

Microsoft SQL Server

ASP.NET framework

Entity Framework Core

LINQ

jQuery

PowerShell

Drupal

LAMP stack

Job description

The North Carolina State Highway Patrol is seeking two Application Systems Analysts II to join our Technical Services Unit. You will support, enhance, and optimize enterprise applications, serve as a technical resource, and work on web and database services while ensuring data security and system reliability.

This role requires strong SQL Server expertise, C#/.NET/ASP.NET skills, and experience with modern data workflows.