Manager Oracle
Resume:
Srikanth Manthri
adg136@r.postjobfree.com
Summary
IT Professional with over 13 years+ of experience as an ‘ORACLE APPS DBA’ on different versions and platforms.
EBS Instance upgrade from 11.5.10.2 to 12.0.4, 11.5.10.2 to R12.1.3 & R12.1.3 to R12.2.8
Database upgrades from 9i to 10g, 10g to 11.2.0.4 & 11.2.0.3 to 11.2.0.4. and 12.1.0.2 to 19C
Experience in Migration of On-Premises Oracle Application R12.2.4 to AWS.
Experience in Migration of On-Premises R12.2.4 to OCI.
Experience in working on EBS Cloud Manager and OCI console.
Experience in administration of OCI database and EBS.
Database installation and migration on Oracle Cloud Infrastructure.
Expert in Application and Database Cloning using Rapid Clone Utility and troubleshooting post clone issues.
Experience and proficient in using AD utilities. (adop, adpatch, admrgpch, adctrl, AutoConfig, adadmin, adident, adrelink etc) and applied Database Patches using Opatch utility.
Proficient in Oracle Database Administration including backup, recovery, installation, patch application, RMAN configuration etc.
Good hands-on experience in Oracle Applications (EBS) Installation & Troubleshooting.
Experience in 12C OEM.
Experience in supporting, managing and troubleshooting ASM, Data Guard and RAC.
Experience in supporting and managing multiple Production, Test and Development instances.
Experience in supporting, managing and troubleshooting OBIEE environment, Informatics services and DAC services.
Responsible to drive DB outages from onshore and communicate the client on the progress.
Responsible to keep the incident management tickets under control and ensure RCA is done for aging tickets.
Conduct meetings for problem management and identify regularly occurring issues
Part of steering committee meeting from on-shore and coordinating with the offshore team.
Comfortable working in co-ordination with Application Developers, System Administrators or other team members and superiors.
Creation of Clone databases through COLD, HOT, and RMAN backups.
Monitoring Oracle EBS servers Login issues, balancing load, health check of DB in case of performance issues and resolving them.
Applying Hot Patches, Cold Patches and reducing patch downtime for Oracle Applications.
Expertise in Database Backup strategies & recovery scenarios.
Oracle Discoverer Installation, Upgradation and Configuration.
Good knowledge on Golden Gate, RAC, Data Guard and ASM.
Fusion Middleware and WebLogic Installation, Upgradation and Support.
Good knowledge on OAM, OID & OUD.
Troubleshooting knowledge on Self-service web application issues, Form server issues
Installation and Configuration of Oracle Enterprise Manager (OEM) 13c.
Development Unix Shell Scripts for automating DBA tasks and scheduling in Cron jobs.
Reorganized the tables and rebuild indexes to improve space utilization.
Participate in a team to maintain & support for multiple oracle databases in high availability (24 X 7) heterogeneous environment.
Preparation and maintenance of day to day documentation.
Excellent analytical problem solving, oral and written skills.
Experience in configuring the Printer Installation in EBS 11i/R12.
Experience in configuring the Work flow notification Mailer.
Perform root cause analysis of difficult problems and their solutions.
Generating Stats pack report, AWR Report whenever required.
Single point of contact for the client for any type of communication.
Proactively interacting with the Oracle Product support and performing the OWC.
ITIL Certified, AWS Certified Solutions Architect – Associate.
Technical Skills:
Cloud Computing:
Oracle Cloud Computing (OCI), Amazon Web Services (AWS)
ERP:
Oracle Apps Release 12.2.6, 12.2.4, 12.1.3, 12.0.4, 11.5.10.2, 11.5.9.
RDBMS:
Oracle 19C, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9.x/8.x, Golden Gate, Data Guard, ASM, RAC
Middleware
Oracle Fusion Middleware (OID, OUD, OAM), Oracle WebLogic Server, OBIEE, SSO, Demantra, Discoverer.
Operating Systems:
HP-UX 11.11, Sun Solaris 11, Red hat Linux, IBM AIX, Windows server 2003.
Professional Experience:
USP: United States Pharmacopeia [Rockville,MD] Mar2020 to till date
Senior Oracle Apps DBA Consultant
Upgrade Project (Duration Mar 2020 to till date)
Responsibilities: -
Prepared documentation for the database upgrade from 12.1.0.2 to 19.0.3 and application upgrade from R12.2.4 to R12.2.8
Planning and implementing the upgrade.
Performing the risk analysis of the upgrade
Taking care of the pre and post upgrade activities
Deploying the code migrations to NON-PROD and PROD instances
Taking care of the Developers reported issues.
Taking care of the END users reported issues.
Creating new users in OID and Oracle applications
Taking care of the sysadmin activities.
Taking care of the maintenance activities
Taking care of the SSO related issues.
Omnitracs (Dallas, Texas) Oct 2018 to Mar 2020
Senior Oracle Apps DBA Consultant
OCI Migration Project: (Duration Apr 2019 to Mar2020)
Responsibilities: -
Planning and implementing migration of On-premise to OCI cloud.
Prepared documentation for the migration.
Pre migration and post migration validation checks.
Performing risk analysis on the Patching.
Taking care of the performance issues.
Applying Application patches and FMW patches.
Cloning the Development instances from the PROD instance.
Working closely with the development teams and addressing their issues.
Migration activities like code migration and discoverer migrations.
Discover admin activities.
Troubleshooting the issues and performing the root cause analysis.
Maintaining documentations of critical activities.
Installation of the Oracle applications, WebLogic and configurations.
Troubleshooting the concurrent managers issues.
Housekeeping activities.
Decrease the occurrence of Repetitive Alerts.
Responsible for providing backend support for the development, testing and UAT environments for Oracle ERP as well as other production databases and new projects.
Manage the deployments for Coding, Cloning, Refreshing, Patching, Backups, Purges, etc.
System administrator tasks.
Operating System Migration Project: (Duration Oct 2018 to Mar 2019)
Responsibilities: -
Prepared Operating system Migration document from Solaris 10.3 to Solaris 11.4 version.
Migrated R12.2.4 from Solaris 10.3 to Solaris 11.4 onto the new hardware.
Handling of post migration issues.
Working closely with the development teams and addressing their issues.
Configuring printers on the new EBS servers.
Pointing Discover and Demantra from the upgraded OS version EBS.
Performing Non-Prod clones from the PROD instance for the migration.
Attending the Steering committee meeting regularly.
Performed root cause analysis and documenting the issues.
Coordinating with the other teams like Unix, Infra and Developers.
Providing day to day updates and status with the Project Manager.
Setting up the scheduled jobs in the Cron tab.
Configuring OEM with the migrated instance.
Applied patches.
Hitachi Consulting Services:
Managed Services – UK Team (Hyderabad) Aug 2013 to Sep 2018
Senior Oracle Apps DBA
Responsibilities: -
Technically leading the upgrade and migration projects from signoff till go-live.
Taking care of the OBIEE admin activities
Working closely with delivery teams, Implement standard best practices in target accounts to deliver consistent service delivery and exceptional customer satisfaction
Implementing standard governance, reporting and escalation processes across responsible accounts
Operations optimization - processes driven, standardize and simplify approach.
Adopting latest infrastructure and innovative techniques for significant reduction of iteration timings by the end of every project go-live.
Define scope, timelines with work breakdown structure and resources associated
Project risk, issues and mitigation plans – failure mode and effect analysis and risk tracker
Reporting and business approvals to address critical issues in customer relationship & governance meets
Define communication, escalation and operational metrics
Result driven time to time working group meetings for gauging potential slippages in scope & time
Automation techniques for reducing the migration timelines and reducing duplicity / human error quotient significantly directly impacting Quality of Service.
Expert in technical issue resolution in all the areas of DB and EBS including integrations and configurations.
Major Technical Activities:
Planned and Performed Migration of EBS R12 from on-premise to AWS Cloud.
Planned and Performed upgrades EBS R121.3 to R12.2
Performed EBS 11i upgrades i.e. from 11.5.10.2 to 12.1.1 and 12.1.3.
Performed Oracle Database upgrades and OS Platform Migrations
Oracle Demantra Installation, Upgradation and Configuration
Oracle OEM 13c Installation and Configuration
Interacting with Delivery managers for the deliverables and planning timelines of the projects
Worked on Performance issues after upgrades.
Implementation of Data Guard.
Oracle Fusion Middleware and WebLogic Server
Security Hardening of EBS systems and Database.
Oracle Applications Database Administration Support:
Oracle Applications R12 cloning
Oracle Applications R12 patching
Troubleshooting, identifying root cause and providing solutions.
System Administration tasks
Handling User reported issues
Working on Monitoring System Alerts.
Fujitsu Consulting India Pvt. Ltd: Pune
RDBMS Project Jun 2011 to Jul 2013
Senior Oracle Apps DBA
Responsibilities: -
Applying CPU patches on Application and on Databases
Working closely with delivery teams, implement standard best practices in target accounts to deliver consistent service delivery and exceptional customer satisfaction
Implementing standard governance, reporting and escalation processes across responsible accounts
Operations optimization - processes driven, standardize and simplify approach.
Adopting latest infrastructure and innovative techniques for significant reduction of iteration timings by the end of every project go-live.
Define scope, timelines with work breakdown structure and resources associated
Project risk, issues and mitigation plans – failure mode and effect analysis and risk tracker
Reporting and business approvals to address critical issues in customer relationship & governance meets
Define communication, escalation and operational metrics
Result driven time to time working group meetings for gauging potential slippages in scope & time
Automation techniques for reducing the migration timelines and reducing duplicity / human error quotient significantly directly impacting Quality of Service.
Expert in technical issue resolution in all the areas of DB and EBS including integrations and configurations.
Major Technical Activities:
Upgraded EBS from 11.5.10.2 to R12.1.3 and migrated from Solaris to Linux for BOLTON Client.
Upgraded EBS from 11.5.10.2 to R12.1.3 on AIX for Fellows Client.
Oracle OEM Installation and Configuration.
Configured and Implemented Active Data Guard for CAFOS client.
Performed Platform migrations for EBS Environments.
Interacting with Delivery managers for the deliverables and planning timelines of the projects
Worked on Performance issues after upgrades.
Security Hardening of EBS systems and Database.
Oracle Applications Database Administration Support:
Cloning of Non-PROD from PROD instances.
Patching analysis using patch wizard and applying patches.
Analyzing the root cause and documenting the solution or work around.
Performing the System Administration tasks.
Addressing the end users, developers’ issues.
Working on day to day System Alerts and fixing up the recurring alerts.
Analyzing the database growth and providing the report to the management.
Nekkanti Systems PVT. Ltd: Hyderabad
MMC Project May 2007 to Jun 2011
Oracle DBA
Responsibilities: -
Maintaining the EBS application 11.5.10.2 on Linux.
Applying CPU patches on Application and on Databases regularly.
Generating daily reports and sending reports to the managers.
Analyzing the database usage and adding datafiles to the Database.
Troubling shooting issues and performing RCA for the P1 issues.
Follow-ups with the Oracle Support on the SR.
Installation and configuring of the Discoverer 4 with EBS 11i.
Upgraded application Database from 9i to 10g.
Maintaining Known Error database.
Preparing the documentations for the Critical and day to day activities.
Working with the developers and deploying the code onto the respective instance.
Performing the Non-PROD clones from PROD
Major Technical Activities:
Upgraded application Database from 9i to 10g.
Installation and configuring Discoverer 4 with EBS 11i.
CPU patch analysis.
Oracle Applications Database Administration Support:
Maintaining the 11i Oracle Applications (11.5.10.2).
Troubleshooting, identifying root cause and providing solutions.
Creation of Users, assigning the responsibilities.
Handling end user and developer issues.
Cloning Non-PROD instances regularly.
Housekeeping activities.
Working on the Audit reports and sending it to the management.
Loading up the data using SQL loader into the EBS database.
Education:
M.C.A (Master of Computer Application) from Osmania University, Hyderabad (India).
Certifications:
Oracle Cloud Infrastructure 2019 Certified Architect Professional
AWS Certified Solutions Architect – Associate
OCA in Oracle 10g & 12C DBA from Oracle Corporation
ITIL foundation certified.
Contact this candidate