Systems Engineer - V

NEED LAST 5 digits of SSN + MONTH and DAY of BIRTH TO SUBMIT.
Job Description:

• Targeted Years of Experience: 10 plus years
• To support Employee Engagement Platforms

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.

Must Have Skills:

• 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

Note:

• Bill rate $93.32

Pay Range: $XXX - $XXX

The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.