Oracle Management

Rana Muhammad Umar Liaquat

Email: ***********@*****.***

Cell (Pakistan): 009***********

Objective

To contribute outstanding Database Administration skills and strong

commitment to achieving your company's goals in the field of IT. I am a

highly motivated and committed graduate with all the zeal and enthusiasm to

excel in the field of IT. I have sound knowledge and work experience in the

field of Database Management Systems with the instinct to beat and be the

best.

The end product of all the above is the creation of a hardworking

professional with operational excellence as well as the drive and

initiative to make your company The best.

Key Skills

< RAC 10g/11g, ASM, Data Guard, Standby, OBIEE, Grid Control/Grid

Agents, Oracle Secure Backup, Upgrade of GI/RAC, Shell Scripting,

PLSQL, Linux/HP-UX/Solaris/Windows, Tape Libraries (MLS6000, SL500),

RMAN, DWH,

Profile

. IT professional with more than 10 years of Oracle Database

Administration, with 6+ years of Oracle

10g/11g RAC, Multimaster Advanced Replication, Streams Replication, Data

Guard experience in well reputed organizations in Pakistan/Afghanistan.

.Experience in Analysis, Data Modeling, and Design and normalization of

databases for Enterprise

Applications.

.Experience in Database Administration tasks i.e. Backup and Recovery,

Performance Tuning, (Oracle

8/8i/9i/10g/11g) on Windows / Linux / Solaris/HPUX platforms.

.Expertise in devising technical solutions for back-end database

development and implementation of back-

end logic and development using PL/SQL.

.Working knowledge of Data Warehouse Analysis, Design and Implementation.

Work Experience

MTN Afghanistan

DBA-BI Consultant November 16, 2009 - August 15, 2012

Managing, tuning, patching the operational databases (Billing (HPUX 11iv1),

VAS, DWH). Implemented multimaster replication on VAS DB

(Oracle11g/Solaris). Designed, and managing Tape Library (MLS6000),

database backups (RMAN,EXP) of all databases. Designing and implementing BI

models in OBIEE 11g. Databases in use are Oracle 9i/10g/11g. Operating

systems are HPUX/Solaris/Windows. Designed, installed a multimaster

replication solution for billing databases, RAC 11gR2 solution for

Technotree billing database on Solaris10. Designed and deployed Oracle

Rac11gR2 on OEL for BIB, OBIEE 10g, Grid Control (11g), Grid Agents, Oracle

Secure Backup, and Upgraded GI/RAC 11.2.0.1 to 11.2.0.2

Interactive Convergence, Islamabad, PAKISTAN

Asst. Mgr. DBA September 08, 2008 - November 14, 2009

To design, deploy, manage, and (now) tune a production DSS database of 58

terabytes Oracle 10g Release2 database, which is on RAC (2-node), on Sun

UltraSPARC E-6900 machines.

To design, deploy, support a DR-site (Disastor site) Oracle 10g Release2

database, which is on RAC (3-node), on Sun v-490 machines.

Taking backups (on SL-500 Tape Library, using Veritas NetBackup), uploading

old data, as per requirements.

Making data models (Logical, Physical) for development teams for the

purpose of new components developments.

Inov8 Limited. Lahore, PAKISTAN

Database Administrator February 14, 2007 - August 23, 2008

Worked on a mobile based-financial merchandizing product "Genie", my core

responsibilities include designing, managing, implementing the database

system for the company's product, using Oracle DBMS 10g Release2, with

Linux (RHEL ES) OS, and with Oracle RAC, with Advanced Multimaster

replication on 2 sites (connected using VPN), one being Primary and the

other being Failover site. The product has been launched now, primarily for

