Manager Oracle

KUMARASWAMY MAVURI

Mobile : +91-834******* Or +91-812*******

E-Mail: ********@*****.***

Professional Profile

SUMMARY

** *****+ of experience as Oracle Application DBA (11i,R12 and R12.2), on UNIX, Linux, AIX,Solaris and Windows2000 .

Applying patches to test instances and performs rigorous testing and subsequently applying to development and production instance.

Well versed in using AD utilities – adadmin, adpatch, adrelink, adctrl, adident, admrgpch.

Managing concurrent process,concurrent programs/managers registering new concurrent programs concurrent types, defining workshifts and specialization rules and combined specialization rules, defining new concurrent managers as per client requirements.

Involved in Migration of 11.5.10.2 to 12.0.4 ( R12)

Involved in PCP(Parallel Concurrent Processing) configuration.

Performa Database upgrade from 10g to 11g

Perform Database upgrade from 11g to 12c

Involved in creating RMAN backup scripts.

Configure and install RAC (10G RAC) on Linux

Involved in configuration on LOAD Balancing

Administer and maintain Cluster (RAC) environment since last 4 yrs.

Good knowledge of cloning RAC as well as Non-RAC database and configuring ASM database.

Managing Database structures,constraints,database access,roles and privileges.

Good Knowledge of online, offline and RMAN backups and recoveries.

Managed ASM configuration and migration of database from clustered file system to ASM.

Installation, Configuration and deployment of Oracle 11i, R12 and 10g/9i/8i database.

Install and maintain multi node installation of 11i and R12.

Expert in OEM, TKPROF, Explain Plan and SQL tuning of Oracle databases.

Highly experienced in Oracle 11g/10g/9i/8i Administration, Export and Import. Performance Tuning, Backup & Recovery.

Designed and implemented backup and recovery strategies. Extensively used RMAN for backup and Disaster recovery.

Responsible for patching oracle application and Oracle Databases as per requirements.

Successfully implemented Physical Data guard (standby database ) using Oracle Data Guard feature for High availability configuration.

Provided 24/7 support to production databases beyond regular hours.

Efficient in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.

Experienced in Database design including creation, modification, and deletion of table spaces, data-files, rollback segments and schema's, creating schemas (Tables, Indexes, views, sequences, synonyms, roles, and users).

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Eposure on Weblogic administration.

Exposure on OBIEE administration.

Exposure on Informatica administration.

Exposure on SOA Administration.

Technical Skills

Applications

Oracle Applications 11.0.x, 11i .R12 and R12.2

Application Object Library, System Administration, Workflow and Alerts

System Administration

Accounts Receivables, Purchasing, Order Entry,Account Payables, Fixed Asset, Cash Management and General Ledger

RDBMS

Oracle 8.0.x, Oracle8i, Oracle 9i, Oracle 10g and 11g

Languages

SQL, PL/SQL,

Administration

Database Administration, Backup & Recovery, Performance & Tuning,SQL Server 6.5 and 7 Database administration

Database Utilities

Export / Import, SQL * Plus and SQL Loader, Tkprof, Bstat / Estat, StatsPack, AWR, Server Manager,ASM Backup, RMAN,,

Database Tools

TOAD, Oracle Enterprise Manager (OEM), Grid Control, DBArtisan

Development Tools

VB 6.0 Forms 4.5 and Forms 6i

Operating Systems

Sun Solaris 2.6, Linux – RedHat Linux, AIX, Solaris,Windows 3.x/9x/NT/2000/2003/XP

Hardware

HP9000, Sun 6800, v880, 4400, Sequent & NT, Windows 2000

Project Experience :

Lead Solution architect

Gerab India EngneeringProducts Pvt Ltd, Hyderabad

From April 2016 to 31st Aug 2016

Working as Lead Solution Architect and giving offshore support to Gerab Dubai based company,

It has multimode environment running on Linux operating system.

My responsibilities as below

Application : 11i and R12(12,2,5)

Database : 10g and 11g.

Node : 2 node installation.

