Job Description :
Title: SQL Server DBA
Location: RENSSELAER, NY
Duration 6 months+
Interview: 1st round On Screen after that F2F


Top 3 Skills:-
ETL (Extract, Transform, and Load) Proficiency: This resource will be working with large data sets from 500 different healthcare providers. The DBA will pull data from the database using both SSIS and writing complex SQL Queries
7+ years of Writing Complex SQL Queries. Experience writing SQL code against code in non-SQL format that has been converted from stored procedure logic
Documentation Proficiency: Experience creating Data Flow Diagrams and Entity Relationship Diagrams. Samples or references that can back up experience

Description:-
Build SSIS from scratch
Write SQL codes against data that is being received in a non-SQL format that will be needed for data loaded
Processes that need to be converted from SQL (TSQL, stored procedure)
Good at documentation: Data flow diagrams, Entity document diagrams.
Willingness to go beyond the role of a DBA to talk to the end users to use the data


Oracle experience:-
Work Environment: The DBA will be working beside a small team (4 person development team) and a data architect. Therefore they should have experience coming from a culture of collaboration