Description
Summary: * Over 11 years of experience in IT industry as an Oracle Core DBA and Oracle Applications DBA in support and implementation projects. * Proficient in Oracle 9i/10g/11g Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN). * Proficient in Administration and installation of Oracle Applications ERP systems 11.5.10.2 & R12 in single node and multi nodes on Linux/Unix environments. * Experience in 10g, 11g RAC implementation and support. * Upgradation of EBS from 11.5.10.2 to 12.2.4 * Experience in Upgrade of database from 10.2.0.5 to 12c. * Experience in Conversion of Single node instance to 2 Node RAC. * Much familiar with 12.2 new feature of on-line patching (ADOP) and various options to reduce the downtime * Managing user's information like creation of users and managing their roles, tablespace allocation, profiles and privileges. * Strong experience in writing SQL Queries. * Experience in database reorganization, migration, capacity planning and high-availability * Experience in Workflow Administration, Configuration and troubleshooting of workflow issues. * Experience in XML Publisher administration and configuration and troubleshooting of xml report errors. * Experience in Exadata machine * Strong knowledge of administration processes and controls to meet security and compliance audit requirements for SOX. * Installation and Configuration of APEX with Embedded PL/SQL Gateway/Oracle Application Server and Oracle WebLogic. * Have experience on the installation, administration and maintenance of Oracle Fusion Middleware 12c and 11g products (WebLogic, SOA, OSB etc.) in a clustered environment. * Experience in working with AWS for the internal HR application. * Have Experience in Oracle GoldenGate . * Cloned Oracle applications R12, 11i and Databases. * Applied product specific fix patches, family packs and maintenance packs. * Supported 24/7 on-call in Production & Development environment. - Environment: Oracle 11.2.0.3/12c, Oracle Apps 11.5.10.2, 12.2.4 Description: 800 Flowers is a leading floral and gourmet foods gift retailer and distribution company in the United States. It was one of the first retailers to use a 24 x 7 toll-free telephone number and the Internet for direct sales to consumers. Responsibilities: * Providing support for Critical Oracle EBS Application and Databases which has various modules like Financial (AR AP GL) SCM (Order Management iSupplier) and HR. * Re-assigned concurrent requests to various custom concurrent managers for avoiding bottlenecks and to improve the performance of overall batch processing. Oracle Database Upgrade Cloning Patching and Troubleshooting. * Provided support for the Oracle database with size of 3 TB. * Migrate Forms / Reports from Development to PROD using FNDLOAD utility.
Accomplishments
Highlights:
Keywords
