Oracle DBA, Consultant in AT&T

Windsor, Ontario, Canada
Current:AT&T
Past:Nationwide Financial
Education:Master

Job Experience

Oracle DBA, Consultant

AT&T

July 2012 to October 2013

? Part of the Data Architecture team which supports development, test and production databases.
? Implementing High Availability Oracle Golden Gate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments.
? Performed Database migration from Oracle 10gR2 to Oracle 11.2.0.4 using Golden Gate.
? Worked on RMAN duplication, Cross-platform Transportable Tablespace.
? Implementation and support of 10g and 11g migrations and upgrades from Oracl

Oracle PL/SQL Developer

Nationwide Financial

July 2011 to July 2012

? Executed different phases of SDLC including gathered and analyzed business requirements, designed and modeled them into diagrams and documents, monitored function and structure implementations, designed test scenarios.
? Analyzed and segregated Business Requirements into high level and low level Use Cases.
? Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
? Loaded source data files with SQL*Loader and imp/exp util

Education

Master

University of Windsor

Currently studying

Languages

English

Advanced

IT skills

Oracle Database

Advanced

Other Skills

Haipeng

More Haipeng

Career Goals

Industries of interest

Areas of interest

Availability to travel and work outside the city

Yes

Interests and hobbies