A Data professional with * years of industry experience with extensive skills in Databases Systems, Unix/Linux and Business intelligence platforms.
Just finished “Jan-2018” a 1-year post-graduate program focusing on the areas of Data Analytics and Machine learning with hands-on implementation of Big Data Applications on Hadoop Ecosystem.
-Oracle Database 9i/11g/12c. - Microsoft SQL Server 2012,2014,2016
-Informatica PowerCenter v. 9.0.1 (ETL) - Hadoop, Hive, Spark
-Oracle Business Intelligence (OBIEE) 220.127.116.11 - SAP BusinessObjects XI 3.1
-IBM AIX 5.3, 6.1, 7.1 (Unix). - RedHat Linux 6, 7
-Oracle Sun Solaris 11.1 - Oracle E-Business Suite 12.0.3
-Oracle Weblogic Server 11g. - IBM WebSphere Application Server 7.1
-Veritas NetBackup on EMC Data Domain. - Dell Shareplex for Data Replication.
-SQL, PL/SQL. - Java -Scala - Python 3. - Shell Scripting.
Oracle DBA (Part-time), Canadian Graphics West Inc, Mississauga, ON Canada (06/2017 – Present)
-Administrate Oracle Database on Oracle Enterprise Linux and on Microsoft Windows Server
-Administrate Oracle VM Server for X86 (XenServer) using Oracle VM Manager.
-Administrate Oracle Application Server on Microsoft Windows.
-Customize existing Oracle Forms and Reports depending on the Business requirements.
-Converting Physical Servers to Hyper-V virtual machines (P2V) to virtualize the environment.
-Implement Oracle Data-Guard for remote database replication.
Teaching Assistant (Part-time), Queen's College of Business & Technology, ON Canada (09/2017–12/2017)
-Preparing labs and Classrooms for Data Analytics and Big Data Courses.
-Grading the students’ assignments/exams and write reports for the College to review.
-Assisting the students with setting-up their own Sandbox Virtual Machine for Data Analytics.
-Guiding students in proper data collection, writing lab reports, and generating statistics.
-Courses being delivered:
Big Data Fundamentals Application Design for Big Data
Big Data Tools Data Encoding Principles
Database Administrator, IT Operations, Banque Du Caire, Cairo, Egypt. (06/2014 – 04/2017)
-Administrate mission-critical database systems such as Oracle FLEXCUBE Core-Banking System, Oracle E-Business Suite and Oasis IST ATM Switch.
-Administrate the Data Warehouse for the Financial Reporting System (FRS).
-Administrate Oracle Business Intelligence Platform (OBIEE) and SAP BusinessObjects (BOBJ).
-Administrate Microsoft SQL Server Databases located at each branch.
-Administrate/Track ETL scheduled Workflows using Informatica PowerCenter for Oracle Financial Services Analytical Applications (OFSAA).
-Implement Data replication across sites and platforms using Dell Shareplex.
-Clone any required production database or server for development or testing purposes.
-Ensure proper database backup/recovery policies and procedures are in place.
-Enforce strict database security policies by controlling user’s privileges and access methods.
-Implement Fine Grain Auditing polices for confidential data & high-level customers’ accounts.
-Optimize query performance and re-write queries if necessary.
-Administrate Oracle Data-Guard for disaster recovery and Oracle RAC for High Availability.
-Write PLSQL procedures to automate databases’ maintenance tasks.
-Write scripts to purge historical data into archive databases.
-Maintaining the disaster recovery plan with detailed switchover and failover scenarios.
Participating in Big Data PoCs and pilot projects with IBM (BigInsights) and EMC (Pivotal).
Upgrading Oracle Database from 9i to 12c for the Core-Banking Database and creating a roll-out plan to upgrade the 200 databases in the branches with minimal downtime.
1 Year Post-Graduate Certificate (Big Data Applied Science), 2018, Lambton College, ON, CA.
B.Sc. in Computer Science, 2013, Loughborough University, UK.
Hortonworks Certified Associate (HCA)
Oracle Database 11g Administrator Certified Professional
IBM Certified Associate AIX 7 System Administrator
ITIL Foundation Certificate in IT Service Management
EMC Academic Associate, Cloud Infrastructure & Services
Big Data Specialist Training
Data Science and Big Data Analytics
Oracle Database: Program with PL/SQL
Oracle Database 11g: Administration Workshop I Release 2
Oracle Database 11g: Administration Workshop II Release 2
Power Systems for AIX II: AIX Implementation and Administration
Cloud Infrastructure and Services Version 2
Business Continuity Management & IT Disaster Recovery
Egyptian Banking Institute
Received a Certificate of Appreciation handed by Banque Du Caire's Chairman Mr. Mounir ElZahid for outstanding performance during 2016.