Migration Analyst - Databases

Employer: Vauban becomes Inetum
Domain:
  • IT Software
  • Telecommunication
  • Job type: full-time
    Job level: 1 - 5 years of experience
    Location:
  • BUCHAREST
  • Updated at: 07.01.2021
    Short company description

    Inetum is an agile IT services company that provides digital services and solutions and a global group that helps companies and institutions to get the most out of digital flow.

    Vauban, the Romanian division of Inetum, is an important player in the IT services and solutions market in our country, with over 13 years of activity. Vauban has over 450 employees who provide, from the service centers in Bucharest, Pitesti and Constanta, IT consulting services, infrastructure and software development services, digital services, solutions for Smart City.

    Requirements

    Oracle Database – PL/SQL
    Shell Scripting UNIX/LINUX

    Responsibilities

    Analysis and Testing
    • Participate to data source analysis, source to target data mapping and migration data model definition.
    • Requirements definition and “expected data to be compared” preparation for source to target reconciliation reports
    • Participate in overall migration cutover plan preparation involving different teams and organizations
    • End to end migration execution for testing purposes
    • Multiple testing migration execution for preparing full and low volume data environments together with vendor teams
    • Data migration testing, bug reporting and defect tracking
    • Migration issues impact assessment and prioritizations
    • Reconciliation reports preparation, error investigation and fixing
    • Testing support, writing tools for testing automation/assistance
    • Create Runbook documents (steps to be run) for various migration activities/phases as input for live migration execution teams

    Oracle Database – PL/SQL
    • Reconciliation scripts development for migration data validation between source systems and new complex system with new data model based on “expected data to be compared”.
    • Scripts development for data validation and cleansing using SQL and PL/SQL to evaluate data quality in the source systems.
    • Maintain Migration Databases in terms of preparing schemas for new migration, import/export data for test purposes
    • Maintain Databases Passwords, flawless running in terms of performance, load and available space monitoring

    Shell Scripting UNIX/LINUX
    • Shell scripting (mainly in UNIX OS) to create automatic scripts that executes SQL queries for comparing, exporting and importing data.
    • Maintain UNIX servers in terms of user passwords, Public/Private keys, cleaning the directories and organize the space available
    • Run scripts, create directories, transfer files and manipulate dumps of data