RESUME

M.SHANAWAZ

Mobile # +1-847-***-****

E-mail: acef5v@r.postjobfree.com

Linkedin : http://lnkd.in/bnWbmgx

objective:

TO TURN OUT TO BE AN ADEPT IT PROFESSIONAL BY EXPLORING AND DELVING INTO

THE DEPTHS OF DATABASE ADMINISTRATION NEEDS OF AN ORGANIZATION AND TO SEEK

A PROFESSION THAT ALLOWS APPLICATION OF MY KNOWLEDGE AND ALSO GIVES

EXPOSURE TO UPCOMING TECHNOLOGIES.

PROFESSIONAL SYNOPSIS

. Having 9+ years of experience as a Core Oracle Database Administrator

specializing in Production, Development and Testing Environments.

. Proficient in Oracle Database Administration involving installation,

configuration, tuning, backup and recovery of databases along with

database design and management.

. Conversant in analyzing existing systems and procedures, preparing

business continuity plans, designing internal control systems and

facilitate effective decision-making.

. Experienced in Backups, Recovery, Data Guard and RAC.

. Adroit in handling and working on Windows NT/2000/2003 administration,

AIX, LINUX, SOLARIS, HP-UX, LAN and Network administration.

. Extensive Knowledge of all Software like SQL Navigator, TOAD, Lotus

Notes 6.5 & 6.5.1

. An effective communicator with excellent relationship building &

interpersonal skills.

CORE COMPETENCY

DATABASE ADMINISTRATION

. Managing Oracle database administration function involving:

. Installation, configuration, upgradation of Oracle server software

and evaluation of the hardware.

. Database security viz. enrolling users, profiles, roles and user

rights management.

. Creation & administration of all database objects, including

tables, indexes, views, sequences, packages, procedures and

database replication.

. Database tuning, performance monitoring and troubleshooting.

. Resolutions of database start up problems and database

reorganization.

. Experienced in Hot and Cold backups, Recovery, Data Guard, RAC and

OEM.

. Disaster Recovery Management, supervising technical team to restore

database in-case of system failure.

. Designing Backup Strategy & ensuring scheduled / unscheduled backups

as per the backup plan.

Technical Expertise:

. OPERATING SYSTEMS: MICROSOFT WINDOWS NT/2000/2003, IBM AIX 5.3, SUN

SOLARIS 5.10, HP-UX 11.11, LINUX (RH/AS), NOVELL NETWARE 4.1 & MS-DOS.

. LANG/ TECH: C, C++, PL/SQL and UNIX Shell Scripting.

. DATABASES: Oracle 8i/9i/10g/11g.

. TOOLS: SQL developer, SQL Navigator, TOAD, Legato backup, VERITAS net

backup.

Education:

. BACHELOR OF COMPUTER APPLICATION (BCA), TEXCITY ARTS & SCIENCE

COLLEGE, COIMBATORE, INDIA

CertificationS:

. ORACLE CERTIFIED PROFESSIONAL IN ORACLE DATABASE 10G ADMINISTRATOR.

. Oracle Certified Expert in Oracle RAC 10g administrator.

ACHIVEMENTS:

. BEST LOCATION ENGINEER AWARD FOR STABLE SUPPORT AND EFFORTS IN

COMPLETING TECHNICAL WORKS.

. Achievement Award for the DR drill and technical activities.

. Dream Team Award from Wipro Technology Services.

Professional Training and workshops:

. CORPORATE TRAINING PROGRAM ON ORACLE 10G ADMINISTRATION NEW FEATURES

IN ORACLE CORPORATION LIMITED.

. Corporate Training program on Oracle 10g RAC Administration in Oracle

Corporation Limited.

. Corporate Training program on Oracle 10g performance tuning in Oracle

Corporation Limited.

organisational Experience:

WIPRO TECHNOLOGIES,

Chennai, India (Mar 2010 to Dec 2013)

Vernon Hills, IL, USA (Dec 2013 to till date)

Technical Consultant

. Working as a Technical Consultant (Team Lead - Oracle DBA).

. Handled ERP database sizes of morethan 5 TB database 24 * 7 production

supports (PROD/ DEV/UAT).

. Provided level 3 support to database issues as per defined SLAs.

. Ensured day-to-day administration and support for the Information

Technology environment to maximize system availability for our

clients.

. Applying rolling patches on RAC instances.

. Installation, configuration, and managing Oracle 12c cloud control.

. Knowledge on golden gate and Oracle Exadata.

. Control files, Redo log files, and Data files are re-located to new

file system in RAC environment.

