Recovery Manager Renewable Energy
Resume:
ORACLE APPS AND ORACLE DATABASE ADMINISTRATOR
Shubha KE
******.***@*****.***
PROFESSIONAL SUMMARY
Around 8.5+ years of experience in oracle application and oracle database administration by providing 24/7 support for production, development environments on various platforms.
Good understanding and work experience with different unix and windows platforms,
Strong experience in installation, configuration, maintenance and administration, customization of oracle ebs11i, r12 application and oracle database.
Experience in database and application cloning, patching, upgradation.
Experience in single node and multi-node erp installation and administration of RAC database.
Expertise in setup, administration of data guard for disaster recovery.
Good in Performance tuning at database and application level.
Good in cloning, refreshing ebs11i, r12 and database using different backup methods.
Sizing, planning the database storage and experience in troubleshooting backup and restore.
Experience in database security and management.
Used AD utilities like adpatch, adadmin, adclone, adident, adctrl, admrgpch for application activities
Mongo database administration and weblogic application administration, patching.
Good understanding and administration of oracle cloud environments.
Have good analytical and problem solving and excellent communication and interpersonal Skills, ability to understand and adapt to new technologies and environments faster.
TECHNICAL SKILLS
Operating System
Unix (AIX 5.3, Red hat Linux, Sun Solaris 2.x/8, HP-UX 11i, 10.x), Windows XP/8/9/10
ERP
oracle ebs 11i, R12 (12.1.3, 12.2.4, 12.2.5)
RDBMS
oracle database 9i,10g,11g,12c,13c dataguard, RAC, oracle clod database
Languages
sql,c, unix shell, plsql
Tools
Toad, sqldeveloper, tkprof, sqlprofiler, opatch, oracle diagnostics pack, AD utilities, oam, application desktop integrator (ADI), web ADI, oracle Enterprise manager (OEM), recovery manager (RMAN), discoverer
Other
OBIEE 10g, OID, SSO, fusion middleware 11g, apache, UPK, ringmaster, kintana, appworx, oracle cloud, mongodb, cassandra, aws
ACADEMIC QUALIFICATION
BCA from Sahyadri Science College Shimoga.
MCA from Bangalore Institute of Technologies, Bangalore
Oracle Certified Foundations Associate from Oracle University
PROFESSIONAL EXPERIENCE
1.Employer: Tata Consultancy Services
Client: Cisco Systems India Pvt Ltd
Duration: Feb 2016 to Jan 2017
Client: Arris India Pvt Ltd.
Duration: Feb 2017 till date
Role: Oracle apps dba
Environment: oracle ebs 11i, r12.1.3, 12.2.5 database 10g and 11g, 12c, data guard, RAC, OEM13c,
oracle cloud database (paas), fusion middleware 11g, oracle weblogic server.
2.Employer: VeriFone India Technology Private Ltd
Duration: Feb 2014 to Jan 2016
Role: Oracle apps dba
Environment: oracle ebs 11.5.10.2, R12.1.3, R12.2.4, database 10g and 11g, 12C,
dataguard, fusion middleware 11g, SSO, OBIEE, BPEL, hyperion, amdocs, agile.
3.Employer: Soham Renewable Energy India Pvt Ltd
Duration: Feb 2012 to Jan 2014
Role: Oracle apps dba
Environment: oracle ebs 11.5.10.2, R12.1.3, database 10g and 11g, oracle modules ap, ar, gl
4.Employer: Cooperp Software solutions
Client: Wipro Technologies
Duration: Nov 2010 to Aug 2011
Role: Oracle apps dba
Environment: oracle ebs 11.5.10.2, 12.1.3, oracle database 11g,
discoverer 10g & 11g, dataguard, RAC, oracle 10gAS, fusion middleware 11g, OID, SSO
ROLES AND RESPONSIBILITIES
Administration and monitoring of production, development, test, staging and uat Instances.
Setup disaster recovery environment and performing routine DR-test
Single-node and multi-node install of ebs r12 as part of upgradation.
Scheduling and administration of backups and recovery strategies.
Database, application patching (opatch, adpatch, adop), cloning and monitoring automated cloning jobs.
Debugging issues related to apache, forms, concurrent managers, use, workflow and setup parallel concurrent processing as per the business requirements.
Logical backup and migrating database objects using oracle datapump
Creating database and application users, responsibilities and adding application printers.
Reorganizing the database to reduce disk contention, migration and chaining.
Monitoring the instance statistics and tuning the database to improve performance.
Organizing table spaces, data files and other database objects as per ofa standards.
Compiling, registering forms using f60gen, frmcmp and compiling invalid objects in the database.
Configured oracle internet directory (OID) and oracle single sign-on.
SSL Certificate upgrade in oracle wallet, keystore.
Custom top creation and its registration.
Periodic cleaning of Log, output files.
Involved in ebs11i to r12 upgrade and database upgrade from 10g to 11g.
Installing oem agents, adding and monitoring oem13c alerts.
SSL implementation for oracle web and forms server.
Monitoring cluster services and filesystem space management, creation of user, roles, db link, dba_directories and other db objects and solving browser java launch for ebs forms.
Performance tuning of the database like memory allocation tuning, i/o tuning and tuning contentions. Used tkprof, explain plan, hints, and SQL trace utilities for sql tuning.
Weblogic administration, bouncing services and applying patches to weblogic home
Supported Mongo database administration, maintenance and monitoring
Experience in handling Incidents, request and change management process
DECLARATION
I hereby declare that the above written particulars are true to the best of my knowledge and belief.
Place: Bangalore Signature
Date: 18-02-22 Shubha KE
Contact this candidate