Customer Service Oracle

Indrasena Reddy

*********.***@*****.***

512-***-****

Oracle DBA

Note: Available Immediately *** ONLY FOR A CONTRACT POSITION ***

* EXPERIENCE SUMMARY

Over 7 years of experience as an Oracle Database Administrator having hands

on experience in database administration, production support, installation,

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

cloning, space management, database security, auditing.

. Involved in different scenarios of OLTP as well as DSS (Data warehouse)

databases.

. Worked with a team to provide 24x7 on-call production database support.

. Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.

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

10g and 11g in UNIX/LINUX and Windows environment.

. Installation, configuration maintenance of Oracle 10g RAC, 11g RAC,

Standby Databases (DataGuard).

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

databases for OLTP, DSS and Data Warehousing using customized shell

scripts and stepwise.

. Management of schemas, objects & Partitioning the tables & indexes.

. Development experience in creating Procedures, Packages, Functions,

Triggers and other database objects using SQL, PL/SQL.

. Proactive Monitoring, identifying areas that need to be improved in the

application and database using Statspack, AWR, ADDM and OEM Grid

Monitoring.

. Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid

Monitoring, Recycle Bin.

. Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of

databases.

. Excellent knowledge in Backups and Recovery and Cloning of databases

using RMAN with VERITAS Net Backup.

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

Tuning.

. Planned and implemented Disaster Recovery & high availability solutions

using Oracle Standby Database

. Delivering Oracle Database performance-tuning services for customers with

Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control

custom scripts troubleshooting Oracle databases using SQL trace

utilities.

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

distribution, buffer cache, redo mechanisms.

. Experienced in Oracle Support processes for technical requests through

Metalink and other Support Procedures

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

modeling, OLAP, Logical and Physical Database Design, Backup and Recovery

procedures.

. Experience in replication using Oracle Streams, GoldenGate and experience

in using OEM, TOAD, Database Migrations using transportable tablespaces,

transportable database, benchmarking using load testing tools

. Expertise in maintaining Database Security using security compliance

auditing, expertise in loading data from flat files using external

tables, SQL*LOADER.

. Worked on different types of storage structures (SAN/NAS).

. Good written and verbal communication skills with a customer service

oriented attitude.

* TECHNICAL SKILLS

Operating HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1,

Systems 5.2,5.3,6.1

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

95/98/ME/NT/2000/XP.

RDBMS Oracle 11g/10g/9i/8i, Oracle 11g RAC, Oracle 10g RAC, SQL Server

2000.

Languages SQL, PL/SQL, C, C++,UNIX Shell Scripting

Tools TOAD, SQL Plus, SQL Developer, RMAN, OEM, SQL*Loader, SQL

Server, EXP, IMP, DataPump (expdp, impdp), ERWIN, VMware, Golden

Gate, Informatica, Putty.

Tuning TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Grid Control.

Tools

Other VERITAS, NetBackup.

Web Tools HTML, XML.

* EDUCATION

. Master in Computer Applications from Jawaharlal Nehru Technological

University.

. Bachelor of Science (Computer Science) from Osmania University.

* PROFESSIONAL SUMMARY

Contact this candidate