Software Engineer II (SQL Developer)

Qualifications
Applications are developed in VB.Net and C# using Visual Studio and MS SQL Server development tools
Bachelor's degree in Computer Science, Mathematics, or Data Science
Experience with large databases
MS SQL Server
Visual Studio, VB.Net development experience optional
Ability to deliver projects on time and with a high quality of code
Ability to deal with complex processes
Minimum 5 years of experience in software development or similar role
Experience with data analysis
Responsibilities
Analyze and optimize large, complex datasets and queries
Perform statistical analysis to valid data and impact of software upgrades and enhancements
Develop and maintain stored procedures and SSIS packages
Support production backend processes
Develop new backend processes
Maintain code standards
Work closely with the team to maintain component reusability and integrity of the system
Troubleshoot and address problems wherever they exist
Job description
TransCore, (TRN) a subsidiary of ST Engineering, is seeking a full-time Software Engineer II (SQL Developer) to join our team in Harrisburg, Pennsylvania.

Job Summary: We are looking for a full-time Software Engineer II (SQL Developer) to join our software development team based in Harrisburg, PA. The team currently supports and develops enhancements to our Customer Service Center software and the Toll Host systems developed for the Pennsylvania Turnpike Commission. System components include a client-server application, website, mobile application for Android and iOS, Web API, OCR image processing module, and a SQL Server database. Our systems utilize a tiered architecture and object-oriented technology. Applications are developed in VB.Net and C# using Visual Studio and MS SQL Server development tools.

Essential Duties And Responsibilities Include But Not Limited To
• Analyze and optimize large, complex datasets and queries
• Perform statistical analysis to valid data and impact of software upgrades and enhancements
• Develop and maintain stored procedures and SSIS packages
• Support production backend processes
• Develop new backend processes
• Maintain code standards
• Work closely with the team to maintain component reusability and integrity of the system
• Troubleshoot and address problems wherever they exist

Required Skills And Experience
• Bachelor's degree in Computer Science, Mathematics, or Data Science. Master's degree is a plus.
• Experience with large databases
• MS SQL Server
• Visual Studio, VB.Net development experience optional
• Ability to deliver projects on time and with a high quality of code
• Ability to deal with complex processes
• Minimum 5 years of experience in software development or similar role.
• Experience with data analysis.