Randstad Database Developer - Optix in Irving, Texas

Database Developer - Optix

easy apply

job details:

  • location:Irving, TX

  • salary:$60 - $65 per hour

  • date posted:Friday, September 15, 2017

  • job type:Contract

  • reference:558320

easy apply

description

This resource will be responsible for building the metrics platform for Optix and ensure the metrics can be tracked and accurately communicated to business partners including:.

  • Data Analytics activities for the Optix transformation program

  • Develop Metrics Dashboard and enable Optix for cloud

  • SDLC automation and overall DevOps transformation

  • Re-design Operational Metrics and use AWS Big Data Platform / Migration

Required Skills:

Extensive technical knowledge in SQL Server, ETL,Reporting Tools (SSRS, Tableau,..etc)

Atlest 2 years working experience using SQL Server SSIS, SSAS, Data development

Extensive experience working with SQL development and SQL Server tools

Expertise in Reporting data models (Cubes/Dimensions/Star Schema)

Experience with open source tools for data management and data reporting/transformation

Knowledge and experience with Devops.

Proven experience with development activities for large, complex programs involving multiple application teams.

Excellent communications skills, experience managing communication with senior leadership.

Experience with driving teams to arrive at a solution. Ability to coordinate with multiple teams to achieve this.

Ability to work both independently and as part of a team.

Sound knowledge on Microsoft SQL Server 2005/2008/2012/2014/2016 SSIS/SSRS/SSAS, OLTP and OLAP.

Candidate should have experience in developing, designing and trouble shooting DTS/SSIS ETL Packages

AWS cloud migration experience

Candidate should have experience on adhoc reporting and Custom Reporting.

Candidate should have experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining and writing MDX Queries, Calculated Members, and KPI's using Microsoft sql Server

Report experience in SSRS

Good Understanding of Programming and using tools like VBscript and C#

Need analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Core DBA

Experience in performing back-up/recovery, running Database Consistency Checks using DBCC,

implementing security, configuring replication.

Experience in performance tuning, query optimization and running database.

Expertise in writing T-SQL Queries using Joins, Sub queries and Cursors in MS SQL server 2005/2008

Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production server.

Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups, Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.

Experience in Database Architecture, Design, Coding, Implementation and Production Support.

Expertise in design and architecting web based applications.

Experience with open source tools for development (Git, Jira, Confluence).

Knowledge and experience with Devops.

Proven experience with development activities for large, complex programs involving multiple application teams.

Excellent communications skills, experience managing communication with senior leadership.

Experience with driving development teams to arrive at a solution. Ability to coordinate with multiple teams to achieve this.

Ability to work both independently and as part of a team.

Desired Skills:

Data analysis experience

Knowledge of Open source tools and software

Telecom Experience preferred