MOHSIN ALI

S/O: Kamran Asad

Date of Birth **/**/1987

Cell No: +923*********

CNIC No: 17301-2990121-5

Passport #: XK1791211

Email: acn3dg@r.postjobfree.com

LinkedIn Profile: pk.linkedin.com/in/mohsinali87

Mailing Address: House # 35, St # 1, Sector F6, Phase 6, Hayatabad, Peshawar

Pakistan.

Objective

Rendering my services as Database Administrator, Maintenance and

Development Team member in your well-reputed organization by making best

use of my analytical and Professional skills and technical expertise in IT

for rapid growth of company, good will and revenues.

Experience Details:

Having more than 6 years of experience in Database Administration as an

Oracle DBA.

Database Administrator

(From November 2012 - Present)

Working as Oracle Database Administrator at Shaukat Khanum Memorial Cancer

Hospital & Research Centre, Pakistan.

Duties and Responsibilities:

* Managing 24x7 Database servers using oracle 11g R2 RAC, Data-guard and

Enterprise grid controls to meet high availability and data protection of

nonstop business operations over EMC SAN and Centera.

* Installing, Configuring, patching, upgrading and migrating live DB

servers with minimal Down time.

* Managing online backups of servers, testing, validating and storing on

tape to keep historical Data safe.

* Managing different remote servers and on-going projects of different

clients e.g. METRO CASH AND CARRY PAKISTAN, SOCIAL SECURITY HOSPITALS,

ARMED FORCES INSTITUTE OF CARDIOLOGY, NATIONAL INSTITUTE OF HEALTH

DEPARTMENT, TABBA AND MAROOF HOSPITAL.

* Day today support, capacity planning and performance tuning for Oracle

Databases.

* Oracle fusion middleware Web-logic 11g server administration,

configuration and troubleshooting and Weblogic Clustering on 2-node.

* Backup and Recovery Administration.

* Install, Configure and Administer Oracle Cluster-ware / Grid Infra

Structure

* Apply patches to an Oracle application and database tiers.

* Plane and Configure RMAN backups.

* End to end Configuration, Management and Maintenance Replication using

Golden-gate, Bidirectional replication using Golden-Gate.

* Manage the Oracle E-Business Suite using Oracle Applications Server 10g.

* Upgraded oracle 11i EBS production servers to oracle EBS R12 servers and

DB Tiers upgraded from 9i to 10g R2, Patching cloning etc.

* Upgraded Oracle 10gR2 SE (Windows 2008) to Oracle 11gR2 EE (Linux 5.9) in

0-downtime migration using Golden-Gate.

* Microsoft SQL SERVER 2005 and 2008 configuration and maintenance.

* Configuration of Oracle 11g gateway for accessing data from SQL SERVER.

* Cloned Multi node system to single node system (Rapid Clone).

* Administering through Oracle Management Server (OEM).

* Experience of Administration of SAN/NAS i.e. adding and configuring LUNs,

provisioning, zone volume group etc.

* Installing, Patching, assigning roles to users in Oracle R12 apps.

* Helping Functional consultants in Identifying problems and solving it.

* Helping Developers in develop and tuning custom forms and reports.

* Implementing Oracle Enterprise Manager 11g Grid Control Production

machines on Windows and LINUX platforms.

* Automate Oracle Data-guard Switchover/Failover, using Shell Scripting.

* Providing high availability solutions to business by deploying Data Guard

refining operating procedures to enable switchovers and failovers in less

than the agreed SLA of 5 minutes for key business systems.

* Upgrade Oracle EBS 12.1.1 to 12.1.3 and upgrade database from 11.1.0 to

11.2.4. Converted single Instance EBS database to RAC using

Rconfig. Hands on experience in Managing EBS R12 instances - Hands on

experience in Building Oracle EBS environments - Hands on experience in

Patching, Cloning, Backup, restoration and EBS R12 system administrator

activities - Experience in setting up DR and testing DR - Experience in

architecting Oracle EBS r12 environments - Experience of working in R12

upgrade projects

Database Administrator

(From September 2011 - October 2012)

Worked as Oracle Database Administrator in Central Directorate National

Savings of Pakistan.

Duties and Responsibilities:

* Responsible for ensuring availability and performance of the databases

