Ravi Palle

703-***-****

Public Cloud (OCI & AWS) Solutions Architect:

Lead Oracle Apps/Middleware DBA

• Over 15 years of experience in Information Technology having handled various responsibilities and roles as an Oracle Applications 11i/R12 DBA, Oracle DBA, Oracle Middleware Administrator and has significant experience in Oracle 11i/R12 E-Business suite system administration, database administration including installation and upgrades of the Oracle Applications 11i/R12 and Products registration as well as end user support.

• Worked on AWS Cloud Technologies for migrating customer systems. Expert knowledge in Elastic Black Store, EFS File System, S3 buckets, Load Balancers, Dedicated Machine, NVMe, compute, Database, EC2 machines, RDS, Autoscaling, CloudWatch, AWS Snowball, etc.

• Worked on OCI - Oracle Cloud Infrastructure for migrating new customer EBS Systems. Expert knowledge in VCN, VPN, Compute, Exadata as service, DBaaS, Load Balancers, IDCS, EBS Asserter, File Server, Object Storage, Block Volumes, Subnets, Security rules, etc.

• Experience in configuration management with AutoConfig and Maintenance of Oracle Applications 11.5.8, 11.5.9, 11.5.10, 12.0.x, 12.1.x & 12.2 releases with single and Multi node environments.

• Experiences of Oracle Applications upgrade (11.5.9 to 11.5.10 and 11.5.10 to R12.1, R12.1 to R12.2) process.

• Experience includes Backup & Recovery using RMAN, Performance Tuning using TOAD, OEM and Confio tools, DB Security, Patching, Cloning using Rapid Clone, Unix Shell Scripting, cronjobs, Perl scripting.

• As Senior Oracle Applications DBA Exclusively Worked on MLS (Multilingual Support) Installations and configurations of non-US Languages.

• Worked in a Team of database administrators in a large IT shop/Data Centers with thousands of Databases.

• Experience in Oracle APEX (formally known as HTML DB) including installation, up gradation and custom code troubleshooting.

• Experience with UPK production Installation and administration and configuration with EBS Databases.

• Experience with Single Sign On and OID registration with E-Business Suite and Oracle Portal Administration including installation and cloning.

• Experience also includes Database Performance Tuning, Oracle Support management, EBS Concurrent Managers administration, shell script development; documentation of various EBS patching, cloning, upgradations and new employee training.

• Experience with RMAN backup and recovery and also cloning using the RMAN duplication utility.

• Experience includes Oracle Discoverer 10g, 11g & 12c installation, upgradation, and EUL migration and Cumulative Patching.

• Experience includes E-Business suite patching of ATG.RUP.4,5,6,7 and JDK & JRE plug-in upgrades, Developer 6i patchset upgrades, 17,18,19 and HRMS Year End Payroll Patching, platform migration from AIX to OEL of Oracle Database and EBS. Also supported the printer’s configuration and support (OMPLUS). Worked on quarterly CPU patching, concurrent managers troubleshooting, OATM migration, workflow configuration and troubleshooting, iStore configuration and support, shared APPL_TOP support, 11.5.10.2 baseline patching, MWA support, GIS support.

TRAINING & CERTIFICATIONS

• Oracle Cloud Infrastructure –Architect Professional

• AWS Certified Solutions Architect.

• Oracle 11i Applications DBA Certified Professional.

• Oracle PL/SQL Developer Certified Associate.

EDUCATIONAL QUALIFICATION

• Masters in Information Technologies

Technical Skills:

OPERATING SYSTEM

• UNIX Sun Solaris, IBM AIX, Red Hat Linux/OEL 4.x/5.x/6.x7.x,8.x, Windows Server 2008 R2 (Standard, Enterprise) /2012/2016/2019 Servers releases.

ERP

• Oracle Financials, Manufacturing, HRMS, SCM of EBS versions 11.5.x, 12.0.x, 12.1.x, 12.2.x Database Administration, System Administration, maintenance, Cloning, Patching, and Oracle Discoverer, OBIEE Integration.

