Chandra Aitharaju

862-***-****

acoq1b@r.postjobfree.com

Sr. Oracle Database

Administrator

SUMMARY

7+ years of experience in the IT Environment as an Oracle DBA. Expertise in

database administration, production support, installation, configuration,

upgrades, patches, performance tuning, backup and recovery, cloning, space

management, database security, troubleshooting, database design, Unix shell

scripting and documentation.

> Experience with Oracle 11gR2 RAC/11g/10g/9i in Installation,

Administration, Monitoring, Maintenance, Performance Tuning, Database

Backup and Recovery.

> Experience with working on EXADATA, Linux, Solaris, AIX and Windows

environments.

> Experience with Installation and administration of 2 node 11g RAC

database on Half Rack EXADATA X3.

> Experience in doing Cross Platform Database Migration from 10g on

Solaris to 11g on Linux servers using Transportable Table spaces,

Golden Gate and exp/Imp.

> Experience in Installation and Discover of all targets of OEM12c Grid

and OEM 10g Grid control.

> Highly Experienced in Database performance

monitoring/tuning/troubleshooting.

> Experience in reviewing and analyzing Oracle Database performance with

utilities like AWR, ADDM, ASH, SQLT, EXPLAIN PLAN, TKPROF, STATSPACK,

SQL TRACE.

> Involved in the installation and configuration of EBS R12(11g db) as

part of Financial upgrade project.

> Experience in installing, configuring and administration of IBM

Netezza database.

> Experience in setup and configuration of DATA GUARD for both RAC and

Stand alone Databases.

> Oracle Database capacity planning, space management and storage

allocation.

> Utilized SQL* Loader and data pump import to load data in to tables.

> Experience in migrating data from Oracle to Sql Server.

> Experience in Writing Perl Scripting, Shell Scripting, ksh and bash

scripting and Partitioning.

> Experience in configuring and utilizing Oracle Streams and GOLDEN GATE

for replication of Data.

> Experienced in hot/Cold Backup and Recovery and Cloning of databases

using RMAN.

> Worked on Data transferring with export/import utilities and Data pump.

> UNIX shell scripts for hot backups, SQL*Loader, export and import of

database.

> Experienced in Developing Oracle PL/SQL Packages, Dynamic SQL,

Triggers, Stored Procedures, Functions, DDL, and DML.

> Database Administration tools like OEM (Oracle Enterprise Manager),

TOAD, Sql Developer, Sql Server Studio.

> Excellent interpersonal and strong analytical, problem-solving skills

with customer service oriented attitude.

TECHNICAL SKILLS:

Operating HP-UX 10.x, Sun Solaris 9, 10, Red Hat Linux RHEL 4.x and

Systems Windows 2000.

RDBMS Oracle 11gRAC/11g/10g/9i/8i, MS SQL Server 2005/2008, Netezza

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

DB Management TOAD, OEM 12c, OEM 11g, OEM 10g

Tools/Utilities RMAN, OEM, SQL Navigator, SQL* Loader, ASM, SQL Server, TOAD,

Patch Management, ODBC, Oracle Streams, Data pump, Data guard

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

Database Erwin 4.0

Modeling

PROFESSIONAL EXPERIENCE:

Gymboree Corporation, San Francisco, CA

Jan 2012 - Present

Sr. Oracle DBA

Responsibilities:

. 24x7 Production database administration, support and monitoring to

ensure a proactive problem recognition and resolution.

. Installed, configured and Monitoring 2 node 11g RAC database on Half

Rack EXADATA X3.

. Migrated database from 10g on Solaris to 11g on Linux using GOLDEN

GATE for Zero downtime migration.

. Performed Cross Platform Database Migration from 10g on Solaris to 11g

on Linux servers using Transportable Table spaces and Exp/Imp.

. Installed Oracle 12c OEM Grid control, plugin agents on all target

servers and discovered all target 11g databases in our environment.

. Installed Oracle 10g OEM Grid Control, agents on all target servers

and discovered all 9i/10g databases in our environment.

. Involved in configuration of IBM Netezza database for dataware house

environments.

. Experience in Identifying performance bottlenecks on high volume

transaction systems using OEM, AWR, ASH, ADDM and SQLT reports.

. Analyze SQL statements, Re-organize database objects and create

indexes to improve response time of queries.

. Implemented DATAGUARD (Standby) for high availability/disaster

recovery purpose for RAC and Standalone databases.

. Database cloning from Production to Test and Development environments

on Oracle, Sql-Server and Netezza databases.

. Cloned databases from PROD to non-prod using RMAN Duplicate to support

testing teams.

. Applied various One-off and PSU Patches for Oracle 11g GRID/RDBMS homes.

. Involved in the configuration of Oracle EBS R12(11g db) as part of

Financial upgrade project and migrate database from 10g to 11g.

. Configured and maintained Physical Standby databases using DataGuard and

Dataguard Broker.

