Sr. Oracle Database Administrator

Document Sample
Sr. Oracle Database Administrator Powered By Docstoc
					Cheruku Reddy
                                   Oracle Database Administrator

    Over 7 Years experience as an Information Technology Professional. Performed as Oracle DBA, Senior Analyst and
     Programmer Analyst in a variety of (life cycle) environments including: Banking, inventory control, Health-Care Industry
     (medical claims analysis and on-line claims adjudication), Retail Web-Site support, HR (time & attendance).
    Oracle RDBMS Database Administration / Application Design and Development Design, Administration, Disaster
     recovery, Performance Tuning, Cloning, extent/space management, 24X7 On-Calls. Extensive custom development / data
     quality analysis; Legacy data processing, stored procedures, Triggers, indexing strategies.
    Proficient with Oracle 10g RAC, Data guard physical standby & Logical Standby Database, Data Guard, Replication.
    Proven Experience with 11g, 10g Release 2, - 9.2.07, and 8x versions.
    Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
    Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB).
    Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and
     Oracle Applications.
    Proven experience with database performance and tuning techniques to enhance database optimization plans.
    Proficient in Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF,
     STATSPACK, SQL TRACE, custom scripts and wait interface.
    Experience in installation, configuration of Oracle10g RAC.
    Experienced in using 10g features like 10g RMAN, Data Pump, Flash-Back Recovery and ASM.
    Managing the RAC databases such adding new nodes and deleting the existed node from cluster and managing ASM such
     as disk group maintenance database replication
    Good knowledge in Database Replications using Oracle Streams.
    Experienced in Disaster Recovery setup.
    Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
    Knowledge of database recovery techniques and implementation of those recovery techniques to ensure business continuity.
    Expertise includes management of schemas, objects & partitioning the tables & indexes.
    Expertise in maintaining Database Security using auditing.
    UNIX Systems Administration - Database and application integration efforts; CVS system installation experience; Heavy
     UNIX shell scripting, CRON jobs.
    Develop, document, and implement security configuration for Oracle software and database instances to comply with
     existing standards.
    Knowledge on Oracle Support processes for technical requests with Meta Link.
    Excellent ability to work both independently and in teams.

Technical Skills:

    Operating Systems              HP-UX 10.X, 11.X, Sun Solaris 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3,
                                   RHEL 3.x, 4.x and Windows 98/NT/2000/XP
    RDBMS                          Oracle 11g/10g/9i/8i, DB2, SQL Server
    Languages                      PL/SQL, SQL, C, C++, JAVA, VB, Unix Shell Scripting
    Tools                          RMAN, OEM, TOAD, SQL *Loader, Exp/Imp, Expdp/Impdp
    Tuning Tools                   TKPROF, EXPLAIN PLAN, STATSPACK
    Database Modeling              Erwin 4.0, Power Designer, Rational rose
    OS, Hardware, storage          EMC, NetApp, EMC, Veritas NetBackup, Net vault


Bronx Lebanon Hospital, NY                                                                           Aug 2008 - Present
Role: Sr. Database Administrator
Bronx Lebanon is a non-profit health care system serving south and central Bronx. The goal of the project is to install, configure and
administer oracle 10g RAC for few critical databases.


       Installing, Creating and Migrating the Oracle database on 11g.
       Created databases on RAC for Production, Development and ITG environments.
       Performed migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database.
       Migrated databases (10gR2, R1, 9i) to Oracle 10g R2 on RAC environment using Export/Import, SQL Loader,
        Database links, Data pump.
       Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER (OEM.) 10g
        grid control.
       Production support for Oracle database 9i/10g/10g RAC
       Troubleshooting on the Tickets for Oracle database related issues.
       Upgrading and Patching the 9i/10g/10g RAC
       Performed logical backup using export/import and data pump (remote export) utilities.
       Configured the RMAN backup.
       Rebuilding of Indexes for better performance, maintenance of Oracle Database.
       Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
       Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
       Creation and configuration of Standby Database (Data Guard).
       Carried out the Binary Installs in the Oracle 10g RAC environment.
       Done the Migration Review required before the database migration and QA after the database is migrated.
       Instance Strategy / Patch application to Development, UAT & Production environment.
       Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
       Provided full technical support to various application teams before the databases go to Production.
       Experience in interaction with the top management and escalations of the complex issues
       Performed entries capacity planning required creating and maintaining the databases.
       Perform Backups and Recovery; maintain 24 hours uptime for the database.
       Installation and configuration of Oracle Client software and Tools.

Environment: Oracle Enterprise manager, Oracle 9i,10g, 10g RAC, Sun Solaris 9, RHEL 4.x, VERITAS Net backup, RMAN, Toad.

Morgan Stanly, Wall Street, NY                                                                    Sept 2007 – Jul 2008
Role: Sr. Database Administrator

