SUMMARY:

• Oracle Application DBA with over 11 years of experience & strong skill set in administrating the Oracle Databases 10g,11g,12c and Oracle Applications (eBusiness Suite, EBS) 11.5.X, R12.X.
• Migrated E - Business Suite Instances to Oracle Cloud with lift and shift through XTTS .
• Implemented and supported Oracle E-Business Suite Instances for US/Canada federal Clients like Washington Suburban Sanitary Commission, City of Laval, City of Miami, Calgary Board of etc.
• Upgrading Applications from 11i to R12 and 12.0.X to 12.1.X & 11. .2.X.
• Upgrading databases 8.1.7 to 9iR2, 9i to 10204, 9i/10g to 11.1.0/11.2.0 and to 12c.
• Ability to manage Database/Application Instances on Exadata Machines.
• Successfully completed cutover implementation of nearly 50 projects for Oracle Applications and Databases instances with database sizes from 500GB to 15TB.
• Profound knowledge in maintaining RAC databases and Troubleshooting RAC Environment Related issues for high availability of systems.
• Planned & Migrated Database in Homogeneous and Heterogeneous scenarios like Solaris/HP-UX/AIX to Linux using RMAN/Database Migration, Export & Import utilities.
• Expertise in Reducing the Downtime of Patching by following various methods.
• Integrating Fusion Middleware products like Discoverer, Vertex, Web Logic Server with EBS.
• Deployed GRC on standalone WebLogic server and tuned WebLogic memory parameters to generate reports in good time.
• Hands-on experience of Data Guard Implementations and support related activities.
• Performing tuning using ADDM/AWR tuning advisor reports, Explain plan, TKPROF and tuning the Initialization Parameters as part of troubleshooting.
• Expert in dealing P1/P2 issues during on-call support.
• Planned and implemented Oracle GoldenGate 12c between Oracle Databases.
• Worked on Various tools like Taxware updates, Apex Configuration, Clear Orbit Service.
• Regular meetings with customers to understand the enhancements and outstanding issues to support business operations.
• Provide documentation for best practices while performing various tasks like upgrades/patching/cloning/performance tuning.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, IBM AIX, Linux.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Databases: Oracle8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC.

ERP: Oracle Applications 11.5.9, 11.5.10.2, R12, R12.2

ERP Modules: BEN, FIN, HR, INV, IRC, ONT, PAY, WSH, MSC, GL, AP, FA others

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools: Putty, VNC Viewer, EXP/IMP, RMAN, DBUA, DBCA, NETCA, OAMAD UTILITIES, SQL *Loader, ADOP, OPATCH

Fusion Apps: Discoverer, WLS, Vertex.

PROJECT EXPERIENCE:

Confidential, Irving, Texas

Senior Applications DBA

Responsibilities:

• Migrating EBS instances of all Brunswick subdivisions to Oracle Cloud(OCI) by following Lift and Shift process with Transportable Tablespaces methodology.
• Maintenance of EBS R1213 On Oracle Cloud.
• Working with various Client/Internal teams such as storage, functional & network administration teams to coordinate and troubleshoot infrastructure/functionality related issues.
• Migrating different client peripherals like the OBIEE/OID/OAM to OCI.
• Migrated Apex to OCI from On-Prem along with upgrade.
• Coordinating the tasks with Offshore team.

Confidential, Irving, Texas

Senior Applications DBA

Responsibilities:

• Managing the Project plan for Upgrading EBS 11i/11g Multi node RAC/ASM to R12.2.
• Implementing Oracle Backup and Recovery strategies using Cold Backup, Hot backup and RMAN with and without Recovery catalog environment.
• Cloning the Instances from PROD to TEST/Development & simulate few technical challenges.
• Maintaining DR site for high availability heterogeneous PROD Instances for backup and use that to clone of Non-Prod Instances.
• Troubleshooting Concurrent Managers and Workflow mailer issues.
• Performing Tuning using ADDM, AWR, ASH, Explain plan tuning advisor reports.

Confidential

Senior Applications DBA

Responsibilities:

• Upgraded various Application Instances DB from 8.1.7 to 10gR2, 9i to 10g/11g, and 10.2.X to 11.X.X & 12c and Applications (eBusiness Suite, EBS) form 11.5.9 to 11.5.10, 11., 11.5.9 to R12.2 as per client specifications.
• Migrated DB to Oracle Cloud environment.
• Migrated Non RAC database to RAC conversion with Cluster ware installation of version 11.2.0.4.
• Worked on Oracle Applications R12.2 Implementation project on Exadata environment.
• Monitored concurrent managers to ensure system is running smooth, observing throughput and watch for long runners.
• Oracle instance refresh activities and reconfiguration after refresh of various versions including 11i, R12 & R12.2.
• Migrated new forms, reports, custom code to production environment from Development.
• Applied patches, Security alerts and CPU (RDBMS related) patches.
• Good knowledge with ADOP on R12.2 and AD utilities.
• Used key tool to request and renew expired SSL s.
• Performed Shared Appltop, Load Balancing, PCP Setup, OATM Conversion and DMZ setup.
• Performed sysadmin tasks as per the requirement.
• Configured EBS with Java Web Start (JWS).
• Performed the capacity planning required to create and maintain the databases and worked closely with system administration staff.
• Expertise in configuring SSL s and configuring applications with Hardware load balancer.
• Worked on regular database activities, monitoring backups and resolving issues.
• Evaluate releases of Oracle and its tools and third-party products to ensure that the site is running the products that are most appropriate. Planning along with the application development and functional teams to ensure that any new product usage or release upgrade takes place with minimal impact.
• Good exposure and expertise in tuning the Applications from Database, Resource intensive SQLs, Memory (SGA), Disk I/O and wait events perspective.
• Performed database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Implemented necessary monitoring scripts for GoldenGate in Unix/Perl scripting
• Managed RAC Services, migrating databases to RAC nodes, performance tuning and ASM administration.
• Worked in configuration and managing of Physical/logical Standby Databases for Disaster Recovery (DR) site.
• Managed tablespaces and other database objects.
• Prepared and developed number of shell scripts (UNIX) to manage/monitor oracle databases and setup of Crontab for required scripts.
• Worked on WebLogic server Administration.

Confidential

DBA

Responsibilities:

• Performed various activities like Patching, cloning, taking backups, managing archives and regular maintenance activities.
• Worked on Data Guard issues.
• Provided production support for Oracle EBS 11i/R12 instances.
• Performed Cloning and post cloning activities on Non-Prod EBS instances.
• Performed patch analysis and applied patches on Non-Prods EBS instances before applying to PRODUCTION Instances.
• Deployed custom implementations to Production environment.
• Configured workflow notification mailer and setup override email address.
• Created SRs in MOS and worked with Oracle support in resolving issues.
• Worked on executing diagnostic tools and providing outputs for EBS users.
• Extensively used AD-Admin utilities for various EBS maintenance tasks.