. Implemented Oracle Scheduler jobs for various maintenance tasks.

. Storage management, sizing the database objects, monitoring file systems,

and table space growth.

. Work with Oracle support to resolve Oracle bugs and database issues.

. Creation of database maintenance plans, rebuild indexes and integrity

checks

. Implemented RMAN Backups, Creation of RMAN catalog database.

. Recovery of Database (Recovering from Media Failure, Recovering tables

dropped accidentally, Recovering data files, Recovering from Block

Corruption).

. Performed full and incremental backups using RMAN.

. Provide database support during monthly & quarterly releases.

. Maintain and periodically test backup and recovery process for Oracle

databases for Disaster Recovery readiness.

Environment: Oracle11gRAC/Oracle11g/10g/9i, Exadata, Sql Server 2008/2012,

IBM Netezza, Linux, Sun Solaris, OEM Grid Control, Data guard, Golden Gate,

RMAN, AWR, ADDM, ASH, SQLT.

Sunmerge Systems Inc.

Deloitte, Santa Ana, CA

Oct 2010- Dec 2011

Sr. Oracle Database Administrator

(Court Case Management Project)

Responsibilities:

. Worked for Stress Team as Performance Engineer in California Court

Case Management System (CCMS) Project.

. Setting the tuning goals like improving the performance of the data

loads by reducing the total turnaround time to complete the load.

. Run the Oracle STATSPACK on the Oracle Instances to find out the

System Performance Statistics during the peak load times.

. Enabling the Trace files for the sessions which experience a very bad

performance and generate the Trace output using TKPROF utility for

further analysis.

. Trace the SQL that have poor performance and identify the ways of

improving the performance by adding necessary indexes or removing the

unwanted indexes.

. Installed Oracle 10g and 11g RAC database on Redhat Linux using ASM.

. Involved in all the process of System Development Life Cycle (SDLC)

for implementing a project.

. Installation of Oracle Databases on Sun Solaris as well as Windows

Servers.

. Provided 24*7 on-call support for all production databases.

. Responsible for Load and Performance testing of the database servers

and application servers, analysis and documentation of results.

. Created and implemented Oracle database backup and recovery strategies

using RMAN.

. Created and managing the database objects such as tables, indexes and

views.

. Carry general administration tasks using tools like OEM grid control

and Toad.

. Create & Managing Database Structure, Storage Allocation, Table/Index

segments, Rollback segments, Constraints, Database Access, Roles and

Privileges.

. Implemented Oracle Streams for setting up reporting server.

. Capacity Planning: Allocate system storage and plan future storage

requirements.

. Database move from one node to other and Reorganize.

. Database Schemas Creation based on the logical models.

. Perform Daily Monitoring of Oracle instances using Oracle Enterprise

Manager, monitor users, table spaces, memory structures, rollback

segments, logs and alerts.

. Trace the frequently called procedures/packages and pinning them to

improve the performance.

. Diagnose and resolve performance, connectivity, security and database

corruption issues in a critical production environment.

. Monitoring and Troubleshooting of Database Replication issues.

. Provided all kinds of DBA support to development teams as well as

production support to various tasks.

Environment: Oracle11gRAC/Oracle11g/10g, Linux, Sun Solaris, HP-UX, OEM

Grid Control, Dataguard, Ignite.

Sunmerge Systems Inc.

Acxiom, Conway, AR

May 2010- Sep 2010.

Oracle Database Administrator

Responsibilities:

. Installation of Oracle Databases on Sun Solaris as well as Windows

Servers.

. Install, Upgrade and configure Oracle database for various 32-bit and

64- bit platforms on Solaris and MS Windows 2000.

. Monitored around 5 Production databases with largest instance of size

over 2 TB.

. Carry general administration tasks using tools like OEM grid control

and Toad.

. 24 * 7 On-Call support on all production databases.

. Worked as part of D&B migration project to Migrate over 100 production

databases.

. Create & Managing Database Structure, Storage Allocation, Table/Index

segments, Rollback segments, Constraints, Database Access, Roles and

Privileges.

. Monitoring and Troubleshooting of Database Replication issues.

. Involved in the database design, Evaluation and Analysis.

. Setting the tuning goals like improving the performance of the data

loads by reducing the total turnaround time to complete the load.

. Run the Oracle STATSPACK on the Oracle Instances to find out the

System Performance Statistics during the peak load times.

. Enabling the Trace files for the sessions which experience a very bad

performance and generate the Trace output using TKPROF utility for

further analysis.

. Trace the SQL that have poor performance and identify the ways of

improving the performance by adding necessary indexes or removing the

unwanted indexes.

. Trace the frequently called procedures/packages and pinning them to

improve the performance.

. Interacted with data modelers, developers, application owners for

gathering the required information and resolving various issues.

. Diagnose and resolve performance, connectivity, security and database

corruption issues in a critical production environment.

. Responsible for Load and Performance testing of the database servers

