SUMMARY:

• Over14 years in experience in IT industry as an Oracle certified Oracle core DBA and Oracle EBS Application DBA on 11i, R12.1.3, and R12.2.x apps release versions.
• Software installation of Customer Care and Billing (CC&B 2.4.0.2), PeopleSoft FSCM 9.2 and HCM 9.0, plus production support, clone, and dev support.
• Oracle RAC Based DB, HA (High Availability), and DR (Disaster Recovery).
• Installation/upgrade/cross - platform migration of Oracle database and EBS Application software at 9i, 10g, 11gr2, and R 12c
• Software installation of OBIA, OBIEE/Informatics/Data Warehouse, TIBCO based B2B.
• Design, implementation, and maintenance of database solutions for business project/problems, covering full Systems Development Lifecycle (SDLC).
• Oracle DB and EBS apps cloning: both DB and APPS from prod onto non-prod using RMAN for DB backup/duplicate and using Oracle RapidClone for both DB and APPS clone. Able to use CommVault tool for DB and APPS backup/restore/recover.
• Oracle database logical and physical design, data modeling, normalization, capacity planning, access control, production implementation;
• Cross-system integrations among different systems: data flow, interface tables, integration mapping, staging, archiving on both transactional and data warehouse systems.
• Strong Unix scripting/Perl/Python scripting skills: setup scripting programs at OS level for regular DBA related work.
• Strong performance tuning skills on Oracle database and Oracle EBS applications.
• SOX (the Sarbanes-Oxley Act) compliance for publicly-listed company in terms of IT SOX compliance and Internal Auditing requirements, plus change management control.
• Oracle database ST/RDBMS/CPU(Critical Patch Update) patches, Opatch, mini-pack release;
• Evaluate and recommend Oracle EBS apps patches, AD Maintenance pack, product mini-pack, interoperability patches at both 11i ( from 11.0.3 to 11.5.10.2) and R12.2.X: Financial, Manufacturing, and Distribution related modules.
• B2B solution using TIBCO (BC, BW, EMS, and Admin Domain): Architecture (including DMZ based BC domain component design), configuration, business agreements, and implementation.
• SQL Server installation, backup, tuning, production support;
• MySQL server installation, backup, tuning, production support.
• Strong analytical, problem solving, data analysis, communication, and presentation skills;
• Excellent professional working attitudes. Able to learn new technology quickly.
• Work independently as well as a good team player.

PROFESSIONAL EXPERIENCE:

Senior Database Administrator and Applications Administrator Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Oracle EBS R12 DBA and Oracle EBS Applications DBA for both production and non-prod.
• Oracle rdbms CPU patches and EBS R12 apps patches.
• Tuning on EBS CM programs, alerts, integrated systems, reverse proxy servers.
• Adeptia (AvaTax) /RMI service with Oracle EBS R12.
• Hyperion/ODI server for both prod and non-prod.
• Coach junior DBA on both Oracle DB and Oracle EBS apps.
• Help with SOX/JSOX requirements on a regular and on-demand basis.
• Define and document the database standards, procedures, policies, and best practices.
• Oracle EBS ADI end user support on both Citrix as well as end user side;
• Trouble shooting EBS Workflow event and server related issues, plus MailServer;
• Change management and code migration onto production system;
• Maintain coding standards.

Sr. Oracle DBA and Oracle EBS APPS DBA

Confidential, Sunnyvale, CA

Responsibilities:

• Oracle EBS R12 DBA and Oracle EBS Applications DBA for both production and non-prod.
• Support BICS hosted on Oracle Cloud.
• APPS DBA for OBIEE and Agile systems.
• Oracle ERP patch verification and application via adop for R12.2.x;
• Oracle rdbms patch (CPU patches) verification and application;
• Performance tuning on Oracle database and Oracle EBS applications
• Define and document the database standards, procedures, policies, and best practices.
• Oracle EBS ADI end user support on both Citrix as well as end user side;
• Trouble shooting EBS Workflow event and server related issues, plus MailServer;
• Change management and code migration onto production system;
• Maintain coding standards;

Confidential, San Ramon, CA

Sr. Application System Administrator

Responsibilities:

• Installations, configurations, maintenance, administration, and support for CC&B and PeopleSoft FSCM and applications
• Installations of patches and fixes for CC&B and PeopleSoft Architecture for the development, test, and production environments
• Installations, configurations, and maintenance of application servers, process schedulers, web servers, report servers, and file servers
• Migrations of code in all environments
• Configurations, maintenance, and performance tuning of CC&B and PSFS application environment
• Coordination with the IT service group to setup roles, permissions, and general development security
• Coordination with the development team in the review of major new technical areas for performance and database impacts
• Coordination with Infrastructure/Network team to define Window/Network systems requirements
• Performs database administration to define and maintain CC&B and PeopleSoft requirements
• Provides technical and production supports for existing CC&B and PeopleSoft applications
• Troubleshoot development and production application problems across multiple environments and operating platforms
• Assists with debugging and tuning the batch cycle
• Works with technical and development team to resolve performance issues and troubleshoot applications
• Develops work plans and track/report status of assigned projects/tasks
• Assists in the creations and maintenance of system and integration documentation
• Ensures compliance with Sarbanes Oxley (SOX) regulations, audit or other applicable compliance guidelines

Oracle EBS DBA Lead

Confidential, Northfield, IL

Responsibilities:

• Oracle EBS R12 DBA and Oracle EBS Applications DBA for both production and non-prod.
• Responsible for Oracle DBA support on CAP EBS production, testing, and new development Oracle databases, plus cloning prod systems onto non-prod ones via RMAN and RapidClone; DBA related OS level scripting and automation scripting.
• EBS R12.2.4 upgrade to EBS R12.2.6.
• Gateway 11g between EBS and IBM Informix.
• Software installation and maintenance of CC&B (Oracle Utilities Customer Care and Billing) v2.4.0.2: DB, Web Application Server (WAS), Business Application Server (BAS), and Batch Server.
• Oracle ERP patch verification and application via adop for R12.2.x;
• Oracle rdbms patch (CPU patches) verification and application;
• Vertex Sales Tax Rate Update: support on EBS AR module for Sales Q Series;
• Performance tuning on Oracle database and Oracle EBS applications
• Define and document the database standards, procedures, policies, and best practices.
• Oracle EBS ADI end user support on both Citrix as well as end user side;
• Trouble shooting EBS Workflow event and server related issues, plus MailServer;
• Change management and code migration onto production system;
• Database performance trouble-shooting and maintaining coding standards;

Sr. Oracle DBA and Oracle EBS APPS DBA

Confidential, Sunnyvale, CA

Responsibilities:

• Oracle DBA and Oracle EBS Applications DBA for both production and non-prod.
• Responsible for Oracle DBA support on FCS ERP production, testing, and new development Oracle databases, plus cloning prod systems onto non-prod ones via RMAN and RapidClone; DBA related OS level scripting and automation scripting.
• Oracle Data Guard for physical standby, plus GoldenGate for data sync/protection.
• Upgraded EBS from 11.5.10.2 onto R12.2.4; DB from 10gR2 onto R12C.
• Oracle BIS/Data warehouse/Informatica/OBIA installation and maintenance
• APPS DBA to support all the system level services on EBS DB, Report Server, Forms Server, Admin Server, and Web Server powered by Apache;
• Oracle ERP patch verification and application via adpatch for 11i and adop for R12.2.x;
• Oracle rdbms patch verification and application;
• Vertex Sales Tax Rate Update: support on ERP AR module;
• Performance tuning on Oracle database and Oracle EBS applications
• Define and document the database standards, procedures, policies, and best practices.
• Oracle ERP ADI end user support on both Citrix as well as end user side;
• Trouble shooting EBS Workflow event and server related issues, plus MailServer;
• Change management and code migration onto production system;
• Database performance trouble-shooting and maintaining coding standards;
• Successfully helped EBS team in terms of functional level locking issues and fixed the issue on Customer Service related Workflow Event subscription.

