Please send rate, resume and contact information to Deepak.S@shstinc.com or call me if you have any questions.
Job: SQL Server DBA
Location: Denver,CO
Duration:6-12 Months contract
Interview process:
Start off with phone interview and then a face to face
Looking for SQL Server DBA's that maybe have some BI experience in the stack.!!!! If they have BI as well.
The data modeling/BI skills are now just a "nice to have". Truly wants a STRONG SQL Server DBA.
The right candidate will have strong SQL Server (2014/2012/2008) DBA skills with 2+ years of OLAP development experience (Data warehouse concepts, cube design, fact, dimension structure, Data Mart development, etc).
The 3 things that Rob will look for on resume:
SQL Server DBA
Data Modeling skills
BI Development skills
They will do the following:
This individual will work with the team to put together an operational data store.
They will do modifications to the SQL Server database.
Do SQL Server database design, setup and maintenance
Create indexes, load data, run reports, extract information
Put together data store
Work with the Unix Admins
Job Requirements
Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse; Translate requirements into technical specifications, Validate that the data warehouse meets specified requirements
Ability to function and contribute in a team environment.
Work with other team members so that a single version of business terminology is maintained within the existing reporting architecture.
Work with customers internal and external to define and document the scope and functional requirements for data and reporting needs.
Understand and balance business requirements and user expectations.
Ability to work independently on data warehouse tasks with a minimal amount of supervision.
Use of deductive reasoning and analytic ability to transform data into information for key decision makers within the organization verifying that consistent information is always delivered.
Advanced degree in computer science, mathematics, engineering, information technology, business or related field required
Minimum 5 + years of extensive experience in SQL Server Integration Services (SSIS) and SQL Server analysis Services (SSAS) & SQL Server programming
– NICE TO HAVES
Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server. Experience with Oracle, AIX and Hadoop preferred but not required.
Familiarity with Tableau Reporting tool preferred, but not required.
Knowledge of the MS SQL Server data warehouse lifecycle and strong dimensional data modeling experience, star schemas including an understanding of extraction, transformation, and load processes from operational source systems into the data warehouse.
Collaborate on the global data architecture design and planning for the physical structure and implementation of new module on data warehouse cubes and creation of new data marts.
Experience in Mid-size to large scale Data warehouse systems.
Knowledge of health system functions strongly desired including terminology and coding.
SSIS knowledge and MS Analysis Services experience is secondary to SQL Server skills – NICE TO HAVE.
Deepak Rana
Technical Manager
E-mail : Deepak.s@shstinc.com
Direct Line : 412-450-1316 Ext 114
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at http://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment