Oracle Engineer

MOHAMED AZZAB

Oracle Database Expert Oracle Technical Consultant

: +1-646-***-**** : adig6b@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/mohamed-azzab/ PROFILE

A Database Expert with a rich experience of 15+ years in managing and administrating Oracle Database and Oracle Applications with a proven track record of successfully leading complex projects while managing resources in enterprise technology solutions. Over the years have managed and implemented several projects within the domains of installation, upgrade to the latest release, migrate across different platforms and provide high level of support standards. My focus has been always to keep my customer’s environments up-to-date with the latest technology to ensure business efficiency, stability and continuity.

AREAS OF EXPERTISE

Oracle E-Business Suite Oracle Database Oracle EXADATA Oracle Cloud control 13C Oracle Rman Oracle Enterprise Manager OEM Oracle Datapump . Solution Design Software Installation and Maintenance Database Backup and Recovery Application and Database Installation and Configuration Upgrade to the latest technology

Migration across different platforms Migration from Single Instance to Real Application Cluster Environments

Patching & Cloning and Test Environments Oracle Audit Vault Hardware Restructuring and Utilization Storage and Sizing Computing Platform and Virtualization Disaster Recovery Post go-live support and System Administration KEY COMPETENCIES

Identify and introduce industry trends in database systems to address business needs and advice upper management.

Identify measures or indicators of system performance and design & execute actions needed to improve efficiency.

Work with developers to resolve issues related to database and application performance.

Develop methods for integrating different products so they work properly together to fit specific business needs.

Identify and tune poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF.

Develop UNIX Shell scripts and SQL scripts to perform the daily Database & OS monitoring, server validation and health checks.

Excellent verbal and written communication skills, to present ideas and solutions in a clear and precise manner.

CAREER HISTORY

Ministry of Municipality and Environment http://www.mme.gov.qa (Doha, Qatar) Senior Oracle Database Administrator Jul 2010 – 1 sept 2020

• Install Oracle 10gR2 Real Application Cluster running on different operating systems, migration from single node to RAC using export and import utility, Implement backup and recovery strategy using RMAN utility, Upgrade Oracle Database to latest patch set available, Configure and manage Oracle Active Data Guard,

• Perform system administration, database sizing, file system maintenance, system monitoring and security.

• Administered Oracle clusterware and resources on 11g and 12c using CRSCTL/SRVCTL.

• Manage table spaces, adding and resizing data files, manage and maintain system storage.

• Monitor DB Performance using STATPACK, TKPROF, SQLTrace, and Explain Plan.

• RMAN backup and recovery

• Write SQL*Loader control files for uploading legacy data to interface tables.

• Deal with Oracle Support, creating SRs and provide consultation to business teams and maintain knowledge base.

• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.

• Administration of Component Passwords (DB Server, Storage Server, ILOM, InfiniBand switches, Power distribution units etc.)

• Monitoring Cell desk, grid disk, Cell Flash cache, Flash disks

• Starting & Stopping Exadata Cell Server Software

• Using commands cellcli dcli

• Database Migration from HP-UX RAC to Exadata system X4-2.

• Manage Oracle Database RAC 11gR2 on Exadata system X4-2 with DR Site on ODA.

• Using Oracle Cloud control 13c to Monitor Database and Exadata.

• Assist developers with coding PL/SQL.

• Using Oracle Datapump for logical Backups .

• Oracle database performance tuning SQL monitoring – Execution plans – SQL Profiles .

• Work with the team to implement power BI on Azure Cloud and mange privileges on SQL Server on Azure Cloud .

• AD-Hoc Query SAP Reporting Tool.

• Supporting SAP HR/Payroll End Users.

• Team member in project to move Exadata Rac to another Datacenter.

• Implementing Database Security (Oracle Audit Vault, Data encryption, Data Reduction, security triggers ) - password policy

• Microsoft SQL Server

• Perform SQL administrative tasks including installing and upgrading SQL server products 2008 R2 creating maintenance plans, and creating database objects

• Install, configure, and deploy MS SQL Server. Perform capacity planning, monitoring, troubleshooting and optimization of the databases

• Prepares users by conducting training; providing information; resolving problems

• Designing and running system load/stress testing; escalating application problems to vendors

• Standardize and manage Database Administrator procedures for monitoring .

• Maintenance and support of SQL server Mirroring.

• Data Migration from MS SQL Server to Oracle Database . Ministry of Finance https://www.mof.gov.ae (Abu Dhabi, UAE) Oracle Applications DBA Nov 2008 – Apr 2010

• Manage Oracle Application 11.5.10.2 running on multi-application nodes with PCP and 2 RAC nodes on HP-UX OS.

• Perform Oracle Application SYSADMIN tasks including creating application users, assign responsibilities, setup printers, manage concurrent managers and application services

• Execute Clone from production to test environment and Apply database and application patches.

• RMAN backup and recovery

• Monitor and optimizing the performance of the application and database.

• Oracle Real Application Cluster and ASM.

• Oracle Database installation 10gR2 with patch set 4 on HP-UX and configure it for BI project.

