Oracle Manager

Location:

United States

Posted:

February 22, 2021

Contact this candidate

Resume:

Umeshkumar Shende

C: 469-***-**** Email: ***********@*****.*** https://www.linkedin.com/in/umesh-shende-93a94216/

Experience Summary

Oracle Certificated Cloud Professional with more than 15+ years of experience in Information Technology Systems with proven expertise as IT System Architect (DBA), Cloud Specialist, Software Engineer and Performance Specialist.

Experienced as a Cloud specialist in designing, implementing and integrating complex Technical Architecture for clients that serves as a blueprint for secure and maximum availability architecture.

Independently plans installs, integrates and validates systems software and hardware solutions.

Expertise in migration and support Oracle applications on Oracle Cloud Infrastructure

Expertise in Configuring Oracle Cloud Infrastructure for EBS R12 & Database (Exadata CS, VM DB System) deployment including configuration of VCN, Compartments, Compute and IAM Security Policies.

Expertise in Configure VCN Peering, including High Availability with in or across Availability Domain (AD) in a Region. Configuring IPsec VPN Tunnel with Dynamic Routing Gateway (DRG) for On-Premise connectivity.

Experienced in Technical Pre-Sales supporting RFP’s pursuits in identifying technical and business requirements and providing solutions and presenting the same to clients.

Having experience in EBS Upgradation, EBS Migrations, Advance securities, Oracle Database configuration and Administration, cloning, tuning, System analysis, Solution Design and troubleshooting on various Oracle versions (9i/10g/11g,11i,R12) on various platforms (AIX,HP-UX, Sun Solaris, Linux & windows).

Having knowledge of Microsoft Azure Cloud and Amazon Cloud (AWS)

Managed technical change implementation across environments.

Having broad knowledge of the business, its products, and processes.

Resolved issues and navigates obstacles to deliver work product.

Possess excellent analytical, debugging, & problem-solving skills.

Certification

1Z0-932 :Oracle Cloud Infrastructure 2018 Architect Associate

1Z0-052 : Oracle Certified Associate in 11g Database Administration.

1Z0-102 : Oracle Certified Associate in Oracle Weblogic server 11g System Administrator

1z0-1072 : Oracle Cloud Infrastructure 2019 Certified Architect Associate

1z0-0997 : Oracle Cloud Infrastructure 2019 Certified Architect Professional

Software Skills

Cloud

Oracle IaaS, Microsoft Azure, AWS

ERP

Oracle Applications 11i, R12.1 &R12.2

RDBMS

Oracle 8i, 9i, 10g, 11g, 12C & 19C

Fusion Middleware

Oracle SOA, Weblogic 11g/12c server

Operating Systems

Linux AS, Solaris and AIX

Tools

OEM, Oracle Application Manager, TOAD

Utilities

SQL*Loader, Import & Export & RMAN

Professional Experience

Infosys Limited (USA) Sep 2015 to till date

Technology Architect

Designed and Migrated Oracle applications on Oracle Cloud Infrastructure.

Provisioning, Configuration and Maintaining Database in Oracle Cloud Infrastructure.

Implementation of High Availability at OCI – For Applications and Databases.

Configured IPsec VPN Tunnel on Cloud with Dynamic Routing Gateway (DRG) for On-Premise connectivity

Troubleshooting of issues on Oracle cloud and On-premise applications

Performance tuning of the database and application

Expertise in database Installation, creation, patching, refresh and administration of Production, Stage and Dev database versions

Migrate new codes, data fixes, packages, forms using Easy deploy tool.

Create the user documentation for the assigned sub-modules.

Maintain and enhance the quality of the product using The Defect Prevention tool (DP Right Click).

Maintain the database table sizes by archiving and purging the unused information to maintain the effective system performance using Easy cleanup tool.

Perform root-cause analysis of any issues that arise post-implementation and work on solutions related to issue fixing.

