Database Administrator-Architect (15years+experience)

  • New York City, NY
  • Posted 2 hours ago | Updated 2 hours ago

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Able to Provide Sponsorship

Skills

Data Analysis
Data Cleansing
Data Integrity
Data Migration
Data Modeling
Data Quality
Database
Design Documentation
Management
Mapping
Migration
PL/SQL
Performance Tuning
Query Optimization
SQL
Siebel
Siebel EIM
Unit Testing

Job Details

DBA Architect - 15years+ experience

ONSITE

NY CITY

DESCRIPTION OF WORK AND SKILLS DESIRED

-Define the data migration strategy and architecture in line with industry best practices for large-scale data migration.

-Define data migration objectives & scope, identify stakeholders, outline data migration activities & deliverables.

-Develop data migration approach and data model for supporting massive scale data loads.

Work with multiple vendors for data source and mapping of entities.

-Solid work experience required on PLSQL.

-Review and execute data analysis, data cleansing, enrichment, and mapping activities to ensure zero fall-outs.

-Manage execution of data migration cycles, unit test migration .

-Work closely with business functions to maintain data integrity and accuracy, suggest performance tuning/optimal way to reduce fallouts while maintaining data quality.

-Publish execution reports to stakeholders.

-Ensure successful migration from source to target system and obtain data sanity sign-off post cut-over

-Professional experience required on SQL,PLSQL,Siebel EIM, Siebel Admin.

-Good understanding on Siebel EIM performance tuning.

-Deep understanding on Siebel EIM methods.

-Develop PLSQL packages and performance tuning.

-Demonstrated experience creating data models for application operations and performance requirements.

-Deep understanding of query performance tuning

-Deep understanding of Packages/Procedures.

-Advancedknowledge and extensive experience with PL/SQLadvance features

-Good experience in all aspects of SQL development: review requirements, design/document database objects, create database objects and test database layer.

-Experience working on higher environment SQL code delivery

-Advanced PL/SQL & Advanced query tuning

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.