HAMZA FAYYAZ

Database Administrator with above 9 years of experience analyzing and planning database implementation methods, improving data management approach, troubleshooting issues, and maintaining the optimal performance. Possess technical skills and expertise in managing Multi-Terabytes RAC databases, performed numerous upgrades and successful Go-Live. Looking to leverage my knowledge and experience into a challenging role in reputed firm.

DATABASE CONSULTANT at Mannai Corporation Sep 2021 – Current

  Create mechanism for Identification/ mitigation of Oracle License compliance gaps and for audit

  Migrate and Upgrade Oracle 12.1>12.2>19c from X3 to X8. Exadata with minimal down time approach using Data-guard. 

 Successful Upgrade of 12c to 19c RAC for GIS application

EXPERT DATABASES at JAZZ Jun 2020 – Aug 2021 

 Optimizing performance of revenue generating databases helping organization achieving better ARPU  Achieved significant reduction in performance specific incidents during routine time critical bill runs by pinpointing the problematic SQL and suggesting possible solutions. 

 Successfully upgraded RAC 12c to 19c using DBUA in pursuit of end of life database release mitigation project  Implemented suitable table partitioning and indexing resulting in significant improvement in database response time throughput increased from 250 to 800 TPS due to reduced physical reads 

 Identifications and fixation of RAC related issue to ensure service level HA, SCAN load balancing problem due to faulty virtual NICs

EXECTIVE DATABASE ADMINISTRATOR at Zong May 2019 – May 2020 

 Successful Implementation of multiple 12c RAC for In-house developed java-based CRM application (BOSS) by CMCC Chinese Telco. 

 Automation of data purging/archiving of exponential growth databases

  Implemented alerts of performance, service, storage using OEM 13c 

 Reduce new cluster provisioning time by automated installation procedure  Minimized unauthorized access of customer private data by data

ASSISTANT DATABASE ADMINISTRATOR KMBL Jul 2016 – Apr 2019 

 Played critical role in successful Go-Live of T24 Java-based Core Banking system on Exadata X6-2 along with five tightly coupled integrated systems  Managed twelve UAT RAC clusters unassisted and performed change tracking of critical feed databases during mock migration cycles to avoid repetition of already fixed issues.

Bachelor of Computer Science COMSATS University, Lahore 2009 - 2013