خلاصہ

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
دسمبر ۲۰۲۰ - موجودہ | 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
فروری ۲۰۱۸ - موجودہ | 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
ستمبر ۲۰۱۹ - دسمبر ۲۰۲۰ | 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
ستمبر ۲۰۱۷ - فروری ۲۰۱۸ | 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
متوسط Operations Responsibilies
متوسط Oracle Administration
ابتدائی Oracle E-Business Suite
متوسط Oracle EBS
متوسط Performance Tuning
متوسط Query Language
متوسط Sybase DBA
متوسط upgrade, install, administrate oracleDB
متوسط مسؤوليات العملية
متوسط Windows and Linux servers.

زبانیں

متوسط اردو
متوسط انگریزی