Document Sample
Theepi.Reddy_DBA Powered By Docstoc
					Theepi Reddy
Oracle Database Administrator

Around 8+years of IT experience as Senior Oracle Database Administrator on a variety of UNIX (Solaris, HP-UX,
IBM-AIX), Windows NT 4.0/2000/2003 with Oracle (7.x, 8.0.5, 9i, 10g, 11g), 10G RAC, Streams, Data Guard, Advanced
replication, Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance
tuning and troubleshooting.

   Expertise in database administration, installation, configuration, upgrades, migration, performance tuning,
    backup and recovery, cloning, space management, patching, and security, auditing and designing
   Excellent experience in Installation and configuration of Oracle 7.3.4 to 8i to 9i, 9i to 10g to 11g in Solaris
    8/9/10, HP-UX, Tru64 Unix, IBM AIX 5.2/5.3 Linux and Windows environment.
   Experience in Oracle Database Administration including creation and maintenance of the Database (Backup,
    Recovery, Tuning, Security, and Capacity Planning,Upgradation, Migration) and System Analysis, design,
    development and implementation of Relational Databases (Oracle, SQLserver,DB2) and Data Warehousing
   Experience Implementation experience with 11g RMAN Features like Advice on data recovery, parallel
    backup of the same file, and virtual catalogs for security.
   Expert in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
   Experience in Implementation of backup strategies with hot, cold & Oracle exp/imp utility using UNIX shell
    scripts, RMAN backups.
   Expertise in Installation (Oracle 10g RAC software with ASM & OCFS2 File systems), maintenance and tuning of
    RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
   Experience in automating backup strategy using the UNIX shell script CRON UTILITY.
   Expert Integration experience with different clusters (MC Service Guard, VERITAS cluster) clustering in the
    real application cluster Environment.
   Experience Implementing development, testing, staging, production, 10g,11g RAC and standby databases
    for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
   Expert implementing ORACLE STREAMS, and two types of standby databases supported by DATAGUARD,
    logical standby and physical standby databases.
   Experience in basic and advanced replication processes including Oracle Streams, Advanced Replication and
    materialized views.
   Extensively worked on RMAN, media management, backup sets, lists and reports, channel allocation, restoring
    files, media recovery, recovery catalog and integrity checks.
   Expert in tuning using automatic database diagnostic monitor (ADDM) and used automatic workload repository
    (AWR) to gather statistics by collecting, processing, and maintaining performance statistics for database
    problem detection and self-tuning processes.
   Expert in Implementation 11g features like Active Data guard and setting Parameters Memory Target using
    Automatic Memory Management, GRID Control.
   Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning,
    Database/Instance Tuning and Designing Databases.
   Experience in managing of schemas, objects & Partitioning the tables & indexes and in creating and optimizing
    indexes for high-performance applications.
   Expert in capacity planning, space management, storage allocation and different type of storage structure
   Experience in all phases of SDLC like analysis, design, code, unit test, system test, and implementation,
    Integration testing and to check whether the data is loading into target, which was extracted from different
    source systems according to the user requirements.
   Extensive knowledge of Oracle Architecture, SGA, PGA, TNSNames, V$ and DBA views.
   Experience in SQL, PL/SQL, Pro*C and Perl Scripting, Partitioning, Data modeling with utilities like
    ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database
   Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for
    Day – to – Day activities.)
   Expert in Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache,
    redo mechanisms.
   Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes
    for technical requests through Metalink and other Support Procedures.
     Participated in appropriate consulting, interfacing, and training for users and delivered associated
      documentation for user interaction with the database environment.
     Strong presentation, troubleshooting, analysis, design, code, unit test, system test, implementation with
      excellent interpersonal and communication skills.

