Harsha Kagullu

732-***-****

S UM MARY

Over Eight years of experience working for corporate clients in several challenging projects.

Worked in various phases of analysis, design, implementation and support which include

Databases, applications on SUN Solaris, HP/UX and Windows NT.

I T SKILLS

• Hands on Experience in installing, configuring and managing Oracle 10g/11gR2 RAC with ASM

on RHEL Linux and Solaris environments.

• Experience in Configuration, Installation and M igration of oracle databases from oracle 8i,

oracle 9i, oracle RDB to H igh Availability 10g/11g RAC environment.

• Experience in Database Administration activities such as Upgrades, M igration .

• Experience in taking backup using Import –Export, Data Pump Ut ili ty.

• Experience in creating and configuring maintaining Data Guard and Standby database

• Experience in cloning the databases and performing database refreshes.

• Experience in using Oracle Recovery manager utili ty (RMAN) for various types of backup and

recovery.

• Experience in taking backups using COLD, HOT and writing scripts for these backups

• Experience in writ ing proactive monitoring scripts like monitoring the disk usage and the

memory usage of the server and monitoring table spaces.

• Experience in managing Table spaces like Undo table spaces and Temporary table space

management.

• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

• Involved in Performance tuning, database monitoring activities using E xplain Plan, T KPROF,

AWR, ADDM, ASH, SQL Trace, ORADEBUG, STATSPACK, 10g OEM Grid Monitoring, Oracle

D iagnostics pack, Oracle Tuning Pack.

• Proficient in exadata

configuration/maitaince/support/datagaurd/backup/recovery/failover/switchover.

• Enrolling users and Creating roles, profiles and privileges and assigning to users.

• Have 4 months of experience on Big data technology around my 8 years of experience in diverse

f ield of software development administration

• Expertise in developing SQL and PL/SQL codes through various procedures, functions, T riggers

and Oracle packages to implement the business logics of database.

• Maintenance & modification of Shell Scripts.

• Experience in working with reporting tools such as Crystal Reports, SSRS.

• Good understanding in optimization and Normalization in Oracle RDBMS.

• Expertise in handling database related errors using Exceptions.

• Experience in Performing Strong search skills using Oracle Metalink as well as opening Service

• Developing UN IX shell scripts and SQL scripts to carry out routine checks on databases.

• Tuning, assigning proper indexes such as BIT map or B-Tree Index according to requirement.

• Experience in working with different Connectivity like SFTP, FTP, SCP, SSH and Connect

D irect.

• Skilled in using tools such as SQL Developer, TOAD, MS SQL Server query analyzer, Visual

S tudio and loading data from f lat files using SQL Loader and External Tables.

• Familiarity with Golden Gate and Oracle Streams.

• Experience in using Crontab in UN IX environment for scheduling routine tasks.

• Extensive experience in Relational and Dimensional Data modeling for creating Logical and

Physical Design of Database and ER Diagrams using mult iple data modeling tools l ike ERWIN,

ER Studio.

• Documented most critical procedures and t rained backup staff to run them.

• Experience in Forms Load Balancing, Apache/JSERV upgrades and SSL security

• Managed Golden Gate as a complement to Oracle’s HA and DR systems

• Good experience in Data Modeling [using ERWIN, Power Designer], Data mart and OLAP for

business analysis using Star & Snowflake schemas for faster and effective querying.

• Experience Administrating and Maintaining the Database including applying patches and

u pgrades

TECHN ICAL SKILLS

Category Technology

Oracle 8 i/9i/10g/11g, MS Access, MS SQL Server 2000, 2005/2008.

SQL, PL/SQL

Backup planning and implementation RMAN

Performance Monitoring, Analysis and Performance Tuning

(AWR, ADDM, ASH)

Database Skills

Database Recovery (DR) strategy planning and implementation

Capacity Planning and implementation

Parti tioning, Replication, and Standby Database Administration

Installation, Patch ing, U pgrade, & Migration

ODBC, JDBC

UN IX (Sun Solaris 8, 9/HP/AIX4.3), Fedora Linux, H PUX-11.23,

O perating Systems R HEL 4.x, 5.x.

Windows NT/2000/2003

Erwin 3.5/4.1/7.1 Sp2, Oracle Designer 8i/9i/10g/11g

A pplications

PL/SQL Developer 5.2/7.0, SQL *PLUS, SQL load, SQL

Developer.

O racle Management Server (OMS), Oracle Enterprise Manager

(OEM)

O racle Ut ilit ies (Import / Export, SQL* Loader, 10g /11g Data

Pump)

Toad8.5, Quest Central (Spotlight® etc.)

VERITAS Netback up 5.3/6.0

Crystal Report 8.5/9/10, SSRS 2005

UN IX Shell Scripting, SQL, P L/SQL p rogramming.

Language

FTP, SFTP, SSH, Telnet, T CP/IP, Connect Direct.

Protocols

Certification:

Oracle Certified Professional.

Education:

• Bachelor of Science in Computer Science and engineering,

P rofessional Experience:

Comcast Corporation. (Louisville, KY) (April

‘12 – Till To Date)

Oracle DBA Consultant

Responsibilities: -

• Installed, configured, maintained and tuned Oracle 10g and 11g databases.

• Installed and Configured Oracle 10g and 11gR2 RAC with ASM on 2 node RAC setup

• Installed & Managed Physical Standby databases & Data Guard for disaster recovery.

• Implemented replication using Golden Gate and Oracle Streams.

• Configured and monitored various databases using OEM Grid Control

• Used Oracle utili ty Recovery Manager (RMAN) to implement Oracle backup and recovery .

• Designing the Oracle backup strategy, scheduling and implementing database backup and

restoration using I mport/Export, hot backups, cold backups and data pump utili ties.

• Migrating databases to different environment using Data pump.

• Oracle Exadata implementation experience, including zero-downtime migrations leveraging

GoldenGate

• Performs databases cloning manually using scripts and Recovery Manager (RMAN) for QA

Testing team, application team and for developers.

• Performed Capacity planning, capacity monitoring and management.

• Performs tuning and optimization on current and new applications using SQL Trace utility and

D BMS package, and enhancing performance through regeneration and rebuild of indexes and

creation of views.

• Manages users and security of database as per business requirements .

• Creates P L/SQL procedures, packages and f unctions as required by business needs.

• Used SQL Loader extensively to extract data from f lat files and loading into the new

application.

• Performed database analysis, design, coding, testing and i mplementation of database

s tructures.

• Performs t roubleshooting using Explain Plan, TKPROF, STATSPACK, AWR and A DDM.

• Monitors the database, Table space management and Sizing of objects and space utilization in

database using shell scripts.

• Automated a lot of process to keep the systems up to date and to reduce manual errors by

developing shell scripts.

• Upgraded O racle binaries in the development environment and production environment.

• Involved in applying oracle patches like 10.1.0.1 to 10.2.0.2 and from 11gR1 to 11gR2.

• Generated working documentation and run book for DBA team usage.

• Optimizes database performance by analyzing database objects, generating statistics, creating

i ndexes and partit ions.

• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR,

S tats pack, ADDM, ASH reports, OEM Grid Control.

• Working on documents and communicate changes to the OLTP, OLAP systems and data

warehouse teams, including Data Modeling, ETL and Database teams.

• Oracle installation on Windows 2003 Server (development).

• Hands on experience with working and maintaining of 1 terabyte Database servers

• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating

Dataguard Exadata clusters for maximum availability.

• Working with M icrosoft windows Server 2008 R2 Platform

• Cluster management and verifying cluster process to ensure smooth operations.

• Working with Oracle support to resolve like ORA errors issues.

Environment: Red Hat Linux (RHEL) 4.x, 5.x, Oracle 10g RAC and 11gR2 RAC, SQL, PL/SQL, SQL*

P lus, SQL Developer, TOAD 9.0, SQL* Loader, OEM/ Grid Control, RMAN, Data Guard, ASM,

SCP/SFTP, TKPROF, Explain plan, AWR, ADDM, Cronjob, Shell Scripting (BASH), M icrosoft windows

Server 2008 R2 Platform .

I ntel Corporation. (Hillsboro, OR)

( Feb ‘11 – Mar ‘12)

Senior Oracle DBA

Responsibilities: -

• Installed and configured Oracle 10g/9i databases.

• Implemented Database Replication using Oracle 10g Streams.

• Performed patching like one-off, CPU, patch sets to existing versions.

• Supported implementation of BigData solution - involves UAT, ORT testing and driving

operational requirements.

• Collected database performance statistics from production databases for t rend analysis.

• Hot Backups & Exports, Restores & Refreshes for regression tests.

• Development support, Coding standards, application & database tuning.

• Preventive Maintenance & re-orgs. Troubleshooting & tuning.

• Ensured successful & periodical Backup, Restoration & Tuning.

• Developed, Implemented and administered database policies and procedures

