Database Consultant

Elegant Solutions  •  Sacramento, CA

5 - 7 years experience  •  Information Services

$80K - $180K
Posted on 03/01/18 by Reji Thomas
Elegant Solutions
Sacramento, CA
5 - 7 years experience
Information Services
$80K - $180K
Posted on 03/01/18 Reji Thomas

Job Description:

Client is seeking a team of Consultants with collective knowledge and experience in data conversion and data cleansing to assist SOS in converting data from a legacy Oracle database to a modernMS SQL database using the Extract, Transform, and Load tools.

The resource team shall include a Lead Consultant, who will act as the primary Consultant for the services provided under this contract, and one or more additional Consultant personnel that will assist the Lead Consultant with the work and/or deliverables detailed in this SOW.

 

Responsibilities

The Consultants to perform services under this Agreement shall work collaboratively with the SOS CARS SI vendor, SOS PRD staff and SOS ITD staff on all CARS data conversion activities.

 

The related roles and responsibilities are as identified below: CARS Project Task/Activity Mandatory

Develop CAL-ACCESS to CARS Data Migration and Integration Plan

Perform Data Clean up

Perform Data Migration extract, transform and load (ETL) from CAL-ACCESS into a blank CARS Database

CARS Data Integration and testing of full database with CARS System

 

Qualifications

A minimum of three (3) years administrating and maintaining Oracle database systems.

A minimum of three (3) years administrating and maintaining MS SQL databases.

A minimum of five (5) years of experience in SQL query development, query optimizations, rule-based transformation, and source file preparation.

A minimum of three (3) years developing and implementing data strategy for all databases

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.