Oracle Data
Resume:
[pic]
Madhu Reddy
abhq5n@r.postjobfree.com
Madhu Reddy
____________________________________________________________________________
__________
SUMMARY:
. Over 7+ years of experience in Oracle databases (8i/9i/10g/11g)
administration, providing 24x7 production and development support,
backup and recovery, performance tuning, performance monitoring,
schema maintenance on a various environment like Sun Solaris, HP-UX,
AIX, LINUX and Windows 2000/NT.
. Good experience in Oracle10g/11g Real Application Clusters (RAC)
environment on different nodes with Automatic Storage Management (ASM)
to support large volume.
. Experience in Performance Tuning by using tools/utilities by Automated
Workload Repository (AWR), Automatic Database Diagnostics Monitor
(ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
. Successfully configured and implemented Physical Standby Database
using Oracle DATAGUARD feature for High availability configuration and
offline reporting.
. Excellent experience in cloning oracle databases for development and
testing.
. Extensively used Advance Replication (Oracle Streams) of oracle
databases for high availability.
. Experience on Oracle Enterprise Manager-Database Control, 10G Grid
Control for monitoring and tuning the database.
. Expertise in data transfer using Export/Import using command line as
well as in interactive mode and through Data pump.
. Expert in design and implement of database backup strategy and
performed full, incremental and Cumulative backups using RMAN.
. Wrote and modified Unix Shell Scripts to manage Oracle environment.
. Wrote and modified SQL queries to pull data from data warehouse
tables.
. Extensive experience on Partitioning and creation of the Indexes on
large tables to improve the Performance.
. Good experience in managing large OLTP and DW databases.
. Experience in data extraction, transformation and loading, including
parallel data loading, external tables.
. Good experience in HA and DR (Oracle RAC, Streams, Dataguard), Oracle
partitioning and compression experience, database architecture, design
and data modeling in an OLTP and Data warehouse environment.
. Good experience in managing 3rd party applications using Oracle
Database.
. Extensive experience in SQL, PL/SQL package, function, stored
procedure, triggers, and materialized view, to implement business
logics of oracle database.
. Extensively used Oracle support and MetaLink to troubleshoot the
problems and issues.
. Proven ability to work efficiently with Excellent verbal and written
Communication and presentation skills.
. Excellent interpersonal skills, team player, aggressive, hard working
and result oriented.
Technical Skills:
Databases : Oracle 11g RAC/10g RAC/9i/8i/7.3.
Operating Systems : Red Hat Linux (RHEL) 3.x, 4.x,5.x, AIX5.1, 5.2, 5.3,
SunSolaris 8, 9, 10, MS-DOS,
Windows98/NT/2000/XP, HP-UNIX10.x, 11.x.
DB Utilities : EXP/IMP, EXPDP/IMPDP, RMAN, ASM, OPatch,
SQL*Loader.
Languages : SQL, PL/SQL, C, C++, JAVA, HTML, XML, Unix
Shell Scripting.
Tools : OUI, OEM, Grid Control, Database Control,
Putty, RMAN, ADDM, AWR, Tkprof, Toad7.6/7.5, SQL*PLUS,
Statspack.
EDUCATION / TRAINING / CERTIFICATION:
. Bachelor of Technology, Jawaharlal Nehru Technological University,
India.
. Received training in Oracle 9i and Database Administration, NIIT, Hyd,
India.
. Oracle Certified Associate (OCA) - Database Administrator from Oracle
Corporation.
PROFESSIONAL EXPERIENCE:
Price Waterhouse Cooper,Tampa, FL
Aug 2009- Till date
Sr. Oracle DBA
Responsibilities:
. 24x7 Production database administration, support and monitoring to
ensure a proactive problem recognition and resolution of database
issues.
. Senior DBA, Primary point of contact for client for database and
configuration management related issues.
. Installed and Configured Oracle 10g/Oracle 11g database instance
running across four Oracle RAC nodes on Red Hat Linux.
. Installed, configured and administered Automatic Storage Management
(ASM) on Single instance and RAC instances.
. Database cloning from Production to Test and Development environments.
. Administered and managed Production, Test, and Stage and Development
databases involving more than 100 applications.
. Review database environments, such as database settings, monitoring
oracle user processes.
. Installed and configured Data Guard using physical standby for high
availability databases.
. Adding and deleting nodes.
. Created Physical standby database from hot backup of primary database
and wrote shell scripts for backup and cloning.
. Used Oracle Streams for data replication between oracle databases.
. Upgraded databases from Oracle 9i to oracle 10g and Oracle 10g to
oracle 11g.
. Moving data from several databases to Data warehouse database, using
data extraction, transformation and loading, including parallel data
loading, external tables.
. Partitioning large DW table to achieve better performance.
. Performance tuning of OLTP and DW databases.
. Daily database administration tasks including backup and recovery
through RMAN, Import/Export.
. Tuned memory structures such as the database buffer cache, shared
pool, library cache.
. Developed Recovery procedures that are applied for complete and
incomplete recoveries depending on the type of failure.
. Performance Tuning by using Oracle utilities like explain Plan,
StatsPack, Tkprof, Oracle Enterprise Manager for addressing
performance bottlenecks and issues.
. Provided all kinds of DBA support to development teams as well as
production support to various tasks.
. Good working knowledge on HP Service Desk which involves in alert,
service calls, work orders and change tickets for any kind of activity
involved with Production Databases.
Environment: Oracle 11g RAC, 10g RAC/9i, Red Hat Enterprise Linux, IBM AIX,
Sun Solaris, HP-UX, OEM (Grid Control), ASM, RMAN, RAC and DataGuard,
GoldenGate, PL/SQL, DataPump.
Blue Cross Blue Shield, Kansas, MO
Jan 2005 - Jul 2009
Oracle DBA
Responsibilities:
. 24x7 Production Database support of multi-terabyte Oracle databases.
. Installed and Configured RAC on Red Hat Linux Advanced Server with 3
nodes server side with load balancing and using Automatic Storage
Management (ASM).
. Configured and administered Standby database for high availability by
using Dataguard.
. Cloning databases for development and testing.
. Optimized INIT.ORA parameters like DB block size, block buffers,
shared pool and rollback segments.
. Adopted day to day performance monitoring and tuning of database.
Monitoring of database objects like rollback segments, temp segments
and table spaces.
. Tuned SQL queries with the help of explain plan and Tkprof and
advising the application programmer of the opportunities in tuning the
application.
. Generated AWR (Automatic Workload Repository) Reports and used them
for tuning the database.
. Monitored Storage and Space management including table spaces and data
files. Management of table space growth, monitoring data files
additions, extent growth using Grid Control.
. Moving data from several databases to Data warehouse database, using
data extraction, transformation and loading, including parallel data
loading, external tables.
. Partitioning large DW table to achieve better performance.
. Performance tuning of OLTP and DW databases.
. Wrote monitoring scripts to check reports for space, Max. Extents,
coalescing etc which are kept in CRONJOB.
. Created, implemented and Documented Backup and Recovery strategies and
procedures after evaluating various options including RMAN.
. Adopted the best PARTIONING Technique & determined the best INDEX
selection to improve the SQL Queries.
Environment:Oracle10g RAC/11g RAC/9i,DataGuard,ASM,Replication,Red Hat
Enterprise Linux, Sun Solaris, HP-UX, OEM, DataPump,
ExplainPlan,Tkprof,SQL*LOADER, PL/SQL.
Farmers Insurance, Simi Valley, CA
Mar 2006 - Dec 2007
Oracle DBA
Responsibilities:
. Provided 24x7 database support for all systems.
. Installed and Configured Oracle 9i/10g.
. Applied patches to the existing versions of Oracle.
. Worked a lot with Tables, Tablespaces, Data file sizing and
reorganization, Index rebuild, data loading, Analyzing Objects, Data
Modeling, and Managing Rollback Segments using OEM.
. Developer Environments setup using database cloning and refresh
procedures.
. Provided Oracle DBA support included Oracle database installation,
upgrades, instance configuration, tuning, schema maintenance,
troubleshooting and production monitoring.
. Coordinated and Assisted in Database upgradation from 9i to 10g
Release 2.
. Generated backup recovery procedure/scripts for the Database through
Log Archiving.
. Performed day-to-day DBA jobs for managing Prod/Dev databases like
Export/ Import, moving tablespaces, rebuilding indexes, synonyms,
partitioning tables, etc.
. Identified poorly performing queries using ExplainPlan, TKPROF,
STATSPACK reports and assisting the developers in optimizing and
tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.
. Managed the Schemas by creating various objects like tables, views,
indexes and maintaining data integrity using constraints.
Environment: Oracle 10g RAC/9i/8i, RMAN, TKPROF, IBM AIX, RedHat Linux,
DataPump, OEM, SQL*LOADER, PL/SQL.
Image Hospitals, Hyderabad, India
Apr 2003 - Feb 2006
Oracle DBA
Responsibilities:
. Supporting 24x7 production databases.
. Installed and Configured Oracle 7.x/8.x on windows 2000 server
environments.
. Monitored backups, applying patches, exporting and importing data
between the instances, creating database links, creating users,
maintaining rollback segments, adding tablespaces and data files
. Creation of new Oracle user accounts.
. Extensively used Explain Plan, Tkprof and Statspack.
. Created database objects like tables, views, indexes and partitions.
. Tuned and configured Sizing, performance monitoring and tuning the
databases, database objects and custom applications.
. Wrote shell scripts to start and shut down the databases, perform
backups, purging archive log files, cleaning trace files.
. Uploaded the data between the databases using Export and Import
utilities.
. Loaded the data from legacy systems to databases using SQL * Loader
. Wrote small shell scripts for automating jobs.
Environment: Oracle 10g/9i/8i/7.3, Windows 2000 server, Sun Solaris, TOAD,
SQL*PLUS, SQL*Loader
Genex Global Solutions, Hyderabad, India
Jun 2003 - Mar 2004
Jr. Oracle DBA
Responsibilities:
. Handled database migration from 8 to 8i, 8i to 9i.
. Created the Oracle 9i database using the SQL scripts.
. Performed in HOT and COLD backups of the databases and also the
individual table spaces.
. Worked with database export & import scripts to backup database
structures and automation procedures.
. Worked on monitoring and optimizing the database by performance
tuning.
. Wrote SQL queries and maintained documentation of the Database.
. Used STATSPACK for Database Monitoring and Database Performance.
. Tuned the SGA, Buffer Cache, Rollback Segments, Redo Mechanisms,
Monitoring and Detecting Locks.
. Created tables, indexes, table spaces, users, integrity constraints
and supported all phases of a development cycle.
. Contributed to team effort by accomplishing related results as needed.
. Wrote Oracle scripts for the SQL and PL/SQL functions, procedures,
packages and triggers.
Environment: Oracle 9i/8i/7.3, HP-UX, SQL & PL/SQL, TOAD, Putty, ERWIN.
Contact this candidate