Mobilink, (http://www.mobilinkgsm.com/genie)

Advanced VoIP (Pvt.) Ltd. ISLAMABAD, PAKISTAN.

Senior Database Administrator November 01, 2005 - February 12, 2007

Worked on a data warehousing project, my core responsibilities encapsulate

administering Oracle 10g databases (being sized in Terabytes until now),

tuning performance of different databases (being the main responsibility)

using RAC, devising strategies of bakup and recovery and prepare test cases

for planning of disaster recovery. Also managing, tuning many Live

databases (of varying sizes ranging from 50GB to 700GB) of different

clients across the world. Most of them are using Oracle DBMS version 10g /

9i, with Solaris / Linux as an OS Platform.

Interloop (Pvt.) Ltd. FAISALABAD, PAKISTAN.

Database Administrator January 25, 2005 - October 30, 2005

Worked in the Pakistan's largest, the World's 2nd largest Socks-based-

textile organization having its DBMS in Oracle 9i and application built in

Oracle Forms 6i. My core responsibilities are to tune and keep the

performance of the database system (containing database sized to 105GB) to

optimum, devising and implementing latest disaster recovery strategies,

devising and implementing newer strategies and architecture for supporting

the growing business as the business demands IT to be its Strategic Partner

rather than just a facilitator or support functions.

Data XS (Pvt.) LTD., LAHORE, PAKISTAN.

Database Administrator August 11, 2003 - January 18, 2005

Worked on an e-Government Library System ERP of all the Government

sponsored libraries of Punjab, Pakistan, Quaid-e-Azam Library, Baghe-e-

Jinnah, Lahore (the largest library of Pakistan) and Islamia College for

Girls, Cooper Road, Lahore being the first two libraries where this system

has been deployed, having Oracle 9i as DBMS and .Net Framework as an

application architecture on Windows 2003 Server. My responsibilities

involved DB modeling that encapsulates planning, designing the conceptual

and logical data models (using ER-Win/ER-Studio), sizing the database, DB

related script management, DB security management, physical data modeling,

tuning the performance of the overall system by different means, defining

backup and disastrous recovery strategies.

Vigilant Systems (Pvt.) Ltd. LAHORE, PAKISTAN.

Database Administrator September 01, 2001 - June 30, 2003

Worked on a web-based Recruitment Portal Nuclearminds having 3 separate

28GB (each) databases on Oracle 9i DBMS in an N-Tier architecture using

Windows 2000 Advanced Servers, Linux/Unix as an OS. My core tasks included

sizing of the database starting from row-sizing to table-sizing to a full

database-sizing. I was responsible for controlling and maintaining the

development as well as production databases apiece with core tasks

including mapping of developer changes to the development database,

application tuning of queries of views, implementation of star-schema

architecture using materialized views etc. and their management, tuning the

overall performance of all the databases, taking backups (Logical, Cold,

Hot) periodically and self and doing recoveries whenever required. I have

got my special expertise in tuning the performance of database system. This

was particularly the Hybrid System Architecture that was the combination of

OLTP and DSS. I had to take special care regarding many factors like

Rollback Segments, Indexing, Extent Management, Sorting needs and different

Analysis and Structural contrasting issues. I was also involved in

designing the Local Logical Data Models of the system using Oracle Designer

6i.

Qualifications

Year 1999 (Jun 96 - Dec 99)

Bachelor in Computer Science (hons) (3 Years)

International Islamic University, Islamabad, PAKISTAN.

Year 2000

Certificate of Oracle Database Management

Punjab IT Board, Lahore, Pakistan.

Year 2001

Oracle Certified Professional (OCP8) DBA.

Year 2001

Workshop on Database Management

Punjab IT Board, Lahore, Pakistan.

Year 2012

Oracle Database 11g Administrator Certified Associate

Year 2012

Oracle Database 11g Administrator Certified Professional

Year 2012

Oracle Database 11g Performance Tuning Certified Expert

Year 2012

Orcale Certified Expert, Oracle RAC11g and Grid Infrastructure

Administrator

Particulars

Permanent Address

House no.P-9/5-A, Street no.2, Bazar no. 2, Razaabad, Faisalabad, PAKISTAN.

Contact this candidate