Database Analyst (T-SQL Expert) (630 views)

****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