Database Consultant

  •  

Sacramento, CA

Industry: Information Services

  •  

5 - 7 years

Posted 292 days ago

  by    Reji Thomas

This job is no longer available.

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

$80K - $180K