SQL Server Developer

company banner
Apex Systems, Inc
SQL Server 2016, SSAS, Teradata
C2H W2, contract to hire
Depends On Experience
Telecommuting not available Travel not required

Job Description

US Citizens and those authorized to work in the US without Sponsorship are encouraged to apply. We can't provide sponsorship or work on c2c at this time.

 

Basic Job Notes: Must have knowledge of MS/SQL 2016 (required) and 2017 (preferred). The role is to look at their existing SQL application queries and optimize them. They will use data cubes to use different data sources in order to support key initiaves. 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. 

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. **********Job Requirements: * Review to optimize existing queries and stored procedures for required data set. * Review and optimize the table structure for cube generation. * Build an an efficient and scaleable 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. ************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. 


Must have skills/technologies: 
1.) 7+ year MS SQL Development Expertise in a large enterprise working with Teradata and other large scale databases. 2.) Expert knowledge and deep expertise working with MS SQL 2012, MS SQL Server 2016, MS SQL Server Analysis Services. 3.) Strong experience in performance tuning and query optimization, packaging, functions, stored procedures. 4.) Demonstrable approach to creative problem solving and solution recommendations. 5.) Ability to work with other SQL developers and business leaders. 

Nice to haves skills/technologies: 
*Review to optimize existing queries and stored procedures for required data set. * Review and optimize the table structure for cube generation. * Build an an effeicient 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. 

Posted By

8911 Capital Of Texas Highway, Suite 3200 Austin, TX, 78759



Company Information

Apex Systems is a division of the 2nd largest IT staffing and services firm in North America with over 60 branch locations across North America. We help match top IT talent with great companies in all industries. In 2014, Apex placed over 24,500 tech professionals with clients across the U.S. and Canada.
Dice Id : apexsan
Position Id : 170261

Similar Positions at Apex Systems, Inc

SQL Server DBA
  • Austin, TX
  • 1 week ago
Fiserv Consultant
  • Austin, TX
  • 1 month ago
BI/SQL Developer
  • New Haven, CT
  • 2 weeks ago
Web/Database Developer (ASP.NET, C#, SQL)
  • Washington, DC
  • 3 weeks ago
SQL DBA
  • Franklin Lakes, NJ
  • 4 weeks ago
Data Engineer (Sybase, SQL)
  • Baltimore, MD
  • 1 week ago
Sr Data Modeler
  • San Antonio, TX
  • 1 month ago
BI Developer
  • Ruther Glen, VA
  • 1 week ago
.Net Developer
  • Atlanta, GA
  • 3 weeks ago
.NET Developer
  • Nashville, TN
  • 3 weeks ago