• Review the backup and recovery plan, monitor daily backup and maintaining archived data on tape.

• Migrate custom code from test to production to solved real-time problems.

• Provide support to functional team to using TOAD and ADI etc.

• Work as part of a team and provide 24*7 support when required. Mannai Corporation https://mannai.com/ (Doha, Qatar) Oracle Applications DBA Mar 2008 – Nov 2008

• Install, configure Oracle E-Business Suite 11i and R12 running on Windows, Linux, AIX, HP-UX and Sun Solaris.

• Administrate Oracle E-Business Suite and its Oracle Database running of different platforms this include, manage users and responsibilities, concurrent managers, setup printers, performance monitoring and tuning, application and database patching, allocate system storage and ASM administration, RAC administration, manage backup and recovery using RMAN, manage and, create database objects and cloning.

• Provide 24 x 7 support for production environments and maintain standard technical documentation Oracle Corporation USA Egypt Branch http://www.oracle.com (Smart Village, Egypt) Support Engineer Apr 2007 – Mar 2008

• Manage and resolve Customer Requests and Issues according to product main strategy within KPIs targets.

• Ensure the timely completion of planned proactive tasks and Customer Requests.

• Resolving problems and managing customer expectations throughout the life cycle in accordance with global standards.

• Working towards, adopting and contributing to new processes and tools (diagnostics, health checks, scripting tools, etc.)

• Maintain an up-to-date and in-depth knowledge of new products Alpha Center (Alexandria, Egypt)

Oracle Instructor Oct 2006 – Apr 2007

• Provided training courses for SQL, PL / SQL, Oracle Certified Associate and Oracle Certified Professional Tracks

• Using Oracle OEM form monitoring Database

• Using Oracle Datapump expdp - impdp for backup and recovery plus Rman .

• Supervised and supported the students during the hands on labs activities. New Horizons https://alexandria.newhorizons.com/ (Alexandria, Egypt) Oracle Instructor Apr 2006 – Aug 2006

• Provided training courses for SQL, PL / SQL, Oracle Certified Associate and Oracle Certified Professional Tracks

• Supervised and supported the students during the hands on labs activities. Globsoft (Smart Village, Egypt)

Oracle Database Administrator Jan 2005 – Mar 2006

• Install, configure and administrate Oracle Database 9i, 10g running on Windows and Linux.

• Perform database backup and recovery, performance tuning, patching, cloning, upgrade and migration ACADEMIC QUALIFICATIONS

• Bachelor of Science in Education, Technology Department - Faculty of Specific Education, Tanta University, Egypt PROFESSIONAL CERTIFICATIONS

• Oracle Cloud Infrastructure Foundations 2020 Certified Associate .

• Oracle Database 12c Administrator Certified Professional

• ITIL® Foundation Certificate in IT Service Management

• Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator

• Oracle Database 11g Administrator Certified Professional

• Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

• Oracle Database 10g Hands-On Certified

• Oracle Forms Certified Professional

• Oracle PL/SQL Developer Certified Associate

• Oracle Database 10g Administrator Certified Professional

• Oracle Database 10g Administrator Certified Associate

• Oracle9i: SQL Certified

• Network+ Certified Professional

PROFESSIONAL COURSEWORK

• Oracle Cloud Infrastructure Foundations 2020 USA Sept 2020

• Oracle Database 12c R2: Managing Multitenant Architecture Ed2 Oracle University QATAR Oct 2019

• Oracle GoldenGate 12c:Fundamentals for Oracle Ed PRV QATAR Sept 2019

• Oracle Database Appliance Release 12.1 Overview PRV Oracle University Singapore Mar 2019

• Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Ed 3 PRV OU QATAR Nov 2018

• Oracle Database 12c: New Features for Administrators Ed 1 Part 1 PRV OU QATAR Nov 2018

• Oracle Database 12c: New Features for Administrators Ed 1 Part 2 PRV OU QATAR Dec 2018

• Oracle Solaris 11 System Administration Ed 5 PRV Oracle University QATAR Feb 2018

• Oracle Database 12c: RAC Administration Ed PRV Oracle University QATAR Feb 2018

• Oracle Database 12c: Performance Management and Tuning-PRV Oracle University QATAR Feb 2018

• EXADATA Database Machine Administration Workshop Ed 3- Oracle University UK Apr 2016

• Oracle Database 12c: Administration Workshop Ed 2- Oracle University Netherlands Dec 2015

• Oracle Linux7: System Administration Ed1 - Oracle University UK Nov 2015

• Apps DBA 11i,12R, RAC 10g Data Guard - ORATOR CENTER INDIA Sept 2009

• Basic Business Skills Acquisition Program (BBSA) AMIDEAST & SYNERGY EGYPT Jul 2006

• Cisco CCNA Preparation, IBM EGYPT Jul 2005

• Developing Soft Skills - London College of Management EGYPT Feb 2006

• Network technology N+ IBM EGYPT May 2005

• Oracle Database Administration Track, Oracle with MCIT (Full Day Training) EGYPT Apr 2002 REFERENCES

References are available upon request

Contact this candidate