Conduct impact analysis of issues logged, prioritize and ensure that production support is provided as per the committed SLAs.

Participate in architecture review sessions to provide inputs to architecture team through framework analysis, design patterns, prototype specifications.

Perform high and low-level design, provide pseudo codes, implement the prototype and conduct design reviews.

Support client interfacing activities and help create the relevant reports in a timely manner.

Lead validation activities for the assigned sub-modules for all types of testing e.g. Functional, Integration, System, User experience.

Create low level design artefacts independently and high level design artefacts with guidance and supports prototyping through creation of POCs.

Performed POC's on Poly-Cloud setup for Microsoft Azure cloud and Oracle Cloud infrastructure

Co-ordination with different teams to ensure the smooth operations

Infosys Limited (India) Mar 2013 to Sep 2015

Technology Architect

Provisioning, Configuration and Maintaining Database in Oracle Cloud Infrastructure.

Implementation of High Availability at OCI – For Applications and Databases.

Worked as a Production Support DBA providing 24*7 support for environments consisting of mission critical databases and applications accessed by users across the globe, provided On-call and day to day support.

Expertise in database Installation, creation, patching, refresh and administration of Production, Stage and Dev database instance.

Worked on E-Business Suite Implementations and Upgrade

Worked on Oracle Enterprise Manager Cloud Control (OEM-13c) for monitoring and alerting

Support Oracle Application 11i/R12 and R12.2 with shared application with RAC databases having ASM file system.

Worked on implementation of High Availability solutions with Oracle RAC, Dataguard

Extensively used AWR, ASH, ADDM, SQL tuning advisor, Statspack, SQL tracing, Tkprof, explain plan for performance tuning

Worked on Upgrading and configuring Oracle Enterprise Manager Grid Control(10g)

Applied RDBMS and Application Patches-Analyzed new PSU and bug fix patches, documented and applied in non-production and production environments

Worked on backup and recovery using RMAN and custom backups.

Carried out database refresh and setup of Development environments. Worked on refreshing data from production to non-production environments

Applying patches to test instances and performs rigorous Testing and subsequently applying to the development and Production Instances.

Managing Concurrent Process, Concurrent Programs/Managers, Registering New Concurrent Programs, Concurrent Types, Defining Work Shifts, and Specialization Rules and Combined Specialization rules, Defining New Concurrent Managers.

Incorporating Custom Programs, with registration of new User, Menu, Form and Form Functions, defining new Custom Application Top and Request Sets.

Security Management involving Audit Trails, changing passwords for Oracle Application Users, Defining restricted access Responsibility with customized Request Groups, Running Concurrent Programs and Monitoring Application Users

Configured and monitored ERP instances through OEM and developed custom OEM monitoring reports.

Regular task includes patching on multi node / single node / RAC, Cloning on RAC to RAC clone / multimode RAC to single node rac clone, Workflow configuration, Discoverer configuration, Backups using RMAN, Troubleshooting various issues like Concurrent manager / Discoverer / workflow, Configuration of shared application.

Managing and Troubleshooting Data Guard, Physical Standby Databases.

IBM Limited Mar 2011 to Mar 2013

Oracle Application DBA

Managed ticket queues to provide responsive support to customers for operational issues.

Interfaced with developers and vendors and supported requests such as: database restores and cloning including database administration functions.

Manage database and application implementation timeliness and support installation, tuning, validation and management of new customer Oracle applications

Utilized AD Utilities such as adpatch, adadmin, Licmgr to administer oracle 11i/R12 application.

Installed, configured, clone, patch and upgrade of Oracle databases and Oracle E-Business Suites

Regular activities: cloning, patching, backups using RMAN, day to day trouble shooting.

Regular task includes patching on multi node / single node / RAC, Cloning on multi node to single node / single node to multi node / RAC to RAC clone / RAC to single node clone, Workflow configuration, Discoverer configuration, Backups using RMAN, Troubleshooting various issues like Concurrent manager / Discoverer / workflow, Configuration of shared application.

