Oracle Ebs Sr
Resume:
Duration: May **** – till date
Client: Washington Suburban Sanitary Commission
Role: Sr Oracle EBS admin
ERP/FMW Systems/OS: Oracle E-Business Suite R12.2. [3-9]/R12.1.3 & 12c/11g RAC/ASM DB, Exadata,Exalogic envs / FMW applications Demantra, OBIEE, SPWA, WebCenter /Solaris, Linux.
Responsibilities:
Responsible for quality standards, resource planning respective to deliverables and flawless deliveries of Oracle ERP applications Maintenance activities and upgrade activities of databases belonging to GE Corporate Services: HR systems, Capital Finance and Shared Services and Aviation Systems.
Migrated Oracle E-Business Suite R12.2.7 environment
Involved in Upgrade of EBS applications from R12.1.3 to R12.2.4, R12.2.5, R12.2.8, R12.2.9,R12.2.10 architecture.
Migrated single instance to multi node RAC from scratch for clustering the database server to support the increased number of daily claim transaction volumes and high availability of the database system by enabling Load balance and Instance failover features.
Co-ordinate Quarterly Release Security Patching and project migrations.
Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds.
Managed and administrated database and database applications 24x7 that include Oracle 10g/11g Databases with RAC (real application cluster) of ERP applications (R12.1.3), OEM Grid, High Availability, Data Guard, ERP Applications.
Defined Policy/Standards and process for the database changes migration model flow drafted for the production.
Implemented Informatica life cycle management and integrated with ERP systems for archiving and purging outdated data.
Upgrading of Oracle RDBMS and Cluster CRS (cluster resource services) home with the oracle recommended patches and security alert patches
Preparing dash boards for weekly DBA calls and participating in the weekly operation calls.
Planning and co-coordinating Oracle Critical patch implementation, Oracle Applications upgrade activities.
Managing CAB call with change management team and implementing the work orders.
Application cloning from Multi node to single node and Multi node to Multi node.
Monitoring RMAN backups and restores and troubleshooting in case of any issues.
Periodically Co-ordinating the production database backups/restores on development servers using RMAN for cloning databases.
Migrated the EBS RAC database/Application from Legacy to EXADATA/Exalogic platform on Linux.
Integrated the 12.2.4 ERP with OAM and OID (SSO)
Add & Delete application nodes to existing configuration
WebLogic administration and addition of multiple managed servers
Upgrading JRE an JDK to latest certified versions
Install the latest AD & TXK patches, ETCC, WebLogic and RDBMS patches under ADOP patching cycle.
Deploying the FWM Techstack patches
Upgrading the FMW web tier from lower versions to 11.1.1.9
Applied the latest EBS PSU/CPU patches on regular basis.
Duration: Sep 2018 – May 2019
Client: Optum, USA.(short term project)
Role: oracle EBS DBA
ERP/RDBMS/OS : Oracle E-Business Suite 11i (11.5.10.X), R12.1.3 & R12.2.5
/9i, 10g, 11g/Solaris, Linux
Responsibilities:
Managing the daily operations and coordinating with the client.
Participate in weekly meeting with GE Team to review project progress and planning downtime and activities like Patching, Migration etc.
Constant interaction with development teams for trouble shooting & performance related issues. Daily status report to lead Oracle DBA with information on the status of the database, the space utilization, extent information etc. Support customer and system data requirements by providing technical expertise and influence in the design and development, implementation, and maintenance of databases.
Implemented NLS languages (Russian & Dutch) in ERP application.
Upgraded the Database from 10.2.0.4 to 11gR2.
Single point of contact from offshore team.
Rolled out SCM (Software Configuration Manager) on all instances.
DR setup, Support in offsite disaster recovery preparation, planning and testing.
Upgraded the JRE/JDK and JRE client plugin in Oracle ERP application.
Enabled Parallel Concurrent Processing for Oracle Application Instances and tested the failover of concurrent jobs on production application.
Planning and co-coordinating every quarterly released Oracle Critical patch implementation.
Duration: Dec 2017 – Sep 2018
Client: General Electric, USA.
Role: Lead consultant
Project: GE Infrastructure (Security & Sensing) & GE GRC
Responsibilities:
24/7 Production support cases and responsible for the maintenance of Oracle application as well as databases and supporting around 3000+ worldwide users and customers working in GE Industrial project (Security and Sensing ).
Administered the Oracle Applications instances 11.5.10.2 which are of Shared appl top with Multi node architecture (1DB Node + 4 internal application Nodes + 2 Extranet Nodes).
Application / Database cloning from PROD database on a regular basis
Involved in Application as well as RDBMS Critical Patch Updates (CPU) quarterly, Family pack, Mini Pack, Tech Stack Patching. Administering and maintaining Production Apps 11i instances, 24X7 Production Database Support and maintenance.
Worked on 11g and 10g RAC databases.
Installed E-Business suite single and multi-nodes on Solaris platform.
Excellent Knowledge on AD Utilities and their usage.
Implemented parallel concurrent processing.
Purging unwanted request output and log files
Troubleshooting self-service web application issues.
Troubleshooting forms server, Apache server issues
Troubleshooting concurrent manager issues.
Performed Sysadmin tasks as per the requirement.
Worked with end users in resolving E-business Suite application issues reported by them.
User account management – creating users, disabling users, responsibility management.
Managing and Tuning concurrent managers for Production load
Oracle instance cloning activities and reconfiguration after refresh.
Installation and upgradation of application stack (Apache and forms home)
Load balancing across Apache, forms servers.
Implemented Rapid Clone procedures and streamlined cloning process
Monitoring and Following up TAR’s raised with Oracle.
Creation of Concurrent Mangers, Programs, and Request sets.
Troubleshooting of Concurrent Requests and Request sets.
Code Migrations (reports, forms, Concurrent programs and requests, Value sets, Logical apps rules migrations …etc.).
System Administration for Oracle Apps which includes creation and maintenance of Users, Responsibilities, Menus, Profiles, Concurrent Programs, Request Sets, Request Groups etc.
Integrations of all the changes into Production databases.
Proactive monitoring (BMC Alarms), Alert Monitoring, Backups, Performance Tuning and other critical activities
Vertex tax rates update Patching and upgradation.
Maintenance tasks (Customization of autoconfig templates, Store setup, iPayment setups, Application Diagnostic tests, Tablespace management, creation of read only schemas…etc.).
Troubleshoot and resolve issues during cloning, patching and performance related issues.
Duration: Feb 2013 – Dec 2017
Client: General Electric, USA.
Role: Consultant
ERP/RDBMS/OS – Oracle E-Business Suite 11i (11.5.9, 11.5.10.CU2)/9i /Solaris.
Project: GE Energy, Aviation project.
Responsibilities:
Cloning of new instances from CRP2.
Applying Database/Application Patches.
Creating custom applications and Installing Printers Creating New Environments/Databases as per client requests.
Involved in MLS patching.
Custom schemas/Application created and registered with apps.
11i System Administration tasks like Creating Applications Users, Registering Forms, Menus, Functions, Responsibilities and Concurrent Programs.
Involved in major Code Migrations (Packages, reports, forms, Concurrent programs and requests, value sets …etc.) and registering with application.
Participating in weekly meeting with GE Team to review project progress and planning downtime and activities like Patching, Migration etc.
Administered workflow mailer services.
Duration: Dec 2010 – Feb 2013
Client: Unisys Technology.
Role: Jr Oracle DBA
Responsibilities:
Executed Dev/Stage refreshes of Databases on regular basis from Production backup.
Schema/Object Refreshes and Logical backups using export/Import.
Extensively worked using Oracle Enterprise Manager, Toad and SQL*Loader.
Extensively designed and performed Backup & Recovery techniques like Hot backup, Cold backup.
Analyzing and Tuning Database Objects (Index Rebuilding, Gather Schema Statistics etc.).
Extensively worked on database, system and application tuning, monitor & optimize the database performance.
Performed resource management including data, online redo log and control files
Technical support to developer team.
Created user profiles and roles as per the access level of user for data and application security.
Creation of new user accounts, home directories, initialization of files, setting the passwords, setting file permissions.
Allocating the system storage and planning future storage requirements for the production database system.
Tablespace Management and occupied space Optimization using index rebuilding time to time.
Creation of new Data files and rollback segments in OLTP environment and assigning them to different processes.
Exporting & importing of data.
Setting up the parameters of parameter (init.ora) file.
Over 14 years of extensive experience as an Oracle APPS DBA, Supported Fortune 500 clients General Electric (GE Corporate Services,GE Aviation, GE Security & Sensing, GE Power & Water...etc.) on Oracle EBS versions R12.2.x/R12.1.x/11.5.10.x and Exadata platforms, Fusion Middleware applications and Oracle DB versions 19c/12c/11g/10g on various Operating System platforms - Oracle Enterprise Linux 6.x/5.x and .
Instrumental in Upgrades of oracle EBS applications from R12.1.X to R12.2.X, implemented Maximum Availability framework, Techstack migration, Addition of NLS Languages,, Database Reorgs, Various Database upgrades from 9i-11g-12c-19c and strategic execution of initiatives to enhance productivity, quality, customer service, technology and performance.
Excellent working skills with Installation, Upgradation, DR Setup, Cloning, Patching, RMAN snapshot/nbc backup and Recovery, administering and tuning Application, Good troubleshooting skills.
Proficient in Planning and implementation of various high impact EBS Migrations projects, Datacentre movement projects globally and providing mentorship and coaching to the team members to accomplish measurable business process improvements.
Supported Advanced EBS Topologies: Multi node Shared APPL_TOPs,Extranet, SSL and F5 Load Balancer.
Installation of Oracle Fusion Middleware Patch sets and configuration of OHS(Oracle HTTP server)
OEM Implementation for Oracle EBS, Databases,
Performance Tuning of Oracle Databases,EBS application,FMW,weblogic a.
CAREER SUMMARY
CONTACT
ad5sh2@r.postjobfree.com
RajaShekar Thedlapalli
•Highly Experienced with Installation, Implementation, Up-gradation, migration,Cloning, Recovery and Administration of Oracle EBS Administration from 11.5.9, 11.5.10.2, R12.x,R12.2.9,12.2.10 and Oracle Database 9i, 10g, 11g,12c,19c
•Highly Experienced in Installing, configuring and administering in Oracle RAC (9i, 10g, 11g,12c).
•Vast Production Support experience in handling mission cHighly experienced in Backup / Recovery and disaster planning
TECHNICAL SKILL SUMMARY
Working for WSSC as Sr. Oracle Apps DBA from May 2019 to till date.
Worked for OPTUM as Oracle Apps DBA from Sep 2018 to May 2019.
Worked for Genpact LLC USA as Lead Consultant from Jan 2017 to Sep 2018.
Worked for Genpact India as Consultant from March 2013 to Dec 2016
Worked for Hexaware as jr. DBA from Dec 2010 to March 2013
EXPERIENCE
EDUCATION QUALIFICATION
B.Sc Computers, Osmania University College Of Engineering, Hyderabad, India
WSSC, Maryland, USA
United Health Group, Minnesota, USA.
Genpact LLC, New York, USA.
Genpact India, Hyderabad, India.
Hexaware, Bangalore, India
Contact this candidate