Manager Oracle

Meenarani R Rani Phone:

*************@*******.*** 314-***-****

EXECUTIVE SUMMARY

Over five years of experience in IT industry, of which 3 years have been as

an Oracle DBA along with Oracle Development. Extensive experience in

handling DBA duties such as Creation, Implementation, Monitoring,

Performance Tuning and maintenance of the Oracle RDBMS v11g, 10g, 9.x and

8.x in large production environments. Strengths include Oracle database

management with an emphasis on operational excellence in a large corporate

setting, fulfilling various roles in the full cycle of application

development, analysis and modeling with various types of diagram techniques

such as DFD (Data Flow Diagramming), and ERD (Entity Relationship

Diagramming), ability to easily shift between general and detail levels,

ability to communicate with technical and business specialists in terms and

expressions comfortable to them, and a strong aptitude for learning new

technologies.

TECHNICAL EXPERTISE

Languages SQL, SQL Plus, C,C++, COBOL, Unix Shell

Script, Java,PL/SQL 8.0. Experience with

HTML, awk, sed, Perl, Java

script,VBScript,JavaScript,VB6.0,ASP

2.0,ASP.net,C#

Operating Systems Sun Solaris 2.10, HP/UX 11.00, AIX 4.3.4,Red

Hat Linux 6.2/7.1, Windows NT4.0/2000

Database ORACLE (Version 8i, 9i, 10g,11g), SQL SERVER

2000, MS Access

Tools Oracle 11g/10g Grid Contol,Oracle Enterprise

Manager, SQL Navigator/TOAD, ERWIN, TOAD, SQL

Navigator, Quest SQL Lab, Quest Q Designer,

Oracle Recovery Manager (RMAN), EXPDP/IMPDP,

SQL*Loader, Netbackup, Srvctl, Cluvfy and

Symantec Indepth for oracle.

Monsanto Jan 2010 -

Present

St.louis, MO

Oracle DBA

Monsanto is an agricultural company. They apply innovation and technology

to help farmers around the world produce more while conserving more.

Helping farmers grow yield sustainably so they can be successful, produce

healthier foods, better animal feeds and more fiber, while also reducing

agriculture's impact on our environment.

Responsiblities:

. Upgraded 5 databases to 11g from 10.2.0.4

. Installed 11g and ASM on 10 AIX LPARs

. Tuned sql statements to reduce the elapse time by a factor of 2X

. Implemented partition strategy for a billion record table

. Wrote procedure for numerous database maintenance tasks : Password

Compliance, Sarbenes Oxley Audit Controls, maintaining one year of

audit data

Environment: Oracle 11gR1, 10gR2 on AIX 5.3, ASM, RAC, SQL*PLUS, PL/SQL,

Expdp, Impdp, ADDM, AWR, srvctl, cluvfy, SQL*Loader, Net8, Server Manager,

10G Grid Control, and Enterprise Manager, Toad, SQL Developer, and Oracle

Enterprise Manager (OEM)

Barnes & Noble College Booksellers Mar

2007 - Dec 2008

Basking Ridge, NJ

Oracle DBA

Barnes & Noble College Booksellers, nation's largest booksellers and top

retail brand for overall quality and the leading provider of bookstore

contract management committed to delivering superior service, technology

that enables over 500 college and university campuses nationwide to

integrate their financial and course information as it relates to Text

books and general merchandise, and online shopping services.

Responsiblities:

. Managed multi-node Oracle cluster technology RAC, version 10gR2

. Configured and multiplexed voting and OCR disks

. Worked on ASM.Configured ASM on raw devices.

. Configured files such as control files and Server parameter file

(SPFILE) on ASM

. Implemented RMAN backup startegy for Production and Staging

environment. Implemented RMAN policy for Media management using

Netbackup

. Implemented full and incremental backups in RMAN

. Expertise on duplicating (cloning) database using RMAN

. Implemented Data pump technology for logical backup purpose

. Performed complete recovery of production databases in several

scenarios using various techniques

. Worked on 10G OEM to monitor multiple databases

. Refresh Test Schemas using Datapump Utility

. Applying patches to the staging and production databases

. Application development support to programmers on all aspects of

database programming

. Implemented Heterogenous connectivity using Oracle Transparent Gateway

. Generated and analyzed ADDM and AWR reports to improve the database

performance.

. Worked on Cluster administration tools such as Server Control(SRVCTL),

Oracle interface configuration (OIFCFG), OCR dump (OCRDUMP), and so on

. Exposure of taking OCR backups and recovery of OCRDUMP

. Created standby database (for Business Continuity Process) using RMAN

. Independently managed Oracle TARs, interacting with Oracle support

personnel for issue resolution

