Chaitanya Borugadda

Oracle Database Administrator

Executive Summary:

• 8+ years of extensive experience as Oracle 11g/10g/9i Database Administrator.

• Experience in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, C, C++, Unix, NT,JAVA, Shell Scripting.

• Extensive experience with Auditing and Security in Oracle and SQLSERVER.

• Hands on experience in install and Configure RAC (Real Application Clusters), Data guard, OEM, TOAD, Oracle Grid Control on various Platforms including Red Hat Linux, Oracle Linux, HP-UX AIX, Solaris and Windows Servers.

• Enormous Experience in Performance Tuning (Instance Tuning, Application Tuning, Database tuning), Understand proven techniques for Oracle health checks, optimizing SQL and optimize the SGA.

• Experience in installing and configuring ASM for Multiple Node RAC and Standalone Databases.

• Experience in installation and management of Oracle grid control (OEM) on 11g/10g databases and monitoring the servers through the centralized grid management.

• Experience in Migrating Sql Server 2000/2005/2008 to Oracle Using OMWB, Sql Developer.

• Experience as a Production/Development/Engineering/Data Warehouse DBA with Multi-Terabyte 24x7/large databases.

• Expert level knowledge in PL/SQL Programming (Writing stored procedures for Packages, Implementing functions, triggers, collections).

• Excellent knowledge in working with Physical & Relational models of the database in a development environment/multiple environments.

• Experience with implementing Oracle security features such as encryption and VPD- virtual private database

• Awesome experience in Database backups, user-managed backup/RMAN-managed backup with or without catalog, Cold and Hot backup.

• Experience in cloning the databases from production to dev UAT environments

• Experience working with Oracle Performance tuning tools like Statspack, AWR, ADDM, ASH, Explain Plan, SQL*Trace, Tkprof, indexing correctly.

• Experience in applying CPU, interim patches on standalone & RAC Environments.

• Experience with Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.]

• Hands of Experience with STREAMS AND GOLDENGATE Configuration.

• Performed database Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning.

• Experience in Data Loading using SQL * Loader, External Tables and Exp & IMP.

• Experience in latest features like Data Pump, Flash-Back Recovery, Recycle Bin and Transportable Table spaces.

• Experience with Virtual machines setup in both Oracle Linux as well as Red Hat Linux.

• Experience in ORACLE Database administration including Partitioning large tables, capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management

• Hands on Experience with Java in all Health care and Insurance applications.

• Experience in shell scripting and scheduling jobs using cron, DBMS_JOBS, DBMS_SCHEDULER.

• Impressive Experience in Health care, Insurance, Banking and Workforce management sectors.

• Good communication skills with the great demonstration skills, team player and highly professional, with a commitment towards excellence.

Technical Skills:

Hardware Systems Sun, IBM RS/6000, pSeries, x86, x86_64, I64, SAN (IBM DS8300), NETAPPS, EMC, HP 9000/E39, DELL Edge 2550/4500.

RDBMS ORACLE 9i/10g/11g, SqlServer,DB2, MS Access

Operating Systems UNIX, LINUX, HP-UX, AIX, Sun Solaris, WINDOWS NT

Languages UNIX Shell Scripting, SQL, PL/SQL, Perl, PHP, C, HTML

TOOLS/UTILITIES: SQL*LOADER, Data-pump, ERwin , TOAD, Import Export Putty, Win Runner, WinSCP3, SQL*Plus, Test Director, ETL, RAC, Oracle Migration Workbench, ASM, Oracle Grid control, Oracle Enterprise Manager(OEM), RMAN, EXPORT/IMPORT, OLTP, Net Backup, Informatica

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

Education

Bachelor of Technology from Nagarjuna University,India.

Awards and Honors

Certificate from Health Insurance Portability and Accountability (HIPPA) for Great job in protecting PHI (protected health information) and confidential information.

PROFESSIONAL EXPERIENCE

Gateway Health Plan®, Pittsburgh, PA Feb’11 to Till date

Role: Oracle Database Administrator

Responsibilities:

Install and Configurations of Oracle 11gR2 RAC with Oracle Cluster ware (CRS) on four

nodes on Red Hat Enterprise Linux 6 and Oracle Linux 6.

