Email: abl9h1@r.postjobfree.com

Contact no: 423-***-****

WORK SUMMARY

Manjula Gandhi has four years of experience as an ORACLE DBA In MINDTREE

Ltd & an Oracle Certified Professional (OCP certified) from Oracle

University. She has exposure to SQL Server as well. Manjula possesses the

skills to quickly adapt to any environment during any point of the project

cycle and provide efficient response to company deadlines and system

complications. Manjula is an energetic self-starter with excellent

organizational, analytical, and creative skills with an extremely in-depth

knowledge of the Oracle database and other products.

COMPUTER PROFICIENCY

. Oracle 8i, 9i & 10g DBA & MS SQL Server

. Installation, configuration and upgrading of Oracle server software and

related products in Unix (Sun Solaris 10) and Windows

. Evaluate Oracle features and Oracle related products

. Establish and maintain sound backup and recovery policies and procedures

. Disaster Recovery - Data Guard and RMAN

. Take care of the Database design and implementation

. Perform database tuning and performance monitoring

. Implement and maintain database security (create and maintain users and

roles, assign privileges)

. Patch Management and Version Control

. High Availability - Real Application Clusters (RAC) & Automatic storage

management (ASM)

. SQL and PL/SQL

. Exposure to SQL server

. Setup and maintain documentation and standards

. Plan growth and changes (capacity planning)

. Work as part of a team and provide 24x7 support when required

. Perform general technical trouble shooting and give consultation to

development teams

. Interface with Oracle Corporation for technical support.

. PVCS Management

. Training and Mentoring

TECHNICAL SKILLS

Database Oracle 8i, 9i & 10g & MS SQL server

Operation System Unix(Solaris 10, Linux), MS Windows

95/NT/2000/XP

Languages C, Shell Scripting, SQL, PL/SQL,

HTML, Java Script, XML

Workflow tools MS-Excel, MS-Word, MS-PowerPoint,

MS-Visio2000

EDUCATION

. Bachelor of Engineering in Electronics & Communication from Anna

University, India.

. OCP (Oracle certified Professional) certified in ORACLE 9i from ORACLE

University, India.

WORK AUTHORIZATION

. Valid Work Permit

PROFESSIONAL EXPERIENCE

Project #1

Client: ADVENNET Technologies

Project: MWATCH

Duration: December 2009 - Till Date

Role: SQL Server DBA Consultant

Description: An innovative approach to monitor & notify for ERP systems,

IMS (Infrastructure Management Solution) to monitor servers & Service desk

plus to notify help desk team. MWatch stands for Monitor Measure Maximize.

A tool developed by an 8 member team led by Manjula as a module lead. Today

it is one of the powerful tools used by Mindtree organization to track all

the major servers, as well getting popular in market.

Responsibilities:

. Involved in planning, designing & implementing the tool

. Maintaining MS SQL Server by creating database & instances

. Integrating IMS with Service desk plus

. Installing & configuring Microsoft exchange server with service desk

plus

. Documentation of the entire product end-to-end release

Project #2

Client: Cadence Design System

Module: EDAONTAP

Duration: September 2006 - December 2009

Role: Oracle DBA Consultant

Description: Edaontap application is a mission critical Online Transaction

Processing application (OLTP) used by the customers to book orders and

order products/licenses from Cadence. Edaontap helps in storing the

transaction information in the database and also helps in generating

licenses for the various products those customers own. Users of Edaontap

login to the system on a periodic basis to know the configuration for any

given customer or an order. There are various reporting requests such as

total orders booked in Edaontap in a given quarter etc. The Edaontap is an

incremental Product developed on top of existing application to cater to

the online order processing of Cadence design tools. This module deals with

creating perpetual or 99- year order for privileged customer of Cadence. It

processes the perpetual order in interactions with other systems like

Credit Check in SAP and CRM systems. The application is purely J2EE based

build using struts framework, EJB and Web Methods

Responsibilities:

Responsible for the installation, upgrades, and maintenance of all phases

of an Oracle Database Servers on UNIX based SUN client/server environment.

Improved and administered the existing Oracle databases and applications.

Responsible for internet and intranet web page development and programming

Setting up of DB Servers for every Release, which Includes Database Refresh

from Production for Assembly Test, System Test and Regression test.

Planning Releases and preparing Environment calendar for parallel Releases

which include the following tasks:

. Responsible for installation, upgrade, refreshing, account management,

backup/recovery, performance tuning of Oracle 8i, 9i & 10g databases

on Solaris & windows

. Responsible for providing 24x7 support for test servers & production

Oracle databases

. Installing and upgrading the database server and application tools

. Plan for backup, recovery, and restoring the database

. Control and monitor user access to database; monitor and optimize the

performance of database

. Allocate system storage using automatic storage management (ASM) and

plan for future storage requirements for the database system

. Provide technical resolution to Oracle database related problems

. Create primary database storage structures and primary objects

. Assisted in logical and physical database design

. Developed & modified some Oracle backup and recovery by using shell

scripts. Used Oracle backup utility RMAN to implement Oracle backup

and performed recovery.

. Implemented database refresh with the hot backup using DUPLICATE or

full export. Used EXPORT/IMPORT to do table level and full database

defragmentation.

. Developing Unix shell scripts and SQL scripts to carry out routine

checks on databases. This includes checking whether all databases are

running, listener is running, Unix error messages, disk space

availability, checking for errors in alert logs and trace files, etc.

. Setting up the local DB Servers for the team using both OS (windows &

Solaris)

. Managing App Servers of ATG and Web sphere

. Managing Web Servers of ATG and Web sphere

. Building and deploying the ATG & Web sphere code

. Handling web method servers for each application

. PVCS management - Creating Branch for the specific release, User

management, Merging the code

. Generating crystal reports using BOE server.

. Upgrading JDK or Java version on Solaris

PERSONAL DETAILS

Contact Details

Email : abl9h1@r.postjobfree.com

Conatct no. : 423-***-****

Contact Address : 936 Mountain Creek Road

Chattanooga, TN - 37405

United States of America

Nationality and Passport Details

Nationality : Indian

Passport No : G4761421

Issued by : Govt of India

Place of Issue : Chennai

Valid Till : August 21, 2017

[pic]

Contact this candidate