Drag

SQL Developer

Location : ,

Job Description

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)

  1. SQL Server version 2012/2019; complex stored procedures; SQL scripts
  2. Sencha ExtJS/javascript (or can quickly adapt from React, Angular.js, etc)
  3. PHP (v7.2+)
  4. C#/.NET
  5. Experience with development environments (Visual Studio, SQL Server Management Studio)
  6. 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