RDBMS/DATABASES

• Oracle 8.x/9.x/10.1.x, 10.2.x, 11.1.x, 11.2.x, 12.x, 19c and 10gRAC, 11gRAC, 12c, 19c databases. SQL and PL/SQL programming, Oracle Enterprises Manager (OEM), Oracle Grid Control and Import/Export Utility, TKPROF, TOAD, Confio and SQL * Loader.

• Oracle Network Configuration using net8 easy config, Intelligent Agent, SQL*NET, ADI.

• Oracle Physical Standby Server and Oracle Data Guard.

LANGUAGES

• C, C++, VC++, JAVA, Java Script, Python, Configuration, SQL, PL/SQL, OLAP/OLTP Professional Work History

Navisite, Andover, MA Since Aug 2008

Lead Oracle Apps DBA

• Handled Oracle EBS Migration between 2 data centers of Topps to Bazooka.

• Established Clones and automation of copying databases on new hosts.

• Worked on setting up data guard/disaster recovery environments on cross regions.

• Worked on External node setup in DMZ for i-modules like iSupplier, iExpenses.

• Worked on SSL setup on EBS R12 environment by using the Oracle Wallet Manager to generate the Certificate request, and worked with GoDaddy Support in obtaining a certificate and placing it on EBS AppsTier.

• Worked on platform migration project for Oracle ASCP 12.2 to newer certified version of Microsoft Windows Server 2019

• Collect and analyze performance statistics for resource consumption and performance improvement. Managing Tablespaces, Data files, Rollback segments and Temporary Tablespaces. Experience working on MySQL Server Installations, Databases, Backups, Restore, Replication and Administrative activities.

• PostgreSQL and MariaDB installation, configuration, migration, upgrades and patches.

• Supported and administered OBIEE and Hyperion instances for customers who have EBS along with the BI and Hyperion implementation requirements. Migrated different database objects in Oracle into Snowflake multi-Cluster Warehouses environment.

• Installed and configured Oracle Discoverer 10g, 11g, 12c with EBS version R12.1.3 releases for many customers and upgrade from version to version. I also worked on Discover clones during customer migration from On-Premise servers to MTG Cloud Servers.

• Worked on Oracle EBS 12.2 administration activities like patching using ADOP and cloning using RapidClone utilities on Windows Servers 2019.

• Hands on experience with installing and configuring Dell Boom9 (ATOM) utility.

• Worked on Avatax installations with EBS 12.1.3 and 12.2 releases.

• Gained knowledge on Amazon AWS Services like EC2, S3, AWS RDS, Aurora in upgrading to future cloud migration projects.

• Worked on Oracle Agile and Oracle PIP database and application migration to a newer OEL(7) while splitting the company systems from Topps to Bazooka. Oracle EBS DBA / Cloud Solutions Architect

• Engaged to migrate Carwash system EBS 12.2 system from On-Premises to Oracle Cloud Infrastructure deployment (IaaS) model.

• Worked on designing VCN Network architecture and deployed various VMs for Oracle EBS R12.2, SOA11g, Congnos, Kronos and many other products.

• Worked on to allocate different storage types Block Stores, File Service, Object Storage Services and Instance Store volumes.

• Thorough understating on OCI Networking on VCN, VNC Peering, VCN Gateway, Dedicated lines vs VPN tunnels and Gateways and Load balancers. I implemented these conccenpts of my cloud migration customers like ICU Medical, Mr. Carwash, F5 Networks, etc.

• Architected various VM types for workloads based on computing and memory intense applications.

• Cloning of Oracle Applications with Rapid Clone and Autoconfig to Dev/Test environments.

• Managed database administrators on Oracle, SOA & SQL server environments across multiple sites.

• Creation of users, assigning responsibility, creation of custom menus and responsibility for Oracle Applications.

• I assist development and functional teams in EBS environment in terms of migrating code, fixing code syntax errors and coordinating with teams for successful and timely code change in production.

