SUMMARY

• 100 hands-on Oracle DBA and manager with various Oracle projects accomplished over last
• 13 years, using Oracle database 11g, 10g, 9i, 8i, E-Business Suite EBS and Applications 12,
• 11i, Real Application Cluster RAC , Fusion Middleware on Solaris, HP, AIX, Linux/RedHat,
• Oracle Enterprise Linux OEL , NT/Win 2K/XP, MS SQL Server 2005/2008 and Windows
• 2003/2008 R2 platforms Using Oracle Business Accelerators OBA , Applications
• Implementation Methodology AIM , Maximum Availability Architecture MAA and Service
• Oriented Architecture SOA
• Efficient manager for full-cycle Oracle project implementation 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 installs, and handling of problems at all
• levels of project teaming, OS, network, database and applications
• Sharp problem fixer and powerful performance tuner from end-user/client, network, mid-tiers,
• application tiers up to database backend, hosting servers to SQL statements, using Oracle
• performance tuning technologies like ADDM, AWR, ADR, SQL Tuning Advisor STA , SQL
• Access Advisor SAA , Statspack Report, Grid Control advisor center, and non-Oracle tools
• Oracle certified expert on implementing Oracle database 11g, 10g, 9i and 8i , RAC, Data
• Guard, MAA Disaster Recovery DR , Oracle Fusion Middleware, Grid Control, EBS/Apps 12
• 11i, TimesTen In-Memory database, Oracle Portal, Oracle Internet Directory OID , Beehive
• /Collaboration suite, Golden Gate replication, EBS/Apps Identity Management like Single
• Sign-On SSO , Oracle Secure Backup, EBS/Apps Shared Apps Top, and more new features
• Lead DBA role for object data modeling, database design, EBS/Apps system configurations,
• init parameters tuning, install checklist and standard procedure, backup and recovery using
• Recovery Manager RMAN , Flash Recovery Area FRA , Oracle secure backup, Oracle DB
• Vault, advanced upgrade and migration tools, EBS/Apps patching and cloning, EBS/Apps data
• Security like Transparent Data Encryption TDE , API customizations, Critical Patch Updates
• CPU , DR synchronization, Oracle Support/TAR management, SOX auditing, and more
• Over 13 years of solid Oracle architecture experience in successfully managing and consulting
• for various Oracle projects on various architectures, including n-tier OLTP, OLAP, data
• warehouse DW , data mart, data store, data replication, MAA DR design like active Data
• Guard, EBS/Apps/SOA system under RAC and non-RAC environments, stand-alone Oracle
• Apps server infrastructure, central Grid Control vs. Database Control, and cross-platform
• Design, architecture, data conversion, customization, backup, recovery, cloning and patching

SELECTED PROJECTS

• Lead new implementations to deploy Oracle EBS/Apps/Fusion/11gR2 RAC on Linux and Windows 2008 R2 systems from testing, QA to production go-live with pharmaceutical and healthcare clients Daiichi Sankyo, AT T, US Army, CDI, DoD -
• Lead upgrade, migration and optimization of US government learning and training
• system from Oracle RAC 10gR2 to 11gR2 under Solaris and Container 10 environment
• US Navy, DoD -
• Led upgrades and migrations for major telecom, retail and financial clients from
• EBS/Apps/SOA 11i to R12, Oracle RAC DB from 9i to 10g R2 to 11gR2, MAA/RAC/
• Data Guard using AIX GPFS/virtualization, Solaris, Oracle Linux and MS SQL Server
• 2005/2008 Capgemini Confidential , Loblaw, Gateway, Bayview Financial -
• Led major HR, Financials, SC, Manufacturing 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 using Oracle 10gR2 RAC and data guard AICPA, ALC, Kinexus -
• Led EBS/Apps 12 auditing and security set-up using Oracle Advanced Security/Vault
• and Oracle data encryption for a Financials HR membership system including row
• and table level encryptions, and others include: StarComm, DSL, Subaru US, IEEE,
• Priceline.com, Sabre, Platinum IT, IT Convergence -
• 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
• 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 11g, 10g, 9i, 9, 8, 7 Administrator
• Oracle E-Business Suite Applications 12 11i Administrator

PROFESSIONAL EXPERIENCE

Managing Oracle DBA, iOracle Confidential

• As an owner and managing Oracle DBA for iOracle Consulting LLC, I have been partnerships with Big Four over past 5 years, and managing high-profile projects using Oracle latest EBS/Apps/SOA and database technologies
• Full DBA consulting capacity and capability for 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 , Golden Gate GGSCI , 11gR2 Grid Control, Fusion Middleware 11g, Weblogic 11g, 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 database and EBS/Apps/SOA technologies. Document major Oracle DBA procedures, including the CPUs, SOX auditing and reports, Oracle backup and recovery, new feature installs, DBA runbook. Present new Oracle technologies and feature to clients

Lead Senior Consultant, Confidential

• 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

Managing Principal Consultant Confidential

• Lead in applying major Apps installs, upgrade and migrations including recent upgrade from 11.5.x to 11.5.10 using Oracle 10g and RAC Manage patching such as HR K and Financials G, as well as various critical security patches and the year-begin/end Payroll patches
• 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
• Handled severity 1 TARs Performance tuning Cloned Apps instances and refresh/replicate schema data Set up self-service Apps like iExpense and iProcurement Fine-tune workflow mails Maintain RAC operations
• Introduce new features of Oracle Apps 12, Fusion and Oracle 10g Roadmap the upgrade and migration from Apps 11i to 12 Provide pre-sale and post-sale supports with onsite demo/presentation

Lead Oracle DBA Consultant, Confidential

• 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
• 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 auditing
• Lead Oracle DBA Consultant, Confidential Support all pro-go-live testing and go-live Apps administration of Subaru Transactional Analysis and Reporting System STARS using Oracle Financials, Order, Inventory and Manufacturing and other self-service modules
• Set up the standards and best practices for both DBA and development projects Apply patches, automate the DB and system monitoring and reporting
• Trouble-shoot and fixed problems of OEM, workflow, ADI, portal, discoverer, concurrent/batch processing with Oracle Support Set up logical standby and Data Guard Customize Apps interfaces with functional team
• Frequently clone the QA/testing databases from production/gold copy Tune end-user, Apps, database and OS performance Implement Fine Grained Auditing FGA and database auditing using Log Miner

Lead Oracle DBA Consultant, Confidential

• Install, configure and administrate the Defense Medical HR Internet System DMHRSi using Oracle Parallel Server OPS and Real Applications Cluster RAC on Sun cluster server
• Provide a full range of database and applications supports to the Defense Medical Financial and Third-Party Billing System TPOCS using Oracle Financials
• Troubleshoot and fix various issues of Apps database and systems using tools like StatsPack and Apps OEM
• Back up, refresh, recover and restore the systems through home-made cold and hot backups, RMAN, Veritas NetBackup and cloning Set up the standards and best practices for database administration and code implementation
• Upgrade and migrate the systems from Oracle 8.1.7/Apps 11.5.5 to Oracle 9.2.3/Apps 11.5.8 in RAC environment Manage TARs and apply patches
• Architect new Sun-cluster-based DMHRSi and Windows-based systems Manage the helpdesk support for both projects and train users