Manager Oracle
Resume:
Anna Dhande
[pic]
************@*****.*** 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