Installed and configured the Oracle Enterprise Manager (OEM) in virtual machines.

Implemented Oracle security features like Auditing in Oracle 11gR2 and SQLSERVER

2000/2005/2008 Databases.

Upgraded the databases from 10.2.0 to 11.2.0 in UNIX, Windows Environment.

Migrated Non ASM file system to ASM File system Using OEM.

Extracted all the Auditing data from all Oracle & SQLSERVER databases (40 databases)

and Loaded in the Data Ware House using Informatica.

Used EXPLAIN PLAN, TKPROF, SQLTRACE, ANALYZE, HINTS, AWR, ADDM, ASH etc

for Database performance tuning.

Understand the common causes of performance problems, See how data caching improves

access speed, and See how Oracle data repository allows for proactive database tuning.

Setting up Physical Standby Database Data Guard for Disaster recovery.

Configuring database entries, monitoring and maintaining user security for all of the

databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security

Manager (ESM).

Migration from Single instance to RAC and 10g to 11g RAC.

Data Refresh from Test to Production and Development environments using RMAN

Duplicate Database.

Experience with Oracle Very Large Databases (VLDB) of 1TB to 8TB.

Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized

Views and logs utilizing Query Rewrite and Start Transformation.

Working with VERITAS, SAN and EMC Net backup Technology to take the hot and cold

backups.

Involved Oracle query tuning for a data warehouse and STAR schema design and use of

bit-map indexes.

Managed the Very Large tablespaces and tables in 12 TB size of Database.

Configured the Streams both up streams and down streams.

Implemented Advanced features like Oracle security features such as encryption and

VPD- virtual private database.

Developed the database application with java like Installing Java DB, Connecting to the

Java DB Database and Deploying the application.

Configured the Oracle replication like Oracle Streams , Golden Gate

Identified bugs and applied required patches like CPU, DST & Bundle Patches as per the

oracle recommendations.

Developed shell-Scripts for RMAN, Hot and Cold backups.

Configured database using latest features of Oracle 11g like Undo-Tablespace, Automatic

Shared Memory Management (ASMM), Locally Managed Tablespace, Sorting Parameters.

Performed daily database administration tasks: User management, Space monitoring,

Performance monitoring, Alert Log monitoring and backup monitoring.

Provided on-call support regarding production-related database problems.

Environment: Oracle 11g R2 RAC, Solaris ,HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard ,Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, OWB, Toad, PL/SQL, Shell scripting, JAVA .

KRONOS, Chelmsford, MA Oct‘10 to Jan’11

Role: Oracle Database Administrator

Responsibilities:

Install and Configurations of Oracle 11gR2 RAC with Oracle Cluster ware (CRS) on four

nodes on Red Hat Enterprise Linux 5.

Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the

queries.

Performed backups, restore and Recovery procedures using Oracle Hot and Cold backup

procedures.

Performance Tuning using AWR, ADDM and Stats Pack and tuning usage of CPU,

Memory, Disk I/O and Network Contention.

Tuned SQL queries by using Trace, Explain Plan, Tkprof, Hints and Maintaining

appropriate indexes.

Migrating existing production Oracle RAC 10gR2 databases to Oracle 11g RAC databases

Maintain, enhance, and monitor the Retail Internet Environment through Oracle

Enterprise Manager Grid Control (OEM GC) for monitoring production Oracle databases

Configured Workload Management, JDBC, ASM, and RMAN for maximum

performance.

Deployed Oracle technologies like RAC, ASM, OEM/Grid, RMAN, Partitioning, Active

Data Guard, Oracle Streams / Golden Gate, Data Compression in production

environments.

Performed tuning in Oracle 9i/10g//11g for high transaction, multi-TB sized Databases.

Strong ability with UNIX shell scripting to automate tasks and also in Crontab and

dbms_scheduler for scheduling jobs.

Troubleshooting and performance tuning for Long Running Quires.

Managing the Virtual Machines like creating and configuring the Virtual Machine.

Regularly used Oracle VM for all the security applications.

Troubleshooting, backup and recovery, proactive database and system maintenance,

proactive monitoring, security, research and development, all levels of performance

tuning, architecture and design, mentoring and support

Tuned the Oracle Real Application Clusters for 4 nodes.

Setting parallelism on at the table or system level influences the optimizer, and

