Data Oracle
Resume:
Chandra Aitharaju
**********@*****.***
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