Oracle Data

Sridevi Kamineni

Email: *******.********@*****.***

Summary:

A hands-on, skilled and proficient individual with 10 + years of experience

in Oracle Database Administration (core DBA) which includes 4 years of

experience in Oracle 11i application DBA and expertise in application

database administration, core database administration, real application

clusters, data guard, data replication, application server administration,

backup and recovery, data migration, production support, installation,

configuration, upgrades, patches, cloning and performance tuning.

Professional Summary:

INSTALLATIONS AND CONFIGURATIONS

. Experience in Installation, configuration of 11i apps, Oracle 8i, 9i,

10g, 10gAS and 11g, 12c in Linux, HP-UX/Unix, Sun Solaris, AIX

environments.

. Installed, configured and maintained ASM enabled 11iapps database with

failover configured using the cluster ready services (CRS), ASM

enabled RAC databases and ASM enabled stand-alone databases.

. Installed and configured grid control agent on all the databases which

helped in monitoring the databases for all the alerts and errors.

. Installed and configured oracle middleware BPEL, 10g Application

Server, Discoverer.

ADMINISTRATION and MAITENANCE

. Experience in patching to both application (using adpatch) and the

database (opatch).

. Ad administration using ad utilities.

. Experience in performing regular database refreshes and cloning of

apps environment from production to test instances.

. Administration of Oracle 10g ASM RAC instances, standby databases

(both manual and Data guard)

. Extensive experience in Performance Tuning of the database using Grid

Control (OEM), STATSPACK, MTTR, TKPROF, Explain plan, enabling trace

of the session, AWR, SQL tuning.

. Experience in creating users, roles, profiles for both application

users and at the database level.

. Experience in space management of logical structures.

. Always worked with a 24X7 on-call production support database team.

BACKUP and RECOVERY

. Experience in RMAN backup and recovery techniques.

. Can perform DB backup without using RMAN for lower version databases

like 9i and 8i.

. Experienced in taking backup of the apps related files using tar, gzip

or compress.

. Performed logical backups of schema, the whole DB, table structures

using export/import and data pump utilities.

. Automated the hot backup of the database, backup of the archive logs

and export using cron jobs.

DATABASES OTHER THAN ORACLE

. Experience in performing basic maintenance activities on Informix

databases.

. Experienced in managing SQL server database and also converting the

SQL server databases to oracle database.

EDUCATION

. Master's Degree in Computer applications. (MCA) from Visvesvaeaya

technological university(VTU), Belgaum, Karnataka, India

. Bachelor's degree in computer science from Nagarjuna university,

Andhra Pradesh, India

Technical skills:

. Operating System : Red Hat Linux 4.x, 5.x, AIX 5.x,6.1, Sun

Solaris 8,9,10, HP-UX

. Databases : Oracle 11G,10G, 9i, 8i,

. DBA Tools/Utilities : RMAN, RAC, OEM, TOAD, AWR, Data Pump,

SQL*Loader, OEM, STATSPACK, ADDM, TKPROF,

VERITAS.

. Languages : SQL, PL/SQL,

PROFESSIONAL EXPERIENCE

Company : Ericsson Services (September 2009 -

currently employed)

Role : Data Analyst II

Work History: Working as the database administrator for Sprint/Nextel

databases supporting the database activities for both test and production

databases. IWe are a team of 4 and each of us maintain around 200 databases

as the primary DBAs which include both test and production. In addition to

being an individual contributor I also manage the team as the team lead.

Most of the databases I support are connected to various sprint/Nextel

applications. Currently I am also working on Ericsson native projects. In

addition to being a DBA, I am also the team lead for the ERICSSON ORACLE

DBA team. The following are the responsibilities I have been performing at

work at Ericsson services

. Installed 12c standard and enterprise edition with Dataguard.

. Installed 11.2.0.3 and created an ASM instance with grid

infrastructure.

. Migrated a 10g HP-UX database to 11.2.0.3 Linux server using

transportable tablespaces migration.

. Upgraded all the older databases 8i, 9i to 10.2.0.4. Currently getting

ready to upgrade the

10.2.0.4 Databases to 11g release 2.

. Sprint uses Airave to provide better signal performance to customers.

I manage the lab, test and

The production databases of Airave which is RAC 10.2.0.4 ASM

enabled and CRS managed.

The database was on 10.2.0.4 when I took over and have recently

upgraded CRS, ASM and

Database to 10.2.0.4. I also assisted the application users with

