MS SQL Developer/Architect

Duration:  4-6 months
Location: Round Rock, TX 78682 
Onsite - Local Candidates Only

Job Description:
To assist with optimization and building a Business Critical database and data cube that is used for business intelligence and decision making. This position will be required to look at the entire data model, re-architect and develop new in MS SQL. Ideal candidate will have expertise development background in MS SQL but can also look at the whole picture as an architect. 
 
Responsibilities:
* Review to optimize existing queries and stored procedures for required data set. 
* Review and optimize the table structure for cube generation. 
* Build an efficient and scalable architecture for required Data Cube. 
* Write, test and deploy MS SQL Queries and Stored Procedures from start where needed. 
* Build automated procedure for Data cube process based on MS Analysis Services. 
* Create error and metric based automated queries, tables for further resolution actions. 
* Establish version control for query modifications. 
* Measure performance at every level and provide metric indicators to further improvements. 
* Work with Product manager of the Data Cube to obtain guidance and report to for the project deliverables. 
 
Requirements: 
* 7+ year MS SQL Development Expertise in a large enterprise working with Teradata and other large scale databases. 
* Expert knowledge and deep expertise working with MS SQL 2012, MS SQL Server 2017, MS SQL Server Analysis Services.
* Strong experience in performance tuning and query optimization, packaging, functions, stored procedures. 
* Demonstrable approach to creative problem solving and solution recommendations. 
* Ability to work with other SQL developers and business leaders.

Want to apply later?

Type your email address below to receive a reminder

ErrorRequired field

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file