Manager Oracle
Resume:
Gouthami Reddy Ailoni
**************@*****.***
Summary:
Oracle DBA with experience in installation, configuration, tuning and troubleshooting
Over 4 years of experience in full application life cycle development, testing and production in
Information Technology - Software Industry
Experience in Installation and configuration of Oracle 10/11g Real Application Clusters (RAC)
Proficient in Adding, removal of nodes in RAC environment and handling databases on Oracle
10g, RAC, Physical Standby Databases (Data Guard).
Implemented Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load
balancing and designing failover systems on UNIX platforms.
Experience in Installing and Configuring OEM Grid Control.
Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off
Patches using OPatch and runInstaller under UNIX and Windows.
Experience in performance tuning of oracle databases, instances, Memory (SGA/PGA) Tuning.
Performed schema maintenance, troubleshooting, and production monitoring support.
Proactively monitored hit ratios on different components of the System Global Area and determine
the size of SGA.
Experience on tuning applications using OEM GC, Cost optimizer, SQL analyzer, Performance
Manager, Statspack, AWR, ADDM, ASH, RDA, Explain plan (10046), TKPROF, SQL TRACE
and Oradebug.
Expertise in installation, configuration and administration of Oracle 9i/10g/11g in very large
scale database environment (VLDB), high availability OLTP, Data warehouse (OLAP), DSS systems.
Developed Shell scripts for day-to-day database administration tasks that include various Cron jobs
for alert logs and performance, Backups, Restores and Recoverability
Performed TSPITR, duplicating database using RMAN. Involved in Disaster Recovery Planning
(DRP). Experience in partitioning and sub-partitioning.
Expertise in Database upgrading and migration of Oracle server (9i, 10g, 11g).
Test and implement different physical and logical backup and recovery methods like point in time
(PITR), media recovery, full / partial backup, Export/Import and DATA PUMP. Data loading using
SQL*Loader.
Implemented Replications (Oracle Streams) at table level (Unidirectional, Bi-directional) and
also performed proof of concept on the replication using oracle Golden Gate.
Hands on experience in oracle 10g Flashback to provide fast and easy recovery at database, table,
and row and transaction level.
Good exposure of advanced Security using Database trigger, Auditing.
Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, DBlinks,
Packages, Procedures, Functions, Cursors, Triggers.
Experience in managing users, privileges, profiles and schemas using Oracle Enterprise Manager
(OEM) and Grid control.
Provided 24 x 7 support and flexible to work beyond regular hours.
Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments,
Constraints, Database Access.
Oracle Support Services are utilized for troubleshooting and database issues by creating Service
Requests.
Involved in all phases of Project life cycle.
Self motivated and able to work in challenging environment. A team player with excellent
communication and interpersonal skill.
Technical Skills:
RDBMS Oracle 9i/10g/11g, SQL Server 2000/2005/2008
O perating Systems Sun Solaris, Red Hat Linux, HP-UX, AIX, Windows
N T/2000/2008
Tools Export/import, Data pump Exp/DPI, RMAN, SQL*Loader, OEM GC, LogMiner, Oracle streams,
AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN (10046), Oracle SQL
Developer, SFTP
Other Tools AUTOSYS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net
Worker, WinSCP
Languages SQL, PL/SQL, Shell Scripting, PERL Scripting, PHP, ASP.Net
Professional Experience:
Procurex Inc, Erie, PA Sep 10 –June 11
Oracle Database Administrator
Responsibilities:
Installation and maintenance of Oracle 11g/10g Data Guard 24*7 Production Environments.
Installation, configuration and maintenance of Oracle 11g Real Application Clusters (RAC).
Implemented Oracle Streams for the replication of data in Development to Production.
Running Cron job to do scheduled task of database like backup with help of RMAN scripts.
Data Refresh from Production to Test and Development environments using RMAN Duplicate
Database.
Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance
bottlenecks using STATSPACK, AWR, ADDM, ASH, ESTIMATE, ANALYZE, EXPLAINPLAN,
SQLTRACE and TKPROF.
Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of
various natures.
Extensively worked on imp/exp, impdp/expdp and SQL * Loader to load and unload data.
Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different
applications.
Used and maintained bitmap indexes, materialized views, DB links
Experience in partitioning and sub-partitioning (Range, Hash, List, Composite) of tables in OLTP
environment.
Upgrading development and production databases to Oracle 11g and applied patches to Oracle
Databases.
Cloned/Refreshed Oracle Databases and Oracle applications for development and testing.
Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles,
and schemas.
Oracle support and Meta Link are utilized to troubleshoot the problems and issues.
On-call support regarding production - related database problems is performed.
Provided 24X7 database administration support for production and development databases for
customer clients.
Environment: Oracle 9.x/10g/11g, HP-UX, Windows NT, RAC, OEM, Grid Control, RMAN, DBCA, Data
Guard, Putty, TOAD, SQL * Loader.
Gannon University. Erie,PA Aug 09 - Sep 10
Dot Net Programmer
Responsibilities:
• Project Name : Patient Billing System for Hospitals
This project is aimed at developing a patient billing software system that is of importance to a hospital. The PBS is a
local software system. This system can be used to maintain the location (bed no.) of each patient either in the ward or the
ICU. Information about the patient and the charges to be paid is also stored.
Software: ASP.Net using ADO.net as front end, Oracle9i as backend on windows platform.
• Project Name: Cafe Project:
Worked on a faculty schedule report by using crystal report writer equipped with Microsoft visual studio 2008. Created
SQL queries and sub queries to get needed data from SQL database for report.
Software: Microsoft visual studio 2008, MS SQL server 2000 as backend on windows Platform
Environment: Oracle9i/10g, OEM 9i, RAC, PL/SQL, RH-Linux, RMAN, SQL * PLUS, SQL *Loader,
RMAN, Sybase System 11, ASE 15, TKPROF, Explain Plan, TOAD, Sun Solaris and Windows 2000
Brigade Solutions India Private Limited Jun 07 - Jan 09
Role: Oracle Database Administrator
Responsibilities:
Involved in production support activities 24/7 during on call and resolved database issues.
Backup Script creation and Standardization. Performed Database Installation and up gradation.
Created materialized views, table partition for Tuned databases.
Created indexes, rebuild indexes and maintained indexes.
Audited database for statements, privileges, and schema objects.
Performed daily hot backup, weekly cold backup and full export/import
Involved in user creation and user access control. Involved in Schema creation and management.
Implemented Oracle security features and audit mechanisms for Fine grained access control.
Maintained the RMAN repository and customized recovery catalog.
Customized Data Guard as a tool for Disaster Planning and implementation.
Created Logical and Physical standby Databases to ascertain high availability of database during
system crashes.
Taking care of Rollback/Undo segment Issues
Performed database tuning for daily loads and slow response issues.
Used Triggers for database activities, like delete, update triggers.
Involved in session management and monitored the critical wait events in the database.
Involved In query optimization and using rule based optimizers and cost based optimizers.
Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
Used SQL* Loader for data import from remote databases
Written the control files in SQL*Loader to load the files in database tables.
Environment: ORACLE 9i, SQL, PL/SQL, Toad, Erwin, Import/Export, RH Linux, Windows NT.
EDUCATION:
Master of Science Computer and Information Science: Gannon University. Erie, PA
Bachelor of Technology, Jawaharlal Nehru Technological University, India
Contact this candidate