SUMMARY:

• Having 17+ years of experience in oracle consulting on technologies like Oracle virtual machine (OVM) with private cloud setup, E - Business suite (11.0.3, 11.5.7, 11.5.9, 11.5.10.2 and Release 12) with Database (8i/9i/10g/11g and 12c), Single Sign On, Web Logic Server, OBIEE, and SOA.
• Good hands on experience with implementation, post implementation support and troubleshooting.
• Architect and implementation of virtual machines, with RAC cluster and disaster recovery, private cloud.
• Installation and configuration of hypervisors on DELL and HP servers, discover, setup, configure virtual machines on hypervisors.
• Upgrade of Oracle E-Business suite on various versions.
• Implementation of SSO on WNA/SPNEGO SSO for ECM, Portals, web center spaces etc.
• Architect and Implementation of Single sign on (SSO) with Oracle Internet Directory (OID) and Business Intelligence tools.
• Installation of Release 12(12.1.1,12.2.2) E-business suite on Oracle Enterprise Linux and upgrades.
• Installation of Oracle Business Intelligence (OBIEE)
• Installation configure and patching of Oracle 11g R2 and 12c RAC database systems on Linux.
• Up gradation of databases from 9i to10g, 11g and 12c. Installation, configuration and maintenance of OEM 12c.
• DB and oracle applications support experience within managed services which includes performance tuning oracle databases and applications hosted on UNIX platforms.
• Align business requirements to technical configurations and documentation.
• Installation and configuration/support of fusion middleware products with Oracle WebLogic server domains.
• Setup dataguard on 3 node RAC databases using RMAN.
• Analysis and applying of application and database tier patches with CPU and RUP version patches.
• Worked on RAC, PCP, RMAN Backup, Raw volume file system, AIX Unix system with LPARs.
• Supported environments with OID, SSO and portal 10gAS components.
• Database upgrades on RAC enabled and non RAC databases.
• Have worked on oracle applications implementations with 11.5.7 and 11.5.9 environments with customizations.
• Maintenance and Support: Cloning of E-business suite Multi to single and multi to multi node instances.
• Cloning of Oracle8/8i/9i/10g Databases. Registering OID and SSO as a part of cloning.
• Implementation of Oracle streams and documentation.
• Highly effective technical Manager/Leader with a track record of success in consistently delivering outstanding results in Oracle Implementation and support for major Clients.
• Good Experience and exposure working at various client sites.
• Received multiple recognition s, Excellence delivery for many project deliveries.
• Worked on oracle Exadata and Exalogic engineered systems by applying security patches and configurations.

SKILL SET:

ERP Applications: Oracle11i (11.0.3, 11.5.7, 11.5.9, 11.5.10.2) and Release 12.1, 12.2.

Fusion Middleware: SSO/OID/OBIEE/SOA and content management.

Cloud platform: Oracle private cloud using OVM and xen-hypervisors.

Operating System: HP Unix, Confidential OS 5.x, AIX Unix, Oracle Enterprise Linux, Windows NT 4.0Windows2000.

Scripting: Shell Scripts. SQL.

Database: Oracle 8i /9i/10g, 11g and 12c.

Case Tools: Toad, OEM 11g, OEM 12c, DBCA, DBUA.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Consultant

Responsibilities:

• Architect and implementation of Oracle Virtual Machine(OVM - private cloud).
• Creation and setup of virtual machines using templates etc.
• Implementation of oracle cluster using deploy cluster tool for 3 node RAC on 11g and 12c databases.
• Create databases and data guard on 3 node cluster setup for both production and DR environment.
• Migration and upgradation of databases from Exadata boxes to OVM machine platforms.

Confidential

Oracle Consultant / APPS DBA

Responsibilities:

• Architect and implementation of Oracle Virtual Machine(OVM - private cloud).
• Upgrade of Oracle E-Business suites.
• Architect and implementation of APEX on windows servers.
• Platform migration from IBM AIX to Oracle Exadata.
• Implementation of WNA/SPNEGO SSO for ECM, Portals, web center spaces etc.
• Implementation of 10g SSO for Oracle E business suite R12.
• Exposure to Oracle Access Manager/ SOA and Webcenter spaces middleware technologies.
• Installation of Oracle Business intelligence EE.
• Installation and configuration of Oracle Enterprise Manager 12c with E-Business suite.
• Installation/Configuration/domain creations and troubleshoot of Oracle Weblogic server.
• Data guard build for 3 node RAC standby databases.
• Cloning R12 E-Business suite as part of implementation and autoconfig customizations.
• Patching R12 E Business suite and RAC databases.
• Installation of RAC on laptops for personal development and testing.
• Installation of R12 E business suite on laptop.
• Worked on pre sales technical aspects for various clients.
• Support work on various oracle technologies with on call roasters.

