Anna Dhande

[pic]

acoww9@r.postjobfree.com Ph: *72-

***-****

SUMMARY:

Having 8+ years of experience as an Oracle Database Administrator and

performed different tasks like database administration, installation,

configuration, upgrades, patches, performance tuning, backup and recovery,

production support, cloning, space management, database security.

. Excellent experience in Installation and configuration of Oracle 9i,

10g, 11g on a variety of operating systems including UNIX/LINUX,

Solaris and Windows environment.

. Experience in Migration Projects. Hands on experience in-updating from

Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches.

. Experience in Data Warehouse environment.

. Migrated databases using Golden Gate, Transportable tablespace and

Datapump from 9i, 10g to 11g.

. Expertise in maintenance, upgrades, administration, backup and

recovery of Oracle Exadata systems.

. Extensive expreice in using Korn Shell scripts for Regular backup,

instance start and shutdown and for automation

. Installed Oracle 10g RAC software with ASM & OCFS2 File systems.

. Installed, administered, and monitored the GoldenGate on Oracle,

Exadata, and Cloud environment replication

. Oracle RAC Database Administration including Installation,

configuration, Analysis, Design, Backup and Recovery (RMAN).

. Created development, testing, staging, production, RAC and standby

databases for OLTP, DSS and Data Warehousing using customized shell

scripts and stepwise.

. Co-ordinate with UNIX administrators for space managements on various

servers.

. Hot/Cold Backup and Recovery and Cloning of databases using RMAN with

VERITAS Net Backup, IBM TSM & LEGATO Storage Manager.

. Proficiency in Disk management and problem resolving techniques with a

good understanding of Capacity planning and efficient usage of the

disk space.

. Operational Responsibilities - Database refreshes/ backs, security,

documenting standards and procedures, data migration, data clean-up,

copy data archiving, etc.

. Monitoring and management of various database components (logical &

physical) like table- spaces, segments and data files.

. Experience on Data Replication using Snapshot, Materialized views,

import/export.

. Extensive performance tuning activities like Operating System Tuning,

SQL Tuning, Database/Instance Tuning.

. Delivering Oracle Database performance-tuning services for customers

with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.

. Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical

and Physical Database Design, Backup and Recovery procedures.

. Expertise in maintaining Database Security using security compliance

auditing, expertise in loading data from flat files using external

tables, SQL*LOADER.

. Have implemented ORACLE STREAMS.

. Setup, Configured and Maintained Oracle Data Guard to control Primary

and Standby Databases and also to ensure disaster recovery using

various data protection modes.

. Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS,

TOAD and Grid Controlling using OEM

. Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS

TECHNICAL SKILLS:

Operating HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3

Systems Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows

95/98/NT/2000/XP.

RDBMS Oracle 11g/10g/9i/10gRAC.

Languages SQL, PL/SQL, C, C++, C#, VB.NET, JAVA, XML, UNIX Shell

Scripting.

Tools/Utilitie RMAN, OEM, Oracle Management Server, SQL*Loader,

s Export/Import, TOAD, Data pump, MS Access, Data Guard,

Golden Gate 10.4

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR

Hardware Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun

Platforms Enterprise 6500 / 450, HP XP256 / XP512, IBM X series

Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE:

Client : EMC Corporation - NY

Duration : Feb 2014-

Till Date

Role : Sr Oracle DBA

Responsibilities:

. Expert in san storage migration from old storage array to new EMC

storage array with online ASM rebalancing operation.

. Communication with application team owner, Solution Architects, Unix

and Storage team to accomplish successful san storage migration using

online ASM method.

. Hands on experience in building and managing ASM storage for existing

and new database environment.

. Involved during weekend SAN and NAS storage migrations from older to

new storage frames.

. Experienced in generating AWR reports for multiple database

environments manually and using scripts for various time intervals.

. Installation of oracle software and created database using DBCA and

manually.

. Hands on experience using Oracle Enterprise Manager 12C (OEM),

SQL*PLUS, TOAD and Grid Controlling using OEM

. Migrated databases using Golden Gate, Transportable tablespace and

