Oracle Apps DBA
Infosource Systems
مجموع سنوات الخبرة :22 years, 6 أشهر
EBS Implementation & Post Implementation Support - 12.1.1
Oracle Application DBA Al-Babtain Contracting Company
• Responsible for Installation of Oracle Applications in Single node in IBM AIX.
• Upgraded Oracle Applications R12.1.1 to R12.1.3
• Upgraded Database from 11.1.0.7 to 11.2.0.4
• Providing technical support to application development team.
• Cloning Oracle Application for development and testing using Rapid Clone.
• Patching Oracle Application and Database.
EBS Upgradation - 12.1.1 to 12.1.3
Oracle Application DBA National Factory for Glass Bottles (Zoujaj).
• Upgraded Oracle Applications R12.1.1 to R12.1.3
• Upgraded Database from 11.1.0.7 to 11.2.0.4
OBIEE Implementation - 11.1.1.7.0
Oracle OBIEE DBA ACE Insurance and Reinsurance.
• Responsible for Installation and configuration of OBIEE 11g and ODI 11g.
• Very strong experience in developing OBIEE Repository (.rpd).
• Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges)
• Designing DWH schemas as per requirements and configuring ETL in ODI
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports
EBS Implementation & Support - 12.1.1
Oracle Application DBA at National Containers Terminal (NCT).
• Responsible for Installation of Oracle Applications in multi node.
• Responsible for Installation and configuration of OBIEE 11g.
• Upgrading the application to latest release set.
• Troubleshoots and diagnose the report problems.
• Cloning Oracle Application for development and testing using Rapid Clone.
• Managing Oracle Applications using AD Utilities.
• Patching Oracle Application and Database.
EBS Implementation & Support - 12.1.1
Oracle Application DBA at Saudi Railways (SAR).
• Responsible for Installation of Oracle Applications in Single node and Multi Node Environment.
• Upgrading the application to latest release set.
• Cloning Oracle Application for development and testing using Rapid Clone.
• Managing Oracle Applications using AD Utilities.
• Patching Oracle Application and Database.
• Space management, adding datafiles and resizing datafiles.
• Configuring Backup Policies using RMAN and OS level backup.
EBS Implementation & Support - 12.1.1
Oracle Application DBA at Musairiey Metallic Industries
• Install and maintain Oracle Applications in single node.
• Applying latest release of the patches to the instance to resolve few application issues.
• Troubleshoot Oracle Application performance issues.
• Securing Application in terms of creating and managing Application Users, assigning Responsibilities, setting up Profiles and excluding functions.
• Providing technical support to Application development team.
• Responsible for configuring Backup Policies using RMAN and Acronis.
• Restoring and setting up test environments for development team.
• Involved in Regular Database Monitoring and maintenance issues.
• Developed shell scripts to automate the database backups.
EBS Implementation & Support - 12.1.1
Oracle Application DBA at ZAIN Telecommunication
• Responsible for Oracle Alerts and AME (Approval Management Engine).
• Configured email notification for users in Application.
• Performed cloning activities to build development and test environments.
• Patching Oracle Application and Databases.
• Registration of Forms, Reports, Concurrent Programs.
• Responsible for Troubleshoot the Oracle Applications issues and performance problems.
• Securing Applications in terms of creating and managing Applications Users, assigning Responsibilities, setting up Profiles and excluding functions.
• Providing technical support to application development team.
• Monitoring the database growth on daily basis, modification of databases, and addition of tablespaces, datafiles and modification of tablespaces, datafiles.
• Establish and maintain healthy backup & recovery strategy and procedures. Performing
Hot Backup.
• Database Tuning and performance monitoring.
• Implement and maintain database security.
• Checking Alert logs daily for Oracle Errors.
• Performing logical backup using export/import utility and loading data from external file through SQL *Loader.
• Database planning, logical and physical design of the database as per the application requirements.
• Troubleshooting internal errors with Oracle Support.
• I was involved in Installation, Configuration of the Oracle Server, Creating tablespaces, segments and solving the Backup and Recovery issues.
• Monitoring the database growth on daily basis, modification of databases
• Establish and maintain healthy backup & recovery strategy and procedures.
• Performing logical backup using export/import utility and loading data from external file through SQL *Loader.
• Designing VB forms to ensure user-friendly interface and convenience of usage.
• Creating classes, DLLs for the projects to optimize system performance.
• Actively involved in stored procedures writing.
• Creating complex reports using Crystal Report.