that support the system at region level, Pro-active and reactive

performance analysis, monitoring, troubleshooting and resolution of

issues.

* To ensure the Implementation and monitoring of the database backup

policies. Configuration, monitoring and troubleshooting of production and

standby databases at NSCs.

* Monitor the Data Replication of online sites of his region. Monitor the

database growth and system utilization, trend analysis and predicting

future database resource requirements.

* Install and configure standby on Oracle Standard Edition.

* Install and configure application server Tomcat 5.

* Analysing daily Cron jobs on production for extracting data from

different environments and load that data to different environments.

* Writing shell script for automating different jobs, checking availability

of listener agent control and database.

* Import and export old archives and then retransform it to again export

dump using data pump.

* Collecting statistics for database objects daily and weekly basis.

* Implement and managed Oracle Advance replication using MV's.

* Shell scripts for different database recovery purposes. Deploying Oracle

10g Data-Guard on a Red-Hat Linux v5 Backup & recovery using RMAN with

command mode & Enterprise manager.

* Hands-on Oracle 8,9i and 10G and 11g DBA Core Implementation of Oracle

Standby on two systems at different branches of National Savings.

* Complete Implementation of Oracle replication using Golden-Gate from

Master to client sites and vice versa.

* Having work experience on oracle RAC (Real Application Cluster), Data

Guard Oracle Standby and oracle Application Server. VPD, Tools Oracle

Grid, Oracle Data Replication, Oracle Enterprise client console 10g/11g,

Enterprise Manager, Toad, SQL Loader, Performance Tuning, Data Migration,

Cloning, Replication using Materialized views etc.

Red hat Enterprise Linux5 64-bit, Oracle 10g R2 64-bit, putty,

Toad, Fiber Channels, hp server, KVM,hp SAN

Database Administrator

(From Sep 2009- Sept 2011)

Worked as a Database Administrator in Soft Business Systems Peshawar,

Pakistan.

Main Responsibilities

* Install and configure grid control and agents on different boxes

* Analysing daily cron jobs on production for extracting data from

different environments and load that data to different environments.

* Writing shell script for automating different jobs, checking availability

of listener agent control and database.

* Import and export old archives and then retransform it to again export

dump using data pump.

* Collecting statistics for database objects daily and weekly basis.

* Taking online backups with RMAN.

* Shell scripts for different database recovery purposes.

* Plan for backup, recovery, and fault tolerance of database; backup and

restore the database

* Control and monitor user access to database

* Monitor and optimize the performance of database

* Allocate system storage and plan for future storage requirements for the

database system

* Provide technical solution to Oracle database related problems.

* Having work experience on oracle RAC (Real Application Cluster), Data

Guard and oracle Application Server.

* Tools Oracle Enterprise Manager, Toad, SQL Loader

Environment:

Red hat Linux As4, Ms2003 advance server, xp, Oracle 10g R2 ASM, putty,

Toad, Fiber Channels, Fujitsu Primergy, KVM

Certification Details:

* Oracle 11g Certified Associate from Oracle University USA.

* Oracle11g Certified Professional from Oracle University USA.

Courses

* Oracle DBA 10g/11g from U & U Software House Peshawar

* OCP Developer Track 6i, 10g U & U Software House Peshawar

Implemented Projects:

DR Solution at Punjab Employees Social Security Hospital

June 2013

Implement Oracle Active Data-guard for DR.

Shell Scripting for Backup from STANDBY SERVER to BACKUP SERVER; define new

strategies for security and backup and recovery of new environment

(inclusive of RMAN, security roles assignment through packages).

ORACLE 10g SE (Windows 2008) - 11g EE Migration/Upgrade (Oracle Linux)

February 2014

Upgraded Oracle 10gR2 SE on Windows Server 2008 production servers to

Oracle 11gR2 EE on Oracle Linux 5.9 with near 0-Down time using ORACLE

Golden gate product at client of Shaukat Khanum memorial cancer hospital

and research centre.

Backup Design and Implementation at Shaukat Khanum Hospital.

June 2013

Planning and Implementation of backup strategy for Shaukat Khanum Cancer

Hospital which included complete configuration for on-site and off-site

backups through RMAN (Recovery Manager). Configure and automate backups

