Senior Application Architect (.NET / Entity Framework / SQL Server / SSRS / Azure DevOps)

Title of the role: Senior Application Architect (.NET / Entity Framework / SQL Server / SSRS / Azure DevOps)
Duration: 30 Months contract
Location: Menands, NY
Job Description:

Job Description

Architect, develop and maintain REST APIs and backend services using .NET 8/10, C#, ASP.NET and Entity Framework.
Design, architect, optimize complex T-SQL queries, stored procedures, functions, views and triggers in SQL Server.
Create DDL and DML scripts and migrate to lower and production database.
Design and document all components of approved application solutions including integrations and prepare technical specifications, document process flows.
Participate in all phases of the Secure Software Development Life Cycle (SSDLC), ensuring compliance with security and quality standards.
Design and develop reports using SSRS to integrate with application.
Design and develop SSIS packages to automate the data extract and transfers.
Use GIT version control for application code and document repository, code reviews and run CI/CD pipelines for automated builds, test and deployments; manage work items.

Mandatory Qualification:
Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system.
Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

84 months of experience in application architecture, design, developing projects and interfaces using backend services/REST APIs with Microsoft .NET Core 8/10, C#, Entity Framework; frontend with Angular, HTML/CSS, Bootstrap.
84 months experience in architect SQL Server database design and development including tables, stored procedures, triggers, views and functions for relational databases.
84 months experience designing and developing reports using SSRS, and ETL packages using SSIS to automate data extraction and transfer processes.
60 months of experience in CI/CD using tools like Azure DevOps and performing tasks such as automated builds/pipelines and creating work items.
60 months experience in creation of developing user guides and technical documents based on business needs.
Bachelor's degree in Computer Science or related.