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 1211i, Real Application Cluster (RAC), Fusion Middleware on Solaris, HP, AIX, Linux/RedHatOracle 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 biddingPre-sale presentation and hiring, Oracle architecture and design, project budgeting and planning, project tracking, team workload allocation, team coaching, appraisal and timesheetvendor 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-tiersapplication 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 configurationsinit 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

PROFESSIONAL EXPERIENCE

Managing Oracle DBA

Confidential

Responsibilities:

• As an owner and managing Oracle DBA for Confidential 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

Responsibilities:

• 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, CA

Responsibilities:

• 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