Datapump from 9i, 10g to 11g.

. Monitored the GoldenGate processes, checking the performance using the

GoldenGate Director.

. Worked on databases consolidation into a single database in Exadata.

. Worked on moving Oracle 10g database of a Specialty company which

Cardinal bought into Oracle 11g Exadata.

. Performed Explain Plan analysis for Query Optimization and SQL tuning.

. Performed Database and SQL tuning by using various Tools like

STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

. Restored database on different server with same or different file

system using RMAN technology.

. Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC

(Time finder and SRDF), RAID, RAW Devices.

. Installation, Implementation and Maintenance of the Oracle database.

. Created and managed the database objects such as tables, indexes and

views

. Performed oracle software cloning using dbclone utility to fulfill

business need to keep same software version.

. Created and managing the database storage structures which includes

data table spaces, index table spaces,rollback table spaces and

rollback segments

. Loading the database with SQL*Loader

. To improve the performance by Using the Hints, Indexes, Explain Plan,

Sql Trace and TKPROF for effective retrieval and processing of

queries used for retrieving the data

. Performing the logical and physical structure of tables, indexes,modeling normalization and foreign key constraints.

. Hot/Cold Backup and Recovery and Cloning of databases using RMAN

utility.

. Database maintaining including backups, recovery, imports/exports.

. Expert in scheduling and maintaining various jobs in OEM 12C.

Environment:

Oracle 11gR2/10g/9i, Sun Solaris, Unix, Ignite, Windows NT / 2000, Red Hat

Linux, Oracle E-business suite, TOAD, RMAN, Exadata, SQL server, OEM12C,

Grid Control, Data Guard, STATSPACK,AWR,Explain Plan

Client : Corning Incorporated, Corning-NY

Duration : Jan2012-

Dec 2013

Role : Oracle DBA

Responsibilities:

. Installed and configured Oracle 9i, 10g, 11g on a variety of operating

systems including UNIX/LINUX, Solaris and Windows environment.

. Performed updating from Oracle 9i to 10g (10.2.0), 10g to 11g and

applied oracle patches.

. Organized various migration review meetings with the application team

to discuss the migration strategy based on business requirements.

. Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File

systems

. Oracle RAC Database Administration including Installation,

configuration, Analysis, Design, Backup and Recovery (RMAN).

. Performed day to day DBA activities on Oracle 9i, 10g, 11g database .

. Created development, testing, staging, production, RAC and standby

databases for OLTP, DSS and Data Warehousing using customized shell

scripts and stepwise.

. Provided estimation for new environment database storage with UNIX

administrators for space managements on various servers.

. Implemented Data guard, Golden Gate, Streams for faster Disaster

Recovery.

. Performed backup and recovery of GoldenGate replication and

administrated GoldenGate replication security

. Worked on setting up Data Guard on RAC in Oracle 11g & Exadata.

. Managed patching and upgrade of Exadata Storage Server's.

. Experienced in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and

Physical Database Design, Backup and Recovery procedures.

. Database maintaining including backups, recovery, imports/exports and

Exadata.

. Proficiency in Disk management and problem resolving techniques with a

good understanding of Capacity planning and efficient usage of the

disk space.

. Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS,

TOAD and Grid Controlling using OEM

. Database refreshes/ backs, security, documenting standards and

procedures, data migration, data clean-up, copy data archiving, etc.

. Monitored and managed various database components (logical & physical)

like table- spaces, segments and data files.

. Experienced on Data Replication using Snapshot, Materialized views,

import/export.

. Performance tuning activities like Operating System Tuning, SQL

Tuning, Database/Instance Tuning.

. Delivered Oracle Database performance-tuning services for customers

with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.

Environment:

Oracle 11g/10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, Oracle E-

business suite, TOAD, RMAN, SQL server, Exadata, OEM, Grid Control, Data

Guard, STATSPACK,AWR,Explain Plan.

Client : Bank of America, charlotte-NC

Duration : Dec2010-

Nov2011

Role : Oracle DBA

Responsibilities:

