SUMMARY

• Around 10 years of experience as Oracle APPS DBA and Oracle DBA with good experience in administration of Oracle Databases, Tools and Oracle ERP Applications.
• Well Exposed to Oracle Consulting Best Practices and Procedures in Administration that includes installation, configuration, upgrade, cloning, patching and Performance tuning.
• Experience in EBS 11i, R12.1 and R12.2 application administration.
• Experience in 11g,12c and 19c Database administration (RAC, ASM and Non - RAC)
• Experience in EBS upgrade (R 12.1 to R 12.2) and Oracle Database upgrade (11g to 19c).
• Experience in OBIEE & OAS installation, configuration and migration.
• Experience in RMAN, Dataguard, Export/Import, Data Pump (Expdp/Impdp).
• Experience in PCP, SSL, shared APPL TOP
• Experience in patching using adop, adpatch, optach and cloning single node and multi node (dualfs).
• Experience in automation of tasks using shell scripting.
• Troubleshooting long running requests, Blocking sessions, Apache and Forms issues, database link issues.
• Handling different kind of alerts like tablespace alerts, mount point alerts, backup alerts, and memory alerts etc.
• SOA on premise and cloud administration.
• Oracle GTM administration and maintenance tasks.
• Good knowledge in Oracle BI Discoverer (10g/11g) installation and solving connectivity issues and refreshing views in workbook.
• Good knowledge in OEM (12c & 13c)
• Good Knowledge in OCI fundamentals

TECHNICAL SKILLS

Oracle Application: Oracle E Business Suite 11i/R12/R12.2 on Linux & Solaris platforms

Database: Oracle 11g, 12c, 19c

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

High Availability Services: RAC, ASM, Data Guard

Advanced Configurations: Shared APPL TOP, PCP, SSL

Application Monitoring: Oracle Enterprise Manager 12c & 13c, OAM, WebLogic Console

Tools: Known, Putty, Winscp, VNC server, Citrix, SQL developer, Toad etc

Patch application: Adpatch, Opatch and ADOP utility

Cloning: Single node, multi node, RAC to RAC and non-RAC

FMW administration: SOA, Hyperion, OBIEE, OAS, OTM, Agile, Demantra etc

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA Consultant

Environment: Linux, Oracle 12.1.0.2, Oracle Apps R12.2.10, WebLogic 11g, OEM 13c, SOA suite 12c, GTM (6.4.1), AGILE (9.3), Oracle Discoverer 11g, SOA Cloud 12c

Responsibilities:

• 24/7 production environment support.
• Monitoring servers by using Oracle Enterprise Manager, to keep track of what is actually happening within the database.
• Hands on experience in Space management which includes monitoring tablespaces, adding and resizing data files.
• Tracing long running Concurrent Programs, Forms Sessions and User Sessions.
• Cloning Non-Prod servers from PROD (Single node, multi node, RAC to RAC and RAC to non-RAC.)
• Analyzing patches and applying using adop on the test and the Production instances.
• Applied patches on Weblogic Server using BSU utility.
• Applied PSU DB patches, CPU application server patches, fusion middleware patches.
• Upgraded the oracle fusion middleware (webtier) from 11gR1 patchset 6 to 7 (11.1.1.6 to 11.1.1.7)
• Upgraded Oracle 11g database to 19c and EBS 12.1.3 to 12.2.10
• Worked on Data guard, SSL set up, PCP and load balancer set up.
• Migrating the change as per customer/development team requirement.
• Securing Oracle Applications by periodically changing Apps and some other important user passwords.
• Worked on restore and recovery using RMAN and also duplicate database using RMAN.
• Participating in customer calls and ensuring all requirements are documented.
• Monitoring, identifying and resolving user issues and gave support to development teams in general troubleshooting.
• Participated in multiple DBA/Functional/Technical cutovers/releases.
• SOA on-premise and cloud administration and monitoring tasks like datasource creation, composites deployment, assigning roles and privileges to users, purging instances, monitoring deployed composites health.
• Oracle GTM administration and maintenance tasks like user management, bug fixes, schema refresh using expdp/impdp etc.
• Agile administration and maintenance tasks like cloning, patching, executing action plans given by Oracle.
• Oracle BI Discoverer (11g) installation and solving connectivity issues.
• Good knowledge in OEM (13c) Worked on tasks like OEM agent installations, adding targets, setting block outs, creating reports, performing reorganization of objects, setting threshold values for alerts and monitoring servers health.
• Highlighting the scope of automation and automated refresh activities of DataWare house and Agile from respective production servers.
• Automated some tasks using shell scripting like Concurrent programs scheduling, adding responsibilities, cloning backup steps etc.

Confidential

Business & Technology Delivery Team Lead

Environment: Oracle Apps 11.5.10.2, 12.1.3 Oracle 11g database, Linux.

Responsibilities:

• Oracle EBS 11.5.10.2 & R12.1.3 administration and Maintenance
• Patch impact analysis and applying patches using adpatch
• Creating users and assigning responsibilities.
• Code migration and code deployment
• Performed Database and application Cloning from production.
• Monitoring the database alert log for errors.
• Worked on Export/Import activity both table and schema level.
• Worked on workflow related activities and advanced queue issues.
• Worked on alerts like Tablespace alert, Server down, Mount point full, Listener down, dead lock alerts.
• Database and Grid upgrade from 11g to 12c.
• EBS upgrade from 12.1 to 12.2
• Cloning RAC to Non-RAC and RAC to RAC environments.
• OBIEE installation, migration and administration.
• Qlik Sense installation and administration.
• OneStream administration.
• SOA administration.
• Troubleshoot and provide solution for different kind of issues as per service requests created by customers.
• Addressing different queries raised by customers related to CPU, PSU patches.
• Coordinating with Development team and customers to resolve bugs.