PROFESSIONAL SUMMARY:

• 10 years of extensive experience in Linux Administration Activities, Oracle DBA, RAC DBA and Oracle APPS DBA, Oracle Business Intelligence Applications OBIA, Confidential product, ONDEMAND implementations on all Linux environments.
• Responsible for transforming the business requirements into technical requirements and provide guidance to the team in various technical and functional issues.
• Expert in automation of most day to day tasks in support environment.
• Installation and configuration of Oracle RDBMS, E - Business Suite & OBIA, Callidus Products.
• Well versed with Oracle E-Business suite application 11i, R12.0.*, R12.1.* & R12.2.* architecture, configurations, management and administration.
• Debugging the issues related to Linux Environments for all the Applications.
• Patching and Configuration management of Oracle EBS 11i and R12.
• Cloning and Refreshing of Databases and EBS 11i/R12.
• Expert in database (8i, 9i, 10g, 11g and 12c) installation, upgrade, migration and administration.
• Implementation of Oracle Database 9i/10g/11g/12c RAC and Data Guard.
• Expert in backup, recovery and cloning using RMAN
• Oracle Business Intelligence Applications (7.9.x)
• Experience with database replication technologies - Golden Gate
• Business Intelligence Data warehousing tools (OBIEE 10.x/11.x, Informatica PowerCenter 8.x/9.x, DAC - Data Warehouse Application Console, Oracle Data Integrator, SQL, PLSQL, Oracle Database.
• Migration from Oracle Discoverer 10g,11g to OBIEE 10g, 11g
• Well experience in all phases of project life cycle such as project planning, requirements gathering, analysis, design, development, implementation, enhancements, training and documentation.
• Automation of the Process related to Linux through Shell Scripting.
• Installation and configuration of Confidential On demand environments.
• Excellent communication, presentation and interpersonal skills.
• Extraordinary problem-solving capabilities in production environment.
• Ability to multi-task with efficiency and willingness to work in highly dynamic, team-based, challenging environments.
• Ability to learn quickly and to correctly apply new tools and technology.
• Quick learner and excellent team player having ability to be agile, meet tight deadlines, willing to take initiatives and take on new responsibilities.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps DBA

Responsibilities:

• Upgraded EBS to R12.2.4 from R12.1.3
• Configured load balancer with Oracle EBS R12.2.4
• EBS R12.2.4 single node to single node clone
• EBS R12.2.4 multi node to multi node clone
• Implemented single sign on(SSO) for EBS R12.2.4 using Oracle Access Manager
• Administration of Oracle WebLogic server
• Custom top creation with adsplice utility
• Applied patches using adop utility
• Built environments for various project requirements
• Deployed applications in various environments
• Implemented edition based redefinition for custom objects
• Administration of Oracle WebLogic server
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Applied patches using ADOP (R12.2 Environments) ADPATCH, ADCTRL utilities.
• Performed java upgrade.
• Configured RMAN backups.
• Maintained and supported various oracle ERP environments.
• Working with Oracle GoldenGate Software Command Interface (GGSCI).
• Configure and manage source and target Oracle GoldenGate manager process.
• Enable table-level logging using Oracle GoldenGate.
• Performed Oracle GoldenGate backup, recovery.
• Implemented and administered data guard environment
• Partitioned table for optimal performance
• Performance monitoring for application performance enhancement
• Implemented and monitored oracle data guard
• Regular database activities, backups monitoring.

Environment: RHEL, Oracle EBS R12.2.4, R12.1.3, Oracle RDBMS 11gR2, Data Guard, WebLogic, 11g RAC, TOAD, OEM, RMAN

Confidential

Oracle DBA SaaS, Cloud Management

Responsibilities:

• Weekly cloning of non-prod instance from a copy of production.
• Applying Oracle RDBMS Patches.
• Installing new Oracle Databases for ongoing projects.
• Installing and configuring the Database with all the respective applications.
• Monitoring the health of the production system periodically.
• Taking care of the code movement to production.
• Working with Oracle Support to resolve bug fixes.
• Supporting the development team and functional team.
• Performance tuning on the Database.
• Performance tuning on the Application.
• Preparing Shell scripts to automate most of the process.
• Handling the scheduled maintenance for all the Production Environments.
• Enabling SSO between Customer Environment and Callidus Portal
• Integration of Salesforce domain with Callidus Portal.
• Deployment of application on Weblogic Application server.
• Handled more than 100 Database upgrades to Oracle RDBMS 11.2.0.3.
• Implemented the Database backup strategy using the Shell Scripting.
• Automated Oracle RDBMS installation process.
• Automated Application installation process.
• Enabled SSO between Weblogic Application server and Sales Force domain.
• Installation and configuration of Informatica.
• Installation and configuration of Weblogic server.
• Implemented RMAN backups for Oracle RDBMS 11.2.0.3

Environment: Oracle RDBMS 9.2.0.6 and11.2.0.3, Weblogic 11g, Informatica 8.6 to 9.1RedHat Linux 5, Solaris 5.10.

Confidential

Oracle Apps DBA

Responsibilities:

• Installed Oracle RDBMS 11.1.0.7 on Linux and Client on Windows.
• Created Off shore Development environment.
• Export/Import the database using data pump utility.
• Configured other applications with Oracle RDBMS.
• Created a replica of the OLTP at offshore for development.
• Job Scheduling through Shell Scripting.
• Enabled Dashboards with User security.
• Production deployment of all the applications.
• Resolved the Performance issues related to both Database and Linux environments.
• Provided 24/7 support.
• Applied all the necessary security patches to EBS servers.
• Worked with Functional Analysts to setup the settings for EBS R12.1.3.
• Installed Oracle Data Integrator server on Solaris.
• Resolved all the environment issues related to Solaris.
• Installed Oracle PIP related to Oracle E-Business Suite and Siebel.
• Integrated Oracle Data Integrator with Oracle AIA.
• Customizations are done in the existing XML files related to Weblogic Server.
• Created Offshore Development environment for Oracle Data Integrator.

Environment: Siebel 8.1.1.3, Oracle E-Business Suite R12, Weblogic Server 11g, Oracle Data Integrator 11g.

Confidential

OBIA Admin and BIAPPS Consultant

Responsibilities:

• Installed Oracle RDBMS 11.1.0.7 on Linux and Client on Windows.
• Installed & Upgraded RDBMS from 9.2 to 10.2.0, 10.2.0 to 11.2.0.3
• Created Offshore Development environment.
• Export/Import the database using data pump utility.
• Configured other applications with Oracle RDBMS.
• Created a replica of the OLTP at offshore for development.
• Job Scheduling through Shell Scripting.
• Enabled Dashboards with User security.
• Production deployment of all the applications.
• Resolved the Performance issues related to both Database and Linux environments.

Environment: Oracle Database 9.2. Oracle database 10.2.0.4, Oracle database 11.2.0.3, Red hat Linux 5 64-bit.

Confidential

OBIA Admin and BIAPPS Consultant

Environment: Siebel 8.1.1.3, BIAPPS 7.9.6.1, OBIEE 10.1.3.4.1 , Informatica 8.6.1, Dac 10.1.3.4.1 Windows XP, Windows 2003, Windows 2008, RHEL 5.

Responsibilities:

• Prepared the Windows Desktop for the OBIEE install.
• Installed Oracle OBIEE 10.1.3.4.1 on Linux.
• Installed Oracle BiApps 7.9.6.1 on Windows.
• Configured Oracle BiApps 7.9.6.1.
• Installed Informatica PowerCenter 8.6.1 Server on Linux and Client on Windows.
• Configured Informatica on Linux and restored the pre-built Repository from OBIEE.
• Installed DAC 10gR3 Server and Client on Windows.
• Configured the DAC Server on Windows.
• Worked with Functional Analysts to setup the ETL settings in Informatica for Siebel 8.1.1.3
• Configured the OBIEE Web Catalog and Dashboards.
• Created segments, Campaigns in OBIEE 10.1.3.4.1 for Siebel.
• Generated Lists for the campaigns created in OBIEE for Siebel.
• Resolved the Performance issues related to both Database and Linux environments.

Confidential

Oracle Apps DBA

Responsibilities:

• Pro-active participation in the entire project life cycle right from requirements elicitation to the final client-side deployment.
• Entirely responsible for vanilla implementation part of EBS
• Installed Oracle RDBMS 10.2.0.5 on Linux and Client on Windows.
• Installed Oracle E-Business Suite 11.5.10.2 and R12.1.1 vision databases.
• Customized according to the client requirements.
• Prepared the system for POC.
• Provided 24/7 support..
• Applied all the necessary security patches to EBS servers.
• Applied RDBMS patches.
• Configured the Oracle EBS.
• Worked with functional analysts to set up the modules.
• Integration with Oracle EBS Application.
• Resolved the Performance issues related to both Database and Linux environments.

Environment: Oracle E-Business Suite 11.5.10.2, Oracle E -Business Suite R12.1.1, RDBMS 10.2.0.5, Red hat Linux 4.

Confidential

Oracle Apps DBA, Maintenance Support

Responsibilities:

• Pro-active participation in the entire project life cycle right from requirements elicitation to the final client-side deployment.
• Entirely responsible for vanilla implementation part of EBS
• Installed Oracle RDBMS 10.2.0.5 on Linux and Client on Windows.
• Installed Oracle E-Business Suite 11.5.10.2 and R12.1.1 vision databases.
• Customized according to the client requirements.
• Prepared the system for POC.
• Provided 24/7 support.
• Applied all the necessary security patches to EBS servers.
• Applied RDBMS patches.
• Configured the Oracle EBS.
• Implemented out of box SSO between LDAP and Oracle EBS.
• Worked with Functional Analysts EBS R 12.1.1.
• Implemented the Security based on the given requirements.
• Enabled User security and integration with Oracle EBS Application.

Environment: Oracle E-Business Suite R 12.1.1, RDBMS 10.2.0.5, Redhat Linux 4.

Confidential

Oracle Apps DBA

Responsibilities:

• Installed and configured Oracle RDBMS 10.2.0.5 on Solaris 2.9 and OEL 5.4.
• Applied Interoperability patches on RDBMS 10.2.0.5 for EBS 11.5.10.2
• Upgraded the D2K from PatchSet 16 to PatchSet 19.
• Cloned new instances required for the upgrade.
• Upgraded the EBS database from Release 9.2.0.6 to 10.2.0.5.
• Migrated the EBS database from Solaris to Linux using Exp/Imp (Data Pump).
• Migrated the EBS Database to OATM tablespace model.
• Worked closely with Oracle Support to resolve the issues during the migration.
• Applied Interoperability patches on RDBMS 10.2.0.5 for EBS R12.1.1
• Installed and configured the R12.1.1 Applications file system for the upgrade.
• Applied the Mandatory patches required.
• Upgraded the Oracle E-Business suite 11.5.10.2 to 12.1.1 on Linux.
• Responsible for Change request migrations.
• Installed Oracle RDBMS11.2.0.1 on Linux.
• Applied Interoperability patches on RDBMS 11.2.0.1 for R12.1.1
• Upgraded the Oracle database from 10.2.0.5 to 11.2.0.1
• Provided support for the developers to migrate the customizations.
• Implemented the backups on Linux using RMAN.
• Provided Production support for the existing production during project.
• Also provided support for basic Linux Administration.

Environment: Oracle E-Business Suite 11.5.10.2, R12.1.1, RDBMS 9.2.0.6, 10.2.0.5 and 11.2.0.1, Solaris 2.9, Oracle Enterprise Linux 5.4 and Windows XP.

Confidential

OBIA Admin and BIAPPS Consultant

Responsibilities:

• Prepared the Linux Server and the Windows Desktop for the OBIEE install.
• Installed Oracle RDBMS 10.2.0.5 on Linux and Client on Windows.
• Installed Oracle OBIEE 10.1.3.4.1 on Windows and Linux.
• Installed Oracle BiApps 7.9.6.1 on Windows.
• Configured Oracle BiApps on Linux.
• Installed Informatica PowerCenter 8.6.1 Server and Client on Windows and Linux.
• Configured Informatica on Linux and restored the pre-built Repository from OBIEE.
• Installed DAC 10gR3 Server and Client on Windows.
• Configured the DAC Server on Linux.
• Worked with Functional Analysts to setup the ETL settings for EBS 11.5.10.2
• Configured the OBIEE Web Catalog and Dashboards.

Environment: Oracle E-Business Suite 11.5.10.2, RDBMS 10.2.0.5, Redhat Linux 4, OBIEE 10.1.3.4.1 , Informatica PC 8.6.1, BI Apps 7.9.6.1 & Windows XP.