Job Description :
Hi,
Please apply if you are comfortable with this position.
Job Description:
Role: SQL Server Developer
Location: Austin, TX (Round Rock)
Length: 1 Year Contract To Hire
Basic Job Notes: Must have knowledge of MS/SQL 2016 and 2017. The role is to look at their existing SQL application queries and optimize them. They will use data cube to use different data sources in order to support key initiatives. They will also work on the visualization (nice to have skill
MS/SQL is not that different from their old versions. They haven’t moved over to 2017 yet, but want to have someone with that experience to for future planning. They need to have 2016 so that they can leverage the data. He has data scientist on his team that are not SQL experts. They want to build a foundation to help the data scientist and help with strategic initiatives.
Expertise Required:
* 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 2016, 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.
Brief description of the project and how does this person fit into it:
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.
Requirements:
* 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.