Senior ORacle DBA and Cloud Competency Lead
IBM - Egypt
Total years of experience :13 years, 7 Months
As a Cloud competency lead support for Oracle solutions, provide advanced technical support to enterprise DBA team on Oracle database related technologies such as Golden Gate, Streams, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, compression, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, optimize server resource utilization etc.
I’m also responsible for upgrade, migration, patching, troubleshooting, clustering of Oracle fusion applications as forms and reports, Oracle BI, Oracle enterprise manager cloud control, Oracle ERP R12.2 etc.
Projects:
• Egyptian National Post office (ENPO)
• Petroleum Development of OMAN (PDO)
• IBM APP-OPS (Cloud Migration and implementation factory)
• Vodafone Egypt
• Customizing output for request as HTML, XML, PDF and Text for Arabic language and numbers (HINDI)
• Editing Autoconfig File for changing Configuration of the ERP Application
• Resetting passwords and managing Users
• Backup and restore of the application by scripts scheduled under linux (crontab) and compressing backup for space usage
• Troubleshooting and providing support 24/7
2. Application Server
• Installation of Oracle application server and weblogic software
• Troubleshooting custom datasource and java modules applied under application servers
• Troubleshooting OC4J instances
• Managing application files under Linux
• Increasing Java heap size and number of allowed users and changing idle time
• Changing Datasource passwords and application password
• Editing OPMN.xml file for application Configuration
• Checking all Application components (Apache, Oc4j, Custom application…etc) Logs for errors and solving it
• Oracle 10g and 11g Administration
• Upgrade of 9i, 10g, 11.1 to 11.2
• Installing oracle software under Linux & windows
• Applying patches via Opatch
• Applying dataguard between primary database and multiple standby databases
• Creating snapshot databases for Read/Write standby DBs
• Managing switch over between databases and failovers in case of production failure
• Adding a standby database to an already created dataguard structure
• Managing Rman backups and creating scheduled scripts for backup on daily basis
• Point in time recovery for customer requests and business causes
• Oracle Replication
• Performance tuning
• Database Audit
• Database Duplicate
• Managing datafiles and controlfiles by rman and sql utilities
APPS Job Duties:
• Installation of various Oracle APPS.
• Patching.
• Maintenance.
• Troubleshooting.
• Cloning and upgrading oracle applications.
• Put backup policies and procedures.
• Plus Oracle Database Administrator Job Duties.
Database Job Duties:
• Installation of various oracle products.
• Upgrade and migration the database.
• Data guard and cloning high availability solutions.
• Troubleshooting and problem solving.
• Database design.
• Put backup policies.
• Database tuning.
• Oracle RAC installation and knowledge.
• Oracle RAC Troubleshooting.
• Installing Application Server.