with shell scripting and schedule using CRONTAB scheduling.

Oracle 11g Active DataGuard Switchover Automation Shaukat Khanum Hospital.

Implement Oracle Active DataGuard. Configure and automate Oracle DataGuard

11g switchover using shell scripting to reduce manual work.

Human Resource Management System _March

2010

I have developed Human Resource Management System. This

project holds Employee Records, Hiring and all Employees reports records.

This HR project or software is currently implemented in micro systems

Peshawar. I used tools for this software is Oracle Developer 6i and Oracle

Database 10g.

Professional Skills

Oracle

More than 6 years of Solid experience in the I.T field with ORACLE Database

Administration and Management for Enterprise and International, Private and

Government sector Projects. I can make all types of the installations,

configuration and maintenance of Oracle database technologies. I can do

full database administration on different platforms. Strong background and

sound Knowledge of ORACLE 10g, 11g RAC, DATAGUARD Oracle R12 E-Business

Suit(12.1.1) and Oracle 10g Enterprise Grid Control Administration on

windows and Red Hat Linux Systems Using SAN EMC Clarion and Cellera, DAS

2.2 Power vault storage and HP, Dell R900, 2900, 2950, 820 and IBM Power

servers. Self-study on Oracle Exa-data X3.

Specialties: ORACLE 10g/11g Data-guard, GRID CONTROL, Golden Gate

Replication, Partitioning, SAN STORAGE, HARDWARES AND UNIX OPERATING

SYSTEMS

Awards

During Departmental Level Web Page competition, I was selected as a Best

Web Designer of the Department of CS & IT in University of Engineering &

Technology Peshawar, Pakistan.

Hardware:

_ _

Sun Sparc Ultra E-10000, Sun SF 15K, IBM Risc 6000, IBM P 690 & P695, MS

Windows, HP DL380, HP DL 560, HP DL 760, HP Blade Servers, Dell R820.

Servers _

__

Tomcat, MS IIS, Oracle Server, Apache Web Server, OHS. Samba, NFS. MS

HyperV, Oracle VM and VMware

Databases

_

* Oracle 8.0/8i, Oracle 9i, Oracle 10g, 10g Release 2, Oracle 11g Release

2, Oracle 12c,MS SQL Server 2005, MYSQL 5.0

Application Server:

Oracle 10gAS, Fusion Middleware Weblogic Server 11g, LAMP, WAMP.

Applications:

* Oracle E- Business Suite 11.5.10, 11.5.9, 11.5.4.

Development Tools:

* Developer 2000 versions 1.3.2, 2.1.0, Developer 6.0, Developer 6i, Oracle

10g Developer.

Enterprise Tools:

* Oracle Enterprise Manager Versions 1.3, 2.1, 9i, 10g Grid Control Release

2 and 11g Grid Control Release 2.

Programming Languages __

* PL/SQL, SQL, HTML, PHP, UNIX shell scripting including the sed and awk

utilities.

Networks

* Experienced in Installations and configuration of office applications and

operating systems at the end users systems.

* Interaction with end users to provide technical support, Troubleshooting

of Local Area Networks.

* Windows Client server environment (Domain), DNS Server, Active Directory

configuration, Anti Viruses and Virtualization etc.

Operating Systems

* Sun Solaris 10.0, Windows NT/2000/2003/2008, IBM AIX 4.3, 5.1 & 5.2,

Linux Red Hat Advanced Server 2.1, Red Hat Enterprise Linux 3 AS, RHEL

4.1/5.3,Fedora 6,Ubuntu, Suse v11, Oracle Linux 5.3 / 5.9 / 6.2 and Mint.

Languages

* Dependable reading, writing and speaking skills in the following

languages

English and Urdu.

Hobbies

* Watching movies, Computer Games, Web Designing.

Academic Qualification

Bachelor of Science in Computer Science (Hon's) BS (CS)

Session: 2005-2009

University: N-W.F.P University of Engineering & Technology Peshawar.

(www.nwfpuet.edu.pk)

Major: Computer Science

F.SC (In Computer Science)

Session: 2005

Institute: Usmania College Peshawar City.

S.SC (Science Subjects)

Session: 2003

Institute: F.G Boys Public School Peshawar Cant.

References:

Provide as per request.

Contact this candidate