SUMMARY

• Senior Oracle Applications DBA for many different clients. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, fire fighting, developer/integrator relations, script development, documentation and DBA training. Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, ENG, MRP, WIP, BIS, ASCP, DP, FII, me Procurement, iSupplier, and OPM.
• Expertise in installation, maintenance and administration of Oracle Applications R12 (12.1.3, 12.0.4), 11i (11.5.8, 11.5.9, 11.5.10) and 11.0.3 instances
• Expertise in installation, maintenance and administration of Oracle Databases 8i, 9i, 10g and 11g
• Expertise in defining instance strategy for Upgrade and Implementation projects
• Expertise in Oracle Applications (Ebiz) 11i to R12 upgrade. Strategized and carried out upgrades with minimal downtime
• Expertise in Oracle Application 11.5.9 to 11.5.10.2 upgrade
• Expertise in database upgrades 8i/9i to 11g, 10g to 11g
• Expertise in Oracle Gloden Gate setup
• Expertise in platform migration of database and Oracle Applications in different OS platforms
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e - Business Suite 11i and R12
• Expertise in multi-node, shared application top, PCP, SSL & load balancing
• Expertise in Oracle RAC, ASM, Dataguard and RMAN.
• Expertise in Oracle 12c Grid control (OEM- Oracle Enterprise Manager), (AMS) EBS application management suite implementation
• Expertise in Performance tuning
• Expertise in transition planning, management and setting up onsite and offshore production support mode
• Expertise in Oracle Advanced compression
• Expertise in defining Archive and purge strategy for Oracle ERP systems
• Experience in SOA administration
• Experience in OBIEE and WebLogic administration
• Experience in SQL, PL/SQL, UNIX scripting and oracle tools
• 24/7 Production Database Support and maintenance
• Experience in providing training and mentoring DBA’s

TECHNICAL SKILLS

• Linux, HP-UX, SOLARIS, AIX, Windows
• Oracle E-Business Suite R12 (12.1.3, 12.0.4), 11i (11.5.8, 11.5.9, 11.5.10)
• Oracle 12c, 11g, 10g, 9i, 8i, 7.x
• Oracle 12c,11g, 10g & 9i Real Application Clusters on Sun/VERITAS DB/AC
• Oracle Disaster Recovery - 12c, 11g, 10g & 9i DataGuard
• Toad 12.7

PROFESSIONAL EXPERIENCE

Confidential, New Carlton, MD

Environment: Oracle E-Business Suite 11.5.10, 12.2.3, Oracle 10.1.0.2, 11.2.0.3.7, 12c GRID, Linux

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Apps 11.5.10.2 to 12.2.3.
• Installed/Configured SOA 11.1.1.7.0 on Weblogic 10.3.6
• Installed UPK and Knowledge Center.
• Analysis and application of PSU and application patches
• Upgraded Discoverer to 11.1.1.7.
• Upgraded RDBMS from 10.1.0.2 to 11.2.0.3.7.
• Oracle Gloden Gate setup or N-Way replication
• Oracle Apps 11.5.10.2 Install and Production Support
• 12c GRID installation / configuration / upgrade/ maintenance.
• Oracle RAC 11gr2 installation / Configuration

Confidential, San Jose, CA

Environment: Oracle E-Business Suite 11.5.10, 12.1.3, Oracle 10.1.0.2, 11.2.0.3, AIX, Linux OS

Responsibilities

• Responsible for using Oracle 11.2.0.3 in an Oracle E-Business Suite (11.5.10 / 12.1.3) project at teh AIX 6.1 / OEL 5.7 / Linux RH 5 / EMC Symmetrix SRDF platform.
• Responsible for configuring Oracle RMAN backup with Netbackup 7.1.
• Oracle E-Business Suite Upgrade (from 11.5.10 to 12.1.3)
• Oracle database upgrade 9.2.0.8 to 10.2.0.4 to 11.2.0.3.
• Oracle GRID installation / configuration / maintenance.
• Oracle Real Application Custer (RAC) implementation.
• Responsible for supporting several core databases (RAC and non-RAC).
• Lead a team of on-shore and offshore DBAs including staffing and task assignments.
• Supported large-scale enterprise level Oracle Databases (RDMS) in development, staging and production environments and participate in all phases of operations and production support.
• Interacted professionally with cross-functional development and support groups as well as with ITG Project Managers in all stages of teh Software Engineering Life Cycle (SELC).
• Managed a portfolio of database applications and releases in clustered environments to ensure system performance metrics, Operational Level Agreement (OLA) and Service Level Agreement (SLA) are met.
• Established, documented and recommended changes to policies, processes and procedures dat affect database products, including disaster recovery plans.

Confidential

Environment: SAP, ORACLE 10.x, 9.x, Solaris

DBA Architect

Responsibilities:

• Perform root cause analysis of Oracle/Cluster issues and Documenting teh changes
• Responsible for evaluations of software or hardware, and recommend improvements or upgrades.
• Responsible for transition of teh development and/or production environment to latest Oracle database versions.
• Performed database tuning, analysis of AWR, index tuning, in a high transaction volume OLTP environment

Environment: ORACLE 10.g, 9.x, 8.x on Solaris

Oracle DBA Lead

Confidential

Responsibilities:

• Primarily responsible for designing and architecting a huge Oracle Databases for EMEA having an expected growth rate of 500 Gigs/month and getting an optimal response time. Teh higher management continuously monitored teh Performance of this system. Helping teh teams in rolling out new projects and features to our existing ERP systems and analyzing those features through rigorous Volume Performance testing. Responsible for Oracle Database upgrade from 9i to 10g, applying patches. Responsible for RAC environment for Oracle 10g databases
• Expertise in teh use of TOAD/OEM in analyzing database issues and providing an end-to-end analysis of problems and bottlenecks in our huge database environment. Using SAP transactions and Early Watch Reports to tune and enhance performance on a daily basis. Lead our team through KPMG auditing on database security and worked on identifying vulnerabilities in Oracle databases and documented teh risks & controls. Identified Performance problem areas in R/3 (on Oracle 9i RAC) & CRM and fully stabilized teh systems in terms of Availability as well as Response Time.
• Analyzing teh problems with Oracle 8i databases and identifying major performance bottlenecks. Identify and resolve slow running jobs and transactions. Driving teh DBA team to perform regular Database Reorgs on archived tables/indexes to enhance performance