ORACLE DATABASE CONSULTANT
Banque Saudi Fransi
Total years of experience :13 years, 11 Months
Migrated and Upgraded numerous mission critical OLTP databases from Exadata x-7 to Exadata-X8-m and on OCI with minimum downtime. Setup and Configured Zerodata loss and other backup solutions to offload production databases and implemented Flashback Technology.
Implemented Tuning for finical databases to enhance performance and eliminate any financial loss. Implemented security measures like Transparent Database Encryption (TDE). And Data Masking Solution.
Setup Oracle Goldengate(Solution) for core banking and data warehousing databases.Carrying out High Availability solutions(dataguard).
Exadata-8m patching includes Database sever, Yum, Grid home, Oracle home, Cell node, Rocky switches.
Monitoring and supporting day to day activities of the production and development databases and work on urgent issues when fired and resolving database issue related to wait-events, dealing with ideal sessions and long running requests and handling daily Database Deployments for
business needs.
Functioned as Team lead, responsible for assigning tasks and managing team members. Data modelling, conceptual database design. Administeredin complete system development life cycle SDLC in building large high
availability and high performance databases including architecture, designing partitioning, database sizing.Managed 3-node Oracle 19c RAC on
Oracle Cluster ware platforms.
Carried out database performance solutions.Provided assistance to the other members of development team with application tuning and identifying inefficient SQL statements written by the developers using
Explain Plan, SQL trace and TKPROF and assisted the team in using Optimizer hints in the SQL statements to enhance performance.
Implemented database backup and recovery solutions RMAN, Data Pump, Point in time recovery.
An effective communicator with honed people management, relationship
management, coordination, leadership and Inter-personal skills.
AL-RAJHI FOOD GROUP (JUNE’ 10 - JAN’ 11)
Role: Programmer ORACLE Database Administrator - FOODCC Project.
Significant Highlights:
◖ Support role in consolidating all database services running on different platforms (Linux & Solaris) with
different Oracle versions (10g, 11g).
◖ Rendered end-to-end support in:
● Standardising backup policy to use hot RMAN Backup across all Oracle installations.
● Installing and configuring Oracle Clustering to use it for administration along with
applications on multi node.
● Creating a number of database instances for development, testing and production.
◖ Administered Oracle data guard and monitored application and database backup.
◖ Provided “Level 1” technical assistance for the management and maintenance of e-business / production
servers and running oracle databases, through remote access and virtual private networking.
Projects Overview:
◖ Installation and Implementation of Oracle Database.
◖ Troubleshooting and Tuning the Databases.
◖ Backup Database using RMAN Backup.
MASTER OF ENGINEERING (COMPUTER SCIENCE)
BACHELOR OF ENGINEERING (COMPUTER SCIENCE)