Muhammad Hamid

A result-oriented and highly motivated Professional with 14+ years of experience in banking and telecom industries. Expert in Database administration, performance tuning, migrations, upgrades, and database security. Implemented Oracle Exadata Engineered System, AVDF, and Advance Compression for high-volume financial projects. Achieved PCI-DSS compliance by applying Database Advance Security options. Managed incidents efficiently by following proactive and preventive maintenance approach.

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.

MSc IT, 2009
University of The Punjab, Lahore.
BSc, 2006
University of the Punjab, Lahore.