SQL Developer

Skills

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)

Description

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.

Responsibilities

• 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