Application Systems Analyst

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

Agency NC State Highway Patrol Division NC State Highway Patrol Job Classification Title Applications Systems Analyst II (NS) Position Number 65043068 Grade DT09

About Us

The North Carolina State Highway Patrol's primary mission is to reduce collisions and make the highways of North Carolina as safe as possible. The NCSHP has more than 1,600 troopers who cover nearly 80,000 miles of North Carolina roadways, more than any other state except Texas. In addition to enforcing the state's traffic laws, state troopers also guide traffic during hurricane evacuations, re-route traffic around hazardous chemical spills, and they stand ready should any act of terrorism occur. State Troopers are committed to protecting North Carolina's motoring public.

Description of Work

Are you a technology-driven problem solver who enjoys transforming business needs into innovative technology solutions? The North Carolina State Highway Patrol is seeking two Application Systems Analyst to join our team and play a key role in supporting, enhancing, and optimizing enterprise applications.

Key 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 applicable data-security requirements for internally developed applications and systems, as well as data associated with externally provided vendor applications and stored within the SHP enterprise environment
• Participate in system testing, validation, deployment, and post-implementation support
• Evaluate technical solutions and recommend improvements to system functionality, scalability, and performance
• Provide Microsoft SQL Server database support, including performance tuning and complex troubleshooting
• Develop and execute advanced queries, scripts, and reports supporting operational, analytical, and mapping requirements

Job Posting Note

Please note: Job postings close at 11:59:59 p.m. the night before the listed Posting End Date above.

Recruitment Range

Recruitment Range: $81,504-$100,000 Annually

Application Credit

To receive credit for your work history and credentials, you must provide the information on the application form. Any information omitted from the application form, listed as general statements, listed under the text resume section, or on an attachment will not be considered for qualifying credit.

Minimum Qualifications

Candidates meet the minimum qualifications of this position if they meet the minimum education and experience listed on the vacancy announcement. Vacancy specific knowledge, skills, and abilities (KSAs) and/or management preferences are not required. If you possess any of the following skills or qualifications, please include them in your application: 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 making AJAX web-service calls Proficiency with CSS Experience using PowerShell for data workflows Experience with Drupal and the LAMP development stack Understanding of Web Accessibility Initiative (WAI) and Web Content Accessibility Guidelines (WCAG) principles and compliance requirements.

Education and Experience

• Bachelor's degree in computer science or an IT related field or related technical degree from an appropriately accredited institution AND two years of experience in business application consulting or development
• Associate degree in computer science or an IT related field from an appropriately accredited institution AND three years of experience in application consulting or development
• High School or General Educational Development (GED) diploma and six years of experience in business application consulting or development
• An equivalent combination of education and experience

Position/Physical Requirements

Typical work schedule: Monday - Friday: 8:00am-5:00pm

Note: Qualified recommended applicant(s) must undergo and successfully pass: Criminal Background Investigation Drug Screening Test

This positions is located at: 3118 Garner Road Raleigh, NC 27610

Additional Organization Information

The Highway Patrol’s Technical Services Unit supports all information technology needs of the organization and enables the Patrol’s public safety mission through secure, reliable, and resilient IT services.

EEO Statement

The NC State Highway Patrol (NCSHP) selects applicants for employment based on required education and experience and job-related knowledge, skills, and abilities without regard to race, religion, color, national origin, sex, pregnancy, gender identity or expression, sexual orientation, age (40 or older), disability, National Guard or veteran status, genetic information, political affiliation, or political influence. https://www.ncshp.gov

Mission

The Mission of the North Carolina State Highway Patrol is to protect our State with integrity, loyalty, and professionalism. The North Carolina State Highway Patrol will excel as a national leader in public service through innovative law enforcement, strategic preparedness, and community engagement. We are an Employment First state, ensuring that people with disabilities have equal opportunities to succeed in the state government workplace. NCSHP supports pay equity for women, establish paid parental leave for birth, adoption, and foster care, and implement fair chance policies. Join a team that welcomes, values, respects and supports all members of our work community.

Application Resources

Be sure to complete the application in its entirety. Resumes will not be accepted in lieu of completing this application. Information should be provided in the appropriate areas, to include the following: Education, including high school and all degrees obtained, Work Experience, and Certificates & Licenses. It is critical to our screening and salary determination process that applications contain comprehensive candidate information. Due to the volume of applications received, we are unable to provide information regarding the status of your application. The hiring process may take several weeks. Be sure to complete the application in full. Applicants are unable to submit more than one application to an individual posting. Only one application received prior to the closing date will be accepted. Applications must be submitted by 11:59:59 PM on the night prior to the closing date.

Degree/College Credit Verification

Degrees must be received from appropriately accredited institutions. Transcripts, and degree evaluations may be uploaded with your application. If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program. Visit www.studentaid.gov to learn more.

Veteran’s and National Guard Preference

Applicants seeking Veteran’s Preference must attach a DD Form 214, Certificate of Release or Discharge from Active Duty, along with the state application. Applicants seeking National Guard Preference must attach an NGB 23A (RPAS), along with the state application if they are a current member of the NC National Guard in good standing. Applicants who are former member of either the NC Army National Guard or the NC Air National Guard, with honorable discharge and six years of creditable service must attach a copy of the DD 256 or NGB 22, along with the state application.

ADA Accommodations

Consistent with the Americans with Disabilities Act (ADA) and the Pregnant Workers Fairness Act (PWFA), NCSHP is committed to the full inclusion of all qualified individuals. As part of this commitment, NCSHP will ensure that persons with disabilities, or known limitations covered by the PWFA, are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, please contact the person indicated below.

Employment Eligibility

It is the policy of the State of North Carolina and NCSHP that all employees provide proof of employment eligibility (immigration and naturalization) before or on the first day of employment. We participate in E-Verify (Employment Eligibility Verification System).

Contact Information

North State Highway Patrol 512 North Salisbury Street Raleigh, NC 27610 Email: [e-mail]

State Application Resources/Frequently Asked Questions Valuing Education and Experience

The State of North Carolina values the knowledge and experience of our jobseekers and current state employees. Approximately 91 percent of state job classifications allow experience to be substituted for education or do not require a post-secondary degree. Learn more.