Senior Oracle Consultant Resume

SUMMARY

12 years of Database Administrator, Including 5 years as Senior DBA in Cisco, 3 years as Oracle consultant in Confidential worked for 50+ customers like Confidential, Confidential, Hospitals, Government.
3 Years as Oracle ERP developer in Confidential CO. LTD. Design and migrate OLTP and OLAP on Production DB. Fixed lots of Oracle DB issues and bugs on production system.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Consultant

Responsibilities:

Remote On-call Oracle Database/SQL Server of HIS(Hospital Information System), LIS(Laboratory Information System), PACS(Picture Archiving and Communication System), EMR(Electronic Medical Record), BI. Less than 0.5 hour response time.
Automate Windows 2008 Oracle 11.2.0.4.1 RAC cutover Oracle 12.1.0.2.5 RAC on AIX 7.1 (IBM Power 780&EMC), PSU bug fixing, troubleshooting security privilege issues, poor SQL performance like query ALL SYNONYMS slow on Oracle 12C.
Goldengate replicate from Windows 2008 Oracle 11.2 RAC to AIX Oracle 12c RAC.
Build remote DataCenter Oracle 12C Active Dataguard for Disaster Recovery.
OS System maintanence. Redhat 6.3 OS hung bug quarterly on IBM x3850 X5, Found solution of downgrade to Redhat 5.6.

Confidential

Senior DBA

Responsibilities:

7*24 On-call 300+ production Oracle 10g/11g RAC ASM DBs, monitoring and fixing CRS status, Sequences, ASM disks, Database locks, Linux File system free space, Shareplex replication Data out-of-sync, CPU/Memory/IO usage, RMAN backup issue, capacity expend request, Grid control alert mail.
Global Production DB Oracle 10g/11g RAC installation, configuration, cutover.
Shareplex/Goldengate migration. Hundreds of Databases multiple replication channel build and configuration. Source and target Data compare, and repair for data out-of-sync.
Successfully deployed T27-T29 major Cisco WebEx meeting DB Patches to lab and production.
Cassandra cluster deployment for billing DB, migration from Oracle RAC to Cassandra cluster for internal Database.

Confidential

Consultant

Responsibilities:

Working with Sun Solaris, IBM AIX,HP-UX, Oracle RAC, Data Guard, Recovery Manager, Linux and Windows platforms.
Supported Sales team to sign and renew Oracle Database Service and yearly satisfied all customers to continue quality business.

Confidential

Oracle D2k developer

Responsibilities:

Oracle D2k/6i Form& Report Builder developer for ERP system. Oracle AS 9i deployment. ERP C/S and B/S deployment.
Understanding, analyzing and documenting business rules, requirement and data sources for the ERP system.
Developing and modifying PL/SQL packages, functions and procedures for Form and Report .
Ultimus bpm workflow developer for OA system.