Manager Oracle

NEELIMA SHANDILYA

E-MAIL: *********@*******.***

Phone: 347-***-****

____________________________________________________________________________

_____________________

OBJECTIVE Oracle Database Administration

SUMMARY OF QUALIFICATIONS

. 19 years of IT experience with proven background of technical problem

solving.

. Over 12 years of Oracle DBA experience in Oracle 10g/9i/8i/7.3

installation, configuration, Upgrade, Maintenance, Performance tuning,

backup & recovery, troubleshooting of custom databases of sizes over

500 GB in UNIX environment.

. Oracle 8i CERTIFIED PROFESSIONAL DATABASE ADMININISTRATOR, 2003.

. CERTIFIED SYSTEM ADMINISTRATOR (SA 1) for Sun Solaris9, 2004.

. Certificate course in APPLICATION SERVER.

. Knowledge of WEBSPHERE, INFORMATICA and BUSINESS OBJECTS.

. Backup, Recovery, Cloning using SQLBacktrack and RMAN

. Experience of Data Guard and standby database for High Availability of

databases.

. Experience of Veritas Cluster Server

. Database Tuning - Tuning Databases, Applications, Tuning Memory and

Tuning Disk Usage

. Configuring, starting and maintaining application servers, web servers

and process schedulers on PeopleSoft application

. Experience in programming skills using SQL*PLUS, PL/SQL, Unix Shell

Scripts.

. Knowledge of database features like OEM, Logminer, dbverify, TKPROF,

Oracle Streams

. Knowledge of SQLT for performance analysis and tuning

. Experience in Unix Administration, Patch application, User

maintenance, Performance Monitoring of CPU, Disk and Memory usage,

Shell scripting, security and File system maintenance.

. Write monitoring/health check scripts to alert team of database

uptime/downtime status, ORA errors, sizing issues, which ensured

availability 99.98% of the time.

. A self-motivated, responsible and reliable team player with a set of

strong technical skills.

. Excellent communication skills and the ability to work independently

or in a team environment

TECHNICAL SUMMARY

. Databases : Oracle 7.3, 8.0, 9i, 10g, Acess

. Operating Systems : Unix, Linux, Windows

. Data Tools : PL/SQL, SQL Programming, Shell scripting,

TKPROF, Oracle Enterprise Manager,

Informatica, Business Objects,

Data Guard, Logminer, SQLT

. Backup Tools : RMAN, Exp/Imp, SQLBacktrack

. Languages : SQL, PL/SQL, C, C++, HTML, Unix Shell Scripts.

. ERP : Peoplesoft and Wizard.

. Other software : Remedy, Autosys, TOAD

PROFESSIONAL EXPERIENCE

October 2005 - Present

UBS, New York

Senior DBA Technical Specialist

Specific Responsibilities:

Database

. Creation, administration, documentation, maintenance, patching,

troubleshooting and deletion of Oracle 10g databases on UNIX

platforms (Solaris)

. Storage administration ( SAN RAID1, SAN RAID5), backups, exports and

imports and monitoring, auditing, cloning and managing the Disaster

Recovery Solutions

. Design, maintenance and troubleshooting of RMAN/SQLBactrack backup

programs including scripts

. Design, maintenance and troubleshooting of complex database-to-

database refresh scripts on Solaris

. Dedicated support of the Production, QA and UAT and Development

environments for more than 40 databases.

. Use of Grid Control to administer multiple databases, cluster and

stand alone databases.

. Migration of aging databases to modern hardware and software

. Configure, administer and monitor Oracle Streams

. Work with the application development teams resolve issues and tune

databases for optimal performance

. Ensure that releases and configurations changes to the environments

have gone through the required change management process

. Ensure that the databases are kept in accordance with the banks

software policies and contribute to implementation of version

upgrades

. Working with the architecture team, help determine and implement

best practices for database setup, monitoring, backup and recovery,

installation, tuning, auditing.

. Use of BMC Remedy Incident and Change Management Tool

. Security auditing and remediation. Set up and support DARS for

database auditing

. Support Veritas Cluster Sever - high availability software for

redundancy

. Support Oracle Data Guard

. Knowledge of SQLT for performance analysis and tuning

. Monitor database growth and provide database capacity planning.

. High availability, 24/7, clusters, standby database

. Increased company's database performance to run 4 times faster.

Others:

. Involved in level 3 support for the applications : Websphere,

Informatica, autosys and Business objects

. Stopping and starting Websphere servers in a cluster

. Creation, monitoring, start/stop of Autosys jobs

. Monitor informatica jobs

. Unix shell scripting for pro-active database monitoring

Environment: Oracle 10.2.0.3 on Veritas Cluster Server, SunOS 5.10 (4.3),

Grid Control, Data Guard, SQLBacktrack, RMAN, Websphere 6.0, Linux,

Informatica, Autosys, Business Objects/Intelligence, WebI

March 2005 - July 2005

Convergys

Sr. Analyst.

Responsibilities:

. Cloned databases to support disaster recovery and upgrade process.

. Worked on multi-tier client/server models using Web servers,

application servers with BEA/Tuxedo.

. Monitor the job and process summary and details for the process

scheduler server queues related to PeopleSoft application database.

. Creating configuration files for process schedulers, web servers and

application servers.

. Process Scheduler, Application Server, and Web Server Error resolution

at startup and shutdown.

. Ability to manage application security within the PeopleSoft HRMS

application and outside of the application, specifically at an Oracle

database level.

. Administration and review of the processes through the Process

Monitor.

. Perform daily database administration tasks: User management, Space

monitoring, Performance monitoring and tuning, Alert Log monitoring

and backup monitoring.

. Managing database security by creating and assigning appropriate

roles, privileges and profiles to users. Managed security at the OS

level also.

