Summary

I have started my career with Oracle 11g. My area of specialization is Oracle Database, especially in the challenging and highly motivated environment to get expertise. My commitment is always with quality of work related to my job. I understand my responsibility, believe in honesty and hard work with discipline.

Projects

Migration of Database from 11gr1 to 11gr2 RAC
Oracle Enterprise Manager Cloud Control 13c Installation
Database Migration

Experience

Company Logo
Database Administrator/Resident Engineer at JAZZ
Techacess private limited
Feb 2018 - Present | Lahore, Pakistan

 Basic responsibility as a Database Administrator is the Management of Oracle Exadata at
Client side Mobilink Jazz (mobile network operator).
 Monitoring of Performance and tuning issues using OEM.
 Managing of Table spaces and data files, their usage and space requirement issues.
 Managing backups of databases using Export utility.
 Performance tuning using OEM, AWR, ADDM & ASH reports.
 Providing DB level support to client for Exadata with RAC setup
 Involved in performance tuning & performance monitoring.
 Providing 24x7 support for critical production databases.
 Migration of Oracle Database (11.2.0.4.0) for Windows operating system to Linux operating system.
 Expertise in PL/SQL, Packages, Stored Procedures, Functions, and Triggers.
 Creation of Active Data guard 12cR2, Switch Over and Fail over.
 Installation, up gradation and migration of PostgreSQL database.
 Expertise in Partition table creation, converting Non partition table to partition table with Jobs and procedures to manage partitions.
 Creation of Active Dataguard 12cR2, Switch Over and Failover.
 Responsible for applying Oracle Database Security Patch Set Update 11.2.0.4.0 Quarterly.
 Team member for latest Patch Deployment (Jan 2019) on Exadata Production databases.
 Oracle Enterprise Manager Cloud control 13c Installation & Configuration with targets discovery
and monitoring rules for Mobilink Jazz.

Company Logo
Database Internship
Descon Engineering
Sep 2017 - Feb 2018 | Lahore, Pakistan

 Implementation of Oracle Database 11g R2 (11.2.0.4.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
 Implementation of Oracle Database 12C R1 (12.1.0.2.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
 Implementation of Oracle Database 11g R2 on & 11R2 Data Guard (11.2.0.2 Single Instance Physical Standby) in test Environment on Windows server 2008 SP1 64-bit used for high availability, data protection, disaster recovery and Real Time Apply .
 Implementation of Oracle Database 12C R2 on Data Guard (12.2.0.2.0 Single Instance Physical Standby) in test Environment on Oracle Enterprise Linux AS 6 Update 5 used for high availability, data protection, disaster recovery and Real Time Apply
 Expert in managing Table spaces, Data files, Oracle instance, Database links, Schema objects and Listener issues in multi user Environment.
 Troubleshoot Oracle Applications and Databases.
 Backup restoration and Recovery using RMAN through Disks.
 Managing backups of database using RMAN.
 Ability to work in the following Operating Systems:
• Windows
• Linux

Education

Islamia University
Masters, Masters in Science, BS(CS)‎
Computer Sciences and Information Technology
CGPA 3.3/4
2017

Skills

2 Years Communication for Development
1 yearCustomer Support Engineer
2 Years Database Administration
1 yeardatabase administrator
2 Years Database Design
1 yeardatabase installation and backups
2 Years DBA
2 Years English
Less than 1 YearExperience in Postgre
1 yearimplementation of data guard
1 yearMySQL
2 Years Oracle Administration
1 yearPerformance Tuning
1 yearSQL
1 yearstrong analytical skills and problem solving
1 yearsybase dba
1 yearupgrade, install, administrate oracleDB
2 Years Windows and Linux servers.

Languages

Intermediate Urdu
Intermediate English