and application servers, analysis and documentation of results.

Environment: Oracle 11g/10g, Sun Solaris, Windows 98/2000, Tru32 and

64bit, OEM Grid Control, Toad.

Sunmerge Systems Inc.

Wells Fargo, San Francisco, CA

Dec 2008- May 2010

Oracle Database Administrator

(Wachovia-Wells Data Conversion Project)

Responsibilities:

. Involved in performing migration from Oracle 10g to Oracle 10g RAC

database.

. Supported Remote DBA Support for all Oracle Production databases.

. Involved in Large data conversion project (Wachovia -wells) converting

sql-server, Seibel and Oracle data to Oracle.

. Wrote PL/SQL Scripts, Packages and views to extract load and create

data files using DTS and Sql server integration services (SSIS) in the

Sql server 2005.

. Involved in NDM (Network Data Mover) and secure plus setup for file

transmission between wells and Wachovia.

. Implemented Oracle Streams for the replication of data in Development

to Production.

. Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and

applying patches whenever required.

. 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).

. Monitoring experience includes Oracle Enterprise Manager Grid Control

and Quest Fog light.

. Troubleshooting on the databases for Application Server and Oracle

database related issues.

. Used ERWIN for logical and Physical database modeling.

. Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables,

stored procedures, functions, Cursors, triggers and UNIX Shell

scripts.

. Developed Perl Scripts in order to provide reports.

. Involved in development and implementation of Data ware house and Data

mart Design.

. Data Refresh from Production to Test and Development environments

using RMAN Duplicate Database.

. Daily Health Checkup of the database using statspack, AWR, ADDM.

. Involved in Oracle Warehoused Builder creating Star schemas,

Partitioned Materialized Views and logs utilizing Query Rewrite and

Start Transformation.

. Created database objects like tables, indexes, synonyms, views etc.

using SQL* Plus, used SQL*Loader control files to load data from

external data sources into Oracle database.

. Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming

to resolve business problems of various natures.

. SQL statement Tuning using Explain Plans and SQL Trace using TKPROF

utility and AUTOTRACE utility.

. Created scripts for data migration from flat files and MS Access to

Oracle.

. Developed ETL Process to load the data from .DAT files

. Analyzing tables and indexes for performance tuning. Optimizing

database objects and streamlining applications.

. Monitoring CPU usage, I/O Contention, memory paging on UNIX server.

Provide technical direction to system administrator.

. Worked with the business analysts throughout the development cycle,

and provided post-implementation support, for data and report issues

identified by customers.

Environment: Oracle 10gRAC/11g/10g/9i, Sun Solaris 9.0/10.0, IBM-AIX, SQL

Server 2005, Oracle Streams, Toad, SQL*Loader, Network Data Mover (NDM),

ASM, OEM Grid, RMAN, Erwin 4.1.2.

Sunmerge Systems Inc.

Touchstone Health, Manhattan, NY

Oct 2007 - Nov 2008

Jr. Oracle Database Administrator/Analyst

Responsibilities:

. Involved in Oracle databases configuration and Oracle Tuning.

. Coordinating Backup and Recovery operations over all databases,

ensuring 100% recoverability

. Performing Daily, Weekly and Monthly Oracle monitoring and maintenance

tasks

. Wrote Stored Procedures according to specs and control files for input

to SQL*Loader utilities for loading data from external files into the

Oracle database.

. Planning, Installation and Configuration of Oracle Database on the

Server.

. Creation of Table space, Data files, Indexes, Rollback Segment and

monitoring them.

. Creation of Users and Granting them privileges and roles.

. Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener

setup for oracle databases.

. Created Data Modeling and Data definition Language (DDL) to support

development efforts.

. Created and maintained different database entities included table

spaces, data files; redo log files, rollback segments and

renaming/relocating of data files on servers.

. Supported development effort by providing SQL statement tuning and

query performance bottlenecks by using tools Explain Plan, SQL Trace,

Tkprof, TOAD and Oracle Enterprise Manager.

. Created Heterogeneous services for accessing the database links from

an Oracle database to SQL server database.

. Performed Database Tuning. Performed Database Security and Integrity.

. Used extensive Sub Queries, PL/SQL procedure, DDL functions, database

triggers and packages.

. Responsible for writing database programming to Store/Retrieve the

information from the database using SQL

. Designing and creating schema objects like Database tables, indexes,

views, synonyms, and all schema objects in Oracle.

. Writing Pl/Sql procedures and functions. Writing shell scripts to

automate the data loading.

. Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 9i/10g, SQL Server 2000, UNIX (Sun Solaris), Windows

2000, TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, PL/SQL

navigator.

Educational Qualification:

. Masters in Software Engineering from Colorado Technical University,

Colorado Springs.

. Bachelor of Engineering in Computer Science from Jawaharlal Nehru

Technological University.

. Oracle 11g Certified (OCA).

Contact this candidate