Morgan Stanly is a global financial services provider headquartered in New York City. It serves a diversified group of corporations,
governments, financial institutions, and individuals. I am Involved in creating, migrating oracle databases to a newer version and
giving a 24/7 on-call support.

    Involved in administration of over 30 Oracle instances.
    Performing all the Database Administration activity like space management in database, user and roles administration,
       schema management, checking alert log of all the databases.
    Involved in team management, team building exercises for the DBA team.
    Converted a single instance database to Oracle RAC 10g.
    Installation, Configuration and Administration of Oracle 10g RAC.
    Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent
       manager processing etc.
    Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
    Cloning of application from production environment to test environment and application of patches.
    Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
    Carried out hot backup, cold backup and RMAN backup.
    Creating tablespaces, sizing the system tablespace, allocating default tablespaces for users.
    Creating tables and indexes, sizing their extent, partitioning and so on.
    Creating users with restricted access, with default and temporary tablespaces.
        Creating roles and granting to users based on their group requirements.
        Creating profiles and attaching them with users.
        Developed database system build sheets, code review check lists, code promotion process documents, outage reporting
     SQL issues and Tuning Considerations for Different Applications.
     Monitoring the table growth, database growth, current users, and system resource usage and so on.
     Experience in SQL*Loader, loading data from text files.
     24x7 production database administration.
     Knowledge in writing shell scripts for automating backups and restoration.
Environment: OEM - Grid, TOAD, Sun Solaris 2.8/2.9 RHEL 4.x, Oracle 9i/10g, Oracle 10g RAC, 9.2.x, SQL Server 2000, Shell

Prudential Financial, Roseland, NJ                                                                           Jul 2006 - Sept 2007
Role: Sr. Database Administrator

Prudential Financial companies serve individual and institutional customers worldwide and include the prudential Insurance Company
of America, one of the largest life insurance companies in the U.S. These companies offer a variety of products and services, including
mutual funds, annuities, real estate brokerage franchises, relocation services, and more.


    Installing 10g on AIX Server.
    24x7 production support and resolving the problems reported by the development team.
    Responsible for setting up Production, Dev-Test, FTP and Warehouse databases on AIX.
    Applying latest patches to the database.
    Created & monitored the usage of Index to achieve maximum performance of the database applications.
    Implemented Shareplex Architecture for data Replication.
    Implemented the Data warehouse on AIX.
    Configured the Netvault with the database on Solaris/AIX
    Did Heterogeneous connectivity between databases.
    Responsible as secondary DBA for Remedy Applications.
    Performance monitoring and tuning.
    Fixing the problems encountered during the data load from the database to the warehouses.
    Database migration between cross platforms.
    Daily Health Check Up of the Database using stats pack, AWR, ADDM.
    Making changes for the existing shell scripts as per the needs.
    Worked closely with the architects and development team.
    Follow-up projects work with crisp documentation.
    Checked IO, CPU or memory bottlenecks and suggest appropriate measures.
    Used oracle tools (SQL*loader) and write procedures to migrate data from legacy systems.
    Verified daily loads and monthly loads.
    Managed indexes, partitioned tables.
    Installing Oracle and Upgrade to latest versions on IBM Aix.
    Configuring the Netvault server with Oracle RMAN.
Environment: Oracle Enterprise manager, Oracle 9i,10g, Power Designer, Netvault, IBM AIX ,Windows 2000,SQL server 2000.

Sprint Nextel Group, Overland Park, KS                                                             Nov 2005 - Jun 2006
Role: Database Administrator

Sprint Nextel is widely recognized for developing, engineering and deploying innovative technologies including robust wireless
networks serving more than 53.1 million customers in USA. Most of the databases of Sprint Nextel group hosted by EDS Corporation.
There are approximately 150 Production database in this project supported by EDS and are size of from 100GB to 8TB.

    Primarily responsible for 12 applications databases and for all applications supported by the team while in on call.
    Planning for Backup and recovery plan and performance tuning of the database as and when required.
    Communicating with the client and application team to resolve the problem within SLA.
       24 X 7 support of all production environment in Sprint Nextel group supported by our team.
       Proactively monitoring the database and fixing the problems.
       Involved in the process of tuning and refining queries of various applications.
       Planning and implement of the Backup and recovery standards in the entire Sprint Nextel database.
       Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
       Planning for future storage requirement of the database and notified to the application team.
       Performing hot and cold backups.
       Monitoring the Backup status. Database Health check.
       Restoration and recovery from backup.
       Created Flashback tables & Query.
       Applying patches, releases.
       Creation and up gradation of Oracle 9.x/10G database.
       Database move from one node to other and Reorg.
       Tuning the database performance through STATSPACK/AWR/ADDM report.
       Guiding the application team to understand how the database works with their application.

Environment: Oracle database 10g, 9i, 8i, HP-UX, Toad, RMAN, Data Guard, ASM, OEM.

SAI Info System Pvt. Ltd., India                                                                 Aug 2002 – Oct 2005
Role: Developer / DBA

This system is made to computerize the Personnel Department. It takes care of personal information of employees, history and their
monthly wages. The System also makes record of leaves, earnings, deduction, PF, attendance & personal accounts of each employee.


       Contribution as an effective team member in the design and development of sales and purchase information system.
       Modified and implemented logical and physical models of the companies on Sales and purchase
       Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to
        create database.
       Developed PL/SQL packages, Oracle tables, stored procedures, functions, triggers and UNIX shell scripts.
       Logically helped in database design, creation.
       Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
       Performed Database Security and Integrity.
       Creation of Users and Granting them privileges and roles.
       Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and
        formatted the results into reports and kept logs.
       Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
       Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to
        create database.
       Performance tuning of the SQL queries using Explain plan.
       Reading Alert Log and User trace Files and Diagnosing the Problem.
       Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
       Responsibilities include implementation of security of data according to client's requirements by creating views.

Environment: Oracle: 8i, 9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, UNIX
Shell Scripting, Quest software tools.