Shiva Kumar Aarati

Emailid:acfln8@r.postjobfree.com

Phone number: 617-***-****

Summary:

Highly motivated Software Professional with 8+ years of expertise in

Oracle 12c/11g/10g/9i DBA and have been involved in Installation,

Configuration, Upgradation, Patching, Backup and Recovery, Migration,

Memory and Space Management, Cloning, Replication, Reporting, Performance

Tuning, RMAN, RAC, Data Guard, OEM Grid Control.

. Experienced in Installation, Configuration and Troubleshooting of

Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux

(RHEL) and Windows on highly transactive and Very large databases

(VLDB).

. Expertise in Oracle 11g RAC implementation & administration using

Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle

Cluster ware setup and configuration, RAC installation, Configuration

and Patching, RAC Backup and Recovery)

. Monitored and maintained 2 node and 3 node RAC environments

. Migrated Application data from NON-RAC to RAC environment

. Created databases in RAC environments and in ASM (Automatic Storage

Management)

. Created RAC database with ASM and Data guard configuration which

includes primary and standby database creation

. Configured Automatic Storage Management (ASM) to fulfil storage needs

. Experienced in Implementing, configuring, trouble shooting,

switchover, failover of Physical Standby Data Guard on 10g and 11g

. Configuring Data Guard to ensure high availability, data protection

and disaster recovery for enterprise data

. Monitored and Supported the DataGuard - Standby Databases using

OEM/grid Control and DataGuard Broker

. Checking data guard status of databases and resolving issues like sync

with its primary

. Performed DR Drill activity

. Configured and maintained replication using Oracle Golden Gate.

. Performed replicate splits

. Involved in upgrading the Golden Gate from Lower to Higher Versions

. Implemented unidirectional and bidirectional replication

. Performed out of place upgrade and applied PSU patches

. Upgraded from 11.2.0.3 to 11.2.0.4

. Experience in Backup & Recovery techniques of databases running in

ARCHIVELOG MODE using RMAN

. Experience in Cumulative and Differential Incremental backups using

RMAN.

. Having good knowledge on EXADATA and Involved in moving databases in

EXADATA RAC environment.

. Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic

Workload Repository), ASH (Active Session History) for analyzing the

database performance and tuning

. Experience in up gradation of Data bases in 10g and 11g.

. Experience in Data Migration using Data pump utility.

. Scheduled Crontab for database backup jobs

. Database replication using snapshots, materialized views,

import/export and advanced replication methods.

. Database Refresh from Production to Development and from Development

to Test environments.

. Refreshed development environments with production RAC and non-RAC

environments at DB and schema level.

. Performed compression of tables using OLTP

. Replication of tables to cross platform and Creating Materialized

Views.

. Managing Table/Index segments, Rollback Segments, Undo Segments, and

Constraints.

. Planning and scheduling Physical Backups (offline/online) and Logical

Backups.

. Experience in implementing Flash Back Pointing Time Recovery.

. Experience in maintaining ETL tools for Reporting Solutions.

. Experience in User Management by Granting, Revoking Privileges

according to requirement.

. Experience in Space Management by Monitoring and Managing Tablespaces.

. Keeping the database up to date by applying the latest CPU and PSU

using the OPATCH utility.

. Configured network components like TNSNAMES, Names Server, Connection

Manager, etc. For easy and effective management of Oracle networking.

Configured Listener for external procedure calls.

. Performance Tuning of SQL statements and Database using tools like

Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance

Views.

. Diagnosed and troubleshooted typical SQL Tuning issues using

SQLTXPLAIN.SQL

. Experience in Partitioning and creating Global, Local Indexes on

Partitioned Tables.

. Experience in Administering Oracle Database using Oracle Enterprise

Manager, Toad, and PL/SQL Developer.

. Monitoring Alert log for any errors and issues.

. Developing Unix shell scripts (Korn and Perl) to extract data

from ETL database environment as reports and importable delimited data

sets.

. Supported development effort by providing SQL statement tuning

and optimizing ETL procedures and removing load and query performance

bottlenecks by using Explain Plan.

. Worked with application team on different change request situations.

. Preparing Weekly and Monthly report of Database Health Check and

various activities done by team

. Communicated and interfaced with Oracle support via Metal-link to

