Download PDF

Summary

Seeking a long-term career in ERP and Database Administration or Data Analysis leading position; where there is healthy and ambitious working environment. 

Work History

King Khalid Eye Specialist Hospital (KKESH)

Apr 2022Present

Senior Database Administrator

Description:

Administering KKESH's Oracle ERP (EBS), Oracle Databases, MS SQL Server Databases, and InterSystems IRIS. 

Projects:

  • Changing the infrastructure design of all the available databases from single node to high availability.
    • MS SQL Server: by applying failover cluster.
    • Oracle Databases: to be hosted in RAC environment. 
  • Upgrading the oracle databases to a supported release (19c). 

Technical Experience (Related to ERP and Database Administration):

  • Enhancing the performance of EBS from both levels (Application and Database). 
  • Administering the technical part of HRMS, GL, Procurement, and iRecruitment modules. 
  • Solving the issues of the EBS Concurrent Manager. 
  • Apply the quarterly released security patches (Application and Database security patches).
  • Solving the issues that are reported by the users (Technical Level).
  • Using python and Jopyter Notebook to generate a daily health check report.

Tawuniya Insurance Company

Apr 2021Feb 2022

Senior ERP Administrator

Description:

Administering the oracle ERP's application and database, solve the available issues, provide improvements to the application and the working environment. 

Projects Done:

  • Migrating EBS RAC databases from one server to another using dataguard.

Technical Experience (Related to ERP and Database Administration):

  • Enhance the user login experience by solving the login attempts bug. 
  • Moving from using the unsupported browser (Internet Explorer) to the use the modern browsers (Chromium browsers like Edge and Chrome) by enabling Java Web Start in the ERP. 
  • Fix the SMTP configuration issue in the ERP that is related to sending application notifications to the users through the email.
  • Enhancing the application's performance by tunning the queries running in the background.
  • Applying the Tawuniya's password policy to both the application and the database by modifying the profiles' options and create PL/SQL script for the database and Java class for the application. 
  •  Administering the oracle application 12.2.8 and its database 12.1.0.2 in Exadata machine Cloud at Customer engineered system. 
  • Patching the database through the Exadata special tools.
  • Patching the application using adop tool using both, normal patching cycle (Prepare, Apply, Finalize, Cutover, and Cleanup) and the hot patching mode. 
  • Using Python libraries and tools such as Jupyter notebook to analyze and visualize the technical data and provide some clean reports to the management.

Nontechnical Experience:

  • Writing a document to set the rules and the regulations of using and administering the oracle ERP in many different levels:
    • Security
    • Production data usage
    • The administration
    • The development cycle using best practice 
  • Writing Technical Documentations.

ERP and Application Server Administrator

Description:

Administering Oracle EBS (E-business Suite) in addition to its database. Furthermore, improving EBS from many different prospective. 

On going Projects:

  • Upgrading the databases from 11.2.0.4 to 19c (19.6.0) for EBS 12.1.3.
  • Applying RPC5 patches in EBS 12.1.3. 

Technical Experience (Related to ERP and Database Administration):

  • Migrating EBS's databases from HP-UX to Redhat Linux and Oracle Sun Solaris.
  • Enhancing some of the old implementations by following the best practices. 
  • Applying security and recommended patches in both the application and the database.
  • Installing oracle EM agent to monitor production databases.
  • Preparing scripts to switch between PROD and DR applications and Databases.
  • Converting EBS's databases from noneCDB to one CDB with one PDB. 
  • Supporting two GLs, one HR with self service, and one Inventory & order purchasing. 
  • Supporting some of the functional and techno-functional issues. 

Nontechnical Experience:

  • Wrote a report to the management that's providing the current status of the EBS application and the databases from the technical point of view, in addition to suggesting some solutions to eliminate the existing weaknesses and prevent the future obstacles.

ERP and Database Administrator

Description:

Administering Oracle Database and Application (E-Business Suite) by monitoring the performance, solving issues, securing database and application, backup and cloning database and application.

