Oracle DBA

MOHD IRFAN ALI

E-mail : **************@*****.***

Mobile : +919*********

Carrier objective:

An accomplished Oracle Database administrator (DBA) with expertise in

technical skills and knowledge fruitful for the growth of the firm.

Carrier Summary:

. Having 3+ years of experience as Oracle Database Administrator on

production and

development database.

. Had done various projects using RMAN for Backup and recovery, Data

guard for Disaster recovery, Installation, Configuration, Migration,

upgrade, cloning, patching, Performance Tuning.

. Installation and configuration of oracle software on Linux.

. Migrated database from oracle 10g on windows to oracle 11g on Linux.

. Hands on exposure in Oracle Database user management, profiles,

Database files

management,

Tablespace management, network management.

. Regular monitoring of Alert log file on day-to-day basis.

. Successfully migrated non ASM to ASM.

. Having knowledge on ASM.

. Creation of Database links and Materialized Views.

. Performed logical backups using Export/Import utilities.

. Monitoring and performing the backups using Cold, Hot.

. Implemented Flashback Database and Transportable Tablespace.

. Experience in configuring RMAN and Expertise in RMAN backup.

. Cloning an oracle database for Testing.

. Familiar with implementation and configuration of Data Guard.

. Knowledge in SQL, PLSQL.

. knowledge in RAC

Technical Skills:

Operating System : Window NT 4.0, Solaris, Red Hat Linux 5.0, 5.4

RDBMS : Oracle 10gR1 & R2, 11gR1 & R2

Backup Tool : Cold, Hot backup, RMAN, Import/Export

Tools : SQL Plus, Oracle Enterprise Manager

(OEM), SQL * Loader, Toad

Script : Having knowledge of UNIX\Linux shell

script

Language : Having Knowledge of SQL, PL/SQL, C

Web Technology : Having Knowledge of HTML, XML

Virtual Machine : VM Ware server 2.0 to 2.2, Oracle VM Virtual

box 4.0

Educational Qualifications:

. MCA (Master of computer applications) in 2012 from Osmania University

Hyderabad,A.P with FIRST CLASS.

Experience Summary:

. Working as Oracle DBA for Waandreams Pixel Flow Systems Pvt Ltd,

Hyderabad from November 2011 to till date.

Detailed Experience:

Project # 1

Client : PREMIA FOR STAR HEALTH INSURANCE Ltd

Environment : Oracle 10g, Linux

Team Size : 6

Duration : Feb 2012 to June 2013

Description:

Premia is an Enterprise-class insurance Management system that supports

underwriting, Claims and Re-insurance, backed by Comprehensive financial

accounting, reporting and analysis. A proven and tested solution, It is

designed with years of experience and knowledge of the insurance business.

The customer related details are stored in this 1TB database. My role

starts from maintaining of the Oracle 10g DB, the sizing the Database

Tablespaces on Monthly basis, and automation of maintenance activities

using shell scripts and enterprise manager.

Roles and Responsibilities:

. General administration including creation and management of users

and their profiles and other Configuration, installation and

defining backup strategy for the Oracle Database.

. Successfully applied patch on Test, Development and Production

Database.

. Taking care of all other daily routine DBA tasks like creating

users, roles, tablespaces, monitoring alert logs etc.

. Exporting and importing schemas.

. Worked on RAC.

. Reorg the Tablespaces on scheduled basis.

. Configured RMAN and managing the backups through RMAN in IBM

Tivolic Tape drives.

. Working with RMAN scripts for backup and recovery of databases on

Linux/Unix based environments.

. Auxiliary database creation, restoration on common host and remote

host (Duplication of DB using RMAN).

. Perform Database upgradation from 10g to 11g.

. Cloning the Database from Production Databases for testing server.

. Data Guard Configuring and maintaining (physical & logical).

. Database Cloning user managed and RMAN Cloning.

. Diagnose and monitoring log Alert files.

. Troubleshooting performance issues reported by the Application

Team.

. Work beyond regular hours based on business demands. Provided 24x7

on-call production supports.

. Configuring and creating ASM databases, converting non ASM

databases to ASM.

. Tracing, troubleshooting with database performance and tuning

issues.

. Analyzing and validating database objects.

Detailed Experience:

Project 2 #:

Client : Alliance Resource Partners, L.P. (ARLP) USA.

Environment : Oracle 11, Linux

Duration : July 2013 to till date.

Description:

Alliance Resource Partners, L.P. (ARLP) is a diversified producer and

marketer of coal to major United States utilities and industrial users.

ARLP's predecessor company began mining operations in 1971, and has since

grown through acquisitions and internal development to become the fifth-

largest coal producer in the eastern United States.

Roles and Responsibilities:-

. Maintenance of production database and development database which

includes tablespace space management, user creation, privileges, roles

etc.

. Replication of data through Datapump.

. Maintaining archive data on appropriate storage devices.

. Migrated 11gr1 to 11gr2.

. Monitoring Alert logfile and Trace file.

. Configure Data Guard configuration for making primary database more

consistent.

. Successfully done Manual and RMAN Cloning of database from production

to non production database.

. Automated hot backups using a combination of incremental, differential

and full RMAN backups.

. Job scheduling in Crontab.

. Troubleshooting performance issues reported by the Application Team.

. Provide 24/7 on call for production Database.

. Created partition tablespaces for production database.

. Applied patch on non production and production Database.

. Rebuild the Indexes for performance Issues.

. Migrated Non-ASM to ASM.

. Created Snapshot Database for Testing purpose.

. Configuration of Flash recovery area and usage of Flashback

Technology.

Personal Details:

Name : MOHD IRFAN ALI

Sex : Male

Languages known : English, Urdu, Hindi

Marital Status : Single

Nationality : Indian

E-mail : **************@*****.***

PAN no : CQAPM3438A

Passport no. : G9058494

Contact Mobile no. : +919*********

.

Date:

Place: Hyderabad

Mohd Irfan Ali

COVER LETTER

Dear Hiring Team,

Enclosed please find a copy of my resume, Which Exhibits my extensive

experience in the field of ORACLE DBA. I believe my experience makes me a

particularly strong candidate for a position in your firm because it has

made me extremely self directed yet at the same time, able to work well as

part of a high performance team.

I have an associate degree in information systems, which helps to qualify

me to hold this position. I have extensive knowledge of database

administration and of how the Oracle systems work. I have experience

working with web servers along with a variety of operating systems that

include Windows, Unix and Linux.

I have the ability to install software applications and to make upgrades

when necessary to optimize the performance of your system. I have the

knowledge to customize your system to meet your company's needs and to make

sure your system is user friendly. My experience also includes managing

security to ensure all data is protected.

I am self-motivated with the ability to stay focused and meet deadlines

when working independently. I also have great social skills and function

well as part of a group. I have excellent communication skills and I have

the ability to provide exceptional customer service.

I also possess very strong problem solving skills with the ability to

resolve system issues in a fast and efficient manner. I am dependable,

trustworthy and I have excellent multi-tasking abilities. I have acquired

the skills needed to manage your database systems and I am certain that I

can be a great asset to your company.

You can reach me for an interview by calling +919********* and I look

forward to meeting with you soon to discuss this position in more detail.

Thank you for your consideration.

Sincerely,

Mohd Irfan Ali.

Contact this candidate