• Exceptional knowledge in establishing interfaces with Banks and other vendors using SFTP type connectivity over VCN and also public interfaces. I also handled SSH key authentications, GPG, PGP encryption methods for safe file transfer over the internet. Oracle Apps DBA/ Cloud Solutions Architect

• Hands on Experience with EBS R12.2 (12.2.5) release installation and upgrades from 12.1.3 to 12.2 release.

• Used ADOP utility to apply patches online mode and hot patching as well. Experience with adop phases and fs_clone utilities and troubleshooting issues related to ADOP.

• Worked as a Solutions Architect implementing Oracle EBS and other products on AWS Platform.

• Implemented Oracle EBS SSO using Oracle IDCS based on the SAML service.

• Architected Linux VMs, Bastion Host and Dedicated Host (I3) for Oracle EBS R12.2 release and Oracle OBIEE, Hyperion and Tibco products. Managed Enterprise Data Warehouse including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas

• Provisioned different storage types, EBS, EFS, S3 bucket and Instance Store volumes.

• Designed various EC2 types for workloads based on computing and memory intense applications.

• As a Principal DBA, I play role of Application Technology Lead handling priorities, tasks and projects. I oversight all tickets and handle escalations. I meet customers on daily to weekly basis reviewing priorities and work with management in planning project planning.

• Designed solutions for cost optimization while moving workloads from On-Premise to AWS and OCI IaaS. These solutions were secure and redundant of data storage and high availability structure in place.

• Used various storage options for OCI migration projects and familiar with all storage options like Block volumes, File Storage, Object Storage services.

• I mentor my team DBAs to document each assignment and make sure documents are followed and standardized to share and get help from Customer Service Desk.

• I also work with 24x7 Service Desk DBAs in orchestrating the tasks being executed overnight and weekends.

• Daily activities includes supporting the users/business team in resolving and fixing the performance issues with Oracle EBS application in various aspects like, Database query performance, DB table locks, row/record locks, Concurrent requests performance, forms/oacore memory stabilization issues.

• Created, installed and upgraded MySQL databases.

• Performed MySQL database copy/refresh.

• Involved in tuning EBS instance with multiple techniques in identifying the issues. Resolved issues rose with Oracle DB Server Swapping, Oracle application server memory bottle necks, Oracle Database query performance, Oracle Database Server memory management/tuning, Oracle Concurrent managers review.

• Developed and deployed various cron jobs for monitoring and detecting long running concurrent requests, database server memory usage, runaway forms processes and application server memory usage monitoring.

• Reviewing the customers requested tasks and following up with the daily on-call analyst in executing them in timely manner and mentoring them in case of a requested assistance and providing the guidance in completing the tasks.

• Prepared checklists for tuning the databases and EBS to resolve the performance issues if any occurred.

• Worked on Demantra application administration that was hosted along with Oracle EBS deployment. Part of the Hardware migration, I migrated Demantra part of the other applications to new hardware and OS Versions

• Extensively worked on troubleshooting and performance tuning of the EBS applications and supporting tools.

Oracle Apps DBA

• As a daily activity, I support in assisting and resolving various issues with printers and print queues setup in EBS application. Troubleshooting involves on OS level, EBS level and network level. I also support the printing types like label printing, PDF printers like PASTA driver setup.

• Worked on SSL Setup for various applications. The intranet based applications like EBS, Discoverer, OBIEE is to handle traffic on https protocol from http. Implementing Reverse proxies or load balancers to terminate the traffic is one of my favorite option in http to https implementation.

• Installed and configured Vertex Q Series (Sales Tax purpose) (Vertex Central and Web Services) for one of the customer in non-production environment. The architecture includes a separate Database and Weblogic 11g installation (for deploying Vertex remote services)

• Expertise in managing EBS Java Notification Mailer for Workflow Notifications. I did advanced troubleshooting with SMTP, IMAP and recent experience of using Google Apps and Microsoft office365 cloud servers.

