Oracle Database

Ram Damineni 571-***-**** *************@*****.***

Experience Summary: Around 7+ years of experience in IT and as a Senior Oracle Database Administrator in the Database Installation, Development and Production System Support leading global teams in a wide variety of cutting edge environments.Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, UNIX shell scripting, korn shell scripting and documentation.Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.Strong experience with Oracle Databases (11g/10g/9i/8i), RAC on Unix/Linux/Windows/VMware platforms. Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.Experienced in 7i/8i/9i/10g and 11g Database administration & Oracle Applications 11i and R12Experienced in various Unix Platforms like HP-UX, Sun Solaris, IBM-AIX, RHEL X86-64 and Windows System.Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (shell scripting) and documentationProficiency in standby database (Data guard) installation, upgrading, configuration, maintenance, backup and administration for disaster recovery on 10g/11g RACExpertise in converting single instance database to Real Application Cluster (RAC) Experience in upgrading SOA suite (BPEL, ESB and OWSM) from 10.1.3.1 to 10.1.3.3 and 10.1.3.4.Installed, Implemented and Configured 11i/R12 Oracle Applications.Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.Applied quarterly CPU security patches to Oracle E-Business Suite 11.5.x and R12.xMultiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g, 11.5.5 to 11.5.09, 11.5.5 to 11.5.10 as well as application tier upgrade Experienced in working with adutilities like adadmin, adpatch, adctrl and adsplice and also resolving the issues during patching.Proficient in cloning the Oracle Apps and database using rapidclone and autoconfig.Experience in working and tuning with Oracle Workflow. Experience in basic and advance replication using Oracle Streams, oracle golden gate.Experience in using 11g features such as real application testing, sql plan baselines.Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM. Experience in Installing Oracle 11gR2 GRID Infrastructure, 11gR1 CLUSTERWARE, 10g CRS on RHEL.Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 trace, 10053 trace, AWR, ADDM, to collect and maintain performance statistics and improve the database performance.Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers.Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.Profound knowledge in Oracle utilities including export/import, Toad, SQL*PLUS, Data Loading using SQL Loader. Adept in data modeling, Physical and Logical Database design, partitioning of tables and indexes, management of schemas. Exceptional communication and interpersonal Experiencing in basic and advanced replication6 years of Experience in using OEM,TOADExpertise in loading data from flat files using external tables, SQL*Loader.Installation, Configuration and Updating of Oracle Business Intelligence tools.Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Technical Disciplines:

Technical Skill Set:

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, Windows 2003, Windows 2008

RDBMS

Oracle 11g/10g/9i/8i

Languages

SQL,PL/SQL C, C++, Perl, Korn, UNIX Shell Scripting, Java.

Tools

RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR .

Database Modeling

Erwin 4.0, Rational rose, UML 2.0

Other

EMC, NetApp, Veritas NetBackup

Professional Experience:

Client: Cisco Systems – Sanjose, CA Mar 2011 – Aug 2012

Role: Sr Database Administrator

Roles and Responsibilities: Upgraded Database from 9.2.0.5 to 10.2.0.2, 10.2.0.2 to 10.2.0.3 and 10.2.0.3 to 11.2.0.2Production support Maintenance activities, written shell scripts for Monitoring production activities.Perform general technical troubleshooting and working with Functional teams for possible solutions for various issues.Applied patches using KINTANA and also in various modes using adpatch utility.Concurrent manager administration and Oracle Apps sysadmin functions.Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.Upgraded Oracle database from 11.1.0.6 to 11.2.0.3Troubleshooting RMAN backup and recovery related issues.Worked with Oracle Corporation to resolve applications/database issues by opening TAR/SRSupporting Oracle Databases 9i/10g/11g also RAC on Linux/UCS(Cisco linux version)Experience in troubleshooting some Oracle EBS hosted databases on R12 and 11.5.10.2Performed Cloning, export/import and Patching.Designing the logical and physical database structure.Designing the security and database access strategies.Taking Backups on scheduled time and monitoring scheduled BackupsPerforming backups and recoveries using RMAN conventional hot backups.Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.Creating and dropping of users, granting and revoking rights as and when required..Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention. Tuning heavy data loads. Monitoring and Performance tuning.Using TKPROF, EXPLAIN PLAN and AWR for the Better performance.Monitoring of database for growth and performanceMonitoring Database for fragmentation and correcting them.Performed and Monitored Database using tools TOAD and OEM 10g

Environment: Oracle Server 10g/11g, SQL, PL/SQL, Linux Itanium, Solaris 10, Shell scripting, TOAD, OEM 10g, Oracle EBS

Client: NetApps – SanMateo, CA July’2009 – Mar’ 2011

Role: Sr Database Administrator

Roles and Responsibilities:Strong working experience in 24 X 7 Production database administration, data warehouse systems and monitoring to ensure a proactive problem recognition and resolution of very large database issues.Creating of databases for Testing, Development and Production on VLDB systems. Converted a single instance database to Oracle RAC 10g Installed and Upgraded Oracle 11g database from Oracle 10g database on test and development environments.Installation, Configuration and Administration of 4 node Oracle 10g RAC.ASM and CRS installation and new database creation for 10g RAC.Experience in configuring Oracle Advanced Security Option (ASO) and Secure Sockets Layer (SSL) on both server and client machines.Implemented Streams on both 9i and 10g Databases, Export & Import on 9i Database, DataPump in 10g Database.Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation. Used RMAN for backup and recovery. Performed backup validations using RMAN.Implemented and Involved in Hot, Cold and Logical backup plansOracle 9i & 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.Proactive database monitoring using 10g grid monitoring tool.Developer Environment Setup, Support, Cloning and Refreshes.Performed database cloning to setup test and development databaseSetup of Standby database for faster disaster recovery and data guard setup for high availability.Used External Tables to Load data from flat files to database.Implemented different Partition methodologies to improve performance and manageability.Diagnose and troubleshoot Database problems and failuresWritten Korn, Perl, shell scripts for digitization the process.Load balancing, databases/schema/table re-organization for faster performance.Installation of Oracle version 10g on Solaris, HP-UX and AIX boxes.Database dot release upgrades using oracle universal installer and catpatch.sqlUpgrading of Database from 9.2.0.6 and to 10.2.0.2Was involved in developing a disaster recovery (DR) plan and Stand by Database Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK Conducting sizing & capacity planning for Oracle databases.Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent OLAP patches.Experience in reading Alert. Log and User trace Files and Diagnosing the Problem.Scheduling jobs through Oracle job Scheduler.Providing Solutions to the Problem Faced by end Users Or ProgrammersAutomation of Startup Shutdown on all Production and Development Database.Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Serves.