. 24x7 production support for several mission critical systems which

utilize multiple Oracle databases.

. Performed day to day DBA activities on Oracle 9i, 10g, 11g database

. Performed migration from 9i to 10g from AIX to Linux.

. Coordinate with UNIX administrators for space management on various

servers.

. Installed Oracle 9i and 10g, 11g RAC database on Red Hat Linux.

. Installed RAC on Oracle 10g and worked on ASM feature of Oracle

. Installation of ASM into various storage parameters like SAN and NAS.

. Installation, Configuration and Maintenance of Oracle RDBMS Software.

. Upgrading databases to Oracle 11g from Oracle 10g.

. Creating and maintaining the Oracle databases.

. Created and managing the database objects such as tables, indexes and

views.

. Table Partitioning, creating Index Organized tables, Creating Locally

managed Table spaces.

. Unix Shell scripting in (cshell)csh, (korn shell)ksh for automating

startup/shutdown of databases, getting system alerts.

. Applying patches both Server side and Client side.

. Setting up new environments (Development, Production etc).

. Database Sizing, Tablespace Management and Rollback Tablespace

Management, Transaction Management and Security Administration

. Worked in data ware house environment.

. Created Users, Groups, Roles, Profiles and assigned users to groups

and granted privileges and permissions to appropriate groups.

. Manage users, privileges, profiles, schemas using Grid Control of

Oracle Enterprise Manager.

. Worked with application developers to debug PL/SQL procedure, tune

queries and database sizing.

. Installed and Implemented Backup & Recovery procedures. Implement Hot,

Cold and Logical backup plans.

. Worked on import/export and SQL- loader.

. Setup backup and recovery procedures using RMAN.

. Involved in I/O tuning by moving data files and redo log files to

faster disks.

. Used analyze table, analyze indexes to tune queries and increase

performance.

. Used hints for SQL tuning and optimization.

. Created the conceptual model for the data warehouse with emphasis on

insurance (life and health), mutual funds and annuity using

EMBARCADERO ER Studio data modeling tool.

. Expanded Physical Data Model (PDM) for the OLTP application using

Erwin

Environment:

Oracle 11g/10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, Oracle E-

business suite, TOAD, RMAN, SQL server, OEM, Grid Control, Data Guard,

STATSPACK,AWR,Explain Plan.

Client : T-Mobile, Atlanta -GA

Duration : Aug 2009 - Nov 2010

Role : Oracle DBA

Roles and Responsibilities:

. Performing all the Database Administration activity like space

management in database, user and roles administration, schema

management, checking alert log of all the databases using OEM.

. Installed RAC on Oracle 10g and worked on OCFS2 feature of Oracle

. Provided instance level performance monitoring and tuning for Event

Waits, Sessions, Physical and Logical IO and Memory Usage.

. Performance Tuning i.e. tuning applications, shared pool, I/O

distribution, rollback segments, buffer cache, redo mechanisms

. Created database design according to the requirement of Application

Software, monitored and configured databases.

. Involved in numerous Unix Korn Shell Scripting pertaining to the

activities of the DBA

. Configured Oracle data guard and Streams.

. Made performance improvements to the database by building Partitioned

tables, Index Organized Tables, Materialized Views and Bitmap Indexes.

. Supported development effort by providing SQL statement tuning and

optimizing ETL procedures and removing load and query performance

bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and

Oracle Enterprise Manager.

. Performance tuning of Queries by maintaining Aggregates, Compression,

partition, indexing and use of Hints, Stored outlines, Statistics for

the same.

. Created Users, Groups, Roles, Profiles and assigned users to groups

and granted privileges and permissions to appropriate groups.

. Estimate the size of the database and its objects (in large database

of 1 to 2 Terabyte).

. Devised & Implemented backup strategies using hot, cold, and exports

based on the business requirements.

. Implemented Backup-using RMAN (Recovery Manager) as a media management

layer.

. Used SQL*Loader for loading legacy systems database data.

. Installed and configured Oracle 10g database on a test server using

Oracle standard procedures and OFA, for performance testing and future