Technical Skills:

    Operating Systems           Sun Solaris 2.5, 2.6, 8, 9, 10, Tru64 Unix, AIX 5.1, 5.2, HP-UX 10.x, 11.x,
                                RHEL 2.1, 3.x, 4.x and Windows 95/98//NT/2000/XP
    RDBMS                       Oracle 10g/9i/8i, SQL Server 2000/2005/2008, Teradata 12/13,DB2.
    Languages                   SQL, PL/SQL, C,C++, UNIX Shell Scripting,VB,AWK Scripting, Bash Scripting, Perl
    Tools /Utilities            RMAN, OEM, SQL*Loader, SQL Server, RAC, ASM, EXP, IMP, expdp, impdp, TOAD,
    Hardware                    HP Unix 11.x, Sun Server Enterprise 10000 with 128 Processors and EMC Disk
                                Array Sun ES 6500/5500/4500 E 10K with RAID, Digital Alpha Server AS800,
                                EMC Disk Storage 8000 Families, HP LH 5/100 Servers, OPEN VAX/VMS, AIX
                                & SCO Unix Servers, Unisys 6000/60 (Super Mini), Compaq Cluster Servers.

    Database Modeling           Erwin 4.0, Rational rose, Toad Data Modeler, Datanamic and start UML, ER/Studio.
    Front ends                  Web Logic Applications, Developer 2000 (Oracle Forms 6i), Oracle Web Server
                                1.0, Oracle Reports 2.5, Oracle Browser 2.0, PRO *C, DBTUNER (EMC)


InterContinental Hotels Group, Atlanta, Georgia
Duration: July 2008 – Till date
Role: Sr. Oracle DBA

Project Scope: The goal was to assist local developers in the design, construction and management/operations of
individual hotels in important international gateway destinations and traffic centers. Managed the databases of
various sizes ranging from 2 TB to 30 TB and supported Large Databases. There were many development projects.
Which were going on, as a result of ever growing demand of new databases in the organization, the development
projects were more client based, which included all the client related information as well as investment data, Hotel
opening management Application, Plan sales history, Revenue management Applications other tasks also included
InterContinental Hotels Group (ICG) datacenter migration and supporting production databases.

Rational rose, PL/SQL, SQL*Loader, SQL Server 2005, DB2, Toad V9.7 and VCS.


     Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
     Performed upgrades from Oracle to on Intel and IBM P590 Boxes.
     Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 9i over to
      IBM P590 Boxes running Oracle 10g and 11g.
     Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g and 11g).
     Installed and created 10g databases and 10g OEM.
     Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
     Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges
      and user logins.
     Installed Oracle 9i and 10g, RAC database on Redhat4, Windows Servers, and IBM-AIX.
     Configuration, maintenance and tuning of Oracle 10gRAC and 11gRAC.
     Configured 11g Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file,
      and virtual catalogs for security.
     Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW
     Cloning databases using scripts as well as RMAN.
     Setup grid control for managing lots of databases.
   Installed Oracle 11g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related
    problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of
   Data Replication, Event Management and Notification.
   Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within
    managed databases.
   Data Warehouse Loading, Data Protection.
   Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned
    databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-
    related documents such as manuals and spreadsheets
   Extensive UNIX Shell scripting in csh, ksh.
   Used third party clusters (VCS) in clustering environment.
   Implementation of 11g Active Data Guard.
   Supported SQL server and DB2 Databases in a large Environment.
   Involved in Creating / Renaming the database and implementing SOX policy.
   Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN
    duplicate features and then upgrading them to Oracle 10g.
   Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
   UNIX shell scripting in csh, ksh to be controlled from Crontab.
   Database schema refresh.
   Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
   Extensive Performance Tuning, Memory (SGA) Tuning, etc.
   Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
    Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL
    analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD. For SQL tuning using “Explain plan”,
    “TKPROF”, “SQL_TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics, Statspack etc.
   Expertise in interpreting EXPLAIN PLAN.
   Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity
    plans, and index analysis.
   Writing Procedures, Triggers and Packages and Development.
   Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
   Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle
   Taking Hot and Cold Backups, Exports.
   Oracle Grid control installation for monitoring databases.
   Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced
    Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
   Data Modeling using Erwin, Database Design and Creation.
   Deciding the naming conventions of data file, redo log files, table spaces, and segments.
   Writing scripts for backup and recovery, Import and export procedure.
   Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts.
   Applying patches both Server side and Client side.
   Setting up new environments (Development, Production).

Merck & Co., Inc, Whitehouse Station, NJ
Duration: Jan 2007 – June 2008
Role: Sr. Oracle DBA

