خلاصہ

Approximately 14 years Professional experience working with different companies in Oracle Database Administration & EXADATA Database Machine Administration for highly complex large environments from Banking (Oracle Technical Consulting Services) , Telecommunication and Government Sectors


پراجیکٹس

Implemented Disaster Recovery
Performance & Tuning and implementation for GG OLTP AND OLAP
Shell script for different services status and enable auto restart service
Oracle 19c RAC installation on Red Hat Linux 7 successfully
• Installation Oracle database 19c (19.3.0.0) and upgraded to 19.9.0.0
upgraded 11g database (11.2.0.4) to 18c (18.6.0.0.0)
Install and Configure of Oracle Virtual Machines
Oracle 13c Enterprise Manager Cloud Implementation
مزید دیکھیے

تجربہ

کمپنی کا لوگو
Sr. Database Administrator (Team Lead)
World Bank (Gove of Pakistan)
جون ۲۰۲۱ - موجودہ | Islamabad, Pakistan

PROJECTS COMPLETED
DR Migration Following tasks performed in DR migration from one city to other.
• Health check before and after Shutdown & startup of Exadata X-8Machine
• Starting up oracle database and cluster services on both nodes of Exadata DR • Synchronization and communication checks with all cell nodes
• Start copy of backup from PR to DR and apply to resolve the gap and synchronization. Audit Vault/Database Firewall Implementation
• Implemented Audit Vault and Firewall on Database Level.
• Made the policies for AVDF
• Housekeeping Audit logs Data Governs Implementation
• Participated some task with Business Intelligence team in Data management implementation like Data Categorization, Data Definition and Data Quality Rules. Golden Gate Broadcast Implementation
• Golden Gate (19.1.0.0.4) Unidirectional Broadcast implemented between Exadata Production database and other oracle databases.
• Golden Gate (19.1.0.0.4) Heterogeneous Unidirectional replication from ExadataProduction Database to MySQL Database and vice versa. Consolidation
• Consolidated some sets of data was using for same purpose with single application by teamwork including DB team, Developer DBAs , system architect and applicationusers. Consolidation is progress between BISP and some other Gove Organizations to administrate joint work for some National projects. Data Archiving Currently Following Data Archiving activities are in progress in Exadata Production Database.
• Backup & Remove a very huge chunk image based Passive data approximately (7TB) from Exadata Production Database.
• Backup & Remove some object have same information with different name in different schemas. • Backup & Remove schemas created only for development purpose
• Overalldatabase performance & tuning after reclaim space by above all actions
• Restore all backups in a separate machine for future use as per user need. 

کمپنی کا لوگو
Sr. Oracle DBA (Resident Engineer Exadata)
Meezan Bank Limited
جنوری ۲۰۱٦ - موجودہ | Karachi, Pakistan

Currently Deployed as a Resident Engineer (Sr. Technical Consultant Oracle)
Responsibilities:
·         Daily basis Administration, Maintenance, Performance & Tuning operations on Linux & Aix based Databases including Core Banking (Temenos T24), Internet Banking, Mobile Banking, AML and Several critical banking databases.
·         Installation, configuration and Monitoring of CLOUD CONTROL 12c & 13c
·         Administration of ORACLE ZFS STORAGE APPLIEANCES BY GUI CONSOLE and command line storage administration.
·         Database Migration at storage level between different storage Pools.
·         Implemented Data Guard technologies and Managing DR Database’s
·         Working with the Development team to fix the problems in specific environment.
·         Maintaining and Creating clone database for test and training purpose.
·         Implementing different techniques for Performance tuning
·         Responsible to Roll Forward standby database by RMAN INCREMENTAL BACKUP FROM LIVE DATABASE to resolve huge gape at standby database.
·         Keep in touch with ORCLE SUPPORT for anychallengein Liveand Test Environments
·         Support at WEBEX SESSOIN with ORACLE SUPPORT ENGINEER and ORACLE PLATINIUM GATEWAY SUPPORT SERVICES.
·         Dailly Monitoring to synchronized the database to maximum availability for Disaster Recovery in all Oracle and Partially SQL Server Databases
·         Oracle Database Machine monitoring and administration for all EXADATA COMPONENTS
Provide and coordinate with local vender of EXADATA MACHINE to resolve the hardware level issues.

کمپنی کا لوگو
Resident Engineer (Oracle Support Consultant)
Habib Bank Limited
دسمبر ۲۰۱۴ - جنوری ۲۰۱٦ | Karachi, Pakistan

