SUMMARY:

• Around 10 years of experience as Oracle APPS DBA and Oracle DBA with solid experience in administering of Oracle Databases, Tools and Oracle ERP Applications.
• Successfully completed cutover implementation of 38 projects for Oracle Applications and Databases
• Well Exposed to Oracle Consulting Best Practices and Procedures in Administration that includes installation, configuration, upgrade, remote administration, cloning, patching and Performance tuning.
• Worked and supported Oracle Instances in Oracle Cloud and AWS
• Support Oracle Applications and Database systems on HP, AIX, Sun Solaris & Linux Platforms
• R12.2 development/Prod Upgrades from 11.5.10.2 to R12.2 and 12.1.1 to R12.2 and provided Prod/Test/Dev Support for R12.2.
• Upgrading databases 8i,9i to 11g/12c
• Specialist in Performance Tuning for resolving various performance related issues for Database and Applications.
• Expertise in migration of applications from one platform to other platform or same platform
• Specialized in Reducing the Downtime of Patching by following various methods and applying patches using Adpatch, Opatch and ADOP utility
• Profound knowledge in maintaining RAC databases and Troubleshooting RAC Environment Related issues for high availability of systems
• Hands - on experience of multiple Data Guard Implementation and support related activities
• Cloning of the Applications using Rapid Clone and Manual Clone, Database Cloning (Including RAC and non-RAC Databases), Refresh of Database.
• Migration of file system from Non-ASM to ASM and vice - versa
• Configured shared Appl Top, Load Balancing and PCP Setups, DMZ configuration, OATM Conversion.
• Expertise in Implementation and Integration of OID/OAM/Discoverer/Vertex/OTM/Planning Instance with EBS
• Have experience in Weblogic server configuration and administration and upgrade of WebLogic server
• Expertise in Oracle Exadata database machine administration and Cellcli commands.
• Performed clones in Oracle Exadata database machines for Oracle Applications.
• Deployed GRC on standalone WebLogic server and tuned WebLogic memory parameters to generate reports in good time
• Had Experience in troubleshooting issues related to Demantra and making sure SALES DATA and MDM DATA Tables re-organized often for better performance
• Worked on OBIEE and Hyperion Database related activities and Application Support
• Live experience in dealing with Shareplex Environment for replication of data for reporting Purpose
• Expertise in Control M for concurrent programs Maintenance
• Troubleshooting of Apache, Forms and Concurrent manager issues
• Expert in Configuring/Implementing RMAN, Manual Backup/Recovery and Export/Import.
• Training and mentoring junior DBA’s and Co-ordinating with offshore team to handle the projects in non US time zone
• Worked as a Production coordinator in Support Services for maintaining 500+ databases at EMC2

TECHNICAL SKILLS:

Oracle Application: Oracle E Business Suite 11i/R12/R12.2 on different OS platforms

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

Oracle SQL and PL/SQL development: PL/SQL Developer 7.0, SQL* Plus and Toad

Backup Tools: RMAN, User Managed Backups, Impdp/Expdp

High Availability Services: RAC, CRS, ASM, Data Guard

Advanced Configurations: Shared APPL TOP, PCP, Load Balancing, DMZ Setup, Golden Gate, Discoverer, SSL, SSO Integration

Application Monitoring: Oracle Enterprise Manager, OAM, WebLogic Console, Control M

Third Party Tools: Stat, Control M, Ship Console, Kewill

Patch application: Adpatch, Opatch and ADOP utility

Cloud Systems: Oracle Cloud, AWS Cloud

PROFESSIONAL EXPÉRIENCE:

Lead Applications DBA

Confidential

Responsibilities:

