SUMMARY

• Having 12+ years in experience Oracle Applications 11i, R12.1 and R12.2, Database administrations in 11g RAC and core environment. Provides database support on RAC and standalone databases of 10g, 11g, 12c environments.
• Involved in ORACLE Database Installing, Administering & Configuring on RHEL, OEL, Solaris, AIX and HP - UX.
• Implementing and providing service, support and maintaining Oracle Application 11i, R12, 12.2 & 9i, 10g 11g and 12c Databases.
• Database & Application disaster recovery (DR/standby) setup, maintenance and DR testing.
• Migrated successfully Oracle EBS application from on premises to Amazon Web Services (AWS) Cloud and Oracle Cloud (OCI).
• Administration of Oracle 11g Oracle clusterware (OWC), Grid Infrastructure and 11g RAC databases.
• Very good knowledge on 12c Flex RAC new features.
• Administration of Oracle X5 Exadata machines.
• R12.2.5 upgrade and support. Online patching using ADOP.
• Data centre migration: worked on three customers data centre migration projects to modern data centre.
• Experienced in leading a team and holding calls with clients interactively and therefore ensuring timely deliveries of services and support to the database and application instances.
• Providing support and maintaining Oracle Databases from 9i, 10g and 11g, 12c running on Oracle EBS 11i/ R12.
• Worked with other applications along with EBS such as OTM, SOA, GRCC, OBIEE, Discoverer, Agile, Hyperion.
• Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and security.
• Experience in Troubleshooting and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.
• Provides on-call support for production environment.
• Performs root cause analysis for system outages and different critical user raised issues.
• Creates problem records of repetitive issues for analysis, identifying solution and implementing fix.
• Effectively communicates to internal and external stakeholders.
• Ability to lead teams and take decisions and a good team player.
• Strong troubleshooting skills and performance tuning skills.
• Effective communication and interpersonal skills.
• Highly motivated to resolve problems efficiently. Hardworking and dedicated personality.
• Worked as an onshore lead located at Atlanta, GA. Gets the details of activity/issue from customers. Analyse & provides task details to offshore team for the execution of the work. Handles task/activities assignment and allocations to the offshore team members. We work on a 24/7 environments.
• Following up on task status about its progress for the delivery and works on it to the accomplishment.
• Creating and ensuring the documents is in place for all our regular activities.
• Maintaining document repository for all issue and fixes of our support activities.
• Involves with task planning, co-ordination, resource allocation, task execution, periodic status update and documentation.
• Playing active role in coordinating internal team meeting with onshore and offshore teams.
• Building templates on delivery activities for process adherence and improvements.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Database upgrades 9.2.0.4 to 10.2.0.4. Support of database administration.
• Oracle Application upgrade for USG from R12 (11.5.10) to latest R12 (12.0.6)
• Applying application patches in Oracle Application such as minimum base line, CPU/security, bug fix
• Pre-Patch analysis, applying patching in test/development instance
• Troubleshoot problems with respect to patch issues, failure, invalid objects etc.
• Extensive experience in Cloning of different Oracle Application instances from prod to non-prod.
• Supporting extensively on R12 environments.
• Building new instances existing instances.
• Performance issue analysis. Recommending and resolving the database performance.
• Creating DR/Stand by databases for the production databases and maintaining these DR databases
• Upgrading Java, JRE, JDK in Oracle application 11i and R12 for the Customer requirement
• Configuring and troubleshooting Workflow notification mailer
• Experience in Autoconfig management
• Administrating and troubleshooting Oracle Application Server i.e. Apache
• Managing Concurrent Managers and concurrent requests, workshift etc.
• User management and assigning responsibilities to the users in Oracle Applications
• Monitoring & Managing various log and output files generated by different adutilities
• Worked on Discoverer, OBIEE, Vertex (pay roll), Agile and Hyperion administration
• Tacking necessary core database activities such as
• Database schema refresh from production to non-prod databases environments
• Monitor and troubleshoot the jobs scheduled by a 3rd party job scheduler Appworx integrated with Oracle 11i/R12
• Worked on 10g RAC using ASM (Automatic Storage Management) on RH Linux AS 4.0
• Maintaining 10g RAC database
• Backup & Recovery in clustering environment using RMAN.
• Taking backup from standby database using RMAN
• Installing and upgrading the Oracle database server
• Plan for future storage requirements for the database system
• Database creation in Unix platforms
• Managing tablespaces, tablespace growth and undo management
• Managing export and import utility, data pump, transportable tablespace & reorganization of database
• Configuring, managing and troubleshooting the 10g/11g Stand by database (DR databases)
• Performing regular DR activation and validating our DR solution.
• Handled database space requirements and adjust for future needs for supported database.

Confidential

Technical support

Responsibilities:

• Providing support to various systems, servers, Windows desktop support.
• Installation of windows, configuration as per the project requirement. Networking support.
• Printer configuration, support and troubleshooting.
• Pre-Patch analysis, applying patching in test mode and finally applying patch.
• Troubleshoot problems with respect to patch.
• User management and assigning responsibilities to the users in Oracle Applications.
• Apps Back-End database administration and TAR Support.
• Monitoring & managing various log and output files generated by different adutilities.