Hyperion DBA
Al Rajhi Bank
مجموع سنوات الخبرة :18 years, 3 أشهر
Installation of Oracle Hyperion version 11.1.2.4
•Creating Database schemas for Essbase, FDMEE, Planning and Reporting applications
•Configuration of Hyperion application
•Integration of Hyperion with LDAP (MSAD)
•Migration of artifacts from UAT to PROD servers using LCM
•Creating automated backup scripts for Essbase and LCM
Solution Competencies
•Multi-Node Implementations of EBS 11i, R12.1.x, R12.2.x
•Upgrade of EBS 11i to R12.1.x
•Production Support for EBS 11i and R12.1.x
•Implementation of Disaster Recovery Solution for Oracle EBS Database using Data Guard
•Implementation of Backup Solutions for Oracle EBS and Database
•Migration of Oracle EBS 11i from non-RAC to RAC database
•Performance Tuning of Oracle EBS & Database
•Cloning & Patching of Oracle EBS & Database
•Troubleshooting issues related to Apache, Forms, and Concurrent Managers etc.
•Installation of Fusion Applications
•Installation of Oracle Hyperion 11.1.2.4 (Planning, FDMEE, Essbase)
•Migration of Hyperion from AIX to Oracle Exalytics server
•Installation of OBIEE 11.1.7.x
•Installation of OBIA 7.9.6.4
•Technical retrofit of CEMLI’s as part of EBS R12.1.x upgrade
Companies worked for:
Oracle Financial Services:
Installation of repository creation utility and creation of MDS & BIPLATFORM metadata schemas
•Installation of OBIEE version 11.1.7.0
•Minor upgrade to OBIEE version 11.1.7.1
•Preparing Installation documentation
•Integration of OBIEE with LDAP (MSAD
EBS R12.2 implementation for Metrobank
(Phillipines)
•Installation of Oracle EBS 12.2.4
•Cloning of different environments - DEV & UAT
•Regular maintenance of all the Oracle EBS environments
•Patching and Cloning
EBS R12 Pre-Upgrade and Upgrade for BlackRock Inc. (USA, UK & Asia)
•Lead the pre-upgrade technical activities to clean-up and prep the EBS 11i environment for the R12 upgrade
•Performed Retrofit of CEMLI objects in AP and PO modules as part of the R12 upgrade
Installation of Oracle EBS 12.1.3
•Upgrade of Oracle EBS database to 11.2.0.4
•Installation and configuration of OBIA Financial Analytics 7.9.6.4
•Cloning of different environments like CRP, DEV, SIT & UAT
•Regular maintenance of all the Oracle EBS environments
•Patching and Cloning
EBS R12 Production Support for Reserve Bank of Malawi (Africa)
•Tracking various technical & functional issues and change requests reported by client and ensuring their timely resolution/delivery
•Status reporting to the client on a bi-monthly basis
•Communicating with client for any important issues/concerns
•Performing regular DBA maintenance activities of the existing EBS 12.1.3
•Patching and Cloning assistance to client DBA
Lead Apps DBA + Technical
Supporting the R12 Production and 3 Test instances for a major Retail chain in India
•Upgrading the Oracle EBS R12 from 12.0.4 to 12.0.6 version
•Cloning & Patching
•Managing Oracle Workflow Notifications
•Designing new backup policies and fine tuning existing policies
•Developing Automation scripts for automated health checks, automated backups and automated database archive purging
•Regular performance analysis of the system and subsequent performance tuning
•Taking timely and proactive decisions with respect to server sizing and Database tuning to ensure optimal usage of system resources, and efficient working of Oracle Applications
•Developed shell script for automatic archive space management on Database server
•Client-facing role with daily interaction and reporting to the General Manager of IT
EBS 11i migration to multi-node with RAC for Damac Properties. (Dubai, UAE)
•Designed and built a new Oracle 10gR2 RAC based architecture for an existing Oracle Applications setup
•Migrating existing 11.5.10 Applications and database onto the new ASM based 10g RAC database
•Configuring Parallel Concurrent Processing(PCP)
•Putting in place a new backup policy
Oracle 9i RAC & platform migration for Vela Marines (Dubai, U.A.E)
•Designing strategy and migrating 32-bit 9iRAC to 64-bit servers for one of world’s largest shipping organization
•Implementing the IT security policies at database and OS level
•Implementing a Oracle 9i DataGuard Physical Standby database as a disaster recovery solution
Apps
EBS database OATM upgrades for COCC (USA)
•Designing a strategy to migrate the objects from the old tablespace architecture to Oracle Application Tablespace Management (OATM) architecture
• Developing Shell scripts for performing the OATM conversion
Production support for various versions and architectures of Oracle EBS for over 50+ clients (USA)
•Performing on-demand patching and cloning of various EBS client instances
•Assisting the Sr. DBA’s in Production Upgrades
•Communicating with client over email’s and phone relating to issues
in