• Supporting EBS, ASCP, OBIEE and Hyperion and third-party systems in Oracle Cloud
• Supporting Migration of Oracle Instances from Oracle Cloud to AWS Cloud.
• Worked along with OMCS Team to support instances in Oracle Cloud
• Configured OEM 13c on AWS systems to monitor Oracle Instance on AWS and expert in OEM monitoring and taking necessary action upon any performance related issues and system alerts and Metrics.
• Expert on R12.2 versions of Oracle EBS Applications and database related activities.
• Applied patches on R12.2 environments with ADOP utility and worked on to resolution for various issues encountered
• Worked with Functional and development teams to resolve several application, code, forms and concurrent program issues
• Expertise in Performance tuning for resolving various performance issues reported for applications and databases and improved query response time
• Troubleshooting issues by enabling different kind of traces and root cause the issue
• Specialization in understanding AWR/ASH/ADDM Reports, trace files and accordingly tuning the SQL as required
• Performed the capacity planning required to create and maintain the databases and worked closely with system administration staff.
• Configured data guard setup for production database in different datacenter for maximum availability and provided support to have prod and standby in sync all the time
• Worked extensively on OBIEE Administration and tuning several OBIEE reports and related issues
• Successfully completed SSL Configuration for OBIEE for more secure communication between the client and application server
• Worked on Hyperion Instance for all database activities including bouncing and troubleshooting on Performance issues
• WebLogic administration, WebLogic Server Upgrade and troubleshooting using WebLogic console and WebLogic Enterprise Manager
• Worked on Installing PEA, CCG and AACG component of Oracle GRC
• Configured Data sources in GRC Applications and ran synchronization with Oracle EBS Applications
• Deployed GRC application on standalone WebLogic server and tuned WebLogic memory parameters to generate reports in good time
• Configured Workflow Mailer Imap account with office365 and did successful testing from front end and backend
• Expert in Configuring/ Implementing/ Maintaining backups using RMAN, Manual Backup/Recovery and Export/ Import.
• Did re-orgs of tables for better performance while accessing the tables
• Excellent in working with P1/P2 tickets by meeting the response/resolution time
• Troubleshooting on Concurrent Manager and Output Post Processor, Apache, Jserv processes Issues
• On Call Support with Pager Duty Application

Lead Applications DBA

Confidential

Responsibilities:

• Work with the senior leadership to help prioritize, plan and coordinate both short and long term systems strategy and implementation
• Worked on R12.1.3 and R12.2 versions of Oracle EBS Applications and database related activities.
• Successfully completed Application upgrades from 11.5.10.2 & 12.1.3 to 12.2 and upgraded associated databases to 12c
• Applied patches on R12.2 environments with ADOP utility and worked on to resolution for various issues encountered
• Worked with Functional and development teams to resolve several application, code, forms and concurrent program issues
• Expertise in Performance tuning for resolving various performance issues reported for applications and databases and improved query response time
• Troubleshooting issues by enabling different kind of traces and root cause the issue
• Specialization in understanding AWR/ASH/ADDM Reports, trace files and accordingly tuning the SQL as required
• Performed the capacity planning required to create and maintain the databases and worked closely with system administration staff.
• Expertise in Maintaining Standby Database for Primary in DR setup and making sure we don’t have archive sync issues
• Worked extensively on OBIEE Administration and tuning several OBIEE reports and related issues
• WebLogic Server administration and troubleshooting using WebLogic console and WebLogic Enterprise Manager
• Applied various Application/DB patches using adpatch, OPatch
• Migrated file system from Non ASM to ASM file system and vice-versa.
• Conversion from RAC to Non-RAC database and vice-versa .
• Scheduled, administered and monitored jobs in Control M.
• Configured Web Load balancing, DMZ and Rman Backups.
• Successfully migrated applications and database from one platform to different platform
• Administering and Supporting the Planning instances
• Excellent in working with P1/P2 tickets by meeting the response/resolution time
• Installed OEM 13c and Expert in OEM monitoring and taking necessary action upon any performance related issues
• Troubleshooting on Concurrent Manager and Output Post Processor, Apache, Jserv processes Issues
• Taking Knowledge Transfer sessions within Team
• On Call Support

Lead Applications DBA

Confidential

Responsibilities:

• Worked on EBS, Planning and OTM instances to support various applications
• Performed database and application upgrades and migration of database from one OS to another OS
• Use procedural & query languages to initiate or enhance program execution, evaluate, recommend and implement software solutions
• Estimate, schedule and monitor upgrade tasks. Analyze, design, develop software, code review, troubleshoot, test case design, quality assurance, database design & modelling
• Applied patches on R12.2 environments with ADOP utility and worked on to resolution for various issues encountered
• Specialized in performance tuning by taking various approaches to get optimum performance
• Expertise on Oracle Exadata database machine administration and cellcli commands
• Expertise in Golden Gate administration for replication of data between different databases
• Used Rman for backup, Restore and Recovery Operations
• Configured Workflow Mailer imap account with office365 and did successful testing from front end and backend
• Licensing new products and new languages using License manager and adding Off Cycle products using adsplice
• Worked on integration of Discoverer with EBS
• Configured SSL configuration for end point URL
• Configuring DMZ to provide application access through internet without compromising on security aspects
• Managed RAC and ASM instances to provide high availability with good performance.
• Migrated file system from Non ASM to ASM file system and vice-versa.
• Conversion from Non-RAC to RAC database and vice-versa .
• Did re-orgs of tables for better performance while accessing the tables
• Installed OEM agent and configured prod/test databases in OEM
• Configured PCP to load balance the concurrent request flow for optimum performance.
• Schedule purge programs to cleanup workflow and cm data & crontab to cleanup OS level files.
• Worked with Issue Track system for working with tickets by meeting the response/resolution time
• OEM monitoring and taking necessary action upon any performance related issues
• Troubleshooting on Concurrent Manager and Output Post Processor, Apache, Jserv processes Issues
• Doing Proactive maintenance by providing Monthly health check of Environments

