beBee background
Professionals
>
Technology / Internet
>
Lahore
Muhammad Hamid

Muhammad Hamid

Database Administrator | Oracle | SQL | MySQL

Services provided: Database Administration , Oracle SQL , Oracle , Database Migration Engineers , Database Clustering Consultants , Database Design & Administration , SQL Server , Database Services , SQL Tuning , Data analysis , JBoss Application Server , MySQL , Database Integration Engineers , Systems Administration

Lahore, Lahore District
₨30 / hour
Approximate rate

Social


About 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.

Experience

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.

Education

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

Professionals offering similar services to those of Muhammad Hamid

Professionals in the same Technology / Internet sector as Muhammad Hamid

Professionales offering Database Administration services

Professionales offering Oracle SQL services

Professionales offering Oracle services

Professionales offering Database Migration Engineers services

Professionales offering Database Clustering Consultants services

Professionales offering Database Design & Administration services

Professionales offering SQL Server services

Professionales offering Database Services services

Professionales offering SQL Tuning services

Professionales offering Data analysis services

Professionales offering MySQL services

Professionales offering Database Integration Engineers services

Professionales offering Systems Administration services

Professionals from different sectors near Lahore, Lahore District

Other users who are called Muhammad

Jobs near Lahore, Lahore District

  • Home Department Punjab

    Naib Qasid

    Found in: beBee S2 PK - 5 days ago


    Home Department Punjab Lahore, Pakistan Full time

    New Class 4 jobs in Home Department Punjab January 2023 has been announced through the latest advertisement and looking for Interested, Dynamic, Experience, Brilliant Candidate to Full fill these Positions with a Handsome salary Package and Allowances According to Department Poli ...

  • HRSI

    Project Manager-NGO

    Found in: Manatal GBL S2 T2 - 1 week ago


    HRSI Lahore, Pakistan

    Position: Project Manager · Department: Projects (Home Chef) · Reports to: Program Manager · Location: Lahore Office · Job Purpose: · As the Project Manager for the Home Chef Program , your primary objective is to lead the seamless planning, execution, and delivery of the prog ...

  • Punjab Danish School & Center of Excellence Authority

    Principal

    Found in: beBee S2 PK - 5 days ago


    Punjab Danish School & Center of Excellence Authority Lahore, Pakistan Full time

    New Principal Jobs in Punjab December 2022 has been announced through the latest advertisement and looking for Interested, Dynamic, Experience, Brilliant Candidate to Full fill these Positions with a Handsome salary Package and Allowances According to Department Policies. Applica ...