Mavuri - Oracle Administrator - Hyderabad, AP, India

Kumaraswamy Mavuri

Hyderabad, AP, India

Services

Oracle Administrator

Summary:

Hi

This is Kumaraswamy having very good exposure on administering oracle applications(11,11i, R12) and oracle database(8i,9i,10g and 11g) and also having very good exposure on ASM,RAC,GRID CONTROL,OEM and DATA Guard, for your consideration here i am attaching mym update resume
.
Presently i have been with Hitachi consulting (India, Hyderabad) as principal consultant
you can reach me on +91 8686846489 or +91 8341403199

Work History

Principal consultant

From February 2011

Project 2: Current
Working as principal consultant and giving production and development support to NetApp Environment:
Applications: 11.5.9,12.04 and 12.1
Database: 10g and 11g
Node: two Node installations
RAC: 10g RAC
Responsibilities:
• Code Migrations using KINTAN (third party tool) in DEV, TEST, UAT and PROD instances.
• Analysis and Applying the patches like CPU , application patches , Country code patches, one off patches and Maintenance Patches
• Refresh PROD instance to TEST and UAT.
• Resolving the user problems like accessibility of applications
• Creating the Users and assign the responsibilities.
• Configured SSO
• Implemented and configured the SSL setup.
• Performed the OEM and 10g Grid installation and configured the database and application Alert. Performed alert mailing configuration so that if issue came it will notified through mail.
• Upgrade large financial organization from 11.5.7 to R12.1. Design architecture put together all technical documentation, mentor dba's during the upgrade process. Implemented Data Guard for standby migrated existing 9.2. Databases to 11g Real Application Clusters. Implement a shared application top for both techstack and appl_top. Customers run AIX, HP-UX, Linux and Solaris.
• Manage Code migration, Data Conversion, disk space management, database performance and resource monitoring. Manage database network setup, Cluster setup, Fail Over set up, distributed database setup, and trouble-shooting (e.g. SQL statements, locking issues, network and performance problems)
• Backup the Database or logical/user objects for securing the data and database structure. Build up plans for cumulative or incremental backups using RMAN, Exp/Imp and Shell scripts. Set-up Backup policy and plans for Daily, Weekly and Monthly backup. Make cold or hot backups according to the production and Business requirements. Test and verify that the backup is completed and reliable to restore and roll forward if required. (Tools- Net...

Sr.OracleAppsDBA

Aptude Software Solutions

September 2009 - January 2011

Support project
Working as Sr.Oracle Application Consultant and giving production and implementation support for US Client Like Schneider logistics Inc,
My Responsibilities includes the following.

About the client and environment
Schneider is the biggest logistic company based on US (Green-Bay), It has more then 70 servers all are linux and AIX boxes most of the instances are running in RAC environment,

• Using the Grid control create jobs for (RMAN) backups and purging activities for different instance
• Involved in RAC (10G) configuration.
• Involved in Dataguard configuration..
• Installation or Oracle R12 and 11i single and multi-nodes
• Cloning the oracle application using Rapid Clone.
• Database Refresh using the Oracle Application tools RAPIDCLONE
• Done upgrade/migration from 11i to R12
• Done so many upgrade/migration from 12.0.4 to 12.0.6
• Applied patches using ADPATCH when ever require with different options.
• Installed and configured Standby Database
• Maintain RAC Instances
• Creating jobs in Grid Control (RMAN Scripts) to take the Level 0 and incremental backups(Level 1).

Sr.OracleAppsDBA

Sunera Technologies

August 2007 - August 2009

Upgrade project from 11.5.9 to 12.0.4
Handling 10 + clients and there environment and involved Data guard environment and upgrade from 11i ro R12.

• Installation of Oracle 8i,9i,10g ,11i, R12 single and multi-nodes.
• Involved in up gradation of Oracle Application from 11i(11.5.10.2 to 12.0.4) to R12.
• Cloning the oracle application using Rapid clone.
• Database Refresh, Using the Oracle Applications tools for maintaining the database and
Application like Adpatch, Adadmin, Adctrl etc.
• Done upgrade/migration from 12.0.4 to 12.0.6
• Involved in upgrade/migration from 11i to R12
• Done installation and configuration of Discoverer.
• Maintain the RAC instances Using the SRVCTL, OCRCONFIG, CRSCTL
• Applied the patches when ever requires and also applies security patches.
• Created number of instances for test, development and production.
• Managing the concurrent Managers and its operations like starting , stopping concurrent
• Managers, re-schedule the request, purging the concurrent request historical data, tuning of • Concurrent managers and monitoring the concurrent managers.
• Creation of scripts to automate the procedures to generate statistics on database space
• Management, performance and pro active monitoring.
• Application user's creation and responsibilities

Oracle Application DBA

Olam International Ltd

December 2006 - May 2007

• Installation of Oracle 8i, 9i.
• Involved in Database upgrad from 9i to 10G.
• Involved in configuration of Data guard
• Copy/Clone of Oracle application environment using Rapid clone.
• Database Refresh.
• Used Oracle Application tools for maintaining database and application like adpatch,
adadmin, adctrl etc.
• Applied RDBMS patches Opatch.
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas.
• Managing the Concurrent Managers and its operations like starting, stopping the
Concurrent managers, re-schedule the requests, purging the concurrent requests historical
data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Creation of new scripts to automate the procedures to generate statistics on database
Space management, performance and for proactive monitoring.
• Application user creation / responsibilities assignment.

Oracle Apps DBA

Clinet: HRM Business Consulting Sdn Bhd Malaysia

April 2003 - February 2004

Implementation project
Responsibilities Managed:

• Installing (11.5.9) and configuring the applications on single node.
• Copy/Clone of Oracle application environment using Rapid clone.
• Performance Tuning of Applications and database.
• Troubleshooting the servers (web server, form server etc).
• Monitoring Applications and Database Backups.
• Monitoring and Following up TAR's raised with Oracle.
• 24/7 Sys Admin Activities and Support.
• User creation setups, Creation of Responsibilities.
• Menu and functions creations, Profile Option Settings.
• Creation of Request Group, Data group, value sets and Flex Field setups.
• Creation of Concurrent Mangers, Programs, and Request sets.
• Troubleshooting of Concurrent Requests and Request sets.
• Automation of manual day to day activates using Concurrent programs.
• Knowledge of all business functional flow with in the Origination.
Project # 1:

Oracle Apps DBA

DB-Xpert Sdn Bhd Malaysia

May 2002 - November 2006

Responsibilities Managed:
• Installing and configuring the applications on single node.
• Involved in up gradation of Oracle Application from 11i(11.5.8. to 12.0.4) to R12.
• Copy/Clone of Oracle application environment using Rapid clone.
• Performance Tuning of Applications and database.
• Troubleshooting the servers (webserver, formserver etc).
• Monitoring Applications and Database Backups.
• Monitoring and Following up TAR's raised with Oracle.
• 24/7 Sys Admin Activities and Support.
• User creation setups, Creation of Responsibilities.
• Menu and functions creations, Profile Option Settings.
• Creation of Request Group, Data group, value sets and Flex Field setups.
• Creation of Concurrent Mangers, Programs, and Request sets.
• Troubleshooting of Concurrent Requests and Request sets.
• Automation of manual day to day activates using Concurrent programs.
• Knowledge of all business functional flow with in the Origination.
• Installation of Oracle 8i, 9i.
• Involved in Database upgrad from 9i to 10G.
• Involved in configuration of Data guard
• Copy/Clone of Oracle application environment using Rapid clone.
• Database Refresh.
• Used Oracle Application tools for maintaining database and application like adpatch,
adadmin, adctrl etc.
• Applied RDBMS patches Opatch.
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas.
• Managing the Concurrent Managers and its operations like starting, stopping the
Concurrent managers, re-schedule the requests, purging the concurrent requests
historical data, tuning of concurrent managers and monitoring of the concurrent manager
operations.
• Creation of new scripts to automate the procedures to generate statistics on database
Space management, performance and for proactive monitoring.
• Application user creation / responsibilities assignment.
Project # 2:

Oracle Application DBA

Dataprep Sdn Bhd

May 2002 - March 2003

Implementation Project:

• Installing (11.5.9) and configuring the application on single node
• Copy/Clone of Oracle application environment using Rapid clone.
• Database Refresh, Using the Oracle Applications tools for maintaining the database and application like Adpatch, Adadmin, Adctrl etc.
• Applied RDBMS patches using Adpatch.
• Created number of instances for test, development and production.
• Managing the concurrent Managers and its operations like starting , stopping concurrent
Managers, re-schedule the request, purging the concurrent request historical data, tuning of Concurrent managers and monitoring the concurrent managers.
• Creation of scripts to automate the procedures to generate statistics on database space
management, performance and pro active monitoring.
Application user's creation and responsibilities.

Database Administrator

Compurex Corporation Sdn Bhd

January 2001 - April 2002

Responsibilities Managed:

• Managed and supported 24X7 Oracle9i production databases as well as development
databases.
• Performed Oracle database daily routine maintenance including standby database
• management, user management, daily hot backup & weekly cold backup.
• Monitored and tuned production environment utilizing OEM, Performance Manager,
Statspack(9i) Utlbstat.sql/Utlestat.sql, TKPROF, etc..
• Provided full support to application development teams for application.
• Development, testing, system acceptance, implementation and migration to production.
• Responsible for Oracle software installation, configuration, maintenance, upgrades.


AtlantaSoftwareSystemsPvt.Ltd.

Database Administrator/Programmer

June 1998 - December 2000

Responsibilities Managed:

• Troubleshooting and 2nd-level support for database application issues, including Remote
administration of Unix OS: HP-UX, Solaris, Linux. Backup and recovery via RMAN scripts and troubleshooting, Monitoring of Oracle database; automated error notification. SQL statement analysis and tuning
• Storage analysis and allocation.
• Online index rebuilds and storage recovery.
• production database, archives database, training and multiple test environments.
• Application development support to programmers on all aspects of database
programming.
• Responsible for maintenance and improvement of production, archive Oracle database.
• Responsible for data refreshes for production, development and training databases.
• Responsible for storage usage of all databases, including rearrangements of the database
• logical structure and tables when needed.
:

Qualifications & Certifications

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?