Farhan Ali Email & Phone Number

Mississauga, Ontario, Canada

o Supporting 24X7 most critical production databases and environments towards achieving high availability and performance. o Expertise in doing various Oracle Database Administration tasks like database upgrade, database patching, database cloning, performance tuning etc.o Upgrade of Oracle E-Business Suite application tier from R12.1 to 12.2.10 and database tier from 11gR1 to 19c.o Troubleshooting performance related issues being reported in Database and EBS concurrent requests.o Upgraded standard edition Oracle databases from 12c to 19c using Autoupgrade utility.o Devised and implemented strategies for database backups and recovery using RMAN.o Upgraded OEM Cloud Control from 13.3 to 13.5o Installed and configured OEM Grid Control. Expertise in OEM administration and usage.o Expertise in system wide performance tuning using OEM, AWR, ASH,ADDM, SQL Tuning Advisor, SQL Access Advisor.o Provided mentoring, guidance and general oversight to less experienced staff in a variety of database design and administration concepts and issues.o Worked on development of data pipelines to ingest data from multiple sources into Data Lake using PL/SQL, shell scripting.

Punjab, Pakistan

o Implementation of Oracle Exadata X8M, migrating 85TB of database from IBM AIX Power System to Oracle Exadata using XTTS.o Setup Oracle Golden Gate to ingest data from multiple sources into Data Lake for business reporting purposes.o Performed 4 node RAC database upgrade from 11gR2 to 19c sizing 85TB in 4 hours downtime.o PCI DSS, Internal, External, Regulatory Auditingo Performed Complete Data Centre Disaster recovery drillo Supporting 24X7 most critical production databases and environments towards achieving high availability and performance. o Expertise in doing various Oracle Database Administration tasks like database upgrade, database patching, database cloning, performance tuning etc.o Performed 4 node RAC database upgrade from 11gR2 to 19c sizing 85TB.o Upgrade of Oracle E-Business Suite application tier from R12.1 to 12.2.10 and database tier from 11gR1 to 19c.o Troubleshooting performance related issues being reported in Database and EBS concurrent requests.o Installed and configured Oracle Golden Gate for business reporting.o Devised and implemented strategies for database backups and recovery using RMAN.o Upgraded OEM Cloud Control from 13.3 to 13.5o Installed and configured OEM Grid Control. Expertise in OEM administration and usage.o Expertise in system wide performance tuning using OEM, AWR, ASH,ADDM, SQL Tuning Advisor, SQL Access Advisor.o Provided mentoring, guidance and general oversight to less experienced staff in a variety of database design and administration concepts and issues.o Worked on development of data pipelines to ingest data from multiple sources into Data Lake using PL/SQL, shell scripting.

o Database Administration support for 80+ Oracle, SQL Server databases.o Experience of managing 5 members DBA teamo Planned business continuity policies with business and BCP team deciding RTO and RPO objectives for all applications as per their criticality factor.o Performed platform migration of Oracle EBS R12.2 Database tier from Linux to IBM AIX platform.o Ensured performance and high availability of critical databases using RAC & Data Guardo Executed Data Centre drill and ensuring that applications are available to business as per requirements decided in BCP policies.

Lahore, Pakistan

o Administration of more than 40 Oracle Databases including RAC environmentso Migrated 2 node RAC cluster from Linux(RHEL) to 4 node RAC cluster on IBM AIXo Performed upgrades of databases from 11gR2 to 12co Worked on AWR reports of critical databases to resolve performance related issueso Monitored Database environments using Oracle Cloud Controlo Set up alerts for different thresholds like tablespace usage, archive area, filesystem space usage etc.o Developed data migration strategies for multiple applications to be consolidated as a result of two banks mergero Troubleshooting database and SQL queries performance issues.o Performed capacity planning and sizing of databases based on growth trends and business inputs. o Installed and Configured Oracle Cloud Control for Application and Database Monitoring

o Performed Analysis, Design and Development of Database Applicationso Upgraded Oracle databases from 9i/10g to 11go Installed Oracle Golden Gate to replicate data from source database to reporting environment.o Managed team of Database Developers for designing backend solutions for leasing product software solutiono Provided database support for day-to-day operational issues for multiple clients across the worldo Worked on the development of Data Migration project to migrate client’s data from its Legacy System to Leasing Product

Lahore, Pakistan

o Worked as Oracle Apps DBA providing Administration support for Oracle EBS R12o Implemented Dataguard to establish physical standby sites for tier-1 and tier-2 databaseso Installed and configured 2-node RAC databases for Core Banking Solutiono Upgrade of 2-node RAC database from 10g to 11go Worked on the development of Treasury application software using Oracle Forms 6io Installed and configured Oracle Database environments for new applications deploymento Upgraded Treasury application software from Oracle Forms 6i to 10go Monitored and resolved different database alerts generated by OEM involving infrastructure, performance and space related alerts.o Performed data migration using traditional export/import or data pump utility.

o Database Operational Support for 80+ branches.o Guided operations team in Implementation of Core Banking Solution in branches of the banko Provided backend support to operations team for troubleshooting issues related to Core Banking Softwareo Worked on development of different modules of Core Banking Solution using PL/SQL, Oracle Formso Worked on optimization of the existing SQL, PL/SQL codeo Writing effective SQL, PL/SQL, database triggers, procedures and functions.