Manager - Oracle Cloud Solution Architect / Oracle EBS Apps DBA / Oracle DBA
Etisalat, UAE
مجموع سنوات الخبرة :19 years, 2 أشهر
Installation, Configuration, Maintenance and upgrading Oracle R12 E- Business Suite and Database
Regular Application and Database Server clone from production servers
Oracle E-Business suite Application and database clone using Rapidclone(adpreclone.pl&adcfgclone.pl)
DMZ Configuration of iSupplier and iRecruitment in Oracle E-Business suite
Lift and Shift Oracle EBS Suite using Oracle Cloud Manager tool
Provisioning Oracle Cloud infrastructure (Virtual Network, Load Balancer, Storage, Database, Firewall Security Rules, VM Compute instance etc.)
Cloud adoption plans, cloud application design, and cloud management and monitoring.
Application architecture and deployment in cloud environments
Creating compartment to organize jobs responsibility and control access to the Oracle Cloud Infrastructure (OCI) Resources (Compute, Storage, Network, Load Balancer etc.)
Managing and ensuring database availability 24x7
Tuning and Troubleshooting of VLDB used for Oracle ERP/Telecom Billing/CRM Applications
Database health checkup, ensuring safety, confidentiality and integrity of data
Protecting the database from failures
Performs regular physical, RMAN backups and ensure the backup process are fool proof
Diagnose and resolves performance problems
Detect and resolve latch and lock contention problems, Identify and resolve I/O, storage and database configuration problems
Database objects access security management
Performs capacity planning activities \[space utilization and growth monitoring\]
Shell / Perl / Terraform / Chef / JSON / SQL / Command scripting for auto management processes.
Data extraction and transformation activities
Perform data archiving activities
Prepare technical documentation of Etisalat databases
Interfaces with Oracle Support and other vendors for database related issues
Ensures 24 hours database Tier 2 support for the users.
Ensures compliance with RDBMS vendor license agreement
Applying the latest patches to Oracle Database, Oracle EBS suite and SAP systems
Do the server clone from production to test environment
Give access to the development team to deploy customization on the test and production server after finalize the testing phase.
Do the technical steps to configure oracle components
Managing Oracle RAC Database, Instances and ASM Instances
Maintain Site log for the production system
Follow up with Oracle Support for technical issues SRs
Respond to all SRs in the technical part
Do the regular backup for the production and test environment.
Do the regular tuning for database
Oracle Database SAP Bundle patch update using MOPATCH utility
SAP Database Maintenance using BR Tools
SAP Router Configuration and OSS administration
SAP User and RFC administration
SAP Transport Administration
SAP HANA 2.0 DB installation and SAP S4HANA Application installation
Trace any problem and errors which are related to database or application servers
Installation, Configuration, Maintenance and upgrading Oracle R12 E- Business Suite and Database
Applying the oracle application and database patch sets, Setup and configure Data Guard.
Establish and maintain sound backup and recovery policies and procedure
Perform general technical trouble shooting and give consultation to development team
Design, Setup and implement Oracle Application Server in multi servers environment
Allocating storage space and planning for future storage requirements
Patch management and version control
Interface with Oracle Corporation for technical support
Troubleshooting and regular checking of alert log file.
Application and database cloning using Rapid clone (adpreclone.pl and adcfgclone.pl)
Setup and configure Oracle Workflow Notification Mailer (outbound and inbound notification mailer).
Creating and managing Responsibility, menus, users, value sets, alerts, descriptive flex field and performing other system administrator responsibilities.
Registering Printer, custom application, tuning of concurrent programs
Performance monitoring and optimizations of database and application.
Troubleshooting in Web/forms, Installing NLS/MLS and setup MWA/MSCA in Oracle Apps
Administrating oracle HTTP server and SSL Configuration
SSL environment setup and Configure Apache for SSL Connections using AutoConfig
Monitoring & managing the tablespaces and data files growth
Maintaining data integrity also managing users, profiles, resources and password security.
Maintenance and managing oracle database, instances and application servers using Oracle Enterprise Manager
Installation, configuring and upgrading Oracle Enterprise Manager 10g Grid Control
Installation, configuring and upgrading Oracle Application Management Pack(AMP)
Install Oracle Application Express(APEX) and Configure Oracle HTTP Server with mod_plsql distributed with Oracle Application Server 10g
Data Masking and Scrabbling the sensitive data from the cloned instance using AMP and custom scripts.
Installation, upgrading and maintaining BI Web Discoverer server, Discoverer Administrator, Discoverer Plus and Discover Viewer.
Creating and maintaining EUL and Business areas.
Performing backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.
Performing periodical Backup and Restoration using RMAN (full & incremental).
Create, configure and utilize Recovery manager catalog (RC).
Performing Export & Import operations using EXP/IMP, SQL Loader.
Mass Loading of Data using Oracles Apps API and Custom Scripts
Deployment of custom forms and Reports to Oracle Apps, Support to developers for developing Reports using XML Publisher, Report Builder and Discoverer.
Evaluate Oracle features and Oracle related products
Installation, upgrading and maintaining the Oracle Database and its applications.
Plan growth and changes (Capacity Planning)
Creating and maintaining Oracle Database, instance and its objects.
Performing Export & Import operations using EXP/IMP, SQL Loader.
Perform database cloning and re-location activities.
Setup and configure Oracle Data Guard.
Applying the Oracle Database patch set.
Managing tablespaces, data files, redo logs, tables and segments.
Create, configure and utilize Recovery manager catalog (RC).
Monitoring and eliminating Row chaining and Row migration issues.
Maintaining data integrity also managing profiles, resources and password security.
Monitoring locks and various sessions using OEM and views.
Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
Performing backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.
Performing periodical Backup and Restoration and recovery using RMAN (full & incremental).
Providing support to developers for the smooth functioning of the Database.
Development of several shell scripts used for both hot and cold backups.
Controlling and monitoring user access to the database.
Managing Users, Privileges and Roles.
Enhanced the performance of the database by providing advanced performance tuning and coding standards.
78.68 %
Bachelor of Science (Physics)