Experience

• 

  Telenor microfinance bank limited

  Jan 2007 - Apr 2014

  Assistant director (database administration)

  Assistant Director (Database Administration)Core Oracle DBA Responsibilities• Implement extensively List, Range and Hash Partitioning.• Enable ADDM to monitor and diagnose the potential performance issues.• Implement Oracle Enterprise Manager Grid Control for Centralized monitoring and maintenance of multiple databases.• Configure and Implement Flash Recovery Area for automatic Disk based recovery.• Implement Enable Block Change Tracking to improve incremental backup using RMAN.• Implement and Managing Data Guard for Disaster Recovery on 500GB (Core Banking Application Database), 300GB Financial Switch (IRIS) database.• Expert in query re-writing, procedures & functions Optimization.• Oracle 10g Database Migration into Oracle 11g with zero down-time using Oracle Streams.• Migration of Single instance database into two-node cluster database with very minimal down-time.Apps DBA Responsibilities• Implement list and hash partitioning on GL_BALANCES,GL_JE_LINES and GL_COMBINATION respectively.• Upgrade Application and database from R12 to R12.1.1 along with 11g.• Online Cloning from RMAN backup using duplicate database.• Cloning from single node into multi-node and vise versa.• Implement Data guard for Oracle E-Business Suit R12 on 1.5TB database size Core SQL DBA Responsibilities• Implement Transactional Replication for MIS reporting on 500GB UBPS (Utility Bill Payment System) database, which is used through easy paisa mobile account, to offload on production database.• Implement High Availability Solution with Database Mirroring.• Implement Backup & Recovery Strategies.• Implement Performance Data Collector. Show less

• 

  Bank al habib limited

  Apr 2014 - Aug 2015

  Senior manager - db administration

  I am worked as an Enterprise DBA to managing bank-wide databases including Oracle 10g, 11g, EBS-R12, MSSQL Server 2008/2012, DB2 UDB 9.7, 10.5. Also responsible for administrating , backup & recovery and cloning of Oracle Application server instances, Oracle Weblogic servers, Oracle SOA Servers, Oracle Service Bus Servers.Setup high availability of SOA and OSB clusters. Setup development environment of Flexcube Universal Banking (FCUB) and Direct Banking (FCDB) including patching.Setup OFSAAI environment including OFSAA Operational Risk and ERM. Show less

• 

  Dubai islamic bank pakistan

  Aug 2015 - Jun 2020

  Unit head - database & core banking infrastructure-avp

  Leading a team, comprising of 2 Junior DBA and 2 system administrators. I am responsible to managing bank-wide databases (Oracle 11g RAC, HRMS R12.2.4, MSSQL), Middleware (Weblogic), backup solution (IBM Tivoli), operating systems (AIX, Linux, and Windows) and Multi-tier storages.

• 

  Hbl

  Jun 2020 - Mar 2022

  Team lead – erp development and support

  Managing group of team members who are involved in development / Customization on Oracle HRMS Modules including applications and databases issues.

• 

  U microfinance bank limited

  Mar 2022 - now

  Sr. database administrator (vp)

  Managing bank-wide databases and responsible of T24 OpenShift platform. Currently involved in the migration of WSO2 from docker platform into Kubernetes platform.