. Wrote scripts to monitor user activity and logons at both the database

level and system level.

. Configured network parameters so that database clients and tools can

communicate with the Oracle database server.

. Wrote scripts, triggers, procedures, packages and generate/post

reports to the web site.

. Perform efficiently all DBA tasks using commands and also using Oracle

Enterprise Manager.

. Use Statspack to generate reports, and review the performance of the

database.

. Pinning of Packages, procedures and functions in SGA.

. Proficient in SQL trace, TKPROF and logminer utility.

. Configure the RMAN Repository, backup configurations and run

maintenance commands to crosscheck backups, to change availability

status etc.

Environment: Oracle 9.2.0.1.0, Sun Solaris 5.8, PeopleSoft, TOAD, RMAN,

OEM, Shell Scripts, Windows 2K/NT, STATSPACK

June 2003 to Jan 2005

Integrated, Noida

Senior Oracle Database Administrator

Responsibilities:

. Installation of Oracle Server 8i/9i.

. Database Installations, Creations and Upgrades of 9.2.0.4 on Sun

Solaris 2.8.

. Administering, managing and ensuring smooth working of 10 Oracle

Production Instances with zero downtime.

. Managing data patches. Applied patches for the Oracle Server.

. Space management activities as part of 24*7 Production support and

Planning & administering backup strategies.

. Database migrations/upgrades (8i and 9i). User administration,

Security implementation.

. Used RMAN for backup & recovery. User creations at UNIX level for

Databases.

. Wrote shell scripts for performing database activities such as backup

of DB, automatic shutdown and start up of database and for creating

new table spaces and partitions.

. Implemented automated backup strategy using the UNIX shell script CRON

Utility.

. Backup and Recovery. Monitoring the database and taking required

action as and when needed.

. Writing Stored Procedures for achievement of a task.

. Performance Tuning of the database using TKPROF, STATSPACK for optimum

performance and to meet users requirement. Assisting Developers in

writing and tuning their queries.

Environment:Oracle 9.2/8.1.7.4.1, Sun Solaris, RMAN, Shell, Stored

Procedures, STATSPACK

Jan 1999 to May 2003

Excel Technologies, India

Database Administrator

. General Management: Business development, product management and

development, budgets, performance management, strategy development.

. Installed and implemented several Oracle database and applications for

full live cycle development, test and production.

. Set up hot & cold backups, completed database reorganizations,

performed database audits and implemented performance-tuning

improvements.

. Responsible for providing 24x7 support for production Oracle

databases.

. Managing the Oracle 9i database on Sun Solaris9 with Sun StorEdge

3510 system and H/W controller based RAID-5 Volumes in each T3 array.

. Effectively managed the disaster recovery operations due to hardware

failure on RAID 5 with minimum downtime and protecting the business

requirements in a mission critical enterprise.

. Automate the backup and recovery procedures by writing RMAN scripts

for daily incremental backups and weekly full backups.

. Configured the client, server, device, group and pool resources on

Legato Storage Manager.

. Installed and configured Legato Storage Manager for backups to be

taken to tapes.

. Configure the RMAN Repository, backup configurations and run

maintenance commands to crosscheck backups, to change availability

status etc.

. Automated EXP/IMP procedures.

. Managed performance monitoring and tuning of the database.

Environment: Oracle 8i, Oracle 9i, SQL*Loader, Export, Import, SVRMGRL,

OEM, RMAN, Sun Solaris, window 2K

Feb 1995 to Sept 1998

COMP-U-LEARN

New York, USA

Database Administrator and Trainer

. Creating tablespaces, tables, indexes, users, schemas and maintain

user security.

. Duties included Oracle database administration, monitoring and

performance tuning.

. Managing Database Structure, Storage Allocation, Table/Index segments,

Rollback segments, Constraints, Database Access, Roles and Privileges.

. Planning Backup/Restoration Strategy for 24x7 operation support.

. Planning and scheduling Backups, Database Recovery, taking Logical

Backups (with Export/Import).

. Experience in Oracle Enterprise Manager (OEM).

. Part time instructor for introductory and advanced Oracle courses.

. Load Oracle; configure network files and parameter files.

. Taught courses in Advanced Database, Oracle, Visual Basic, MS Excel,

MS Word and MS access with class audience of an average of 20.

Environment: Oracle 7.3, Oracle 8i, RMAN, Sun Solaris, Windows, OEM

June 1994 to Sept 1998

CONSULATE GENERAL OF INDIA

New York, USA

. Designed MS Access data entry forms for main database for processing

and appending to main Database. Responsible for querying and exporting

data from MS Access to MS Excel and MS Word.

. Designed and developed databases in MS Access for Customer Service,

Collections and servicing departments.

. Designed custom reports with MS Access, MS PowerPoint, MS Word and MS

Excel for sales presentations and management.

. Worked as an official in the commerce section to promote export -

import and resolve disputes relating to commerce.

. Grant of various kinds of certificates, which were created by use of

macros.

Nov 1990 to April 1993

DANTAL HYDRAULICS PVT. LTD.

Danfoss, Denmark distributors

Manager Administration

. Evaluate new hardware and software products for use by the department

staff.

. Determine short and long-range major system applications needs for the

Company.

. Train department staff in the use of computer hardware and software;

develop programs for upgrading the skills of departmental staff.

. Manage system installation and upgrade projects to assure optimal

operation during change over.

Jan 1987 to May 1990

DHEERAJ POLYPACK PVT. LTD.

Bombay, India

Manager, Marketing and Sales

. Demonstrated proficiency in new market development, product marketing,

corporate identity, competitive positioning, marketing communications,

creative direction and profit optimization.

EDUCATION

Graduate from Delhi University, 1981

Bachelor of Science in Computer Information Systems

Contact this candidate