Environment: Oracle Server 10g, RHEL 3, 4, Windows, Shell & Perl scripting, TOAD, Oracle 9iAS, OEM 10g

Client: Mepco Finance Corporation, Chicago,IL Dec’ 2007 – June’ 2009

Description: Mepco Finance Corporation specializes in providing payment plans for vehicle service contracts to customers, allowing them to pay for their vehicle service contracts over time. Mepco was founded in 1964 and has grown to national prominence by providing dependable, personalized service to its customers and administrators

Role: Sr Database Administrator

Roles and Responsibilities:Installed, configured and managed Oracle 10g RACConfigured Oracle networking for RACInstallation and creation of 9i and 10g databases for Testing, Development and Production.REFRESH/CLONING of Database and applications for development, testingInstallation and Maintenance of STANDBY database using DATAGUARD.Conducting sizing & capacity planning for Oracle databases.Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.Experience in troubleshooting the ORACLE streams.Configured RMAN backup for 10g RAC databaseMonitoring 10g RAC performance Experience in setting up the Basic/Advanced Replication by using ORACLE StreamsApplied High priority, security patches downloaded from Meta linkDesigning the logical and physical database structure.Logical and Physical data modeling.Performed SQL Server Replication, Database Mirroring and Log ShippingExperienced with SQL Server DTS( Data Transformation Services)Configured Streams bidirectional setup between source and target databaseInstalling and Implementing RMAN backup and Recovery Procedures.Taking Backups on scheduled time and monitoring scheduled BackupsEstablish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.Configuration of Oracle 10g R2 OEM Grid Control to monitor database and report on events as defined by the DBA groupTaking periodic Backup of the Database and the software using RMAN and VERITAS Netback upImplemented Oracle Enterprise Security Manager( ESM) Performed upgrades from Oracle 9i to 10g. Developing 10g Grid Agents to target serversPartitioning Strategies for very large tables.Performing SQL*Loader jobs for data loading.Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.Data refresh from production to test and development, maintain Database Security.Performed block recovery using RMAN. Performed backup validations using RMAN.Oracle 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 Management, Space Management Granting required privileges to users.Defining and Implementation of backup and recovery strategiesTuning heavy data loads. Monitoring and Performance TuningPerforming all daily Maintenance tasks. Interacting with Oracle Customer service when required.Writing scripts for the system and database for effective functionality and report generation.

Environment: Oracle Server 10g, RHEL, Windows, Shell & Perl scripting, TOAD, Oracle 9iAS, OEM 10g

Client: HorizonLines, Dallas TX Dec’ 2006 – Nov’ 2007

Role: Database Administrator

Roles and Responsibilities:Provided 24X7 support for all the production and development databases.Installed and configured Oracle 10g.Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.Appling the patches using OPATCH and Patch sets using OUIApplied Oracle Applications and database patches.Cloned/Refreshed Oracle DatabasesImplemented Disaster Recovery plansResponsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL.Provided support to Application Database Administrators in designing the database. Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.Worked on several Perl scripts to maintain the database activitiesMentoring the Database Performance using automated scripts.Experienced in Security Administration and Space Management Perform other regular DBA activities including space management and performance monitoring.Answerable for setting and managing User Accounts, Granting required privileges to users.Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.Continuous monitoring of database performance during peak and non-peak loads using STATSPACK. Implement Stored Procedures and Triggers based on business plans using PL/SQL.Automation of data load using Korn shell scripting and SQL*Loader.

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

Client: Miracle Software Systems, India Nov’ 2004 – Sep’ 2006

Role: Database Administrator

Roles and Responsibilities:Installing 9i for TEST and Development.Developing shell script to automate the processes.Create table spaces, tables, and users for custom applications.Creating and dropping of users, granting and revoking permissions to users/roles as and when required.Upgrade from Oracle 8i to oracle 9iInstalled and Implemented Backup & Recovery procedures.Write SQL scripts to monitor table space and extent growth.Developed RMAN scripts for database backup and recovery including HOT and COLD backup.Using TKPROF, EXPLAIN PLAN for better performance.Experienced with Oracle Virtual Private Databases(VPD)Upgrading and migrating the databases.Performed Table space Management and Rollback table space Management.Applying standalone RDBMS patches.Capacity Planning & Benchmarking.Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.Created PL/SQL procedures (jobs) to automate maintenance tasks.Database export/import using export and import utilities.Data loads using SQL loader utilities.

Environment: Oracle Server 9i/8i, SQL*Plus, SQL*LOADER, PL/SQL, HP UX, Windows, UNIX shell script Database Size: over 3TB

Education BackgroundBachelor of Engineering in Computer Science VITU - Vellore, India

RELOCATION: Willing to relocate depending on the place

REFERENCES: Available upon request.

Contact this candidate