SQL position
6 Months
Must be on site - 4 days per week in Shelton, CT
Location is in Shelton Connecticut- these positions are on site, therefore need people who are local or who will relocate to be local in Shelton CT
Technical Skills required (min. 5-7 years)
- SQL Server version 2012/2019; complex stored procedures; SQL scripts
- Sencha ExtJS/javascript (or can quickly adapt from React, Angular.js, etc)
- PHP (v7.2+)
- C#/.NET
- Experience with development environments (Visual Studio, SQL Server Management Studio)
- Experience with source control tools (SVN, Git/Azure DevOps)
With a provided business specification, consultant should be able to:
- Understand current manual business processes and related application functionality
- Identify and analyze impacted code base(s) to understand existing code function
- Understand the proposed automated solution (spec)
- Understand existing partially-built stored procedure logic written toward accomplishing the overall automation solution
- Understand existing table structures, including new tables created for this effort
- Identify gaps in existing stored procedure logic, along with additional specifications required to complete this project
- Understand related “downstream” application functionality impacted by the automation changes
- Think in an organized and logical manner, to break down larger automation tasks into smaller units that can be coded, tested and verified
- Understand the various business use cases required to successfully unit test code changes
- Unit test changes - including any affected downstream systems/screens/functions
- Analyze test case/data results to ensure they meet business objectives
- Use current coding structures, standards, practices, and formatting for consistency within the existing code base
- Properly comment code for ease of future maintenance
- Respond to any code defects, or subsequently approved change requests, resulting from user acceptance testing