Senior Oracle DBA and Oracle ERP APPS DBA

Confidential, Sunnyvale, CA

Responsibilities:

• 11.0.3, 11.5.5, 11.5.7, 11.5.9, and 11.5.10.2: DB and APPS on software installation, configuration, maintenance, and production support.
• DB upgrade from 8i to 10gR2; changed from RBO to CBO and troubleshooting;
• DBA and apps DBA for EBS installation, TEST, CRP, UAT, and production implementation.
• Deep knowledge about Oracle patches and release internals: maintenance pack, mini family pack, apps patches, ST/RDBMS patches, Opatch.
• SOX (the Sarbanes-Oxley Act) compliance: maintaining the company’s conflicting responsibility matrix for public auditing as well as internal auditing. Quality SOX related auditing check works as required by SOX requirements.
• Coding Standards for EBS system customization.
• FND user security policy setup and monitoring; ERP CM job purge, monitoring, health checking; FND user management;
• Functional knowledge on GL, Order to Cash (OTC) flow customization and AUTO INVOICE. TCA implementation, including party and customer setups and relationship setup;
• Strong skills on all the involved modules for Order to Cash flow: OM, Shipping, Pricing, Scheduling, Service Contract, AR, Cash Management, plus related workflow programs. Able to support Order to Cash flow at functional level.
• SQL Server installation, backup, tuning, production support;
• MySQL server installation, backup, tuning, production support.
• Maintaining TAR against Oracle Support and trouble-shooting any issues with ERP DB and application modules, like FND, AD, ALR, CE, ONT, QP, BOM, PER, PAY, WSM, GL, Pricing, AP, AR, PO, FA, WIP, Pricing, Costing, OSFM, and etc). Able to help ERP application trouble-shooting at the module level in terms of functionality and tech stack.
• Deep knowledge on Oracle ARU system and verification on any suggested patches recommended by Oracle Support.
• Designed and implemented B2B solution for SST by using TIBCO solution:

Principle System Engineer

Confidential, Redwood Shores, CA

Responsibilities:

• Database administration responsibilities on about 50 Oracle application environments for unit test, stage, system integration test, and customer demo purpose;
• Release manager’s role to create ARU and release the Projects Family at 11.5.10 level;
• ERP (EBS) apps tiers (file system hosted on NetApps; Oracle WebServer powered by Apache; Reports, Forms, CM, Admin, Discoverer server, WF Notification Mailer) migration from Solaris platform onto Linux platform at 11i level;
• ERP (EBS) apps tiers migration from AIX to Linux platform at 11i level;
• DB upgrade from 9.2.03 to 9.2.0.5 on both Solaris and Linux;
• DB upgrade from 8.1.7.4 to 9.2.0.5 on both Solaris and Linux;
• Upgrade ERP (E-Business Suite) applications from 11.5.5/11.5.7 to 11.5.9 UAT and production support with 9iAS 1.0.2.2.2 portal.
• In-depth knowledge and experience on Rapid Clone between source and target envs;
• Enabled non-RapidClone 11.5.7 env onto RapidClone enabled env, still using to different middle tiers hosted on different physical servers to gain the better performance;
• Expertise level knowledge on Application DBA utilities, like adpatch, and etc.
• Developed shell scripts and automizing the route DBA work, like backup, recovery, env monitoring, and etc.
• Trouble-shooting at all development levels to support new production development;
• Setup statspack and getting snapshot reports for dev teams for performance tuning purpose; tkprof, and etc.
• Storage management and monitoring for all the environments for the group;
• Certified new product release on 11.5.5, 11.5.7, 115.8, and 11.5.9 level;
• Daily applications DBA work over about 50 environments.