Syed Faraz Ahmed

Belonging to the elite class of few Oracle Certified Masters in the world help design cutting edge solutions for mission critical systems utilizing expertise in Oracle technologies.

• 11g to 19c Oracle RAC and Database Upgrade (2022)
• Bank Al-Habib 11g to 19c Oracle Grid and Database Upgrade Using rolling upgrade method (Logical Standby Database) without downtime. (2022
• HBL payment system 11g to 19c Database migration using Golden Gate without downtime. (2022)
• Golden Gate Migration from 12c to 21c Micro services. (2022)
• Oracle to PostgreSQL EDB Migration. (2021)
• Migrated whole application to PostgreSQL EDB with minor changes
• Anti-Money Laundering Database migration from Linux to Unix Migration of AML Oracle database from Linux to IBM Power8 (Unix) using Oracle Golden Gate with Zero downtime. (2019)
• MYSQL to MYSQL replication with Golden Gate Implementation. (2019)
• Oracle VM Server Implementation. (2018)
• Oracle Hypervisor implementation on 12c Standard Edition SE2 on 2 Node RAC implementation with Sekure Data Guard replication to DR Site. (2017)
• Oracle 12c Implementation
• Oracle 12c R2 implementation in Bank of Punjab with data Guard on 2 DR site Lahore & Islamabad
• Real Application Cluster Implementation with Dataguard
• Oracle 11g R2 2 Node RAC Implementation at Mobilink. (2016)
• Oracle 2-Node RAC Implementation.
• Oracle 2 Node RAC implementation with Data Guard replicating to DR Site on Waseela Micro Finance Bank Lt.(2015)
• HA + IRIS Application Upgrade with Oracle Golden Gate. Upgrade Major Switching application in Pakistan's largest bank "HABIB BANK LIMITED" which were causing 2 day of downtime including Oracle Version upgrade, TDE implementation, Archiving and Purging and as well as Application upgrade.
• To overcome this issue, we implemented Oracle Golden Gate to reduce downtime into 2 hours and to provide Golden Gate High Availability feature by configuring Bi-directional Replication and Golden Gate Veridata and Monitor deployment for monitoring. (2015)
• Sekure Guard has been designed to specifically cater the need of planned and unplanned downtime along with Disaster Recovery solution
• Sekure Guard is a highly cost effective solution for the small to mid-sized organizations which require Data Guard performance mode features implemented on Oracle Standard Edition targeting maximum uptime
• Sekure Guard has the ability to manually Switch Over and Failover feature just as the Oracle Dataguard
• Sekure Guard is used particularly on Standard Edition Databases in which Oracle Data Guard feature cannot be used
• Sekure Guard provides all the abilities of Performance mode of Oracle Data Guard which is for Enterprise Edition databases
• Oracle Manual Data Guard Implementation
• Creation of Data Guard on Standard Edition Database through Manual Scripts at Waseela Micro Finance Bank Ltd
• 2014
• Audit and SQL Tuning for performance optimization
• Application Design Improvements
• Audit and Performance Tuning of top 10 TPS client in Asia, Middle East and Africa
• Application Architecture Audit and suggest Design Improvements using Pre Built Materialized View, different data partitioning methods, Reports Optimization using Hints, restructuring SQL and table design
• 2013
• Audit and SQL Tuning for performance optimization
• Audit and Performance Tuning of top 5 TPS client in Asia, Middle East and Africa
• 2012
• Oracle Streams & Logical Data Implementation
• Implementation of Oracle Stream & Logical Data Guard at the state owned Employees Old Age Benefit Institute
• Recovery for Database
• Recovery of EOBI complete Oracle 11G database which had no backup using Linux OS recovery tools thus saving highly critical data of last 5 years
• Recovery for 4 Databases after SAN Crash
• Recovery of 4 HBL business critical databases after SAN crashed from TAPE Drive using RMAN and IBM Tivoli within 24 hours
• Real Application Cluster Implementation with Dataguard on Oracle 10g at Silk
• Bank Limited
• Real Application Clusters at Silk Bank were implemented was for load balancing of their new core banking solution - TEMENOS
• All implementations were done on AIX operating systems with IBM-GPFS and the infrastructure was based on IBM P-Series
• Heterogeneous Database Replication using Golden Gate,
• POC performed for various clients for successful Replication between Oracle to MS SQL, Sybase to Oracle, MS SQL to MS SQL
• 2011
• Real Application Cluster Implementation with Dataguard4 Node RAC Implementations in Meezan Bank
• 2 Node RAC Implementation at NIB Bank
• Oracle Security Products Implementation
• Database Vault and Audit Vault implementation at HBL
• Table Level Transparent Data Encryption at HBL
• Virtual Private Database Implementation at HBL
• Data Masking Implementation at HBL
• Logical Data Guard Implementation
• Logical Data Guard Implemented at Tranzium Courier Services (TCS) company
• Database Migration of 9i to 11g DB with Data Guard Implementation
• Successful migration of Oracle 9i to 11g on Linux platform and Implement Data Guard at Bank Al-Habib
• Perform Switchover on standby database
• 2010
• Oracle E-Business Suite R12 Implementation
• Release 12 of Oracle EB was implemented on AIX at Faysal Bank Limited
• Real Application Cluster Implementation with Dataguard on Oracle 10g2 Node Real Application Clusters at Silk Bank were implemented was for load balancing of their new core banking solution - TEMENOS
• All implementations were done on AIX operating systems with IBM-GPFS and the infrastructure was based on IBM P-Series
• Real Application Cluster Implementation with Dataguard on Oracle 10g2 Node Real Application Cluster implementation at Karachi Stock Exchange
• Oracle Dataguard Implementation
• 2009
• Oracle Streams with Multi Master Bi Directional Replication.Implemented Oracle Streams 3 Way Bidirectional Replication.Operating System migration from Solaris Sparc to RedHat Linux with DB migration from 8i to 10g at Dewan Mushtaq. (2008)
• Oracle DB Migration from 9i to 10g
• Oracle Data Base migration from 9i to 10g at Karachi Electric Supply Corporation.