Responsibilities:

Installation of Latest version of oracle application 12.2.5.

Installation of weblogic.

RMAN setup

Cloning of PROD instance to UAT.

Patch analysis and applying the patch both 11i and R12 instances using ADPATCH and ADOP.

Installed 12c cloud control.

OEM configuration and maintained the database administration.

Done Cross platform migration (SunOs to Linux ).

Ennvee Software Solution Jan 2016 to April 2016

Worked Sr.OraleAppsDBA and giving offshore support to US Based Clients based company,

It has multimode environment running on Linux operating system.

My responsibilities as below

Application : 11i and R12(12,2,5)

Database : 10g,11 and 12c

Responsibilities:

Installation of Latest version of oracle application 12.2.5.

Installation of weblogic.

RMAN setup

Monitorin RMAN backups

Monitorin Dataguard issues

Patch analysis and applying the patch both 11i and R12 instances using ADPATCH and ADOP.

Installed 12c cloud control.

OEM configuration and maintained the database administration.

Asm Technologies Ltd,Bangalore,

Client : Oracle India Hyderabad

AMEX AT ORACLE CLIENT

From June 2014 to 30th Sept 2015

Working as Principal consultant and giving offshore support to AMEX(US based company)

Technologies – E-Business Suite(R12),Oracle Database 11.2.0.3 On RAC Oracle solaries sparc 4

Applications: 11.5.9,12.04,R12 and R12.2

Database : 10g and 11g

Node: two Node installations

Responsibilities:

Analysis and Applying the patches like CPU, application patches,Country code patches, one off

Patches and maintenance patches.

Resolving the user problems like accessibility of applications.

Performed taking backups of OCR and VOTEDISK files.

Applied database patches Cluster Patches using Opatch Utility.

Applied application patches using ADPATCH AND ADOP

Cloning the application of run file system then copied to patched system(R12.2

Weblogic administration.

Informatica administration.

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.

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).

Hitachi Consulting (Formerly named as Sierra Atlantic

Role : Principal consultant From Feb 2011 to till June 2014

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 backup, RMAN, Exp/Imp, shell scripts, Data Guard for Standby DB)

Project 1 :

Working as Principal Consultant and giving Production and development support to Sunpower corp US based company

Upgrade project from 11.5.10 to R12.04

Responsibilities:

Code migration on both UAT and PROD instances.

Performed 11i To R12 Upgrade, We upgraded the database from 9.2.0.6 to 11GR2.

Performed the Disaster Recovery setup for the Client. As a part of Maintenance activity

Performed the DR drill. Health checkup of Production instances

Applying the patches on UAT, PROD instances.

Taking care of production and UAT errors.

Refreshing the PROD instance to Development instance every week.

Taking care of RMAN backup schedules.

Creating the Mail alerts such as tablespace free space, blocking session.etc

Proficiency in Upgrading, Patching and implementation of Oracle Apps (Release 12 / 11i) and Proficiency with several AD admin tools like Rapid clone, ADpatch, Auto upgrade, ADadmin, ADcontroller, Etc.

Performed the Disaster Recovery setup for the Client. As a part of Maintenance activity

Aptude Software Solutions

Role – Sr.OracleAppsDBA From Sep 2009 to Jan 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).

Sunera Technologies

From Aug 2008 to Aug 2009

Role – Sr.OracleAppsDBA

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

Olam International Ltd, Singapore December, 2005 – July 2008

Role – Oracle Application DBA

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.

DB-Xpert Sdn Bhd Malaysia May 2002 – Nov 2005

Oracle Apps DBA

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 :

Clinet : HRM Business Consulting Sdn Bhd Malaysia

Implementation project

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 :

Client : Dataprep Sdn Bhd, Malaysia

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.

AtlantaSoftwareSystemsPvt.Ltd. January,2001 to April 2002

Database Administrator/Programmer,

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.

Education

B.Com (Andhra University, 1984)

Higher Diploma in Software Engineering, AP Tech, India.

Contact this candidate