the application upgrade.

. Restored the RAC database to an earlier date due to data issues caused

by the application.

. Sprint also has NRM (network resource management) project which is

made to merge all the

Stand-alone databases. I have been actively performing the

database activities regular refreshes

from prod to test using RMAN cold backup and hot backup.

. Configured DATAGUARD for one of the projects using RMAN backup also

configured a

Manual standby for a 9i database using the cron job entries.

. Assess risk/benefit factors in database software upgrade and patches.

Perform major Oracle

Version and release upgrade, apply patches / bug fixes

. Applied security related CPU and One-off patches using Opatch utility,

Applied RDBMS

PSUs.

. Carry out database migration to new servers, data centers at different

locations.

. Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.

. Extensive performance tuning experience, SQL Tuning, Database/Instance

Tuning and

Database performance tuning services via V$/GV$ views, Explain

Plan, TKPROF, AWR

(Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access,

Oracle Enterprise Manager

(OEM), Grid Control.

. Monitor the databases by installing and configuring grid control agent

on all the database

Servers.

. Used Export/Import, Data Pump Utilities to move the data between

different databases and for

backups.

. Generated performance reports and Daily health checkup of the database

using utilities like

AWR, Stats pack and ADDM to gather performance statistics.

. Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

. Created DB links across databases and Solved Database connectivity

issues by continuously

monitoring the status of the listeners and instances.

. Scheduled jobs in the database using CRON Jobs and DBMS_JOBS.

. Created materialized views and set up jobs to refresh the views.

. Served as a member of 24-hour on call support staff. As a part of the

on-call I have supported

Informix, Sybase and SQL SERVER databases with minimum

maintenance activities.

Company : Sprint/Nextel (July 2007 - September 2009)

Role : Data Analyst II

Work History: Worked as Team-Lead for OMIM (Order Management Inventory

Management) project (Tier1) from design to rollout, delivered best possible

support and helped the Application team to implement this project as

successful and on time.

. Participate, as the project DBA, in various assigned projects through

plan, analyze, design,

build, and rollout.

. Maintenance of CRS (cluster ready services) enabled ASM production

databases.

. Cloning and refreshing of Production to Test and Development using

different cloning utilities

(ASM to Non-ASM, Single node to multimode)

. Administration activities of Oracle Application & Database (production

and development)

. Installation of Oracle Applications 11i

. Application maintenance through ADUTILITIES like ADADMIN, ADPATH,

ADCLONE,

ADMERGE, ADRELINK and FND utilities like FNDCPASS, FNDLOAD.

. Maintenance and Configuration of BPEL console.

. Performance and Tuning of 11i Application.

. Implemented the databarn refreshes for Tier 1 application with EMC

Time finder.

. Regular refreshes of Databases

. Took proactive measured to monitor database in test and ORT

environment to find bad queries

and help developer tune queries and improve performance by 97%.

. Patch application and SYSADMIN activities. Experience includes System

Administration

activities like managing concurrent managers, application user

setup, defining responsibilities,

registering menus, forms, reports, concurrent programs, and

printers, providing support to apps

users for any technical or functional issues.

. Implementing Disaster Recovery setups for Oracle Database and Backup

and Recovery

scenarios.

. Support the IT Excellence program focusing on following initiatives of

Database

Administration, Security compliance of databases, Sql review and

approval, oracle version

Compliance, database backup/recovery Strategy and testing, Data

purging Strategy.

. Participate in the 7 x 24 x 365 on-call support rotation.

. Decrease MTTR (Mean Time to Repair) by decreasing total outage time on

Sev1s by 10%.

. Support SLAs and obtain 95% compliance.

. Participate in establishing guidelines for standards, tools,

methodology, documentation, and

project planning and provide documentation on assigned

databases.

. Identifying the top queries and analyzing them with necessary indexes.

. Work with vendors and application development team to setup database

as per Sprint standards

and support the IT Excellence Program focusing on the following

five initiatives for Database

Administration: Database Security Compliance, SQL Review and

Approval, Oracle Version

Compliance, Database Backup/Recovery Strategy & Testing, Data

Purging Strategy.

Company : Object Soft Group (Client: EDS - Bimbo

Bakeries)

(May 2006 - July 2007)

Role : Database Analyst I

Work History: As on-site oracle applications DBA, I worked for one of EDS

clients: Bimbo Bakeries at Fort Worth Dallas, TX. All the team members were

remote and I was the DBA on-site for any of their database work on Dev,

test and production environments.

. Apply Oracle standards to resolve Performance tuning issues.

. Troubleshoot and resolve Discoverer Issues while generating

reports

. Configure User Access and maintain User profiles

. Setup auto configuration for various available instances

. General System administration

. Configure self-service setup for various Oracle Instances

. Constantly apply required patches on various instances using

Ring Master

. Application/DB Upgrade & normal Maintenance

. Backup and recovery as and when required and creating

backup policies for customer.

. Administration activities of Oracle Application &

Database.

. System Administration for Oracle Apps which includes creation

and maintenance of Users, Responsibilities', Menus, Profiles,

Concurrent Programs, Request Sets, Request Groups etc.

Company : Object Soft Group (Client: Recycled Paper

greetings)

(February 2006 to May 2006)

Role : Database Analyst I

Work History: I was hired by Trishna Corporation, Chicago for their client:

Recycled Paper Greetings to perform upgrade projects. The database they

were using was on 8i and was having a lot of performance issues. It took me

3 months to upgrade all their test and production 11i, 8i databases and

application server to 10g.

. Complete Setup and Installation of Oracle 10g

. Installation of Oracle Applications 11i on Sun Solaris

. Allocating system storage and planning future storage

requirements for the database system

. Upgrade and Migration of Databases from 8i to 10g

. Setup and Install 10gAS for working with Oracle Instances

. Upgrade Application Server from 9iAS to 10gAS

. Patch Analysis and Application

. Troubleshoot Oracle Apps and Database issues as and when

required

Company : Oracle India Pvt Ltd (January 2004 to

January 2006)

Bengaluru, India

Role : Associate Consultant

Work History: I was hired by Oracle India Pvt Ltd out of college. Oracle

provided us with 2 months of class room training and 3 months of on job

training on Oracle applications 11i and Databases 8i and 9i. As an

associate consultant, I supported various clients as an off shore DBA.

Following are some of the clients I supported when working at oracle India.

. Kellwood

. Welch's

. Sterilite

. Agilent

. JM Family

. Key bank

. Invacare

. Delmonte

. Best buy

DBA Activities Performed:

. Refresh from Production to development instances

. Using Kintana EAP tool to apply patches

. Performance tuning of all development databases

. Finding the suitable recommendations based on data analysis

. Writing scripts to minimize the time required

. Trouble-shooting of all oracle application problems

. Worked on 24/7 high availability environment

. Creating Custom Top for the client Requirements.

. Daily Monitoring all the application Systems

. Trouble-shooting of all oracle application problems

. Copy/Clone of oracle application environment

. Used Oracle Application tools for maintaining databases and

applications like adpatch, adadmin, adctrl, adaimgr, adrelink,

adsplice etc.

. Interacting with oracle support to resolve application issues

. Tablespace Maintenance like adding the increase the size of the data

files

. Providing DBA Support for Oracle's eBusiness Studio Hosted

environments to ensure 24x7 DBA support

. Upgrade Oracle Application to current releases and current product-

level with applying maintenance packs and Minipacks

. Migration of the Apps tiers on the applications to Linux from AIX.

. Periodically refreshing TEST instance from PRODUCTION instance

. Performing daily checks and health checks on all the Apps instances

. Cloning and refreshing the database & APPL_TOP whenever required

. Code move, Copying, generation and compilation of the forms and

generation of reports

. Installing, configuring and administering Oracle Application 11i

database in a Multi-tier architecture

. Cloning using ad clone utility and manual clone

. Migration from 11.5.8 to 115.9

. Installation of 10g database and Application server and 10g OEM

Configuration

. Configuring PCP (Parallel Concurrent Processing) for multi node

environments

. Administering Oracle Applications and Internet Databases on UNIX

platforms, which includes creating, designing and maintaining

production databases

. Logical and physical database design, performance tuning

. Oracle on-line/off-line backup and recovery

. Installing and using RMAN for taking backups of Oracle9 Databases

. Maintaining Stored Procedures, Triggers, PL/SQL and other utilities

provided by Oracle

. Managing the Oracle resources for logical structures

. Using Oracle Server Utilities like SVRMGR, Export, Import

. Migrating the database from Oracle 8.x to Oracle 9i and Oracle 9i

using export/import utility and Migration Manager

. Configuring Concurrent Managers and Apache Web Server for Applications

. Users Administration (Roles and Profiles)

Contact this candidate