Ali Altalag
Senior Oracle ERP and Database Administrator at Tawuniya- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Arabic Native or bilingual proficiency
-
English Full professional proficiency
Topline Score
Bio
Credentials
-
SDAIA T5 Data Science (Online) Bootcamp
SDAIA | سداياJan, 2022- Sep, 2024 -
AI for Business
UdacityApr, 2021- Sep, 2024 -
Introduction to Machine Learning with TensorFlow
UdacityNov, 2020- Sep, 2024 -
Future Path Career Preparation Program
Misk AcademyJul, 2020- Sep, 2024 -
Connect - Data Analyst
UdacityJun, 2020- Sep, 2024 -
Future Path Career Essentials Program
Misk AcademyJun, 2020- Sep, 2024
Experience
-
Tawuniya
-
Saudi Arabia
-
Insurance
-
700 & Above Employee
-
Senior Oracle ERP and Database Administrator
-
Apr 2021 - Present
Description: Administrating 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. Administrating 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 administrating the oracle ERP in many different levels: Security Production data usage The administration The development cycle using best practice Writing Technical Documentations. Data Analysis Experience: I linked Jupyter Notebook to the Oracle ERP Database to extract some technical information to analyze to provide over all database health information to the management with visualization. Show less
-
-
-
Arab National Bank
-
Banking
-
700 & Above Employee
-
ERP and Application server admin
-
Feb 2018 - Apr 2021
Description: Administrating Oracle EBS (E-business Suite) in addition to its database. Furthermore, improving EBS from many dierent prospectives. 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. Convering databases from nonCDB to 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. Show less
-
-
-
Banque Saudi Fransi
-
Banking
-
700 & Above Employee
-
Oracle DB and EBS Administrator
-
Dec 2013 - Jan 2018
Administrating Oracle Database and Application (E-Business Suite). Technical Experience (Related to ERP and Database Administration): •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). •Administrating 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). Show less
-
-
Education
-
2008 - 2013
Thompson Rivers University
Bachelor degree, Computer Science -
2020 - 2020
Udacity
NanoDegree Program, Data Analysis -
2020 - 2020
Udacity
NanoDegree, Machine Learning -
2004 - 2007
Dammam Community College
Associate's degree, Computer Applications
Community
