The Bank of Punjab (BOP)
Dept. Head Database & Application Management
Oct 2017 to date
Currently I am working with BOP and my core responsibilities are as follow
- Managing Databases and Applications administration team
- Administrating Oracle, SQL Server, and MySQL databases for banking industries.
- Set Policies to ensure 24/7 Availability of Business-Critical Application & Databases
- Migrated core banking database from virtual machines to Oracle Exadata X62 and X9-2.
- Configured Oracle Grid Control Enterprise Manager OEM 13c for proactive monitoring and alerts.
- Applied Oracle security update patches on a quarterly basis.
- Set up DR for all databases using Oracle Data Guard and performed DR drills successfully.
- Administration of Applications running on WebLoogic, Tomcat & IIS webservers.
- Implemented audit and user access policies.
- Designed and Implemented backup/recovery policies.
- Upgraded 11g and 12c databases to Oracle 19c.
- Implemented Transparent Data Encryption (TDE) on both Oracle and SQL Server databases.
- Performed database and application sizing and capacity planning.
- Contributed to Temenos Infinity Digital Banking & Mobile Application Project as a database expert.
- Designed and implemented short-term and long-term goals of database and applications department.
- Provided vision and leadership to achieve the department’s goals.
- Improved the process efficiency for managing the operational activities.
- Supervised the department’s operations.
- Designed and implemented strategic plans of department.
- Migrated core legacy system to Oracle Flexcube Universal Banking System.
- Implemented advanced security options for PCI-DSS compliance.
- Performed and supervised Flexcube release upgrade project.
- Built and managed a high-performing team.
MCB Islamic Bank (MIB)
Sr.
Manager
Application & Databases
Mar 2016 to Sep 2017
Duties & Responsibilities:
- Administered core banking databases and applications, including IRIS, SAFEWATCH, FLEXCUBE, FCCM, and in-house developed application.
- Configured and administered Oracle Data Guard for local and remote disaster recovery sites.
- Performed database backups (physical + logical) on disk and tape drives.
- Created user accounts, roles, and granted required access permissions and privileges based on the applications they accessed.
- Supported production databases remotely in case of any issue.
- Cloned databases with RMAN & Data Pump Export and Import utilities (expdp/impdp) in 10g & 11g versions.
- Cloned Oracle E-Business Suit R12.
- Raised Service Request (SR) with Oracle Support and used Metalink to resolve the issue in the database environments.
- Coordinated and communicated with system administrators, business data analysts, and development teams.
- Installed and administered AML application.
Ufone
Sr. Executive IT Infrastructure
Dec 2015 to Mar 2016
Duties & Responsibilities:
- Installed, configured, and administered telecom databases, including single node, RAC running on Exadata-X4, X-3 with sizes more than TBs.
- Installed and administered Oracle Real Application Cluster for high availability.
- Configured and administered Oracle Data Guard for local and remote disaster recovery sites.
- Administered Oracle Golden-Gate.
- Performed database backups (physical + logical) and space management for backups.
- Performed database archiving and purging activities to control database size.
- Scheduled custom reporting from 12c grid control for DB health monitoring.
- Managed user access based on the user’s roles.
- Supported production databases remotely in case of any issue.
- Performed database refreshes using RMAN, Data Pump Export and Import utilities (expdp/impdp) in 10g & 11g versions.
Allied Bank Pakistan
Database Administrator
Mar 2010 to Dec 2015
Duties & Responsibilities:
- Planned, installed, configured, managed, and troubleshoot Oracle 10g & 11g databases, including RAC, ASM, Data Guard, and Golden Gate.
- Migrated core banking database from VM to Oracle Exadata.
- Administered Temenos T24 Core Banking System and AML application.
- Implemented advanced compression and reduced the DWH size by 50%.
- Implemented new technology solutions AVDF & Advanced Compression to meet the business requirements.
- Troubleshot various problems that arose in a day-to-day work and fixed the issues.
- Performed performance tuning, query optimization, backup/recovery policies, database patches, migration and upgrade of databases to 11g and 10g.
- Followed change management process for implementation of any change to live system.
- Implemented daily ETL process for banking data warehouse from production OLTP database to OLAP database for reporting purpose from internet banking.
- Communicated with database vendor and Oracle Corporation for technical support.
