Required Skills

Oracle DBA

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :-

  • PG :-

Other Information

  • No of position :- ( )

  • Post :- 23rd Aug 2021

JOB DETAIL

1) Planning: development of a plan to identify the data and application processes that will be migrated based on the business, project and technical requirements identified by DPOR and the new vendor – including associated tests, automation scripts and mappings. Data cleansing through collaboration with information management staff will be required to improve data quality and eliminate redundant or obsolete information.

 

2) Migration: validation of hardware and software requirements and migration procedures are customized to ensure timely and accurate migration from the legacy Oracle database to the new SQL database. Pre-validation testing may be required to ensure requirements and customized settings function as expected. Oversees data extraction to ensure accurate data is read from the old system, and data loading, where data is written to the new system.

 

3. Post-migration: After data migration, the DBA will perform data verification to determine whether data was accurately translated, is complete, and supports processes in the new system. During verification, the DBA will work with DPOR IT staff to monitor a parallel run of both systems to identify areas of disparity and forestall erroneous data loss. Migration close-out meetings will officially end the migration process.

 

Skill

Required

Years Used

Last Used

Oracle Database Management

5 Years

 

 

SQL Database Analysis

5 Years

 

 

SQL Database Management

5 Years

 

 

Data migration including mapping and transfer from legacy to new systems

5 Years

 

 

Ja

Company Information