. Performing Database Reorganization, Tablespace reorganization and file

system reorganization to reclaim space OS level.

. Performed table refresh using transport tablespace/network link method

in data pump.

. Unix Shell Scripting to monitor critical oracle processes for high

availability and scheduling to automate the process.

. Continuity of Business is the lifeline activity for OLTP environment

to performing COB fail-over and switchback on the production

databases.

. Implemented EM alerts to monitor the database to ensure maximum

availability and peak performance.

. Performed Environment maintenance activities like monitoring CPU Load,

Disk Space and Memory.

. Developed, documented and enforced database standards and procedures.

Oracle 11g, OEM 12c, RAC, Data Guard

Mphasis an HP Company, Chennai, India

Senior Oracle DBA

Sep 2008 - Mar 2010

. Worked as a Lead Infrastructure Engineer (Oracle DBA).

. Handled 1300+ database sizes of 3 TB database 24 * 7 production

supports (PROD/ DEV/UAT).

. Provided level 3 support to database issues as per defined SLAs.

. Ensured day-to-day administration and support for the Information

Technology environment to maximize system availability for our clients

and users.

. Primary task is to handle the Remedy ticketing tool to solve the

oracle issues with the phase of Incident management, Change management

and Problem management.

. Responsible for scheduling appropriate changes for the servers and

implement that with the proper approval at the scheduled time.

. As part of team which works on identifying the defects and performing

the Root Cause analysis to avoid repeated issues in future.

. Experienced in data Backups, Restore/Recovery activity on many

critical production databases with and without using RMAN.

. Experienced in database/host migration and Refreshing DB from prod to

DEV/UAT Env using Exp/Imp and data pump.

. Wrote procedures documenting step-by-step instructions for backup

strategy for other DBAs to implement for future development

deployments.

. As an On call DBA, resolved successfully priority incidents and

received appreciation from service management.

. Contacting Oracle Metalink support in case of major technical

assistance.

. Support meetings as Oracle DBA representative.

. Mentor junior DBAs on maintenance and monitoring tasks.

Oracle 7/8i/9i/10g, OEM, RAC, DATA GUARD

Wipro Infotech, Mysore, India

Oracle DBA

March 2007 - September 2008

. Worked as an Eng. Database Administration (Oracle DBA).

. Managed more than 250 production & development database in 24 * 7.

. Configured and maintained Data Guard (Physical Standby database) for

the production database and tested for Switchover, Fail over,

activating the standby to primary and zero data loss.

. Managing and Monitoring Database growth like Tablespace & Disk space

Usage and taking proper actions.

. Monitoring the database with dynamic performance views/ Statspack/

OEM.

. Work with the team to automate reactive procedures where possible, and

to promote rapid response to known issues.

. Work with other teams to promote changes to production and other

environments.

. Performing Online & Offline backups using RMAN, Oracle import /

export as a method of recovering data or individual objects.

. Troubleshooting Network connectivity issues various performance issues

as reported by clients.

. Configuring, Managing and resolving issues in Standby databases.

. Experiences in Oracle Enterprise Manager (OEM), writing scripts

through SQL, patch applying, and DB Cloning.

Oracle 8i/9i/10g, OEM, RAC, DATA GUARD

Wipro Infotech, Chennai, India

Oracle DBA

March 2005 - March 2007

. Worked as an Engineer Trainee (Oracle DBA).

. Supported 8 Production Database sizes of 350 GB & 24 GB RAM, 2

Development and 1 UAT databases in banking sector.

. Used the standby database for doing different operations like taking

backups, recoveries, collecting statistics and running various reports

without disturbing the production database.

. Monitoring Cold, Hot backup scripts of the databases supporting

different applications.

. Do Database Reorganization regularly for removing row migrations and

fragmentation using export and import utilities.

. Taking care of tablespace related issues like increasing the storage

parameter values, resizing the datafiles, adding new datafiles etc.

. Solving different database related issues like taking care of

different processes consuming high CPU resources, listener and connect

string etc..

. QAing the deliveries, Releases, and patches before applying them in

the production and UT envs.

Oracle 9i, RAC

PERSONAL PROFILE:

Date of birth / Age : April 27, 1983 / 31 years

Sex : Male

Marital Status : Single

Languages Known : English, Tamil, Urdu and Hindi

Passport Number : F8358101

Visa : H1B

Expires on : 30-Sep-2015

DECLARATION

I hereby declare that the above information is true to the best of my

knowledge and belief.

Place: Mundelein, IL

Date:

[M.SHANAWAZ][pic]

Contact this candidate