Senior Consultant

Confidential

Responsibilities:

• Cloning of the Oracle Applications using Rapid Clone for 12.1.1, 11.5.10.2 and 11g database
• Worked on archive gap related issues and ensured production and standby database are in sync
• Applied various Application/DB patches using adpatch, OPatch
• Hands-on experience in dealing with Shareplex replication Environment for replication of data for reporting activities
• Migrated Oracle Applications and databases from one platform to other.
• Configured Grid infrastructure and administered using srvctl and crsctl commands for registering services and resources
• Worked explicitly on Propel/Sap Environments
• Worked on databases with ASM, RAC and DR setups for high availability
• Configured multiple database backups in separate database using RMAN catalog
• Completed Schema refreshes as per requirement from dev and functional teams
• Well experienced in resolving issues related to configurator by tracing the sessions
• Have hands on experience on Control M tool.
• Worked with unity incident management system for working with tickets by meeting the response/resolution time
• OEM monitoring and taking necessary action upon any performance related issues
• Troubleshooting on Concurrent Manager and Output Post Processor, Apache, Jserv processes Issues
• Tuned several SQL’s to improve response time with the help of ASH, AWR, Explain Plan and trace files
• Doing Proactive maintenance by providing Monthly health check of Environments

Staff Consultant

Confidential

Responsibilities:

• Successfully completed Application upgrades from 11.5.10.2 & 12.1.1 to 12.2, 11.5.X to 11.5.10.2, 11i to R12 and 12.0.X to 12.1.1 &12.1.1 to 12.1.2
• Successfully completed Oracle DB upgrades from 8.1.7 to 9iR2, 9i to 10203/4, 10.2.X to 10.2.0.4 and 9i/10g to 11.1.0.7/11.2.0
• Cloned the Oracle Applications and DB using Rapid clone utility (11i and R12).
• DataGuard Implementation performed and provided post-implementation support.
• Migration of live oracle applications and databases to other platforms using Oracle technologies
• Migration of file system from Non ASM to ASM and vice - versa completed successfully
• Apply various patches to E-Business Suite and Database like CPU Patches, patch sets, DST patches etc
• Experience in running Autoconfig to change configuration in Applications.
• Add additional nodes using Rapid Clone Utility and Configure the Shared Apps/Application Tier.
• Load Balancing & PCP configurations.
• Experienced in using expdp and impdb while migrating DB across the platforms
• Maintaining the Oracle Applications using various ad-utilities like Adpatch, Adadmin, Adctrl, Adautoconfig, Rapid Clone, Adrelink, License Manager and Adsplicer etc.
• Monitoring Concurrent Managers and Concurrent requests and troubleshooting the issues encountered.
• Expertise in maintaining high configuration RAC databases.
• Configured Web Load Balancing, DMZ and PCP set up
• Configured Workflow Notification Mailer and Monitor WF components through OAM.
• Working with Cemli Team and migrate the customizations to upgraded instances.
• Licensing new products and new languages using License manager and adding Off Cycle products using adsplice.
• 10g Discoverer Installation and Upgrade completed
• Weblogic administration and troubleshooting using weblogic console and Weblogic Enterprise Manager
• Interact with Functional and Technical teams to understand their technical queries/issues related to Database & Applications and provide assistance in resolving them.
• Database backup, restore and recovery done as per issues encountered.
• OATM Conversion, Tablespace management and space management.
• Regular Health Checks of Oracle Applications Services and Database (Like Forms, Concurrent etc)
• Performance tuning for applications and databases using various methods.
• Tuning the database using database utilities like ADDMRPT, SQLTRPT, ASHRPT & AWRRPT
• Working with Oracle Support to resolve issues related to Upgrade, Post Upgrade support. administration using OEM to improve the health of database