Oracle DBA, Consultant in AT&T
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 WindsorCurrently studying
Languages
English
Advanced
IT skills
Oracle Database
Advanced
Other Skills
More Haipeng
Career Goals
Industries of interest
Areas of interest
Availability to travel and work outside the city
Yes