Systems Engineer - V

JOB DUTIES: Translate user business requirements into program specifications. Create database objects Tables, Views, User defined functions, Store procedures, Joins, Dynamic SQL, Indexed Views, Daily Jobs and Workflow objects. Developed business logic workflows in SQL Server using stored procedures, UDFs, views, temp tables, table variables, For loops, CTEs. Performance tuning on database Objects to achieve optimal data retrieval/updates using SQLProfiler, Execution plan. Execute SQL Task and Data Flow Tasks were used extensively as part of ETL packages. Monitoring daily database jobs, data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting. Prepare Unit, Integration and System test plans and execute and log results. Analyze and fix bugs in the existing system. Create documentations and follow standards and methodology as defined by the project manager.

Targeted Years of Experience: 10+ years To support Employee Engagement Platforms, Positive, Proactive and Forward thinking

-Experience in the following technologies: HTML/CSS, JavaScript (jQuery and ReactJS),

-.NET Framework/.NET Core, ASP.NET MVC/WebAPI (C#), Java Spring, Jenkins, New Relic, Docker -2 or more years experience with overall Microsoft Stack (MSSQL, C#).

-Agile development experience

-Thorough understanding of Micro Service Based Architectures and open stack technologies.

-Experience with data automation and connections across multiple environments. SQL Server development in 2012, 2019 CTEs, Stored procedures, UDF, Database development SSIS package development, DB job debugging ETL

DESIRED SKILLS: Google Cloud Platform (Google Cloud Platform) C# Scripting