Worked as a Resident Engineer (Technical Consultant Oracle)


Job Responsibilities:
• Major concern of deployment in HBL was performance & tuning of IRIS Database.
• Monitoring, Administration, Installation, configuration and maintenance of Enterprise Database servers on Linux/ Windows/AIX platforms and storage technologies/methods
• Provide 24/7 support for production database and also technical support of database to application development teams.

ACCOMPLISMENTS IN HBL BANK
• Part of the team implemented ORACLE GOLDEN GATE at IRIS DATABASE
• Resolved the maximum issues during the period regarding performance & Tuning.

کمپنی کا لوگو
Lead Database Administrator
Augere Pakistan (Pvt) Limited
جولائی ۲۰۱۳ - جنوری ۲۰۱۵ | Karachi, Pakistan

Job Responsibilities:
Joined Augere Pakistan as a Senior Oracle Database Administrator & worked under supervision of IT Head. Following are the responsibilities

• Responsible for Oracle database administration, maintenance & ongoing day-to-day operations support including Controlling and monitoring user access to the database
• Implements sound backup and recovery policies for the Oracle database
• Middleware (Apache Tomcat & Red Hat Jboss) administration and maintenance.
• Implementation tables partitioning and its maintenance

ACCOMPLISMENTS IN AUGERE PAKISTAN
• Implemented Disaster Recovery Solution by Oracle Data Guard.
• Shell scripting to query for huge Reports from Standby Database.
• Database Purging with the help of Application Team

کمپنی کا لوگو
Technical Consultant Oracle Database
ORA-TECH SYSTEM (PVT) LTD
دسمبر ۲۰۱۱ - جولائی ۲۰۱۳ | Karachi, Pakistan

PROJECTS AT ORA-TECH SYSTEM:

Silk Bank Limited
• Worked as a Resident Engineer (Oracle DBA)

Job Responsibilities:
• Provide 24/7 support for production database and also technical support to application development teams.
• Maintain Database & Application Backups i.e. RMAN, Export Import, and Cold Backup.
• Performs Database re-organizations as required to assist performance and
Ensure maximum uptime of the database.

ACCOMPLISMENTS IN SILK BANK
• Database Migration from Dell P5 to P7 using Data guard switchover


Bank Alfalah Limited
• Temporary Deployed and worked as a Database Administrator

Muller & Phipps Pakistan
• Upgrade Oracle Database from 10.2.0.4 to 10.2.0.5
• Configure Oracle 10g Data Guard with one Standby Server

Atlas Honda
• Reconfigure Oracle 10g Enterprise Manager
Atlas Asset Management
• Install Oracle 10g (10.2.0.1) Database on redhat Linux 5.5
• Cloning Oracle 10g Release 2 Database
Lucky Cement
• Performance & tuning of Oracle 10g database on Redhat Linux 4

کمپنی کا لوگو
Assistant to Database Administrator
R & K SERVICES
اپریل ۲۰۰۹ - جنوری ۲۰۱۱ | Karachi, Pakistan

Job Responsibilities:
Administer databases across the organization including maintenance, backup, and implementation, etc. Monitoring databases performance and ensure that databases are operational at their optimum capacity.

کمپنی کا لوگو
Assistant to IT Support Officer
Gamma Intl. Group of Companies UAE (Dubai)
فروری ۲۰۰٦ - دسمبر ۲۰۰۸ | Karachi, Pakistan

Name of Group of Companies
 Gamma Construction Company UAE (Dubai)
 Oxford International School UAE (Dubai)
 Apple International School UAE (Dubai)

Major Responsibilities:
• Plan and provide the latest IT technologies for the organization
• Application troubleshooting and maintenance
• Daily backup for all Databases
• Proceed hardware complaints and follow up with concern department.

تعلیم

ILMA UNIVERSITY
ماسٹرز, ماسٹرز ان سائنس, MCS‎
Advance Database Management System, Advanced Topics In Databases
2020

پیشہ ورانہ مہارتیں

ماہر CLOUD CONTROL 12c and 13c implementation
ماہر Data Guard configuration
ماہر Datapump Exp & Imp
ماہر Installation of Windows Server, Linux, S
ماہر ORACLE EXADATA and ZFS STORAGE APPLIANCE
ماہر ORACLE GOLDEN GATE configuration
ماہر Oracle RAC
ماہر Oracle Security
ماہر Rman restore & recover
ماہر Upgrade and Migrate from 11g to 12c&19c

زبانیں

ماہر اردو
ماہر انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں