Uploaded File
add photo
Huafeng
iOracle.Consulting@yahoo.com
732-789-9309
Sarasota, FL 34239
Managing Oracle DBA
18 years experience W2
0
Recommendations
Average rating
15
Profile views
Summary

Senior hands-on Oracle database and Apps Consultant and Manager with various Oracle projects accomplished over last 16 years, by deploying Oracle standalone and multitenant databases (12c/11g/ 10g/9i), Exadata X5/X4/X3, E-Business Suite (EBS) and Applications (r12/11i), Real Application Clusters (RAC), Data Guard, Fusion Middleware Infrastructure and Oracle Database Alliance (ODA) X 5, on Solaris, HP, AIX, Linux/RedHat, Oracle Virtualized Platform (OVP), Oracle Enterprise Linux (OEL), Oracle Cloud/NoSql/MongoDB, MS SQL Server 2008/2012/2014, Windows 2008/2012/2014 servers, GNS/DevOps, as well as Oracle Business Accelerators (OBA), Applications implementation Methodology (AIM), Oracle Database Appliance (ODA), Maximum Availability Architecture (MAA), Service Oriented Architecture (SOA) and Agile full cycle development technologies.
• Highly effective manager for various full-cycle Oracle project deploys and maintains including contract bidding, pre-sale presentation and hiring, Oracle architecture and design, project budgeting and planning, project tracking, team workload allocation, team coaching, appraisal and timesheet, vendor liaisons, policy and standard-making, hands- on problem-resolving at all levels of OS, network, database, applications and end business community, and agile management of both team and project on the fly. Also being top-notch technology-oriented, leading by examples, micro-controlling by deadlines, and being technical excellency pursuer and key team player.
• Sharp problem fixer and powerful performance tuner from end-user/client, apps mid-tiers and database back ends all the way up to hosting servers, storage servers and network, by fully using Oracle and non-Oracle tuning tools like ADDM, AWR, ADR, SQL Tuning Advisor (STA), SQL Access Advisor (SAA), SQL Performance Advisor (SPA), Grid Control 11g, Cloud Control 12c/13c, Enterprise Manager Express (EME) 12c, Oracle Access and Identity Management Packages 10g/11g/12c, SOA, TOAD and other non - Oracle Apps plugins, as well as MS SQL server management studios.
• Oracle Certified Professional (OCP) DBA on implementing Oracle database technologies (12c, 11g, 10g, 9i), RAC, Active Data Guard, MAA Disaster Recovery (DR), Oracle Fusion Middleware, Grid/Could Controls (11g/12c/13c), EBS/Apps r12/11i, Oracle Supercluster, RAC remote clusters (11g/12c), Oracle Access and Identity Management packages, GoldenGate Replication /GGSCI/Studio (11g/12c), Oracle Advanced Securities like Transparent Sensitive Data Encryption (TSDE), Data Redaction, Data Masking, Oracle Database Vault, Auditing Vault and Database Firewall (AVDF) and Key Vault (11g/12c). I
• Leading DBA Consultant for various object data modeling, agile database development and design, EBS/Apps system golden configurations, Init.ora parameters tuning, standard installation checklists and standardized procedures, backup and recovery using Recovery Manager (RMAN) and Flash Recovery Area (FRA), Oracle secure backup, Zero Data Loss Recovery Appliance (ZDR), advanced upgrade and migration tools like ODA, EBS/Apps patching and cloning like Online Patching (ADOP), EBS/Apps Data Appliances like Selective Transparent Data Encryption (STDE), API customizations, CPU & PSU Patching, DR synchronization, Oracle Maintenance Plans, Oracle Support /TAR management, SOX/STIGS auditing, SOA securities and Weblogic servers.
• Over 16 years of solid Oracle architecture and system integration experience on architecting and designing Oracle n-tier OLTP, OLAP, Data Warehouse (DW), data mart, data store, data replication, MAA DR like Active Data Guard, EBS/Apps/SOA/ Dementra systems on Oracle HA systems like RAC (10g/11g/12c), and other non-Oracle systems, 11g/12c Fusion Apps/Middleware/Weblogic integrations including OAM, OBIA, OBIEE, SOA, ODI, as well as all upgrades and migrations from 10g/11g to 12c standalone and multitenant systems, from EBS/Apps 11i to r12 now up to 12.2.x, along with Oracle Access and Identity Management (OAIM) installs and maintenance plans. SELECTED PROJECTS
• Led major implementations and migrations from EBS/Apps 11i to r12, from 10g/11g to 12c (standalone and multitenant), from 10g Fusion Infrastructure to 11g/12c along with OAIM packages and cloud control 12c in both RAC and non-RAC environments for both commercial and government clients.
• Led specific migrations and deploys to deploy Oracle Access and Identify Management Package, 11g Fusion Infrastructure Roll-Up, Weblogic 11g/12c installs, OBIEE from 10g to 11g to 12c, RAC and Data Guard from 10g to 11g/12c and set up DR sites.
• Led upgrades and migrations for major telecom, retail banking and financial clients from EBS/Apps/SOA 11i to R12, Oracle RAC DB from 9i /10g R2/ 11gR2/12c, MAA/RAC/ Data Guard using AIX GPFS/virtualization, Solaris, Oracle Linux and MS SQL Server 2005/2008/2012.
• Led major Oracle HR, Financials, Supply Chain (SC), Manufacturing, Retail, Order Management and others' upgrades, patching, performance tuning for global EBS/Apps/SOA systems, including migration from Apps 11.5.x to 11.5.10/9i to 10g to 11g and 12c using Oracle 10g/11g RAC and active data guard deploys.
• Led EBS/Apps r12 auditing (SOX/STIGS) and security setups using Oracle Advanced Security/Vault (10g/11g) and Oracle data encryption for a Financials & HR membership system - including both tablespace and row level encryptions, and others include:
• N-tier Oracle Apps/Financials set-up using RedHat, RAC, Oracle 10g database and Apps server for a global subscription and catalog system.
• Go-live of a Transactional Analysis and Reporting System (STARS) using Oracle Financials, Order, Inventory, Manufacturing and self-service modules. II
• Design and build-up of Defense Medical HR Internet System (DMHRSi) using Oracle Financials, HR and RAC.
• Performance tuning of Def

