****Direct Client Requirement ****
Title: Database Analyst (T-SQL Expert)
Location: Des Moines, IA
Duration: 2 Months
Rate: DOE
Interview Type: Skype and phone
Work Status: Successful applicants must be legally authorized to work in the U.S.
Job Type: C2C,C2H ,W2,
Experience: 8+ YEARS
Responsible for designing, modeling, developing and supporting Microsoft SQL Server 2016. Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.
Designs and supports DBMS of low to medium complexity. Works on one or more projects as a project team member or sometimes as a project leader. May coach more junior technical staff.
Primary Skill Set
• 8+ years where the primary job function was writing and performance tuning complex TSQL queries at an expert level
• 2+ years writing SQL to access commercial databases like PeopleSoft, Microsoft Dynamics, Workday, SAP or similar for user reports.
• 5+ years where the primary job function was design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine
• 3+ years where the primary job function was design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine 2016 or newer
• 3+ years where the primary job function was writing SSIS packages that used objects like calculated columns, script tasks, parameters, and primarily CRUD SQL that were scheduled to run on a regular basis for SQL Server 2016 or later.
• 3+ years creating/managing Team Foundation Server Automated Build and Release Definitions in a DEVOPS process
• 5+ years actively using visual studio database projects to for the build of database changes and maintaining database source control in a DEVOPS process.
• In depth understanding of using Entity Framework against SQL Server(e.g. coding, debugging, optimizing)
• In depth understanding of using Reporting Services against SQL Server(e.g. The abilities of what can be done in a report vs. TSQL)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• In depth understanding of Networks(e.g. Network Transmission Protocols, Firewalls, DNS, troubleshooting)
• Excellent verbal and written communication skills
Secondary Skill Set
• Experience as a developer coding VB.NET or C#
• Visual Studio 2017 or Newer
• Experience creating/managing Control-M Scheduler jobs
• Experience in Data Warehouses
Preferred at least 2+years’ experience in Azure DevOps
• Boards
• Repos
• Pipelines
• Releases
At least 1+ years’ experience with Azure Components is a plus
• Data Factory
• Data Lake
• Data Bricks
• SQL Data Warehouse
• Stream Analytics
Required / Desired Skills
writing and performance tuning complex TSQL queries at an expert level
Required 8 Years
writing SQL to access commercial databases like PeopleSoft, Microsoft Dynamics, Workday, SAP or similar for user reports.
Required 2 Years
design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine 2016 and newer
Required 5 Years
writing SSIS packages that used objects like calculated columns, script tasks, parameters, and primarily CRUD SQL that were scheduled to run on a…
Required 3 Years
…basis for SQL Server 2016 or later.
Required 3 Years
creating/managing Team Foundation Server Automated Build and Release Definitions in a DEVOPS process
Required 3 Years
using visual studio database projects to for the build of database changes and maintaining database source control in a DEVOPS process.
Required 5 Years
In depth understanding of using Entity Framework against SQL Server(e.g. coding, debugging, optimizing)
Required
In depth understanding of using Reporting Services against SQL Server(e.g. The abilities of what can be done in a report vs. TSQL)
Required
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Required
In depth understanding of Networks(e.g. Network Transmission Protocols, Firewalls, DNS, troubleshooting)
Required
Excellent verbal and written communication skills
Required
Experience as a developer coding VB.NET or C# – Visual Studio 2017 or newer
Required
Experience creating/managing Control-M Scheduler jobs
Required
Experience in Data Warehouses
Required
Experience with Azure DevOPs (boards, repos, pipelines, releases)
Required 2 Years
Experience with Azure Components (Data Factory, Data Lake, Data Bricks, SQL Data Warehouse, Stream Analytics)
Required 1 Years
Position Keywords: MODELING , WORKDAY , C# , SQL , DBMS , MICROSOFT DYNAMICS , SCRIPT TASKS , DEVOPS , T-SQL , SAP , DNS , VB.NET , SQL SERVER , PEOPLESOFT
Pay Rate: DOE
Job Duration: 2 Months
% Travel Required: None
Job Posted by: Consulting Services
Job ID: 622503
Work Authorization: Successful applicants must be legally authorized to work in the U.S