خلاصہ

Hello,

I am  Assistant Manager Databases & MIS  Oracle,MS SQL,MYSQL (CBS) MMBL Head Office Islamabad with have 1 year Experience.

Before MMBL Database administration FMFB Head Office lahore with have 2 year Experience.

Total Experience in Database Field 6 year.


تجربہ

کمپنی کا لوگو
Database Administrator
Pakistan MNP Database Guarantee Limited
اگست ۲۰۲۱ - موجودہ | Islamabad, Pakistan

Administration and manged oracle databases.
Implementation and manged oracle golden Gate 19c.
Successful migrate oracle golden Gate from 12 to 19c.
Administration and manged mariadb.
Working in progress to magrate  oracle database to mariadb.
Working on different  projects.

کمپنی کا لوگو
Assistant Manager Databases & MIS
MMBL
ستمبر ۲۰۲۰ - موجودہ | Islamabad, Pakistan

Led a team of 2 database administrators responsible for daily database operations. • Administration and managed all Oracle and SQLSERVER production databases.
• Implementation and configuration of reporting server automated 100 reports to delivered client via emails using shell scripting. • Administration of BI Database Server. • Configure database level security at oracle production databases. • TDE Configuration at 11g ,12c,19c databases. • Maintained two node Oracle 19c database RAC for Core Banking. • MSSQL server high availability configuration and administration. • IRIS 3 ,5 database administration. • Working multiple digitalization projects at MMBL.

کمپنی کا لوگو
Database Administrator
Frist Micro Finance Bank (FMFB)
ستمبر ۲۰۱۸ - ستمبر ۲۰۲۰ | Lahore, Pakistan

•The First Micro Finance Bank LTD May 2018 Till Present Database Administrator (CBS).
Responsibilities:
• Installation Oracle database on Linux, Solaris, AIX, Windows on ASM/filesystem .
• ASM Configuration on Linux/AIX/Solaris.
• Managing Control files, Data files, Redo Log files, Undo etc.
• Oracle Server (RMAN) and User Managed Backup and Recovery (complete and in-complete recovery)
• Responsible for refreshing and cloning of databases per customer requirements using RMAN and Data Pump.
• Use of Import, export and datapump utilities.
• Monitoring the database activities using Alert log and trace files for errors to take appropriate actions.
• Job Automation with Bash Scripting in Linux
• Monitoring space related issues.
• Administration of Flexcube database/ Application for Core Banking.
• Cloning the Database on the Test environment as per demand and policies.
• Applying the Database Patches on the Production Environment.
• Plan and implement auto backup and recovery of the All Oracle databases.
• Maintained two node RAC Database oracle 11g for Core Banking.
• Maintained Application for Core Banking. Deployed application fixes.
• Maintained two node Oracle 12c database RAC for IRIS/Branchless.
• Preparation of Mock and Reporting Databases as per requirement.
• Installing and configure MYSQL 8.0/5.7 on linux.
• Configure master and slave on MYSQL server 8.0.
• Managing MYSQL server and perform daily task (i.e Backup, Restore etc).
• Installing and configure MS SQL server 2017/2014 on window server.
• Configure mirroring on MS SQL Server 2017 .
• Role Switching on MS SQL Server 2017/2014 on production environment.
• Managing SQL server and perform daily task (i.e Backup, Restore etc).

کمپنی کا لوگو
Database Administration (CBS)
Allied Bank Head Office Lahore
اکتوبر ۲۰۱۷ - مئی ۲۰۱۸ | Lahore, Pakistan

Database Administration (CBS) Core Banking Sector working on EXADATA with Multiple production Database with KT side same Database on KR Side .
Multiple Test databases on VM with different version , Restoration test databases with multiple testing in development team (Restore backup with requested date)
Multiple window server backup taken and restore.
Create restore point on singal instance OR RAC with Flash database to requested restore point.
Change deployed to production database according to changed.
Upgrade 11.2.0.4 to 12.1.0.1 .
Schedule Rman backup on production database with automated job.

کمپنی کا لوگو
Database Administrator
Ora-Tech Systems Pvt Ltd
مئی ۲۰۱٦ - اکتوبر ۲۰۱٦ | Islamabad, Pakistan

Installations Oracle 11g and Oracle 12c. • OEM Configuration 11.2.0.4 and 11.2.0.3 • Full Database backup or Incremental backup taken through RMAN. • Full Database OR Specific schemas backup taken through DATAPUMP. • Oracle DBA infrastructure. • Performs monitoring, tuning and capacity planning. • Perform database restore and recovery

تعلیم

University of Peshawar
بیچلرز, بی سی ایس / بی ایس, BCS‎
CGPA 3.1/4
2014

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

ماہر Assistant Manager Databases & MIS
ماہر CVs Screening
ماہر Database
متوسط Query Language
ماہر SQL

زبانیں

ماہر انگریزی
ماہر پشتو

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

Shafiq آپکے جاننے والے

Waleed Bilal
GE Grid Solutions