sometimes makes full-scan operations.

Invoking Parallelism like System level Parallelism, Session level Parallelism, Object

level Parallelism and SQL-level parallel query and also Extensively Worked with Oracle

column level compression.

Creating large tablespaces, big tablespaces and managing the tablespaces in Oracle

Performed data migration by data pump export and data pump import and utilities

Provided on-call support regarding production-related database problems.

Environment: Oracle 11g R2 RAC, Solaris ,HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard ,Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, OWB, Toad, PL/SQL, Shell scripting .

PNC Bank, Pittsburgh, PA Oct‘09 to Sep’10

Role: Oracle Database Administrator

Responsibilities:

Supported 50+ databases including RAC Production database, a Data warehouse database

and lot of Development and Test databases.

Setup of Standby database for faster disaster recovery and Data guard setup for high

availability.

Day to day performance monitoring and tuning of database. Monitoring of database

objects like rollback segments, temp segments and tablespaces. Diagnose and troubleshoot

Database problems and failures.

Monitor on a regular basis, as part of database preventive maintenance, the database

Growth, alert logs and archive log destination space through Toad and OEM.

Dealing with Oracle Support/Support Requests (SR), one-off patches.

Configured Dynamic SGA in Oracle Database 10g - Automatic Shared Memory

Management (ASMM).

Configured the Streams and Data guard in Oracle 10g

Migrated/Upgraded from Single Instance to RAC and 9i to 10g RAC.

Refreshed using Exp, import, hot, cold and rman backups from Production to non-prod

Environments.

Monitor database performance with Statspack/ V$ views/ TOAD.

Intended solutions and performing global enterprise database backup and recovery

Handling large database environments (Data warehouse) using ETL tool and Oracle

Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the

production database and constantly active regarding performance and space management

issues and accordingly providing on-fly solutions to make database healthy and running.

Storage and Space management including table spaces and data files. Management of table

space growth, monitoring data files additions and extent growth.

Taking care of all alerts for space issues and user requests.

Tuned SQL queries by using Trace, Explain Plan, Tkprof and maintaining appropriate

indexes.

Working with Clients, Business analyst and Reporting team.

Designed tools to proactively report system and database availability in highly available

environments. Created SQL and PL/SQL scripts to provide periodic reporting and

database monitoring for internal and remote customers.

Developed or modified some Oracle backup and recovery scripts. Used Oracle backup

utility RMAN/EBU to implement Oracle backup and performed a number of times of

disaster recovery.

Implemented database refresh with the hot backup using DUPLICATE or full export. Used

EXPORT/IMPORT to do table level and full database defragmentation.

Responsible for 24x7 support department.

Provide support for Oracle Enterprise Manager Grid Control and Agents.

Checking the invalid objects & recompiling the invalid objects by using utlrp.sql.

Environment: Oracle 11g/10g/ 9i, DB2, HP-UX, Solaris, OEM, Statspack, Tkprof, AWR, ADDM, TOAD, ERWIN, RMAN, ASH.

Wall Greens, Chicago, IL Mar ’08 to Sep ‘09

Role: Oracle DBA

Responsibilities:

Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle

Clusterware(CRS) on 3 node clusters starting from scratch..

Configuring Oracle 10g Data Guard for RAC production systems

Managed multiple instances, including strategy, planning and technical implementation.

Configured Automatic Storage Management (ASM).

Implemented advance features Flashback Query and Data guard to provide advanced

reporting and high availability (Hot Standby) solutions.

Design backup strategies for minimum downtime & providing maximum data security.

Used RMAN for full, incremental and cumulative backups and tested various RMAN

recovery scenarios for production databases.

Proactively monitoring, identifying areas that need to be improved in the application and

database using 10g OEM Monitoring.

Taking care of all alerts for space issues and user requests.

Locally managed tablespaces were used which track all extent information in the tablespace

itself. This results in improved performance as it eliminates recursive operations and

reliance on data dictionary.

Performed SQL tuning by using Explain Plan and Tkprof.

Migrated Non ASM file system to ASM File system Using OEM.

Must have experience with Oracle query tuning for a data warehouse and STAR schema

design and use of bit-map indexes.

Wrote Perl scripts for checking of Alert log and Trace files to monitor database on a daily