• Installed and configured SOA systems using FMW 12c release and applied CPU patches and integrated with bank interfaces.

• Responsible for Maintaining Oracle Applications Releases 11i & R12 for all customers, daily activities includes reviewing the production and non-production monitoring alerts and implementing the fixes and preventive steps.

• Implementing Oracle Real Application Clusters (RAC) 11g on Linux 64bit OS with multi node Database setup for Merury Internal EBS Application as a High Availability configuration. Installed OEM Grid Infrastructure setup with ASM and setup a separate Oracle Binaries for the RDBMS $ORACLE_HOME.

• Also Installed the OEM agents for other customer databases to monitor and to perform the daily operations.

• Involved in migration from Physical to virtual Machines.

• As a Service admin, I am involved for all the projects and analysis and preparation of the documents for assigned customers.

• Implemented and supporting the OID/OAM integration with EBS R12 release for one customer.

Experience with OAM/OID Integration with EBS R12(12.1, 12.2): o Installed and configured Oracle Identity Manager 11gR1 o Configured the components like OID, DIP, Directory Service Manager and Enterprise Manager Fusion Middleware Control

o Configured OID Synchronization profiles and worked with bootstrap process. o Setup and Configured the Java External Authentication Plug-in for EBS. o Installed and configured Oracle Identity and Access Manager 11gR1 and configured Oracle Access Manager.

o Setup the OAM agent and configured the private, public, protected resources o

o Setup OAM Agent and Access Gate and Web Gate and WebTier components. o Registered EBS with OID for the FND_USER data synch. o Configured and deployed EBS Access Gate.

o Troubleshoot and fixed many commonly raised issues during the setup and initial load.

o Fixed issues like JDBC connection overload, apps password changes caused issues in redeploying the access gates.

o Worked with users in troubleshooting the SSO Login issues

• Installed and configured 11g OID/OAM environment with oracle EBS release. Configured multiple managed Weblogic services.

Oracle Apps DBA/ Developer

• Installed and configured Oracle Identity Manager 11gR1

• Configured the components like OID, DIP, Directory Service Manager and Enterprise Manager Fusion Middleware Control

• Configured OID Synchronization profiles and worked with bootstrap process.

• Setup and Configured the Java External Authentication Plug-in for EBS.

• Installed and configured Oracle Identity and Access Manager 11gR1 and configured Oracle Access Manager.

• Setup the OAM agent and configured the private, public, protected resources.

• Setup OAM Agent and Access Gate and Web Gate and WebTier components.

• Registered EBS with OID for the FND_USER data synch.

• Configured and deployed EBS Access Gate.

• Troubleshoot and fixed many commonly raised issues during the setup and initial load.

• Fixed issues like JDBC connection overload, apps password changes caused issues in redeploying the access gates.

• Worked with users in troubleshooting the SSO Login issues.

• Installed and configured Oracle Business Intelligence Enterprise Edition.

• Configured Informatica and DAC tools to extract data from EBS Databases.

• Installed and setup Windows Tools for Developer access on Remote Desktop Machines.

• Worked OBIEE upgrades and clones.

• Using the Export utility to export tables to Unix system files, and the Import utilities to load exported data back into Oracle tables, creating data backups, compressing extents.

• Users raise their support requests using Remedy tool where we work on priority issues. Also supporting the module development/Support teams on their code movement to production instance.

• Worked on Oracle EBS 11.5.10 & 12.1.3 release administration on both HP Unix and Windows platform releases.

• As Service Admin, I have the complete knowledge and history of the specific customer systems issues and fixes that were applied during my duration.

• Also involved in weekend on call coverage in assisting for all the customers’ tasks in weekends on a rotation basis. It needs an extensive knowledge and multi-tasking skills to work on many requests simultaneously during the duty.

• Involved in migrations when a new customer engagement is signed and coordinated with internal teams (Infrastructure, Solutions, and Administration teams) with Customers and their vendors and implementers.

Contact this candidate