• Migration of databases from DB2, SQL server to Oracle using utili ties Toad, SQL Developer.

• Created and configured10gR2 RAC databases in shared as well as dedicated servers.

• Implemented Backup and recovery using RMAN.

• Performed data modeling using tools like ERwin,

• Wrote scripts for various database activities, t roubleshooting errors etc.

• Experience in using AWR for database performance and statistics.

• Recommended changes to increase efficiency, minimize operating expense or improve accuracy

and t imeliness of application systems.

• Experience in H andling production outage calls

• A strong skill in PL/SQL procedures, packages, t r iggers.

• Experience in database driven application development like Oracle, My SQL, NO SQL

• Performed database analysis, design, coding, testing and implementation of database

s tructures.

• Maintained several databases ranging between 500GB to 3TB.

• Install, configure and support unidirectional and bi directional Oracle to Oracle replicated

environments utilizing GoldenGate v7

• Finest granulari ty approach to Oracle implementation and defragmentation.

• Maintained physical standby databases using Data Guard.

• Performed capacity planning, capacity monitoring and management.

• Experience in Database Security User Management, Privileges, Roles, Auditing.

• Performed t ransaction-sizing measurements.

• Managed databases on day-to-day basis in production as well as Development.

• Worked closely with the Oracle developers for the better performance in Applications in writing the

efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.

• Seasoned experience with UN IX and a strong ability with UN IX shell scripting.

• Worked extensively in Oracle’s Enterprise Manager (OEM), Generating Stats pack Reports,

E xplain Plan, SQL Trace and TKPROF, ADDM, AWR, ASH.

• Worked with Microsoft windows server 2008 R2 Platform

• SQL tuning and Database tuning has been done based on reports generated by SQL Trace,

T KPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database

• Performed D isaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss

of service/Rebuild/Corruption/Loss of datafile testing.

• Performed Analyzed application SQLs and provide guidance on improvement

• Established standards for database security and coordinate with production D BAs for execution

and data modular exclusion activates

• Involved in data modeling, analysis of Configuration Management database system (CMDB).

Responsible for data gathering, mapping and documenting

E nvironment: O racle 10g/9i/8i, Quest Toad Ver8.5, SQL*Loader, Windows 2003, Erwin4.14, AIX5.3,

Solaris5, M icrosoft windows Server2008 R2 Platform.

Citi group Corp. (New Castle, DE)

( April ‘10 - Jan ‘11)

Oracle DBA

Responsibilities:

• Installed & Managed Standby databases & Data Guard for disaster recovery.

• Handled Databases using hot /cold backups and dump/loads.

• Tested and implemented many backup and crash recovery scenarios on test environment

(9i/10g), using RMAN tool.

• Registered the databases in Recovery Catalog Databases for the setting up the Backups.

• Extensively used export-import and Data Pump -- Expdp/Impdp to take logical backup and

m igrate databases in different environment.

• Managed Undo Segment in order to avoid "Snapshot too old" error.

• Configured and implemented using 10g new feature BFT (Big File Table space – size of 2

E xabyte) for storing large objects.

• Configured databases in OEM for monitoring purposes.

• Worked On post-outage reviews (POR),And developed and deliveerdr Root Caus Analysis (RCA) to

management and to the customer.

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

• Hands on experience with working and Maintaining database of 800 Gigabyte Platform

• Scheduling meeting with the Application Team in different location to gather the information

for migration.

• Installed and maintained Oracle 9i database server software at Windows 2003 and RH8 Linux,

i ncluding RDBMS, Apache servers, patching software, configuring clients

• Maintained data integrity and tune database for optimum performance and availability.

• Created schema (tables, Indexes, views, sequences, synonyms, roles) & grant roles to users.

• Worked with Development team to fulfill the requirements of applications with Database design

• Performed tuning using UTLSTAT reports, Explain Plan and monitoring Alert logs.

• Identified the poorly performing queries using Explain Plan, TKPROF, STATSPACK reports

and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL

t race & SQL Tuning Advisor

• Extensively used FTP and SCP to copy the dump files from SQL to ROM servers.

• Used Remote export for migration of databases with used of DB links to migrate the data due to

space constraints on the SQL servers.

• Experience in Deployment of database to support the API Platform.

• Good exposure of 10gR2 RAC databases in dedicated server’s mode.

• Providing 24x7 on-calls Production Support on database and application side.

• Responsible for developing custom database monitoring scripts using Corn shell.

• Adding space to the data files to accommodate growth of tables paces.

• Automated the different tasks like (Creating Databases, Binaries Installation) using shell