basis.

Identified, resolved, or provided recommendations to other different kinds of the

performance problems ranging from Database performance problems to I/O hardware

performance problems.

Periodically uploading data from flat files using SQL*Loader.

Used Oracle scheduler and Unix Cron utility for automating jobs

24/7 Production support on a rotational basis.

Environment: Oracle 11g/10g R2 RAC, HPUX, Red Hat Enterprise Linux 4, Toad, Erwin, OEM, sqlldr, ASM, ERWIN, GRID, AWR, ADDM, Data Guard, shell-script.

AON corporation, Las Vegas, CA July ’06 to Feb’08

Role: Oracle DBA

Responsibilities:

Installed Oracle 10g RAC with 2 Nodes on New Data mart Database Servers (RHEL- 4.0)

with New SAN Storage

Performed Migration of the databases from file system to Automatic Storage Management

(ASM) for managing huge data in SAN.

Experience ensuring the high availability, Performance and integrity of databases.

Configured logical/physical Data guard and managed data guard using data guard broker.

Installed Oracle 10g, Gridcontrol on Linux, Sun Solaris and Windows servers.

Have worked as Data modular building complex logical data models using sophisticated

modeling techniques and tools like TOAD, Erwin and Visio.

Responsible for Data Modeling and converting Domain model to Data model- logical and

physical database design, implementation, transforming logical data models into physical

databases, and defining strategies for database implementation, high performance, streams,

failover and Disaster Recovery.

Setup backup and recovery procedures using RMAN.

Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).

Worked on import/export, Datapump and SQL- loader.

Created and managed database objects such as tables, indexes, partition tables and views.

Created and managed users, roles, privileges, profiles, schemas using OEM.

Manage data architects, data administrators and client enhancement requests.

Expertise in Client server GUI software and different Operating systems.

Creating and rebuilding indexes and optimizing the code to improve the performance.

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

Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database

performance on daily basis. Having stored outlines before and after Database tuning to

stabilize and optimize the database by changing the parameters.

Extensively worked on Database administration activities like Installation, Configuration,

Backup & Recovery and Database Security.

Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-

clustered environments.

Database and log backups & restoration, backup strategies, scheduling backups.

Created Database Security by giving proper permissions to users and Admins.

On Call 24/7

Environment: Oracle 10g R2 RAC, Solaris , Red Hat Enterprise Linux 4, Data Guard ,Grid, OEM, ASM, RMAN, ASSM, AWR, OWB, sql developer, Toad, PL/SQL, Shell scripting .

Sunshine Corporate Services, India Feb’ 03 to Apr ’06

Placement Support System

ROLE: Oracle DBA

Responsibilities:

Administered all database installation, creation, modification, and tuning issues of Oracle.

Configured database using latest features of Oracle 9i like Undo-Tablespace, Locally

Managed Tablespace, Sorting Parameters

Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the

queries

Run oracle stats pack to tune the databases.

Wrote SQL scripts for DB monitoring, and online backups.

Implemented Oracle Replication to enable database fail over in cases of system or database

crash.

Performed database recovery in various scenarios ensuring least downtime.

Creating users granting the permissions and coping with the day-to-day demands and

troubleshooting their connectivity, permissions and performance problems.

Database activities include allocation and maintenance of Rollback Segments, Automatic

Undo Management, table spaces, data files, redo log files.

Performing scheduled Restoration drills by bringing down a test database in different

scenarios.

Maintaining and configuring the archived data on appropriate storage devices like Legato

Media manager.

Backing and restoring the database using RMAN utilities, Datapump and Veritas netback

up.

Creation, maintenance, and administration of databases under UNIX and Windows

environments.

Cloning of production database to the test environment using Recovery Manager (RMAN).

Running SQL Tuning scripts for gathering information on database performance like sorts,

gets, misses, cache hits, disk I/O activity, disk reads etc.

Database performance and tuning issues.

Tuning of I/O, which includes separating of data files and redo log files on different

locations, striping.

Experienced in using utilities like Export/Import and SQL Loader.

Developed PL/SQL packages, procedures, functions and triggers to support application.

Provided 24*7 System support.

Environment: Oracle 9i, HP-UX, Red Hat Linux, RAC, Tkprof, Statspack, SQL Loader

Contact this candidate