Oracle DBA Manager (apps&core),infrastructure
Royal Group
مجموع سنوات الخبرة :18 years, 5 أشهر
Nov 2013 to Present
Company
Key Responsibilities
Oracle Database Administrator Manager (Oracle E business apps & core database), application server and system administrator (Solaris and Linux), project manager for migration & upgrade ERP from 12.1.1 to 12.2.7
Royal group - Abu Dhabi
• Supported 10 production instances stand alone and RAC database Installed, Setup, Configured Oracle version from 9i to 12c on Solaris, Linux, Hp-UX and windows
• Upgradation and Migration of Database from 10g to 11g and 12c also applying patches whenever required
• Maintaining Complex database environments(+20 database)
• Applying upgrade patches, maintenance and interim patches on all the database
• Manage and configure backup solution to our environment
• Configure workflow and troubleshooting the issues
• Experience in Working with RAC Database and troubleshooting RAC environment
• Developing and Implementing Disaster Recovery (DR) Plan using DataGaurd
• Daily Health Check Up of the Database using AWR, ADDM & ASH
• Automation of Startup Shutdown on all Production and Development Database
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Installation and configuration oracle cluster with ASM 11g&12C
• Upgrade application from 12.1.1 to 12.1.3
• Upgrade database for ERP from 11.1.7 to 12.1.0.2
• Upgrade application from 12.1.1 to 12.2.7
• Restore backup from veritas backup and clone test environment
• Prepare Unix shell scripts to handle Unix/Oracle related tasks.
• Day to day support, capacity planning and performance tuning the bank databases.
• Manage and administer Concurrent Manager
• Plans, schedules and tracks project timelines, milestones and deliverables using appropriate tools.
• Estimates the resources and participants needed to achieve project goals.
Environment:
Linux, HP -UX, Solaris, Windows, Oracle 9i, 10g, 11g &12c, RAC, ASM Enterprise Manager and application server
Oracle Applications R12.1, R12.3 &12.2.7:
• Applying Patches ( Database & Application )
• Create and Follow up Service Requests with Oracle Support for Technical Support
• Working with the Development Team to fix the problems in Applications
• Monitoring Health Check of servers by background process and by using OAM
• Maintaining Application Security and Database Security
• Managing Users, Responsibilities and Profile options
• Plan for backup, recovery; backup and restore the database.
• Responsible for RAC Production Database Servers.
• Upgrade application from 12.1.1 to 12.1.3
• Upgrade application from 12.1.1 to 12.2.7
• Upgrade database for ERP from 11.1.7 to 12.1.0.2
• Upgrade and install oracle cluster 12 c
as oracle dba and application server admin on many application
Senior Oracle DBA and system administrator (Linux /Unix and Windows)
Ideal soft
Dubai (RTA & Dubai Police projects at Dubai )
NCEMA at Abu Dhabi-UAE manage database 7 month as outsource
ADJD, MOF
• Responsible for the installation, upgrades, and maintenance of all phases of an Oracle Database and Application Servers on UNIX based and Windows based client/server environment System Administration support to the enterprise with high availability systems for the Development, QA and QC Teams. Improved and administered the existing Oracle databases and applications.
• Installation, configuration and manage application server 10g R2 and 10g R3.
• Installation, configuration and manage application server WebLogic
• Implemented WebLogic servers, Reports servers.
• Maintain regular production database clone sites/streaming and RMAN backup.
• Monitors the database system to ensure secure services with minimum down time.
• Oracle DBA consultant for applications (INTERNET, MERSAL, Lost &Found and EPS application).
• Data Pump and troubleshooting daily problems on applications.
• Oracle DB consultant for 3 applications ERP, GIS and MERSAL application
• Installation and configuration oracle cluster 10g
• Installation and configuration oracle ASM 10g and cluster 11g
• Installation and configuration oracle 11g r2 for GIS application
• Daily DBA tasks like backup and recovery by RMAN and Data pump and make strategy for backup and recovery
• Install application server for MERSAL application and configuration
• Installation and configuration DR site and use VERITAS program for NCEMA applications
• Linux administrator.
• Oracle Data Guard installation and configuration
• Sql server administrator
Nov 2013 to Present
Company
Key Responsibilities
Oracle Database Administrator Manager (Oracle E business apps & core database), application server and system administrator (Solaris and Linux), project manager for upgrade application and database to 12.2.6
Royal group - Abu Dhabi
• Supported 10 production instances stand alone and RAC database Installed, Setup, Configured Oracle version from 9i to 12c on Solaris, Linux, Hp-UX and windows
• Upgradation and Migration of Database from 10g to 11g also applying patches whenever required
• Maintaining Complex database environments(+20 database)
• Applying upgrade patches, maintenance and interim patches on all the database
• Configure workflow and troubleshooting the issues
• Experience in Working with RAC Database and troubleshooting RAC environment
• Developing and Implementing Disaster Recovery (DR) Plan using DataGaurd
• Daily Health Check Up of the Database using AWR, ADDM & ASH
• Automation of Startup Shutdown on all Production and Development Database
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Installation and configuration oracle cluster with ASM 11g&12C
• Upgrade application from 12.1.1 to 12.1.3
• Upgrade database for ERP from 11.1.7 to 12.1.0.2
• Prepare Unix shell scripts to handle Unix/Oracle related tasks.
• Day to day support, capacity planning and performance tuning the bank databases.
• Manage and administer Concurrent Manager
Environment:
Linux, HP -UX, Solaris, Windows, Oracle 9i, 10g, 11g &12c, RAC, ASM Enterprise Manager and application server
Oracle Applications R12.1&R12.3:
• Applying Patches ( Database & Application )
• Create and Follow up Service Requests with Oracle Support for Technical Support
• Working with the Development Team to fix the problems in Applications
• Monitoring Health Check of servers by background process and by using OAM
• Maintaining Application Security and Database Security
• Managing Users, Responsibilities and Profile options
• Plan for backup, recovery; backup and restore the database.
• Responsible for RAC Production Database Servers.
• Upgrade application from 12.1.1 to 12.1.3
• Upgrade database for ERP from 11.1.7 to 12.1.0.2
• Key Projects:
o Royal group EBS 12.1&12.1.3
o Database 11g &12g
o Sea Palace EBS 12.1
o Bunya EBS 12.1.3
o IGG EBS 12.1.3
o Cromwell Hospital (Healthcare ERP)
From Jan 2010-Dec 2010 working for TransIT Company
http://www.transit.com.eg
Performing database& development consultation tasks for different application
ERP application and ticketing application
Key Projects:
-ERP SAP administration
SAP installation and administration
-Oracle application forms & report
Manage oracle database 11g (backup & recovery)
Manage oracle application server
http://www.egabi.com
Performing database& development consultation tasks for different egabi’s customers Consultation work involves all database administration and Oracle E-Business installation, setup, upgrade and configuration tasks
Key Projects:
Egabi
• Apps DBA
•Installation and patches &cloning
Etisalat (UAE)
• Health check
• Database performance & tuning for CBCM application
Forms & report and database
Vodafone (Egypt)
• Database performance & tuning and archiving application
Damac properties(Egypt)
• Xml Publisher and development report on oracle E business suite
Banisoif University (Egypt)
Conducting Oracle Professional training on DB Administrator
Mobinil(Egypt)
Conducting Oracle Professional training (SQL, pl/sql, workshop1&2)
Emak International Academy
Attending 11i Install and Patch in Oct 2008.
From December 2005 -to June2008 working for Kadi Arabia Company http:www.kadiarabia.com
Working as Oracle Database Administrator & developer in a full time job
During his employment I am also responsible about the system
Kadi ERP Installation& technical support of the integrated Kadi
ERP package serving the company clients
My responsibilities were including and not limited to the following:
1- Oracle Database Administration tasks(backup& recovery)and all DBA tasks
2- Business background about ERP (GL- HR-DIS…..)
3- Clone database
4- Performance and tuning to database
5- Data transform
1- from sql server to oracle and connect from sql plus to sqlserver (make oracle forms read from sql server)
2- access to oracle
3- excel to oracle
6- Installing and customizing Kadi ERP
7- Oracle application 10g release 2 server install and configuration
8- Use Real IP to connect to application server from anywhere by internet
9- Windows server 2003 administrator
10- Oracle Application server administrator
11- Technically manage the IT tasks(Network Administrator)
good
good and excellent on project