Perennial System Oct 2008 to Feb 2011

Senior Database Consultant

Installation and configuration of Oracle applications R12 (R12.0.x & R12.1.x) on Linux

Upgrade Oracle application release 11.5.10.2 to Oracle application release R12.1.1.

Upgrading Oracle application release R12.1.1 to Oracle Application release R12.1.2

Migrating R12.0.4 from Solaris to Linux AS 4.

Migration 32 bit 10g database to 64-bit.

Configuring Standby database for oracle applications R12.

Installing Oracle Olite and configured with R12 application.

Installation of Oracle Enterprise Grid Control 10g R2 (10.2.0.5) on Linux.

Maintaining Oracle Application File System and Database using AD Utilities Like adadmin, adctrl, adpatch etc

Applying patches to resolve bugs or to get new functional changes in Oracle Application

Cloning Oracle Applications from PROD to TEST & DEV Instances and simulate few technical challenges, Coordinate with development and Functional teams.

Involved in activities like creating users and responsibilities, Assigning responsibilities to the users

Monitoring alerts and Configuring notifications to all ERP systems using OEM Grid Control.

Created Custom OEM reports for all ERP applications system

Apart from OEM, Created and Deployed Custom monitoring Scripts in Crontab to generate Alerts.

Oracle Corporation Apr 2008 to Oct 2008 Staff Consultant

Using Rapid Clone Utility cloned Applications and Database from Multi-Node Environment to Single Node Environment as the testing Instances are all in Single Node by merging the Appl_tops.

Patching tasks (on-off, family pack, maintenance packs).

Daily sanity checks for mission critical environments

Part of DBA Shift schedule covering multiple projects.

Regular code moves following customer’s internal ticketing system.

Participation in regular team meetings including customer calls.

Alert handling (Space, locks, file system, long running jobs, runaway, cpu hogging sqls etc)

Zensar Technology Jan 2007 to Jan 2006 Software Engineer

Install and maintain Oracle Applications 11i in complex environments such as Single-node and multi-node installations.

Upgrade of databases from 9i R2 to 10g R2.

Upgrade of Oracle Server software from 9.2.0.3 to 9.2.0.8 on Production & test servers successfully.

Applying latest releases of the patches from Oracle to the instance to resolve few application issues.

Using Rapid Clone Utility cloned Applications and Database from Multi-Node Environment to Single Node Environment as the testing Instances are all in Single Node by merging the Appl_tops as well as cloning shared appl_top and shared application tier.

Assist in developing, documenting, implementing, and sustaining Standard Operation Procedures.

Involved in time-to-time troubleshooting Oracle Databases.

Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.

Performing operations like Creation of Users, Session Management, and Granting Privileges to users from Applications.

Perform backup and recovery using RMAN/user managed database of online/offline databases in archive/no archive mode. Perform RMAN/ User Managed maintenance of database from a recovery catalog.

Develop scripts to configure, support and administer the application software.

Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.

Managing the space, Monitoring the Free Space, Chained Rows & Migrated rows etc.,

Media Channels Pvt Ltd Jan 2004 to Jan 2007 Oracle Apps DBA

Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations.

Upgrade of Applications from 11.5.9 to 11.5.10 on test servers successfully.

Upgrade of Oracle Server software from 9.2.0.3 to 9.2.0.5 on Production & test servers successfully.

Oracle Applications Cloning (Rapid Clone, Manual Clone)

Oracle Applications Patching(adpatch,admrgpch,hotpatch,OPatch).

Oracle Applications Diagnostics / Troubleshooting

Adadmin, adutilities(adrelink, adctrl, adident etc)

Performed sysadmin tasks as per the requirement.

Academics

Bachelors of Engineering (Electronics) from Nagpur University passed in 2002.

Contact this candidate