概要

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
Aug 2021 - 代表 | 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
Sep 2020 - 代表 | 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)
Sep 2018 - Sep 2020 | 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
Oct 2017 - May 2018 | 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
May 2016 - Oct 2016 | 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