Experience
Information Technology
Oct 2019 - present
iPhone# 732-789-9309 ~ Skype # peter.xu19 SUMMARY * Senior hands-on Oracle database and Apps Consultant and Manager with various Oracle projects accomplished over last 16 years, by deploying Oracle standalone and multitenant databases (12c/11g/ 10g/9i), Exadata X5/X4/X3, E-Business Suite (EBS) and Applications (r12/11i), Real Application Clusters (RAC), Data Guard, Fusion Middleware Infrastructure and Oracle Database Alliance (ODA) X 5, on Solaris, HP, AIX, Linux/RedHat, Oracle Virtualized Platform (OVP), Oracle Enterprise Linux (OEL), Oracle Cloud/NoSql/MongoDB, MS SQL Server 2008/2012/2014, Windows 2008/2012/2014 servers, GNS/DevOps, as well as Oracle Business Accelerators (OBA), Applications implementation Methodology (AIM), Oracle Database Appliance (ODA), Maximum Availability Architecture (MAA), Service Oriented Architecture (SOA) and
No skills were added
Remove Skill
Highly effective manager
Oct 2019 - present
various full-cycle Oracle project deploys and maintains including contract bidding, pre-sale presentation and hiring, Oracle architecture and design, project budgeting and planning, project tracking, team workload allocation, team coaching, appraisal and timesheet, vendor liaisons, policy and standard-making, hands- on problem-resolving at all levels of OS, network, database, applications and end business community, and agile management of both team and project on the fly. Also being top-notch technology-oriented, leading by examples, micro-controlling by deadlines, and being technical excellency pursuer and key team player.
• Sharp problem fixer and powerful performance tuner from end-user/client, apps mid-tiers and database back ends all the way up to hosting servers, storage servers and network, by fully using Oracle and non-Oracle tuning tools like ADDM, AWR, ADR, SQL Tuning Advisor (STA), SQL Access Advisor (SAA), SQL Performance Advisor (SPA), Grid Control 11g, Cloud Control 12c/13c, Enterprise Manager Express (EME) 12c, Oracle Access and Identity Management Packages 10g/11g/12c, SOA, TOAD and other non - Oracle Apps plugins, as well as MS SQL server management studios.
• Oracle Certified Professional (OCP) DBA on implementing Oracle database technologies (12c, 11g, 10g, 9i), RAC, Active Data Guard, MAA Disaster Recovery (DR), Oracle Fusion Middleware, Grid/Could Controls (11g/12c/13c), EBS/Apps r12/11i, Oracle Supercluster, RAC remote clusters (11g/12c), Oracle Access and Identity Management packages, GoldenGate Replication /GGSCI/Studio (11g/12c), Oracle Advanced Securities like Transparent Sensitive Data Encryption (TSDE), Data Redaction, Data Masking, Oracle Database Vault, Auditing Vault and Database Firewall (AVDF) and Key Vault (11g/12c). I
• Leading DBA Consultant for various object data modeling, agile database development and design, EBS/Apps system golden configurations, Init.ora parameters tuning, standard installation checklists and standardized procedures, backup and recovery using Recovery Manager (RMAN) and Flash Recovery Area (FRA), Oracle secure backup, Zero Data Loss Recovery Appliance (ZDR), advanced upgrade and migration tools like ODA, EBS/Apps patching and cloning like Online Patching (ADOP), EBS/Apps Data Appliances like Selective Transparent Data Encryption (STDE), API customizations, CPU & PSU Patching, DR synchronization, Oracle Maintenance Plans, Oracle Support /TAR management, SOX/STIGS auditing, SOA securities and Weblogic servers.
• Over 16 years of solid Oracle architecture and system integration experience on architecting and designing Oracle n-tier OLTP, OLAP, Data Warehouse (DW), data mart, data store, data replication, MAA DR like Active Data Guard, EBS/Apps/SOA/ Dementra systems on Oracle HA systems like RAC (10g/11g/12c), and other non-Oracle systems, 11g/12c Fusion Apps/Middleware/Weblogic integrations including OAM, OBIA, OBIEE, SOA, ODI, as well as all upgrades and migrations from 10g/11g to 12c standalone and multitenant systems, from EBS/Apps 11i to r12 now up to 12.2.x, along with Oracle Access and Identity Management (OAIM) installs and maintenance plans. SELECTED PROJECTS
• Led major implementations and migrations from EBS/Apps 11i to r12, from 10g/11g to 12c (standalone and multitenant), from 10g Fusion Infrastructure to 11g/12c along with OAIM packages and cloud control 12c in both RAC and non-RAC environments for both commercial and government clients.
• Led specific migrations and deploys to deploy Oracle Access and Identify Management Package, 11g Fusion Infrastructure Roll-Up, Weblogic 11g/12c installs, OBIEE from 10g to 11g to 12c, RAC and Data Guard from 10g to 11g/12c and set up DR sites.
• Led upgrades and migrations for major telecom, retail banking and financial clients from EBS/Apps/SOA 11i to R12, Oracle RAC DB from 9i /10g R2/ 11gR2/12c, MAA/RAC/ Data Guard using AIX GPFS/virtualization, Solaris, Oracle Linux and MS SQL Server 2005/2008/2012.
• Led major Oracle HR, Financials, Supply Chain (SC), Manufacturing, Retail, Order Management and others' upgrades, patching, performance tuning for global EBS/Apps/SOA systems, including migration from Apps 11.5.x to 11.5.10/9i to 10g to 11g and 12c using Oracle 10g/11g RAC and active data guard deploys.
• Led EBS/Apps r12 auditing (SOX/STIGS) and security setups using Oracle Advanced Security/Vault (10g/11g) and Oracle data encryption for a Financials & HR membership system - including both tablespace and row level encryptions, and others include:
• N-tier Oracle Apps/Financials set-up using RedHat, RAC, Oracle 10g database and Apps server for a global subscription and catalog system.
• Go-live of a Transactional Analysis and Reporting System (STARS) using
Agile Methodology Auditing Data Warehousing Microsoft Excel Project Management SOX AIX Disaster Recovery Linux RedHat Solaris
Remove Skill
Banking/Financial
Oct 2019 - present
Order, Inventory, Manufacturing and self-service modules. II
• Design and build-up of Defense Medical HR Internet System (DMHRSi) using Oracle Financials, HR and RAC.
• Performance tuning of Defense Medical Financial and Third-Party Billing System (TPOCS) in NT and Win 2K environment.
• Development and production support for a national securities and investment management system using Oracle data warehouse/data marts.
• Architecture and setup of a global Financials and HR management systems using Oracle Apps 11i.
• Production support for large-scale and high-volume OLTP production databases, WebDBs, data warehouses and Oracle Financials system for a leading online retailer.
• Led development of other medium-to-large, mission-critical Oracle 7.x/8.x databases/applications, including online stock trading, IT job banks, inventory tracking and transaction data warehouse for overseas clients. Oracle Database 12c, 11g, 10g, 9i, 8i, 8, 7 Administrator Oracle E-Business Suite | Applications r12 | 11i Administrator
No skills were added
Remove Skill
Managing Oracle DBA
Information Technology
Nov 2007 - present
* As an owner and managing Oracle DBA for iOracle Consulting LLC, I have been partnerships with Big Four including Capgemini, IBM and Oracle, over past 11 years, and managing various high-profile projects using Oracle latest technologies like EBS/Apps/SOA (11i/r12), 10g/11g/12c databases (standalone/multitenant)
• Full DBA consulting capacity and capability for various full-cycle production new install, design, architecture, setup roll-out, configurations, upgrade and migration also ad hoc consultancy for production performance tuning, troubleshooting, proof-of-concept and set up latest Oracle technologies like TimesTen (IMDB), GoldenGate (GGSCI/Studio), 11gR2 Grid Control, Could Control (12c), Fusion Middleware (11g/12c), Weblogic Servers (11g/12c), Apps Big Tablespace conversion, extended Single Sign-On setup, extended AWR analysis and ADDM reporting, ADR, ASM conversion and Oracle storage optimization
• Best practices for major Oracle new databases (11g/12c) and EBS/Apps/SOA technologies. Document major Oracle DBA procedures, including the CPUs, SOX auditing and reports, Oracle backup and recovery, new feature installs, OS/DBA runbooks. Present new Oracle technologies and feature to clients like conversions of 10g/11g databases to 12c CDBs and PDBs III
Database Backups Database Design DBA Oracle Performance Tuning OPTIM
Remove Skill
Managing Principal Consultant, IT Convergence
Information Technology
Nov 2008 - Aug 2009
* Leading in implementing major Oracle Applications including design, system integration, upgrade, migration, and performance optimization from 11.5.x to 12 using Oracle 10g/11g, RAC and MAA
• Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence, ETL, ASM on AIX, Solaris and Linux servers
• Handling severity # 1 TARs and critical patches Troubleshooting and performance tuning Cloning Apps instances and refresh/replicate schema data via Database Control and Grip Control Fine-tune workflow mailing Maintain RAC operations, DR and RMAN-based recovery
• Promoting new features of Oracle Apps 12, Fusion and Oracle 10g/11g Checklist and roadmap the upgrade and migration from Apps 11i to 12 Design and document each Apps-specific build Provide the Apps DBA runbook Transfer knowledge to onsite and offshore data centers
No skills were added
Remove Skill
Lead Senior Consultant
Aug 2009 - Nov 2007
No skills were added
Remove Skill
Lead Oracle DBA Consultant
Information Technology
Feb 2005 - Sep 2005
Nyc, NY
* Manage major Oracle Apps tasks including advanced security setup, site and row-level auditing, performance tuning, system architecture, patching, TAR, backup and restore policies, vendor communications, demos of Oracle new features, migration and upgrade
• Development and production support for 15 productions and 20 QA/testing databases Administration of both OLTP, data warehouse and Apps servers using Oracle replication, home-made refresh, Oracle Financials and 9iAS
• Deploy of RAC on RedHat as mid-tier using Oracle 10g and Apps 11.5.9 Troubleshoot and fix various issues of Apps database and systems using Oracle TAR, MetaLink, Apps OEM and other diagnostics tools IV
• Migration of the core Financials/membership Apps system from 11.5.7 to 11.5.9 Management of user account, apps security, concurrent processing, batch jobs, patching and profiles as System Administrator
• Back up and restore of all production and QA systems using EBU, RMAN, logical and physical standby, and cloning Data access and usage securities and SOX auditing
Data Replication Database Backups DBA OLTP Oracle Performance Tuning System Architecture OEM Oracle Financials
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Telecom
The George Washington University 1994
Foreign Languages and Literatures
Beijing University 1983
Certifications
Oracle Certified Professional OCP DBA on implementing Oracle database technologies (12c
Skills
OPTIM
2022
15
Database Backups
2021
12
Database Design
2021
12
DBA
2021
12
Oracle
2021
12
Performance Tuning
2021
12
AIX
2021
2
Disaster Recovery
2021
2
Linux
2021
2
RedHat
2021
2
Solaris
2021
2
SOX
2021
2
Agile Methodology
2021
1
Auditing
2021
1
Data Marts
0
1
Data Modeling
0
1
Data Replication
2005
1
Data Warehousing
2021
1
Database Upgrades
0
1
HA
0
1
Microsoft Excel
2021
1
MongoDB
0
1
OBIA
0
1
OBIEE
0
1
OEM
2005
1
OLTP
2005
1
Oracle Cloud
0
1
Oracle Financials
2005
1
Oracle Fusion
0
1
Oracle Hr
0
1
Project Management
2021
1
SOA
0
1
SQL
0
1
SQL Server
0
1
System Architecture
2005
1
Systems Integration
0
1