Ali Anwar

A Senior Database Administrator & Team lead with 12+ years of experience architecting & managing multi-tier mission-critical Oracle & Microsoft databases on multi-platform production environments. Having worked with a range of databases/applications in collaboration with cross-departmental teams, I bring forth a wealth of experience in database administration & large-scale migrations from leading telecom, consulting, insurance & banking firms in Dubai, Abu Dhabi & Pakistan.

INNOVATIVE CHANNEL PVT LTD Karachi, Pakistan

Sr. Oracle DBA Jan 2021 – Aug 2022

FINANCE HOUSE Abu Dhabi, United Arab Emirates

Senior Database Administrator Mar 2015 – Dec 2020

MASHREQ BANK Dubai, United Arab Emirates

Senior Oracle Database Administrator Jan 2011 – Dec 2014

NATIONAL CLEARING COMPANY Karachi, Pakistan

Senior Database Administrator – Deputy Manager Feb 2007 – Dec 2010

• Installation Oracle database 12c, 11g RAC with ASM & GRID control EM on IBM AIX & RHEL.
• Configure and maintain highly optimized Oracle Databases for RAC and Standalone systems.
• Failure Recovery with RMAN & Flashback Recovery, Complete & Incomplete recovery.
• Performance Monitoring via ADDM, ADR,AWR,ASH, OEM Grid control, RAT, RDA & DRA.
• SQL optimization using Segment advisor, tuning advisor, Query Plans, SQL trace & TKprof. 
• Patch management Deploy PSU, CPU, Patch Set Bundles, Rolling Upgrade on Oracle 11gR2Grid.
• Optimize using Tuning packs SQLT, SQL profiles, SQL plan, ACS, xPlan, SQL access advisor, SQL Tuning advisor.
• Migration & Upgrade Database 11g/12g DBCA, Data pump etc. 
• Monitor & Maintenance administration of Unix platform HPUX, RHEL, AIX, Linux

• Bachelor of Science & Technology (BSc), University of Karachi, Pakistan
• Information Technology ITILv3 Foundation 2011ITSM 2016 ITIL® ITSM
• Oracle Certified Professional DBA, OCP® 
• Oracle Database RAC, WebLogic system administration from Oracle University. 
• Diploma in Oracle professional programming