SQL Developer-Onsite@ Shelton, CT -Need Locals Only

Cyber Sphere - Shelton, CT

Full-time - Mid Level

Shelton, CT

Professional, Scientific, and Technical Services

About the position

The SQL Developer will serve as the lead developer on a significant project aimed at automating several key complex and time-consuming processes that are essential for the smooth and compliant daily operations of the business. This role is critical as the new automated processes are expected to be executed multiple times daily, both in batch mode and on-demand by internal business users through the main customer-facing application. The primary technology stack for this project will be Microsoft SQL Server, specifically utilizing stored procedures. However, there is flexibility to consider alternative methodologies, such as a combination of C# and SQL, if a compelling case can be made to enhance speed and efficiency. The consultant will be responsible for understanding the current manual business processes and the related application functionality. This includes identifying and analyzing the impacted code bases to comprehend the existing code functions. The consultant will also need to grasp the proposed automated solution as outlined in the business specifications, as well as the existing partially-built stored procedure logic that is directed towards achieving the overall automation solution. Additionally, understanding the existing table structures, including any new tables created for this project, is essential. The role requires a logical and organized approach to break down larger automation tasks into smaller, manageable units that can be coded, tested, and verified. The consultant will need to understand various business use cases to successfully unit test code changes and analyze test case/data results to ensure they meet business objectives. Proper coding standards, practices, and formatting must be adhered to for consistency within the existing code base, and all code must be adequately commented for future maintenance. The consultant will also be responsible for responding to any code defects or approved change requests that arise from user acceptance testing.

Responsibilities

• Act as lead developer on a large-scale automation project.
• Automate complex and time-consuming business processes using Microsoft SQL Server stored procedures.
• Consider alternative methodologies (e.g., C# and SQL) if beneficial for speed and efficiency.
• Understand and analyze current manual business processes and related application functionality.
• Identify and analyze impacted code bases to understand existing code functions.
• Understand the proposed automated solution as per business specifications.
• Review existing partially-built stored procedure logic for automation.
• Understand existing table structures and new tables created for the project.
• Identify gaps in existing stored procedure logic and additional specifications needed.
• Understand related downstream application functionality impacted by automation changes.
• Break down larger automation tasks into smaller, manageable coding units.
• Understand business use cases for successful unit testing of code changes.
• Unit test changes and analyze test case/data results to ensure they meet business objectives.
• Use current coding structures, standards, practices, and formatting for consistency.
• Comment code properly for ease of future maintenance.
• Respond to code defects or approved change requests from user acceptance testing.

Requirements

• Minimum 5-7 years of experience with SQL Server (versions 2012/2019) and complex stored procedures.
• Proficient in SQL scripts and stored procedure development.
• Experience with Sencha ExtJS or JavaScript (ability to adapt from React, Angular.js, etc.).
• Proficient in PHP (version 7.2+).
• Experience with C#/.NET development.
• Familiarity with development environments such as Visual Studio and SQL Server Management Studio.
• Experience with source control tools like SVN, Git, or Azure DevOps.