Engineer Software
Resume:
Oracle Apps DBA
Contact No:
Email Id:
*********@*****.***
Current Employment
Deloitte - Bangalore
Current Project:
RNDC
Herc
Location:
Deloitte Consulting India Pvt Limited, Block C Divyashree Technopolis
Yemlur Bangalorse -560037
Objective
Self-confident, success-oriented IT professional, who is happily improving his skills/knowledge while building his career and finds it inspiring to face new challenges.
Professional Summary
Having 9 years of IT experience as an Oracle Apps DBA.
Production & Project support of Oracle Applications 11i, R12.1 and R12.2 environments.
Production & Project support of Oracle database 10g,11g and 12c
Supporting RAC, ASM, OEM and Dataguard environments
WebLogic administration, SOA basic administration, Oracle Cloud infrastructure admin
EBS 12.1.3 upgrade to 12.2.5 and database upgrade from 11.2.0.3 to 12.2
Migration of EBS from on-prem to OCI
EBS environment assessment and providing recommendations
Automation of routine daily tasks using shell scripting
Expertise in Application RMAN clones and Database cloning.
Worked on OEM 13c installation, upgrade and adding targets
Registering the Custom Applications into Oracle Application, Creating custom users.
Extensive experience in Oracle Applications comprising of the below:
oExpertise in AD utilities like adpatch, ADOP, adadmin, adctrl, admerge
oPatching & Troubleshooting.
oGenerate & analyze the ASH, AWR & ADDM reports.
oBackup and Recovery
o24x7 support on environments
Educational Qualifications
Bachelor of Engineering (B.E) from Bhoomaraddi college of Engineering and Technology, Hubli, India with 78.7%
Pre-University from SRA Pre University college Banahatti with 80%
SSLC from Poorna Pragyna English Medium High school Rampur with 90.04%
Career
Worked as System Engineer Oracle Apps DBA in TCS from Sept 2011 to July 2014
Worked as Senior Software Engineer in Accenture from July to Feb 2017
Working as Senior Consultant in Deloitte Consulting Services Pvt Ltd from Feb 2017 to till date
Career Profile
Since Sep 2011 to July 2014 - TCS as Systems Engineer DBA
Project : SUPERVALU INC.
Environment : Oracle E-Business Suite & Database
R12.1.3 & 11g
Responsibilities :
Working on ticketing system (CA service desk) on Severity and Priority basis.
Resolving performance issues like environment slowness, long running concurrent programs etc.
Daily Code-Migrations on Dev, Test and UAT
Hardware migration from E25k to T4-4 server
Working on all SYSADMIN activities
User Administration> User creation, User Modification policies and User End-date
QA Assurance for Quality & Standards of Custom Codes
Performance Testing code reviews
Monitoring memory and CPU utilization
Installation of OEM agents and adding the servers to OEM.
Supporting RAC, ASM environments.
Generate & analyze the ASH, AWR & ADDM reports.
Accepting and commitment of clones from Divisions
Database Clones through RMAN and Restoration from RMAN backup’s as per requirement
Resolving issues related cloning and recovery of database
Applying Application patches using Auto patch utility adpatch
Performing RDBMS patches using Opatch and application patching using Adpatch
Trouble shooting workers related issues while applying patches
Minimizing patch time though merging the patches and using options
Resolving day to day user related issues ( user login and user specific ) and Application issues on EBS R12 ( Form server, Report server, Apache ) & Database
Resolving Concurrent requests issues
Used Adadmin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and relinking executables and also, used f60gen to generate and compile forms
Creating database custom users, allocation to appropriate table space quotas with necessary privileges and roles for all databases
Monitoring Backup’s (Scheduled Hot backups and RMAN backups)
Filing Tar’s, coordinating with Oracle corp. for support.
July,2014 – Feb,2017 : Accenture as Senior Software Engineer DBA
Project : ITV
Environment : Oracle E-Business Suite & Database
11.5.10.2 & 10g
Responsibilities :
Working on ticketing system (BMC remedy, Service Now) on Severity and Priority basis.
Resolving performance issues like environment slowness, long running concurrent programs etc.
JRE upgrade from Jinitiator to JRE 6u33 and removing dependency on old Java version.
Monthly code migration in UAT and LIVE environments
Cloning automation and health check automation
QA Assurance for Quality & Standards of Custom Codes
Performance Testing code reviews
Generate & analyze the ASH, AWR & ADDM reports.
Cloning Database/Applications and automating application cloning.
Resolving issues related cloning and recovery of database
Applying Application patches using Auto patch utility adpatch
Applying PSU and CPU patches for database and application.
Performing RDBMS patches using Opatch and application patching using Adpatch
Changing Apps and generic user password based on requirement
Designing the backup strategy
April 2016 – to Feb 2017: Accenture as Senior Software Engineer DBA
Project : COX Enterprises
Environment : Oracle E-Business Suite & Database
12.2.4 & 12c
Responsibilities :
Daily Health checks, Monitoring alerts, day to day DBA activities like code migration, adding space to tablespaces, creating users etc.
Cloning using Delphix tool
SSL certificate installation
Applying patches using ADOP utility
Spinning off new instances for testing
Monitoring automation using shell scripting
OEM agent installation and adding services for monitoring
Printer configuration, management and troubleshooting.
Creation of custom Menus & Submenus, Custom Forms registration.
Troubleshooting workflow issues.
Custom concurrent program (Reports) definition & executable.
Application and Database Monitoring: long running jobs, Application Locks,
Application File Systems, General Operating System Monitoring Oracle
Applications Maintenance, AD Utilities.
Creation of Responsibilities and assigning Request group and Data group to it
Manage Profile Options.
User account management, enabling Audit Trail.
Feb 2017 – to till date: Deloitte as Consultant Oracle Apps DBA
Project : RNDC
Environment : Oracle E-Business Suite & Database
12.2.5 & 12c
Responsibilities :
Applying patches using ADOP utility
Applying quarterly CPU, PSU patches released by Oracle
Maintaining WebLogic administration
Java code signing certificate installation
SSL certificate updates
TLS 1.2 patching and upgrade
Cloning automation using shell scripting
Performance tuning of long running requests, database & application slowness issues
Upgraded OMS and target agents from 13.2 to 13.4
OEM agent installation and adding services for monitoring
Printer configuration, management and troubleshooting.
Creation of custom Menus & Submenus, Custom Forms registration.
Troubleshooting workflow issues.
Custom concurrent program (Reports) definition & executable.
Application and Database Monitoring: long running jobs, Application Locks,
Application File Systems, General Operating System Monitoring Oracle
Applications Maintenance, AD Utilities.
Applied July 2019 Security patches to DB, Middleware and EBS application
Added Oacore servers to the WebLogic
Certifications:
1.Oracle Cloud Infrastructure Foundations 2020 Associate
2.Oracle Cloud Infrastructure 2019 Certified Architect Associate
Personal Profile:
Date of Birth : 20th- Aug-1989
Sex : Male
Father Name : Mr. Shrishail Yadawad
Nationality : Indian
DECLARATION
I hereby declare that all the information furnished above is complete and correct to the best of my knowledge and belief.
Place: Bangalore
Shivanand Yadawad
Shivanand Yadawad
*********@*****.***
Contact this candidate