Ahmed Alshareefi
Email: aczfrw@r.postjobfree.com
Education
B.Sc. In Computer Science
**** – 2009
Oracle Certifications
Oracle RAC 11g R2 Administrator Certified Expert
OCE
Managing Oracle 10g under Linux Certified Expert
OCE
Oracle 12c Administrator Certified Professional
OCP
Oracle 11g Administrator Certified Professional
OCP
Oracle 10g Administrator Certified Professional
OCP
Oracle 11g Administrator Certified Associate
OCA
Oracle 10g Administrator Certified Associate
OCA
Oracle Solaris Administrator Certified Associate
OCA
Skills & Qualifications
Oracle Performance Tuning and business continuity products/tools Implementation Experience:
-Experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
-Conduct regular database health check and provide tuning recommendations and future memory requirements to the Management team
-Oracle High Availability / Business Continuity Solutions product support
-Implement Zero-Downtime Operations that eliminates downtime for planned outages involving Oracle Database upgrades, migrations using oracle data guard and other technologies.
-Expertise in Oracle Database Security including Oracle Transparent Data Encryption and Oracle Key Vault
Oracle Real Application Clusters Experience (RAC) including:
-Oracle Cluster ware, Grid Infrastructure product installation on (Red hat, Solaris, AIX platforms).
-S/W Patching, DB Migration, Upgrade, Troubleshooting skills
-Managing ASM volumes and create the ASM cluster file system(ACFS)
Oracle Data Guard skills :
-Oracle Active Data guard installation, configuration and support on large diverse of OS flavors
-Data Guard S/W Patching, DB Migration, Upgrade, Troubleshooting skills
-Using Data Guard technology to minimize the planned databases outages during the upgrades and migration operations.
Oracle 10g,11g,12c Database expertise with the focus on:
-S/W Installation, Patching, DB Migration, Upgrade, Troubleshooting
-Database Configuration Analysis & Planning on Linux, Solaris and AIX
-Managing Oracle Database 11g on Exadata
-Oracle RMAN
-Oracle Flashback technology
Managing Databases backup activities using the following technologies:
-Oracle Recovery Manager
-Data Domain (DD) technology
-NetBackup
-Oracle Flashback
Oracle Enterprise Manager Grid Control 11g,12c
large diversity of expertise covering platforms such as AIX, Solaris, RHEL and Windows Good Understanding of different flavors of LINUX & UNIX including:
-Install and Configure red hat Linux, Oracle Linux and Oracle Solaris
-Managing users, file system and system and resources utilization
-Create and provision LUNs, Disks using FDISK, UDEV utilities
-Integrate third party tool to support oracle databases on Linux boxes i.e. Data domain (DD) client software
Network Administrations skills:
-Broadcasting, segmentation
-Wireless network design and configuration using microwave and trango
-General Cisco networking Skills and LAN/WAN networks
Professional Experience
Crescent Solution
Contractor -2 months
United States
Jan 2017 – Mar 2017
Oracle Database Security Consultant
Working with Oracle Corporation – Professional Services through Crescent solution as an Oracle Database Security Consultant with the focus on the following:
Oracle transparent Data Encryption Deployment using fast-offline migration approach
Oracle Database Performance tuning for the new encrypted databases
Oracle Key Vault Installation, configuration,support
Develop and Document use cases to proof database protection at rest using TDE technology,
Maximum key protection using the oracle key vault.
Korek Tel
Full Time
Kurdistan
Oct 2013 – Dec 2016
Oracle Database Administrator
Oracle Database Servers Installation,configuration and Support
Oracle Database Management under Exadata boxes (half RAC)
DB & applications DBA on Korek databases that support the Systems and applications
Daily Health Check Up of the Database
Database cloning from Production to Test and Development environments
Configured and maintained huge OLTP databases
Monitoring Table spaces and extent Growth
Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly
Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
Monitoring and troubleshooting SAN related issues
Experience in Identifying performance bottlenecks on high volume transaction systems.
Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
Itisaluna Tel
Full Time
Kurdistan
Mar 11- Oct 13
Oracle Database Administrator
Oracle products installation, configuration, administration and support
Support Billing System Application (TABS) under Oracle Solaris with core databases technology 10g
Support reporting databases systems under Windows/Linux platforms with core database technology 10g,11g
Support billing application team to write SQL queries.
Clean up archives logs to free space on the archive file system through managing the daily RMAN backup job to purge the archives
Responsible for backup accuracy and billing system databases availability
Perform Periodic database health check to early detect database problems and reduce the incident.
Job scheduling using crontab
Creation of database maintenance plans, rebuild indexes and integrity check
Implemented RMAN Backups, Creation of catalog database.
Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Performed full and incremental backups using RMAN
Ensure high availability of Databases at all time.
Support migration and loading of data into oracle database using SQL*Loader
Performed and scheduled re-orgs
Provided support on performance issues during project development resulting in improved response times and reduced contention
Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
Earthlink
Full Time
Kurdistan
Feb 10- Feb 11
Oracle Database Administrator
Network Links Monitoring,troubleshooting and support
Wireless network design and configuration using microwave and trango
General Cisco networking Skills and LAN/WAN networks
References
All references are available upon request.