Systems Engineer - V

  • Alpharetta, GA
  • Posted 21 days ago | Updated 1 hour ago

Overview

On Site
USD 65.00 - 70.00 per hour
Full Time

Skills

Employee Engagement
Workflow
Performance Tuning
SQL
Data Flow
Reporting
System Testing
HTML
Cascading Style Sheets
JavaScript
jQuery
React.js
.NET
ASP.NET MVC
Web API
Java
Spring Framework
Jenkins
New Relic
Docker
Microsoft
Agile
Microservices
Microsoft SQL Server
Stored Procedures
UDF
Microsoft SSIS
Database
Debugging
Extract
Transform
Load
Google Cloud Platform
Google Cloud
C#
Scripting

Job Details

  • 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:

Pay Range: $65 - $70/hr on W2
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About PTR Global