troubleshoot day-to-day database issues.

. Experience in UNIX shell programming.

. Hands on experience working on High Availability Environments.

. 24 X 7 Production Database on Call Support.

. Strong learning abilities with keen interest in learning new

technologies and best practices with passion to take on challenges to

deliver and add value to the clients.

Technical Skills:

Operating Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,Windows

Systems 95/98/NT/2000/XP,

Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.x, 6.1 and HP UNIX.

RDBMS Oracle 12c, 11g R1/R2, 10g R1/R2, 9i.

Languages UNIX Shell Scripting SQL, PL/SQL, C, HTML.

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

Export/Import, TOAD, Data pump, Autosys, VB, MS Access, Oracle

Streams, Pentaho kettle, VMWARE, VSS, VERITAS Net Backup, EMC

Powerpath, Quest, Putty, VERITAS cluster manager.

Tuning Tools AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK, AND ASH.

Database Erwin 4.0, 7.3; Oracle Designer.

Modelling

Education:

Bachelor of Technology from Jawaharlal Nehru Technological University,

Hyderabad, INDIA.

Professional Experience:

First Health Services, Richmond, VA

Feb'13 - Till Date

Oracle DBA

Responsibilities:

. Installed, configured, and maintained Oracle 10g and 11g R2 on RHEL

and also Upgraded from Oracle 10g to 11g

. Administering and supporting Oracle database environment with 36

production, 22 test and 15 development databases, 14 of which included

Linux & HP-UNIX

. Performed day to day administrative tasks by analyzing the database

like checking for failed processors, verifying the query for

particular issues and validating disk space.

. Migrated 30 TB Databases from HP UNIX to RHEL with minimal down time.

. Responsible for setup, implementation and maintenance of 2 Node RAC

on RHEL 11g R2.

. Migrated Application data from NON-RAC to RAC environment

. Created databases in RAC environments and in ASM (Automatic Storage

Management)

. Used to perform backup and recovery using Oracle Recovery Manager

(RMAN).

. Involved in migration of applications of the clients.

. Performed daily maintenance tasks like space management,

rectified locking problems, managed quotas etc., configured network

components like TNSNAMES, Names Server, Connection Manager, etc. for

easy and effective management of Oracle networking. Configured

listener for external procedure calls.

. Perform Daily Monitoring of Oracle Instances, monitor users, and

table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

. Involved in moving databases in Exadata RAC environment.

. Data loading using SQL*Loader into Oracle Database from different

sources (OLTP).

. Used to Perform Cold/Hot Backups and also performed database cloning

using RMAN.

. Daily Health Check Up of the Database using OEM Tuning Pack, AWR, ADDM.

. Configured and maintained replication using Oracle Golden Gate.

. Performed replicate splits

. Involved in upgrading the Golden Gate from Lower to Higher Versions

. Implemented unidirectional and bidirectional replication

. Created RAC database with ASM and Data guard configuration which

includes primary and standby database creation

. Worked on Active data guard and performed troubleshooting.

. Monitored and Supported the DataGuard - Standby Databases using

OEM/grid Control and DataGuard Broker

. Configuring Data Guard to ensure high availability, data protection

and disaster recovery for enterprise data

. Checking data guard status of databases and resolving issues like sync

with its primary

. Performed DR Drill activity

. Replication of tables to cross platform and Creating Materialized

Views.

. Database backup & Recovery with export and import for non archive

and archive database with RMAN commands.

. Develop and enforce both database and OS-level security policies

for data protection. Administer all databases in the areas of

maintenance, tuning, performance, and troubleshooting.

. Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL*

Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

. Developed Scripts for transferring data from production server

to testing/development servers.

. Diagnosed and troubleshooted typical SQL Tuning issues using

SQLTXPLAIN.SQL

. Shell scripting and PL/SQL programming to resolve business

problems of various natures.

. Developing Unix shell scripts (Korn and Perl) to extract data

from ETL database environment as reports and importable delimited data

sets.

. Supported development effort by providing SQL statement tuning

and optimizing ETL procedures and removing load and query performance

bottlenecks by using Explain Plan.

. Migration of database from one server to another server.

. Managing databases on multiple servers.

. Developed table structures, PL*SQL stored procedures and

database triggers to implement business rules.

