DB Manager/Admin - Trenton, NJ - Georgia IT Inc.

Trenton, NJ

DB Manager/Admin
Location: Trenton, NJ
Position Type: Contract
Rate: DOE

Job Description:

This role is for a Technical Architect/Database developer that has managed and conducted the analysis for full scale migrations of Relational Databases.
Candidate should show proficiency in conducting AS-IS/To-Be Assessments and walkthroughs of existing database structures, creating the new structures and managing the to specific milestones while retaining all artifact related to the implementation.
This candidate will use data modeling tools and the latest SQL Server technology to deliver the data migration effort for the implementation of an enterprise wide software application using SQL Server Administration and Integration Services. The position achieves this through the effective planning, capture and translation of data migration requirements into the design and execution of the migration effort for the VERI-NJ platform.

Key Accountabilities:

Data Migration Planning
- Identifies, documents and validates data migration scope, risks, constraints, dependencies and assumptions
- Develops, documents and validates data migration strategy

Data Migration Analysis
- Engages key users and stakeholders in defining data migration requirements
- Identifies, documents and validates data migration requirements, technology and IT infrastructure requirements and expectations
- Identifies source data requirements
- Assesses source data quality
- Defines business rules for handling source data
- Identifies, documents and validates target data requirements
- Maps and specifies the required transformations from the source data to the target data
- Validates data migration requirements with key users and stakeholders
Data Migration Design
- Designs a staging area for conducting data transformation and fixing errors
- Designs target data architecture
- Maps source, staging and target data architectures to each other including rules and transformations
- Identifies data migration technology
- Designs data migration procedures
- Designs data cleansing procedures
- Designs data conversion procedures
- Designs data validation procedures
- Validates data migration design specifications with key users and stakeholders
Data Migration execution
- Tests data migration procedures
- Creates and populates staging areas
- Cleanses data
- Converts/transforms data
- Performs trial data migrations into staging
- Performs data migration into production

Source : Georgia IT Inc.