scripts.

• Experience in Forms Load Balancing, Apache/JSERV upgrades and SSL setups

Environment: O racle 9i/10g, Putty, Sun Solaris 5.8, SQL Navigator, and Quest Toad, OEM grid

control management, PL/SQL, RMAN, Net Backup.

M cGraw H ill (Bakersfield, CA)

( Jan ‘09 - Feb ‘10)

Oracle Database Administrator

Responsibilities:

• Performed installations of Oracle software products and created databases and upgraded the

databases.

• Responsible for data integrity and user security.

• Performed physical database designing, analyzed database space needs and growth analysis,

and future storage requirements.

• Implemented backup and recovery strategies for archiving and non-archiving databases.

• Participated in planning and implementation of off-site Disaster Recovery planning and testing.

• Monitored the database for performance and tune accordingly.

• Created tables and indexes, sizing their extent, parti tioning and so on.

• Created users with restr icted access, with default and temporary table spaces.

• Analyzed design and data model solutions for business needs in cooperation with various levels

of business and systems personnel.

• Developed database system build sheets, code review check lists, code promotion process

documents, outage reporting documents.

• Worked with development and operations staff in resolving problems quickly and efficiently.

• Specified appropriate storage specifications for indexes, tables, table spaces, hashed tables,

clusters and rollback segments using Oracle’s auto extend management feature.

• Tuned SQL queries using T KPROF, E XPLA IN PLAN, and SQL TRACE.

• Supported development life cycle of t raining, development and production databases, reviewing

t he backup and recovery procedures for production database.

• Assisted in design tasks such as debugging, specifications development and system integration

testing.

Environment: O racle 9i/10g, SQL, PL/SQL, TOAD7.6, OEM, SQL Developer, RMAN 5.0.9,

SQL*Loader, UN IX Shell Scripting.

United Health Group (New York, NY)

( Oct ‘06 – Dec ‘08)

Oracle DBA

R esponsibilities:

• Reviewed Database logical and Physical design.

• Installed, upgraded and maintained O racle 10g, 9i on Sun Solaris and Windows 2003, Redhat4.

• Installed and configured of DATA GUARD.

• SQL tuning and Database tuning has been done based on reports generated by SQL Trace,

T KPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database

• Performed design and implementation of DB level replication schemes to support very high

availability across data centers

• Application T uning by tuning queries, identifying problematic code, creation of indexes, re-

wr it ing queries using an optimized path, creation of materialized Views and gathering necessary

s tatistics on objects etc.

• Implemented Database Security, M anagement of role-based security.

• Applied Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.

• Wrote and modified UN IX shell scripts to manage Oracle environment.

• Performed Data M igration as a part of enterprise data warehouse project.

• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and

SRDF), RAID, RAW Devices.

• Cloning databases using scripts as well as R MAN.

• Established database backup/recovery s trategy for different databases.

• Performed Strong search skills using Oracle Metalink as well as opening Service

• Recovery p rocedures are applied for complete and incomplete recoveries depending on the type

of failure.

• Constantly monitored the performance of the Databases and viewed A lert log files & T race files.

• Implemented schema level, table level and bidirectional oracle streams.

• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling,

Relational/ OLTP modeling.

• Used P L/SQL, SQL Loader as part of ETL process to populate the operational data store.

• Performed scheduling Control-m for scheduling jobs.

Environment : O racle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM,

R MAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK

Motorola Mobility (Libertyville, I L)

(Aug ‘05- Sep‘06)

Oracle Database Administrator

Responsibilities:

• Involved with Maintenance and Support processes.

• Documentation of Data Base Setup and administration of Server Environment.

• Performed planning and implemented solutions to handle high-speed data and high volume

data effectively.

• Implemented recovery and backup procedures.

• Implemented backup using NetBackup

• Involved in PL/SQL coding, mapping of view templates to DCMs for defining views to extract

data from tables.

• Performed Oracle applications installations, cloning and patching.

• Responsible for developing the new Master and Transaction Forms for the data Ent ry, Updating

and for data retrieval.

• Loaded data from f lat files and XML files to temporary tables in Oracle database using SQL *

Loader collections for better performance.

• Generated reports using Crystal Reports.

• Documentation of Data Base Setup and administration of Server Environment.

Environment: O racle 8i (8.1.5.0 – 8.1.5.1), SQL, PL/SQL, TOAD 6.5, OEM, Developer 2000, SQL

* Report, Form Builder6i, SQL*Loader

Contact this candidate