Environment:

Oracle 9.2.0.8/10.2.0.4/11.2.0.3, RHEL 5.8, Hp- Unix 7, Solaris 10, ASM,

RMAN, RAC, Oracle Enterprise Manager 12C, RDBMS, AUTOSYS, SQLPLUS,

PL/SQL, Shell Scripting, Stored Procedures.

Inter American development Bank, Washington DC

Sep'11 - Dec'12

Oracle DBA

Responsibilities:

. Installed, configured, and maintained Oracle 10g and 11gR2 on Linux

and also Upgraded from Oracle 10g to 11g

. Performed day to day administrative tasks by analyzing the database

like checking for failed processors, verifying the query for

particular issues and validating disk space.

. Responsible for setup and implementation of 3 Node RAC on Linux in 10g

and 11g R2.

. Configured and maintained Oracle Cluster Ware.

. Configured and maintained replication using Oracle Golden Gate.

. Implemented Bi-Directional replication in golden gate.

. Used to Perform Cold/Hot Backups.

. Used to perform backup and recovery using VERITAS Net

Backup integrated into RMAN.

. Implemented and Managed Oracle Data Guard on Oracle 11gR2

. Upgrading the Oracle 10g to the latest Release 2 and applied patches

as required.

. Perform Daily Monitoring of Oracle Instances, monitor users, and

table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

. Daily Health Check Up of the Database using OEM and Applications servers

health using APPInternals Opnet

. Installed Opnet agents on all Production servers, and monitoring the

different application servers.

. Involved in migration of applications of the clients.

. Created Users with limited rights as per specific module under

specific client. Granting roles and profiles as per system study to

users.

. Replication of tables to cross platform and Creating Materialized

Views.

. Performed daily maintenance tasks like space management,

rectified locking problems, managed quotas etc., configured network

components like TNSNAMES, Names Server, Connection Manager, etc. for

easy and effective management of Oracle networking. Configured

listener for external procedure calls.

. Database backup & Recovery with export and import for non

archive and archive database with RMAN commands.

. Also configured database cloning using RMAN.

. Implemented Data Guard on production database.

. Develop and enforce both database and OS-level security policies

for data protection.

. Administer all databases in the areas of maintenance, tuning,

performance, and troubleshooting.

. Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL*

Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

. Developed Scripts for transferring data from production server

to testing/development servers.

. Shell scripting and PL/SQL programming to resolve business

problems of various natures.

. Developed and maintained the applications by utilizing ASP.NET.

. Migration of database from one server to another server.

. Managing databases on multiple servers.

. Disk Space Monitoring.

. Developed table structures, PL*SQL stored procedures and

database triggers to implement business rules.

Environment:

Oracle 10.2.0.3/11.2.0.3, Linux, Solaris 10, ASM, RMAN, RAC, Oracle

Enterprise Manager Grid Control, RDBMS, SQLPLUS, Autosys, PL/SQL, Opnet,

Shell Scripting, Stored Procedures.

United States Department of Agriculture, Kansas City, MO

Apr'10 - Aug'11

Oracle DBA

Responsibilities:

. Installation, Configuration and Administration of Oracle 10g databases

on Sun Solaris Operation System.

. Implemented Real Application Cluster (RAC) Setup & Administration

using Sun Cluster.

. Supported different Databases like Production, Development, Testing,

UAT and Training.

. Responsible for planning, testing and implementing different backup

and recovery strategies.

. Designed Logical and Physical Modelling using C.A Erwin.

. Logical to Physical Transformation using Erwin

. Forward engineering using Erwin

. Reverse engineering using Erwin

. Model to model comparison using Erwin

. Conducted daily routine checks on alert logs and trace files.

. Creating the Database, table space, Control files, log files and user

profiles

. Performed Backup and Recovery with export and import for non

archive?and archive database using RMAN, scheduled backup on Solaris&

NT environments using the incremental complete and full backup

strategies based on the database purposes.

. Automated back-up procedures using crontab.

. Performed activities such as Query Optimization, Database Consistency

Monitoring. Configured and managed replication server.

. Expertise in Installation, Configuration, Application Support,

Performance Tuning/ Optimization, User/Security Administration,

Backup/Recovery, Data/Network Administration and Maintenance and

