SQL Developer III

 
Location: Spring, Texas
Posted On: 8/9/2017
Job Code: 3063_SQLIII_SPRING
Print
 
Job Description
 
Position: SQL DBA level III
Duration: 12 months (Possible Extensions | Conversion)

Job Description:
• This team is a part that manages SAP Data warehouse that sits on Oracle. This person will be pulling data out of Oracle and putting them into SQL. Person will be part of a larger group that does SSAS design and development. This person needs to have great communication as they will be working and sitting with End Users.
• The dashboard the team will work with is Tableau but it isn’t a must have.
• Must have exp with SQL 2016
• SSAS exp- be able to build models.

Day to Day:
• Responsible for the design, development and maintenance of software applications within the MS environment specifically MS SQL Server and MS Access.
• Supports testing, debugging, and refining the applications to produce the required product including upsizing MS Access applications, including robust Excel models, into MS SQL applications. Devises and provides programming solution approaches to problems and issues.
• Helps prepare both program-level and user-level documentation. Works with moderate work direction and is skilled and knowledgeable to the position. This position would typically include senior Developer who is able to perform tasks of high complexity and difficulty. Such individual could also manage, train and mentor other team members and lead projects.

Looking for a developer that can:
• Upsize existing Excel and Access applications / models into current version of SQL (2016). (This includes a front end to enter data) This is to eliminate numerous MS Access databases and spreadsheets.
• Use SSAS in tabular mode to build models and understand how to create DAX measures.
• Understand how to optimize performance with column store and in memory and advice on the right hardware. Set up row level security in SQL.

The technologies / skills the candidate should have include:
• BI Developer (Power Pivot/View/BI, SSIS, SSAS), SQL Server, Visual Studio .NET
• Reporting - SSRS, MS Access

In addition to “support” activities; the development they will be assisting with is a P&B tool that will be in SQL.
Category:IT  code:new
 
 
Job Requirements
 
 
SQL developer, SQL 2016, SQL Server 2016, SSRS, SSAS, Oracle, MS SQL Server, MS Access, Power Pivot/View, BI, SSIS, SQL Server, Visual Studio, .NET,
 

Not Ready to Apply?
Contact Details
 
Recruiter
Priyanka Tiwari
 
Phone
 
 
LinkedIn