. Wrote stored procedures using BULK COLLECT to retrieve data from

AS/400 into oracle tables

Environment: Oracle 10gR2 on Sun Solaris 5.10, Solaris X86, ASM, RAC,

SQL*PLUS, PL/SQL, Expdp, Impdp, ADDM, AWR, srvctl, cluvfy, SQL*Loader,

Net8, Server Manager, 10G Grid Control, and Enterprise Manager, Toad, SQL

Developer, and Oracle Enterprise Manager (OEM)

National Association of Insurance Commissioners Feb

2006 - Feb 2007

Kansas City, MO

Oracle DBA

National Association of Insurance Commissioners assists state insurance

regulators, individually and collectively, in serving the public interest

and achieving the fundamental insurance regulatory goals such as

facilitating the fair and equitable treatment of insurance consumers,

promoting the reliability, solvency and financial solidity of insurance

institution, supporting and improving state regulation of insurance in a

responsive, efficient and cost effective manner.

Responsiblities:

. Identified application SQL statements performance problems using 10G

Grid Control ADDM, AWR, active session history and resolved them using

SQL tuning advisor, and SQL access advisor.

. Conducted performance meeting to report health and load metrics of the

database to the application teams.

. Generated top SQL statements report for each of the application areas

and reported in a form of Performance Analysis Report, along with cost

benefit factor to show the importance of resolving the performance

issue.

. Tuned top ten SQL statements to reduce overall system resources by

10%.

. Helped Oracle Developer to rewrite 5 critical OLTP sql statements for

better performance.

. Implemented partition schema for very large tables for availability

and performance.

. Rewrote re-organization of tables procedures for 10GR2 version.

Environment: Oracle 10gR2 on HP-UX11.11, ASM, SQL*PLUS, PL/SQL, Expdp,

Impdp, ADDM, AWR, 10G Grid Control, TOAD, SQL Navigator, and Oracle

Enterprise Manager (OEM)

Indiainfo.COM - Internet Portal for India Sep

2001 - Mar 2003

Developer/ DBA

Indiainfo.com is an e-Portal offering search services with a large business

oriented corporations. The portal provides the following E-services: e-

commerce activities such as online stores, Business news such as Stock

quotes, business news etc. The portal also includes India National and

Regional news, weather, e-mail services and Message forums.

Responsibilities:

. Provided development, test, QA and production databases support for

the 10+ applications.

. Maintained application schemas, logging schema changes, and schema

version.

. Performed file I/O load balancing by moving around the files on the

available physical drives.

. Wrote UNIX shell scripts for automating the backups/restores/recovery.

. Implemented business logic using oracle database triggers and stored

procedures/packages.

. Wrote SQL/LOADER scripts to load external vendor datas into data

warehouse tables.

. Carried out upgrades and applying patches to the Oracle software and

databases.

. Monitored databases using OEM. Created events and scheduled jobs and

fixit jobs according to the events.

. Other miscellaneous responsibilities include instance SGA tuning,

query tuning, identifying and dropping the unused indexes, creating

new indexes to improve the performance and contacting Oracle Customer

Support etc.

Environment: Sun Solaris v5,6, HP-UX v11.00, Oracle RDBMS v8, 7, Net 8, Win

NT, OEM v2.1.0

Motorola India Electronics Ltd. Feb 20001 -

Aug 2001

Developer/DBA

Motorola is a global communications leader, powered by, and driving,

seamless mobility. Motorola is revolutionizing broadband, embedded systems

and wireless networks - bringing cutting-edge technologies into your

everyday life, with style. As Developer/DBA, developed Intranet systems.

Responsibilities:

. Involved in creation of database objects, backend packages, functions,

triggers, schema and maintain system security using privileges and

roles.

. Created/modified database storage structures such as Data Tablespaces,

Index Tablespaces, Rollback Tablespace, rollback Segments and

allocated system storage. Performance forecasting of future storage

requirements for the databases.

. Worked on migration of the database and its data from windows to a new

Unix system. This involved in doing an full export and import of the

database into the unix system. Verified the object counts between two

systems. Set up monitoring and Oracle Full / Incremental Export of the

Database.

. Developed procedures to load data using SQL loader with Direct/

conventional/ parallel modes.

. Responsible for supporting and managing database activities during the

development cycle.

. Designed and developed intranet systems using Oracle Forms 3.0/Korn

Shell and PL/SQL.

. Environment: Oracle 8.0 on Sun Solaris 2.6, Designer 2000, Developer

2000.

Education:

. Master's Degree in Computer Applications from Madurai Kamaraj

University, India - GPA 3.6

. Bachelor's Degree in Mathematics from Lady Doak College, Madurai,

India - GPA 3.7

Contact this candidate