Technical Experience (Related to ERP and Database Administration):

  • Migrating EBS Database (12c) from AIX to Exadata using Data pump.
  • Supporting three GLs, one HR with self service, and one fix assist. 
  • Migrating Databases from big endian platform (AIX) to little endian platform (Linux) using Data pump (Export/Import).
  • Upgrading EBS database from 10g R2, 11g R1, and 11g R2 to 12c.
  • Fresh installation of Oracle database 12c on Linux Red Hat 5.11. 
  • Upgrading database from 10g R2 and 11g R1 to 11g R2.
  • Upgrading EBS from 12.1.1 to 12.1.3.
  • Supporting DB (11.1.0g & 11.2.0g) and EBS (R12.1.1 & R12.1.3).
  • Cloning from single node or multi-node server to single node.
  • Enabling SSL in the application level.
  • Securing servers by changing the default passwords of the default users’ names in both levels (Database and EBS).  
  • Backup and Restore database using RMAN tool.
  • Investigating errors and issues in the database and applications levels.
  • Applying application,  and security patches (Opatches).
  • Enabling and using advanced monitoring tool (Oracle Enterprise Manager).
  • Administering and using Oracle Cloud Control 12c on Linux Red Hat 5.11.
  • Creating some scripts and PL/SQL codes for generating on request summaries and sending them via email to the administrators. These summaries contains some of the important information like the disk free space, tablespaces free space, failed backups, and the details about the failed backup.
  • Creating PL/SQL codes to monitor users and privileges and track the changes on these privileges during the time.
  • Scripting DBA tools menu contains killing sessions, extending tablespace, starting up and shutting down the Database and the Application in one shot, creating new datafiles, ... etc.
  • Masking columns of data using FGA policy.
  • Essentials like starting and shutting down the applications and database, creating users, assigning roles and privileges, implementing functions and procedures storing and fetching data.
  • Writing procedures and documenting errors and solutions.

Technical Experience (Not related to ERP and Database Administration):

  • Commanding and scripting using IBM UNIX.
  • Commanding and scripting using Windows Command shell (CMD).

Final Project

I've been the leader of three team members of redesigning and migrating database from Access to Oracle. The database was owned by a department in Thompson Rivers University. The project was to redesign the database, Normalize it, cleaning the original data to meet the data format of Oracle using VBA scripts, and load it into Oracle Database.

Education

Udacity

Oct 2020Dec 2020

NanoDegree (Introduction to Machine Learning)

Online Course. It contained three projects in Supervised, Unsupervised, and Deep learning. 

Udacity

May 2020Jun 2020

NanoDegree (Data Analysis)

Online Course, 40 Credit Hours , Actual time: Start On May 2020 and Ends on Sep 2020. Sponsored by Misk Academy.

Bachelor Degree (Computing Science)

Thompson Rivers University - Kamloops, British Columbia (BC), Canada

Associate Degree (Computer Applications)

Dammam Community College - Branch of King Fahad University of Petroleum & Minerals, Dammam, Saudi Arabia.

Skills

Python

Using Pandas, NumPy, Matplotlib, Seaborn, and some other libraries used for general coding and Data Analysis

Java
JavaScript
HTML
HTML5
PHP
Visual Basic

Courses

Dec 2014 - Dubai, UAE

  • R12.2 Oracle Application System Administrator Fundamentals Ed1

Jan 2016 - Riyadh, KSA

  • Exadata Database Machine Administration Workshop Ed 3 PRV

May 2017 - Dubai, UAE

  • R12.x Install/Patch/Maintain Oracle E-Business Suite

May 2020 - Jun 2020 - Online Course

  • Data Analysis Track, by 1 Million Arab Coders Initiative

2-9 Jun 2020 - Online Course

  • Future Path Career Essentials Program

Jun 2020 - Jul 2020 - Online Course

  • Future Path Career Preparation Program

Projects

Self-learning project

Arabic Hand Writing Recognition

The project is about recognizing the Arabic alphabets hand writing. The model was built using Google's Tensorflow library. 

Self-learning project

Image Classification Project

This project was created to classify images. The machine should differentiate between 4 classes [humans, birds, fruits, and cars]. The model was built using Google's Tensorflow library. 

Data Science Course - Final Project

Guessing Income Project

The project was about building a machine learning model that can guess based on individuals provided information if their income is <=50K or >50 a year. The models were built using sklearn python library. 

Interests

  • Improving my computer skills & capability.
  • Learning new & interesting issues related to computer.
  • Knowing information about new technologies in the market and putting my hands on some; in addition to watching some press conferences of the important companies like
  • Attending technology expos and conferences.

Volunteering

I work as a volunteer in Al Dokhala Festival. I've started in 2006 (Dokhala 2). In 2007 (Dokhala 3), I was a team leader of three members that have the responsible of the following:

  • Collecting information about the volunteers.
  • Printing volunteers’ cards and certificates.
  • Managing gifts and rewards.

However, since 2013, I’ve started to work with Administrative support team. The mission of this team is to be the link between the management and the leaders of the committees of the festival.

References

Available upon request