SQL Developer

Overview

On Site
Depends on Experience
Contract - Independent
Contract - 24 Month(s)

Skills

sql
c#

Job Details

ON SITE 4 days a week in Shelton CT 2 to 4 year long contract position

Consultant will act as lead developer on large-scale project to automate several key complex and manually time consuming processes required for smooth and compliant daily business operation. Work is anticipated to be completed solely using Microsoft SQL Server stored procedures; however, an alternate methodology (e.g., combination of C# and SQL) could be considered if a compelling case is made (improve speed/efficiency). This new process is required to be run multiple times daily - both in batch mode, and on-demand by our internal business users via our main customer-facing application.

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

The ideal candidate can work independently as well as in a small team setting: perform problem analysis, develop solutions, test and implement. The selected candidate will join a small development team (3-4 members) working closely with the Business Unit staff to enhance our application suite as directed. Candidate must have excellent verbal and written communication skills, and be able to communicate successfully with various audiences business, technical, management.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.