概要

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.

项目

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

工作经历

公司标识
Database Administrator
Synavos
Dec 2020 - 代表 | Lahore, Pakistan

·       Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
·       Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery.
·       Developed shell scripts and PL/SQL procedures and scheduled CRON jobs and DBMS_JOBS to monitor the database performance and for user management.
·       Implemented data guard with maximum performance configurations and worked with data guard maintenance and troubleshooting.

公司标识
Database Administrator/Resident Engineer at JAZZ
Techacess private limited
Feb 2018 - 代表 | 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.

公司标识
Database Administrator
Sharif Group
Sep 2019 - Dec 2020 | Lahore, Pakistan

Managing and supporting the Oracle EBS system at Sharif Group.
Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
Setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
Setup Linux Shell scripts for different database monitoring tasks like storage space at databas level (Table space, Archive logs) and OS level with monitoring of data guard status and backups.
Implemented and maintained oracle active data guard 12C with maximum performance configurations and troubleshooting issues regarding connectivity and log shipping to DR (Data Guard).
Developed Linux scripts for RMAN backup, Data pump export / import, purging archive log filesand old backup files.

公司标识
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

学历

Islamia University
硕士, 科学硕士学位, BS(CS)‎
Computer Sciences and Information Technology
CGPA 3.3/4
2017

技能

中级 Communication for Development
中级 Customer Support Operations
熟练 Data Guard
熟练 Database Administration
中级 Database Administrator
中级 Database Design
中级 database installation and backups
中级 DBA
初学者 Experience in Postgre
中级 implementation of data guard
中级 MySQL
中级 Operation Resposibilities
中级 Operations Responsibility
中级 Oracle Administration
初学者 Oracle E-Business Suite
中级 Oracle EBS
中级 Performance Tuning
中级 Query Language
中级 sybase dba
中级 upgrade, install, administrate oracleDB
中级 Windows and Linux servers.

语言

中级 乌尔都语
中级 英语