Project Scope: Merck & Co. describes itself as a global research-driven pharmaceutical company. Merck discovers,
develops, manufactures and markets a broad range of innovative products to improve human and health. Managed
the databases of various sizes ranging from 50GB to 4 TB and supported Large Databases. The team was involved in
Application Development, Analysis and maintaining dataguard and RAC servers and performed all databases related
activity to ensure maximum availability of databases and also work very closely with the System administration and
the storage administration.

Environment: Oracle database 10g ( to, 9i (, SunSolaris8.0/9.0/10.0, DB2 , Redhat4,
RAC,TOAD,OWB,Erwin7.2,ASM,VCS,Citrix,Oracle Enterprise Manager, SQL Server 2000,ETL, RMAN, SQL*Plus,
PL/SQL, SQL*Loader.


   Installed RAC on Oracle 10g and worked on ASM feature of Oracle
   Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO
    and Memory Usage.
   Installed Oracle 9i and 10g, RAC database on Redhat4, IBM-AIX 5.3, and Windows Servers, SUN Solaris.
   Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer
    cache, redo mechanisms
   Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
   Configured Oracle 11g active data guard and Streams.
   Oracle Grid Control Management Server Installation
   Reverse engineering and forward engineering using Erwin.
   Data Modeling, Database Design and Creation using Erwin.
   Production to development refresh.
   Bi-directional streams implementation.
   Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) 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.
   Made performance improvements to the database by building Partitioned tables, Index Organized Tables,
    Materialized Views and Bitmap Indexes.
   Supported development effort by providing SQL statement tuning and optimizing ETL (OWB) procedures and
    removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and
    Oracle Enterprise Manager.
   Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints,
    Stored outlines, Statistics for the same.
   Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to
    appropriate groups.
   Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
   Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
   Worked on recovering tables and databases using Flash Recovery.
   Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for
    performance testing and future 10g production implementation.
   Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using
    Oracle data pumps.
   Neteeza is used for Performance tuning of Queries. It is a database that has outstanding performance when
    dealing with quering data. This is a relation database, but there are no constraints that are set on the tables,
    which allow very fast querying.
   Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL Procedures
    and Packages, Triggers and database design, database tables, indexes, Instance, memory, operating system and
    java calls.
   Developed UNIX shell scripts to perform the above tasks efficiently.
   Worked as a member of production DBA team in perfect coordination with seniors and team members.

Sprint, Atlanta, GA
Duration: Oct 2005 - Dec 2006
Role: Sr. Oracle DBA

Project Scope: Sprint is the largest provider of local and long distance telephone services, DSL Internet access and
wireless service in the United States with 71.4 million wireless customers and more than 50 million total customers.
Worked on a large environment as a member among team of 11 DBA’s, responsible for support of about 120 Oracle
instances The project was to support oracle database, managing user creation, patching, cloning, log file checkup,
performance tuning of applications configuring oracle application and backup and recovery.

Environment: Oracle 10g1/9i ,Sun Solaris ,Red Hat Linux,RAC,Oracle Enterprise Manager, Rational rose,SQL,
PL/SQL, TOAD,ASM, RMAN, TPROF, Explain plan,ASM STATSPACK, SQL* Loader, Windows NT/2000.


  Involved in 24x7 supports for both production and development databases with on-call pager.
  Installation and creation of 9i and 10g databases for Testing, Development, Production including configuration,
  backup & performance tuning.
  REFRESH/CLONING of Database and applications for development, testing
  Installation and Maintenance of Stand by database.
  Assist with setting coding development and applications standards for developers to follow
    Apply sound development practices to development process for interfaces and applications.
  Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.
  Conducting sizing & capacity planning for Oracle databases.
  Designing the logical and physical database structure.
  Designing the security and database access strategies.
  Logical and Physical data modeling using tools like ER/Studio.
  Taking Backups on scheduled time and monitoring scheduled Backups.
  Performing backups and recoveries using RMAN conventional hot backups.
  Establish and Document Backup and Recovery strategies and procedures after evaluating various options
  including RMAN.
  Partitioning Strategies for very large tables.
  Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
  Performing SQL*Loader jobs for data loading.
  Data Modeling, Database Design and Creation using Erwin.
  Data refresh from production to test and development, maintain Database Security.
  Performed block recovery using RMAN. Performed backup validations using RMAN.
  Database monitoring, troubleshoot and resolve the issues.
  Management of schemas, objects partitioning the tables & indexes.
  Automation of data load using shell scripting and SQL*Loader.
  Responsible for setting and managing user accounts, Granting required privileges to users.
  Defining and Implementation of backup and recovery strategies
  Optimization and tuning SQL queries using TRACEFILE, TKPROF, EXPLAIN PLAN.
  Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
  Tuning heavy data loads. Monitoring and Performance tuning.
  Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required.
  Writing scripts for the system and database for effective functionality and report generation.

Bank of New York, NY
Duration: June 2004 - Sep 2005
Role: Sr. Oracle DBA

Project Scope: Global Trade Solutions system manages Documentary Credit (Letter of Credit) business of Bank of
New York (BNY). The system allows the BNY employees to manage the entire life cycle of a letter of credit, including
initiation, issuance, amendments & verification of the documents. The system also has interface for beneficiary bank
since BNY’s branches and partner-banks in Asia would act a beneficiary bank. Supported production databases and
involved in tuning many of these applications by studying the overall system performance and suggest the
appropriate suggestions to improve the performance of the Oracle based Applications.

Environment: Solaris 8.0/9.0/10.0,OAS 10g, Linux Red Hat,ASM,Windows 2000/2003 Oracle 8i (8.1.6/8.1.7), Oracle
9i/10g2, RAC, RMAN, Oracle Enterprise Manager, Oracle Partitioning, Standby, Rational rose ,PL/SQL, SQL*Loader,
SQL Server 2000, Toad.

 Review of Database logical and Physical design.
 Install, upgrade and maintain Oracle software products/versions for on Linux, Sun Solaris and HP-UX.
 Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
 Installed RAC on Oracle 10g and worked on ASM feature with EMC Storage of Oracle.
 Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using
   an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
 Implementing Database Security, Management of role-based security
 Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
 Applying Patches and applying Oracle DST Patches on Oracle database.
 Configuration, maintenance and tuning of Oracle 9Irac.
 Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files,
   monitoring disk usage, Table/index analyze jobs, database backup logs etc.
 Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
 Corporation and installation of patches.
 Write and modify UNIX shell scripts to manage Oracle environment.
 Problem analysis involving interactions/dependencies between UNIX and Oracle.
 Production support for Oracle running on UNIX.
 On-Call 24x7 DBA support for production databases.
   Data Migration as part of enterprise data warehouse project.
   Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, net backup, EMC (Time finder and SRDF),
    RAID, RAW Devices.
 Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard.
 Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
British Telecommunications, Newgate
Duration: Feb 2002- Apr 2004
Role: Oracle DBA

Project Scope: BT is one of the world’s leading communications companies, operating in over 170 countries around
the world. Project’s included building; maintaining and testing databases, Involved in the entire development life
cycle right from development to production, other tasks included were supporting and tuning BT applications.

Environment: ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Erwin, Import/Export, UNIX AIX 5.1,
Windows NT.

 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.
 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.
 Performed database tuning for daily loads and slow response issues.
 Used Triggers for database activities, like delete, update triggers.
 Used Statspack, Perfstat, TKPROF utilities for Tuning and analysis.
 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.
 Used SQL* Loader for data import from remote databases
 Written the control files in SQL*Loader to load the files in database tables.

IKEA, Småland, South Sweden
Duration: July 2001- Jan 2002
Role: Oracle DBA

Project Scope: IKEA is a privately-held, international home products retailer that sells flat pack furniture,
accessories, and bathroom and kitchen items in their retail stores around the world. IKEA wanted to migrate all of its
historic data for the last 10 years as well as existing data along with applications to a RDBMS platform. Worked as a
Junior DBA, interacted with the users for studying the existing running Applications.

Environment: Oracle 7/8.1.7,Windows 98/NT / 2000, HP-UX, TOAD, Database Tools/Utilities.

 Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
 Analyzed the structures using Analyze command.
 Involvement in all phases of the project life cycle
 Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the
   database and system
 Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
 Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
 Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning,
   Rollback tuning.
 Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Education: Bachelor’s in Computers Science from Jawaharlal Nehru Technical University (Graduated in 2000)
Certification: Oracle Certified Professional (10g) From Oracle Corporation.

Shared By: