Oracle Support
Resume:
Ravi Shankar Gujjaiah
Professional Profile
Strengths
Oracle Applications DBA,
Oracle DBA
Oracle 11g RAC DBA
Oracle 12c
Oracle Cloud Infrastructure
AWS Cloud Infrastructure
Contact Details
Phone
E-mail **********@*****.***
Ravi Shankar Gujjaiah has 18 years of extensive experience working as Senior Oracle Applications Database Administrator / Oracle Cloud Infrastructure Architect in the information technology and services industry.
Skilled in Oracle Database Administration, Oracle Applications Administration, Oracle Cloud Infrastructure Architect, Data Warehousing, Business Intelligence, and Linux. Strong information technology professional with a Master of Computer Applications from University of Madras.
.
Experience in implementation / Migration / Upgrade of Oracle E Business Suite on Cluster and Non Cluster environment in Private / Public Cloud.
Oracle database 9i, 10g and 11g/12c RAC and 12c installation and upgrades.
Experience in upgrading of Oracle E Business Suite.
Experience in Platform migration of Oracle Applications and Database.
Experience in Advanced database server for high availability and Replication.
Experience in design & deploy disaster recovery site
Education:
Master in Computer Application (MCA) from University of Madras
Post Graduate Diploma in System Analysis & Design from University of Mysore.
Bachelor of Science (Electronics) from University of Mysore.
PROJECTS
Client : BIC Graphic USA Clearwater FL
Period : Oct 2019 –
Role : Oracle Applications DBA
Roles and Responsibilities
Manage Project Implementations.
Comprehensive E-Business Suite and Business Applications Management
Analysis and Implement technology solutions
Enhance process improvements
Client management on strategic projects
Work closely with the clients and conduct project reviews and presentations to ensure client satisfaction
Valuate existing systems and procedures making recommendations for improvement; design prototypes and proof of concepts that best fit the client's needs
Evaluate existing systems and procedures and recommendation improvements
Design prototypes and proof of concepts that best fit client's needs
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance testing / Tuning of Oracle Application and Database for executing Concurrent Programs using AWR and ASH.
Employer : Velocity Technology Solutions. Houston TX.
Period : June 2018 – Sep 2019
Role : Oracle Applications DBA
Roles and Responsibilities
Manage project implementations
Enhance process improvements
Client management on strategic projects
Work closely with the clients and conduct project reviews and presentations to ensure client satisfaction
Valuate existing systems and procedures making recommendations for improvement; design prototypes and proof of concepts that best fit the client's needs
Evaluate existing systems and procedures and recommendation improvements
Upgrade Oracle E-Business Suite from 12.1.3 to 12.2.5
Clone the R12.2.6 system to create Test / Dev environment.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance testing / Tuning of Oracle Application and Database for executing Concurrent Programs using AWR and ASH.
Install / Configure / Troubleshoot / Patch / Upgrade OBIEE
Performance tuning of Application including JVM/OC4J
Employer : Mercury Technology Group. Irvine CA.
Period : Sep 2016 – May 2018
Role : Oracle Applications DBA
Roles and Responsibilities
Upgrade Oracle E-Business Suite from 12.1.3 to 12.2.5
Upgrade Oracle 4 node RAC database from 11g to 12c
Apply 12.2 instance patches with ADOP utilities.
Clone the R12.2.6 system to create Test / Dev environment.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance testing / Tuning of Oracle Application and Database for executing Concurrent Programs using AWR and ASH.
Install / Configure / Troubleshoot / Patch / Upgrade OBIEE
Performance tuning of Application including JVM/OC4J
Client : Amway - Grand Rapids MI
Period : April 2016 – Aug 2016
Role : Lead Oracle Apps DBA
Roles and Responsibilities
Upgrade Oracle E-Business Suite from 12.1.3 to 12.2.5 on Exalogic Servers
Upgrade Oracle 4 node RAC database from 11g to 12c on Exadata servers
Apply 12.2.5 instance patches with ADOP utilities.
Clone the R12.2.5 system to create Test / Dev environment.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance Tuning of Oracle Application and Database for executing Concurrent Programs using AWR and ASH.
Client : Gap Inc Pleasanton CA
Period : Feb 2013 – March 2016
Role : Lead Oracle Apps DBA
Roles and Responsibilities
Migrated R12 instance from Solaris to Linux environment with 2 node RAC Database 3 node application server with shared Appl Top, Parallel concurrent processing (PCP), Reverse Proxy setup for i-modules including BCP setup.
Manage Maintain and Administer Oracle E-Business suite which is 24X7 with Oracle Financials on R12.2 release along with refresh of Reporting instance.
Apply 12.2 instance patches with ADOP utilities.
Clone the Production system to create Test / Dev environment RAC to RAC and RAC to non RAC.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance Tuning of Oracle Application and Database for executing Concurrent Programs using AWR and ASH.
Upgrade of Oracle database 10g to 11g RAC and non RAC database.
Install configure Oracle OIM for SSO with Oracle E-Business suite.
Lead a team of 5 Oracle Apps DBA’s for 24X7 support
Client : Google Inc. Mountain View CA
Period : April 2012 – Jan 2013
Role : Sr. Oracle Apps DBA
Roles and Responsibilities
Manage Maintain and Administer Oracle E-Business suite which is 24X7 with Oracle Financials on R12 / 11i release along with refresh of Reporting instance.
Implement Oracle application new modules.
Clone the Production system to create Test / Dev environment
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance Tuning of Oracle Application and Database for executing Concurrent Programs / Concurrent Managers.
Upgrade of Database from 10g to 11g
Managing user accounts and their security privileges
Database space management to optimize I/O, SQL Tuning.
Setup and Administer Physical Standby database.
Client : Gap Inc. San Francisco CA
Period : Aug 2011 – April 2012
Role : Lead Oracle Apps DBA
Roles and Responsibilities
Manage Maintain and Administer Oracle E-Business suite which is 24X7 with Oracle Financials on R12 release along with refresh of Reporting instance.
Implement Oracle application new modules.
Clone the Production system to create Test / Dev environment
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance Tuning of Oracle Application and Database for executing Concurrent Programs / Concurrent Managers.
Plan & Execute upgrades of Oracle Applications, which includes database upgrade from 10g to 11g as well as application tier upgrade from R12.0 to R12.1 with minimum downtime
Database space management to optimize I/O, SQL Tuning.
Lead a team of 6 Oracle Apps DBA’s for 24X7 support
Client : VMware Inc Palo Alto CA
Period : March 2011 – Aug 2011
Role : Sr. Oracle Apps DBA
Roles and Responsibilities
Manage Maintain and Administer Oracle E-Business suite which is 24X7 with Oracle Financials.
Implement Oracle application new modules.
Clone the Production system to create Test / Dev environment
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Performance Tuning of Oracle Application and Database
Managing user accounts and their security privileges
Database space management to optimize I/O, SQL Tuning.
Maintain and administer SOA, HYPERION and DRM instance and clone of the instance.
Employer : Real Networks Inc Seattle WA
Period : November 2007 – Feb 2011
Role : Sr. Oracle Apps DBA
Roles and Responsibilities
Manage Maintain and Administer Oracle E-Business suite which is 24X7 with Oracle Financials and HRMS modules.
Implement Oracle application new modules.
Clone the Production system to create Test / Dev environment
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Formulate and implement Production system backup and recovery procedure
Formulate Disaster recovery plan and deploy disaster recovery site.
Performance Tuning of Oracle Application and Database
Upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade from 11i to R12.
Upgrade of Oracle Application from 11.5.10.2 to R12.
Managing user accounts and their security privileges
Database space management to optimize I/O, SQL Tuning.
Installing and configuration of Discover Server
Client : World Vision Seattle (Support Project)
Employer : HP GDIC
Period : July 2006 – Oct 2007
Role : Lead Oracle Apps DBA
Roles and Responsibilities
Interacting with the customer to understand and support the needs as per the business requirement.
Standardize the Clone process at World Vision.
Formulate the hot backup for the PROD instance there by increasing availability of PROD instance to Business
Defined Concurrent Programs and Manage Work sift for Concurrent Managers.
Defined responsibilities and assigning these to users.
Backup and Cloning of Application using Rapid cloning utility.
Technical support for the Oracle Financial, Supply Chain, iStore modules in terms of analyzing the issues from the database level
Managing user accounts and their security privileges, preparing Backup and recovery strategies,
Database space management to optimize I/O, SQL Tuning.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Lead a team of 4 Oracle Apps DBA’s for 24X7 support
Client : Avago Technologies Singapore (Implementation Project)
Employer : HP GDIC
Period : Nov 2005 till June 2006
Role : Oracle Application Architect
Roles and Responsibilities
Drawing up, validating and to build the production system for 500+ concurrent users utilizing the Oracle latest technologies.
Installation of the production setup with 5 nodes Data Base RAC with 10g Rel 1
(10.1.0.4) with ASM on 64bit Split Configuration, 6 nodes middle tier on Linux environment with Share Appl Top Configuration and the Load Balancer for the Intranet users along with servers in DMZ for i-modules to be accessed from the outer world with SSO and load balancer to connect all the 6 middle tier node..
Planning and Execution of the Instances for the implementation team as per the Instance Calendar.
Design & Deploy the disaster recovery site using Data guard
Data Base upgrade from 9i to 10g RAC
Implementation of Kintana for Code migration and Instance replication.
Co-ordinate with multiple development teams and multiple software vendors on issues resolution and capacity planning.
Instance Cloning (RAC and Non RAC instance)
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Working closely with SAN experts to layout the storage for RAC database
Client : Hutch Thailand (Upgrade and Support Project)
Employer : HP GDIC
Period : June 2005 till September 2005
Role : Lead Oracle Apps DBA
Roles and Responsibilities
Interacting with the customer to understand and support the needs as per the business requirement.
Cloning of Application using Rapid cloning utility.
Working closely with the application development team for Bug Fixes and tar escalation
Client : Wataniya Telecom Kuwait (Implementation Project)
Employer : HP GDIC
Period : Feb 2004 till March 2005
Role : Oracle Apps DBA
Roles and Responsibilities
Installation (2 Node with High Availability Solution on Tru64), Implementation and Cloning of Oracle Applications 11.5.9.
Installed patches and performed patch management system & configuration of Oracle Applications.
Drawing up Backup and Recovery plan.
Cloning of Application using Rapid cloning utility.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Client : SRF-Limited Chennai (Support & Implementation Project)
Employer : tsunami Infosolutions
Period : June 2003 to Feb 2004
Role : Oracle Apps DBA
Roles and Responsibilities
Oracle Application 11i
Installation (2 Node with High Availability Solution on HP UX11i), Implementation and Cloning of Oracle Applications 11.5.8.
Installed patches and performed patch management system & configuration with Oracle Applications.
Defined Concurrent Programs, Executables
Registrations of Tables, Forms and Reports for Custom applications
Defined responsibilities and assigning these to users
Defined values set and uploaded their values.
Backup and Cloning of Application using Rapid cloning utility.
Technical support for the above modules in terms of analyzing the issues from the database level
Managing user accounts and their security privileges, preparing Backup and recovery strategies,
Database space management to optimize I/O, SQL Tuning.
Periodically refresh Oracle Database and Oracle Application.
Installed tools like ADI.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Client : Q-soft
Employer : tsunami Infosolutions
Period : Aug 02 – May 03
Role : Oracle Apps DBA
Roles and Responsibilities
Oracle Application 11i DBA
Maintenance and Cloning of Oracle Applications 11.5.3
Installed patches and performed patch management system & configuration with Oracle Applications.
Defined Concurrent Programs, Executables
Registrations of Tables and Forms for Custom applications
Defined responsibilities and assigning these to users
Defined values set and uploaded their values.
Backup and recovery.
Technical support for the above modules in terms of analyzing the issues from the database level
Database space management to optimize I/O, SQL Tuning.
Periodically refresh Oracle Database and Oracle Application.
Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
Client : AXA-Direct Non-Life Insurance Company Ltd. JAPAN
Employer : Apex Technologies Pvt., Bangalore
Period : Dec 00 – July 02
Role : System Analyst / DBA
Roles and Responsibilities
As a systems analyst was responsible to designing proof of concept for migration of two tier application to three tier Web based application providing multi-lingual support using Oracle National Language Support features
As a data base Administrator was responsible for Installing Oracle Server, Creating and maintaining Logical / Physical Structure, Schema Management, Volume Estimation, Data Base Tuning.
Employer : Ashok Leyland Information Technology Bangalore
Period : Sep 00 – Nov 00
Role : System Analyst / Developer
Roles and Responsibilities
As a System Analyst / Developer was responsible for analysis/ design and development of OARC (Operation Analysis & Routing Card) module migration from mainframes to client server system.
Employer : Bharat Electronics Bangalore
Period : May 99 – Aug 00
Role : System Analyst / Developer
Roles and Responsibilities
As a System Analyst / Developer was responsible for analysis/ design and development of OARC (Operation Analysis & Routing Card) module in Oracle ERP system.
Employer : KOF
Period : Jan 97 – April 99
Role : Developer
Roles and Responsibilities
As a developer was responsible for development of Personnel Information System, Procurement Accounting System, Quality Analysis System, Society Information System & Pay roll System.
Contact this candidate