configure database stand by database using Data Guard.

. Automated database backup using shell scripting.

. Involved in the database design, installation, creation of various

instances, and creation of tables, granting roles to users and

maintain the security according to application.

. Worked on performance and tuning on SQL queries wherever it is

required.

. Install OCI header files on Client Machines.

. Migration of database from one server to another server.

. Creation of database objects like Tables, Indexes, Views, Users, and

DB Links etc.

. Rename the database and database SID.

. Create Directory in the database.

. Moving data files from one location to other.

. Scheduling Oracle Jobs in the database.

. Analyze the schema and tables.

. Performed daily maintenance tasks like space management, rectified

locking problems, managed quotas etc., configured network components

like TNSNAMES, Names Server, Connection Manager, etc. for easy and

effective management of Oracle networking. Configured listener for

external procedure calls.

. Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader,

TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

. Managing table spaces, user profiles, indexes, storage parameter's.

. Develop table structures, PL*SQL stored procedures and database

triggers to implement.

. Responsible to provide 24 x 7 database administrative activities over

different database servers

Environment:

Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle

Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting,

Stored Procedures, ASM, ASO, VPC, Data guard, CICS business rules.

Mercy Health Plans, St Louis, MO

Jun'09 - Mar'10

Oracle DBA

Responsibilities:

. Installation, Configuration and Administration of Oracle 10g/9i

databases on various Operating Systems.

. Configured RMAN and performed daily backups.

. Implemented Data Guard on Oracle 10g.

. Conducted daily routine checks on alert logs and trace files.

. Creating the Database, table space, Control files, log files and user

profiles

. Designed Logical and Physical Data Modelling using Erwin.

. Creation of database objects like Tables, Indexes, Views, Users, and

DB Links etc.

. Scheduled Oracle Jobs in the database.

. Analyze the schema and tables.

. Used Database Configuration Assistant (DBCA), Database Upgrade

Assistant (DBUA) for migrating Oracle 9i versions in RAC

. Data Refresh from Production to Test and Development environments using

RMAN Duplicate Database.

. Securing the data by using Oracle data vault.

. Extensively used SQL Loader to load data from flat files to the Oracle

Database.

. Created and enhanced DB utilities needed for automation of system and

unit tests and investigation of production issues, troubleshooting.

. Responsible for network configuration and involved in a Client -Server

environment using TNS, LISTENER, Net Configuration Assistant and other

configuration files.

. Created and configured database manually using Oracle Database

Configuration Assistant.

. Monitored and tuned long running jobs by working closely with the

application development team and analyzing objects, created or rebuilt

indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from

Quest software (DB Tuning).

Environment:

Oracle 10g/9i, Linux, Windows 2003, Oracle Enterprise Manager Grid

Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, RAC.

Priya Foods, Hyderabad, INDA

Jun'06-May'09 Developer/Junior Oracle DBA

Responsibilities:

. Created new Table Spaces, added Data Files and resolved Disk

Contention Issues.

. Monitored, Allocated Share memory, Table space as needed and managed

Replicated servers.

. Monitoring daily Hot Backups and weekly Cold Backups performed using

RMAN.

. Monitoring inconsistency Issues long Transactions and Locking Issues.

. Monitoring Alert log file and Trace file.

. Performing analysis and diagnosis of Database Performance Statistics.

. Monitoring performance using Advisors, AWR, ADDM, SQL Tuning etc.

. Monitoring Online and Offline backups with RMAN as well as User

managed.

. Schema and Table level replication using export/import.

. Performed activities such as Query Optimization, Database Consistency

Monitoring.

. Applying and monitoring Patches on Oracle 9i database.

. Responsible for granting required privileges and roles to users.

. Creation and maintenance of database objects.

. Managing table spaces, User Profiles, Indexes and Storage parameters.

. Scripting languages mainly HTML, XLML and JSP.

. Working as a Database developer, writing SQL Queries.

. Involved in developing and implementing PL/SQL functions, Stored

Procedures and Triggers.

Environment:

UNIX, Oracle 8i/9i, PL/SQL, SQL Loader, RMAN, Oracle Enterprise Manager

(OEM), Shell Scripting, Java, HTML, Oracle forms and reports 6i/9i.

[pic]

Contact this candidate