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   

High Availability RAC cluster ASM, Oracle Cloning with Duplicate RMAN command

• 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