10g production implementation.

. Cloned schemas, objects and data on new server using exports from 9i

database and imported in 10g using Oracle data pumps.

. Troubleshooting of various database performances by proper

diagnosis at all levels like SQL, PL/SQL, database design, database

tables, indexes, Instance, memory, operating system and java calls.

. Developed UNIX shell scripts to perform the above tasks efficiently.

Environment:

Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, PL/SQL, Toad, Pl/SQL

Developer, Erwin, RHEL 4.2, HPUX, Windows 2003.

Client : Wyeth, Malvern-PA

Duration : Jan 2009 - Jul 2009

Role : Oracle DBA

Responsibilities:

. Installation and creation of Oracle 9i databases on Production and Test

Linux servers. Responsible for upgrade & migrating databases from 9i to

10g, applying patches.

. Refresh test database from production using Recovery Manager (RMAN).

. Troubleshoot databases, provide reports on the database health check,

follow up and recommendations.

. Great experience in using FTP utility program for copying files on UNIX

and Windows systems.

. Responsible for configuring database memory structure, managing storage

allocation, creating user accounts, roles and privileges for DB

operations and security maintenance.

. Responsible for monitoring and estimating the size of the database &

growth, and configuring the database accordingly.

. Responsible configuring listeners for network connectivity and security.

. Diagnose and resolve performance, connectivity, security and database

corruption issues in a critical production environment.

. Responsible for taking regular backups including cold / hot backups,

Export / Import of database, using RMAN, and recovery in case of

disasters.

. Automated monitoring the databases, performance parameters, backup and

recovery activities by running Cron jobs and various Unix Shell Scripts

in sending Email for ORA- errors, reports for Quick Morning Check (QMC),

move Archive Logs to different mount point when Archive Destination is

full and Resync RMAN catalog.

. Creation and maintenance of stand by database by using oracle high

availability method Oracle Data Guard.

. Interacted with data modelers, developers, application owners for

gathering the required information and resolving various issues.

Environment:

Oracle 9i / 10g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX,

Solaris, Windows XP

Client : CSC, Bangalore - India.

Duration : Jan 2008 - Nov 2008

Role : Oracle DBA

Responsibilities:

. Developed PL/SQL packages, stored procedures, functions, Cursors,

triggers.

. Responsible for installing, upgrading and configuring the Oracle

server.

. Creating databases, objects, roles and privileges.

. Partitioned large tables to increase the performance.

. Configured scripts to monitor activity with database.

. Responsible for optimizing the queries and application tuning.

. Implement Hot, Cold and Logical backup plans.

. Designed backup and recovery procedures for OLTP system

. Use TOAD tool to access the database

. Used PL/SQL developer to create PL/SQL Procedures

. Testing PL/SQL procedures against the test cases.

. Involved in creating use cases and test cases

Environment:

Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database

Tools/Utilities, Oracle Enterprise Manager.

Client : Wipro India Ltd, Hyderabad-India.

Duration : Mar 2007 - Dec'

2007

Role : Oracle DBA

Responsibilities:

. Managed in-house Oracle Databases running on various operating systems

like Windows NT and Linux.

. Installation of Oracle Database products.

. Implementing Backup/Recovery Strategies.

. Using Enterprise Backup utilities for backup.

. System tuning for better performance.

. Designing and enforcing standards and naming conventions.

. Co-coordinated, and delivered Oracle courses such as Database

Administration, database security, enterprise backup and recovery

solutions, PL/SQL concepts.

. Writing UNIX shell scripts for backup and recovery.

. Supervised the installation and configuration of Oracle databases on

Linux and Windows NT

. Database installation and instance creation.

. Creating database triggers, Procedures and packages for the payroll

system.

. Database tuning, backup and recovery and general day to day running of

the system.

Environment:

Oracle 8i/9i, RHEL 4, HPUX v2, Toad, OEM, Database tools/utilities, SQL,

PL/SQL.

EDUCATIONAL QUALIFICATIONS:

. B-Tech in Aeronautical Engineering.

Contact this candidate