Resume

Sign in

Oracle Data

Location:
Mississauga, Ontario, Canada
Posted:
March 09, 2018

Contact this candidate

Resume:

Profile

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.

Technical Skills

Administration Skills:

-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) 11.1.1.6 - 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.

Programming Skills:

-SQL, PL/SQL. - Java -Scala - Python 3. - Shell Scripting.

Professional Experience

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.

-Projects:

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.

Education

1 Year Post-Graduate Certificate (Big Data Applied Science), 2018, Lambton College, ON, CA.

B.Sc. in Computer Science, 2013, Loughborough University, UK.

Certifications:

Certificate Name

Certificate by

Date Issued

1

Hortonworks Certified Associate (HCA)

Hortonworks

9/2017

2

Oracle Database 11g Administrator Certified Professional

Oracle

12/2014

3

IBM Certified Associate AIX 7 System Administrator

IBM

5/2015

4

ITIL Foundation Certificate in IT Service Management

AXELOS

8/2015

5

EMC Academic Associate, Cloud Infrastructure & Services

EMC

3/2016

Training Courses:

Course Name

Delivered by

1

Big Data Specialist Training

IBM

2

Data Science and Big Data Analytics

EMC

3

Oracle Database: Program with PL/SQL

Oracle

4

Oracle Database 11g: Administration Workshop I Release 2

Oracle

5

Oracle Database 11g: Administration Workshop II Release 2

Oracle

6

Power Systems for AIX II: AIX Implementation and Administration

IBM

7

Cloud Infrastructure and Services Version 2

EMC

8

Business Continuity Management & IT Disaster Recovery

Egyptian Banking Institute

Achievements:

Received a Certificate of Appreciation handed by Banque Du Caire's Chairman Mr. Mounir ElZahid for outstanding performance during 2016.



Contact this candidate