Confidential

Oracle Apps DBA/DBA

Responsibilities:

• Architecting and designing implementation of Oracle SSO/OID with Discoverer.
• Synchronization of SSO with Microsoft AD for link on the fly authentication.
• Integration of SSO with E business 11i suite with Oracle Internet directory
• Configuring external authentication plug in with Microsoft AD for user login.
• Synchronization of SSO with discoverer.
• Creation of business areas and workbooks for initial testing and granting EUL privileges.
• Participate in Oracle11i application 24X7 maintenance and support.
• Upgrade of oracle applications databases from 8i to 9i and 9i to 10g, both RAC and non RAC databases.
• Involved in financial quarter end and year end support activities.
• Cloning of oracle applications from multi to multi and multi to single node instances.
• CPU and RUP patch analysis and application.
• Maintaining the database and Application on two node RAC.
• Maintain applications with OID, SSO and Portal instances with RAC enabled databases.
• Planning and implementation of RMAN backup and recovery schedules, involved in database recoveries using RMAN during block corruption and recoveries.
• Performance tuning of SQL, concurrent managers and databases.
• Performance tuning and maintenance using AWR, explain plan, OEM and gather stats package etc.
• Proactively monitor and providing 24x7 On-Call Technical Support to Mission Critical, Business Critical and Normal Databases and Applications.
• Upgrading the application component version by applying interoperability patches in order to base line the application tier for database upgrades.
• Configure printers in oracle applications.
• RMAN backup maintenance and recoveries from block corruptions.
• Settling up the environments at the client site for new module implementation for ilearning and modules.
• Involved in Regular maintenance activities like table data purging and table space reorganization.
• Worked on root cause analysis and providing long term fixes for the p1 issues faced during on call support.
• Worked on troubleshooting issues raised through ticketing system.
• Developing shell scripts to automate health checks and availability of the databases and applications.
• Co-ordination with various teams for testing, implementation strategies, required configuration details etc.
• Documentation of the upgrade projects, on call support issue and troubleshooting steps and long term fix. Analysis, study and documentation of the existing systems for upgradation and enhancement projects.
• Configured oracle streams with documentation and support steps for client recommendation for data replication.
• Achieve high customer satisfaction levels by maintaining high availability database systems.
• Prepare Knowledge repository for future and upgradation technical paths.
• Worked on many client locations directly reporting to client managers.
• Priority (P1) issue handling and knowledge transition to teams across different geographical locations.
• Delivering and implementing the project as per scheduled milestones.
• A good team player, coordinating with various teams during critical projects like upgradation, brining up better clarity in responsibilities and execution.
• Maintain effective working relationships with Colleagues, customers and third party service providers.
• Mentor junior staff on technology and best practices.
• Generating Service weekly/Monthly review report and generating info about Capacity planning.

Confidential

Project lead - Oracle apps DBA/ DBA

Responsibilities:

• Installation of oracle vision and non prod databases for migration of financial applications from people soft ERP to Oracle e business suite.
• Regular cloning and patch application of functional and AD, AU, FND patches for steady maintenance.
• Help support implementation of customized workflows and issue trouble shooting.
• Proactively monitoring (Alert monitoring) the E-business suite and database.
• Handling the outage on weekly and on demand basis. 24x7 On-Call Technical Support.
• Trouble shooting and supporting Oracle ERP and Database related issues.
• Installation and integration of new databases with oracle applications databases for time management systems and resource management systems.
• Handled a team of 10 with functional and technical resources, maintaining the oracle applications along with other databases and application systems.
• Monitoring space at database and at server levels.
• Loading of bulk data to prod systems using tools like ADI, usage of tools like TOAD.
• Initially deployed at client location Confidential for implementation and support, client enrolled me onto their rolls with appreciation of good work.

Confidential

Software engineer - Oracle Apps DBA / Oracle DBA

Responsibilities:

• Maintenance of oracle application along with billing related databases.
• Trouble shoot and support data loading issues with tools like ADI.
• Regular cloning and patch application of functional and AD, AU, FND patches for steady maintenance.
• Database refreshes on request from business.
• Performed backups in case of backup failures and database recovery in case of database failures.
• Assisted the development team in writing tuned SQL and PL/SQL statements.
• Responsible for troubleshooting of the connectivity problems for end-users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
• Monitoring and checking the Background Dump File (alertSID Logs) and User Dump Files for correcting errors and tuning.
• Creating databases for various business requirements like pre paid billing and configuring them to usable format for query execution.
• Perform day-to-day database administration and ensure integrity, security, and availability of the database.