SUMMARY

• Over 18+ years of experience in managing and leading as an Oracle Application DBA, core DBA and Oracle Cloud & Amazon AWS Architect on various platforms.
• 16+ years of experience as Apps DBA on12.2.7, 12.2.4, 12.2.3, 12.1.3, 11.5.10,11.5.9,11.5.8, 11.5.5 on Sun Solaris, HP - UX, AIX, Linux Servers.
• 5+ years of experience in r12.2 on configuring and applying online patches.
• 2+ years of Oracle Cloud experience in migration and maintenance of EBS
• 2+ years of EBS maintenance on AWS cloud
• Extensive experience in installing and configuring OEM 11g and 12c
• Configured OEM alters to monitor servers, databases, listeners and applications.
• Configured OEM to monitor Supercluster & Exadata machines and ASM & Oracle cluster nodes.
• Experience in managing applications Oracle Financials, Oracle HRMS, Oracle CRM, Oracle OLM
• Experience in managing Oracle Application’s Databases and core Databases on 8.x, 9i, 10g, 11g, 12C both RAC and non RAC
• Experience in installing and managing Oracle Applications and Databases on Exadata X3/2 and Supercluster on T5/8 and T7/8 Full and Half RAC
• Experience in Migration of Oracle Applications and Databases from Legacy to Exadata/ Supercluster.
• Completed 3 Upgrade Projects of Oracle Applications from 11.5.10.2 to 12.2.3 and 12.2.4 & Upgrade of Oracle Applications from 11.5.9 to 11.5.10.2
• Numerous Database Upgrades from 11g to 12c, 10g to 11g and 9i to 10g
• Experience in Configuring and Managing DR solutions Oracle Data Guard and SRDF
• Experience in Managing and Leading the dba team of both Apps and Core dbas.
• Experience in handling Oracle Applications and core Database of sizes over 20TB.
• Experience in maintaining the Exadata/Supercluster databases for DW/OLTP
• Experience in Oracle Application Cloning and Configuring using Rapid clone, Adconfig and Adadmin.
• Expertise in Application Patching using Adop and Adpatch
• Experience in migrating large databases from non-ASM to ASM
• Experience in maintaining Oracle RAC & Clustering technologies on Multi-Node with Parallel Concurrent Processing PCP and Load Balancing of Oracle Applications.
• Experience in managing Oracle SSO(OAM and OID) for EBS12.2
• Troubleshooting Concurrent Managers, Forms and Reports issues
• Experience in performing Rman Backup Recovery using Veritas NetBackup, TSM and AVMAR
• Experience in the development specific Solutions, including Technical Design of Servers and determining Server Sizing Requirements.
• Expertise in Upgrades, Maintenance, Performance of Client Tuning, Refresh, and Troubleshooting of Oracle core databases.
• Experience in install, configure and managing 11g and 12c Grid control (OEM)

TECHNICAL SKILLS

Database/Application: Oracle ebs 12.2.4/12.1.3/11.5.10/11.5.9/11.5.8/11.5.5 and databases 12c/11g/10g/9i/8i

Languages: UNIX Shell Script, SQL*Plus, PL/SQL, C, C++.

GUI: Forms 6.0/5.0/4.5, Reports 3.0/2.5, SAPR/3

Hardware: Exadata X3/2, M5000, M3000, IBM RS6000 G30, Sun Ultra Enterprise 450, Sun Sparc20, Sun Solaris, SCO, HP9000, HP10000, Pentium PCsTools/Utilities: AD Utilities, OEM12c, DB Control, RMAN, AWR, ASH, Stats pack, Tkprof, DBCA, Cold/ Hot backup, Data Pump

Operating Systems: Windows NT/XP/2000/98/95, MS-DOS, AIX, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant/Sr.Architect

Responsibilities:

• Maintain EBS12.2 instances and OAM & OID and SITEMINDER SSO applications.
• Support EBS customizations and other changes related to applications.
• Resolve Database and Application performance issues including WebLogic issues.
• Database restoration and recovery using RMAN for database refresh.
• Oracle 11gR2 RAC Database installation, Maintenance and support.
• Resolve issues related to user synchronization in EBS, OAM & OID and SITEMINDER SSO
• Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node. RAC to Non RAC and RAC to RAC using Rapid Clone.
• Applied patches using Adop on application r 12.2 servers.
• Manage Oracle GRC, Prism and Sunflower applications.
• Manage Oracle Dataguard Physical Standby.
• Performing Database/Schema level Refreshes using expdp/impdp and RMAN.
• Maintenance of sql server 2016 and 2017 on Dev, QA, UAT and Production environments.
• Implemented MS Sql Server Disaster Recovery Planning, Testing and Analyzing , continuous update of documentation .
• Manage Sql Server Logins, Users, Roles and User permissions, and conducted backup and recovery.

DBA Manager/Sr. EBS Dba Architect

Confidenial

Responsibilities:

• Migration of EBS applications 12.2.3 and Database 11.2.0.4 from legacy to Supercluster on T5/8 and T7/8 Full and Half RAC
• Install and configured databases on Exadata X3/2 for data warehouse applications
• Upgrade of 2 EBS applications projects from 11.5.10.2 to 12.2.4 & 12.2.3
• Upgrade of EBS application from 12.2.3 to 12.2.7
• Migration of EBS from ON PREMISE to Oracle Cloud using Lift and Shift
• Configured the EBS database and application on IASS and PASS of Oracle cloud
• Maintained oracle EBS on AWS cloud
• Configure and maintain Oracle DR for Core, Oracle EBS financial application.
• Installation and configuration of latest Oracle E-Business 12.2.4 application on Solaris.
• Installation and Administration of Core and Siebel databases.
• Install and configured Oracle OEM 11g/12C on test and prod.
• Configured OEM alters to monitor servers, databases, listeners and applications.
• Configured OEM to monitor Supercluster & Exadata machines and ASM & Oracle cluster nodes.
• Applied patches with adop in testing/development/production environment having multiple applications.
• Manage Rman backups for multiple databases with NetBackup and TSM agents.
• Upgrade databases of different versions
• Clone E-Business application and databases
• Refresh Downstream Oracle Core databases with Expdp Utilities
• Monitoring database and applications
• Performance tuning application and databases and bug fixing.
• Managing E-Business application and databases
• Upgrade E-Business applications
• Managing Internal, CRM and Standard Concurrent managers, Concurrent requests/Concurrent programs.
• Conduct Yearly DR test (Oracle Data guard and SRDF) for all production databases
• Yearly Requirements and Capacity planning for SAN and Refresh of Servers
• Manage and Guide the dbas on different tasks on E-Business, Siebel, Core and Data warehouse databases.
• Configured SSO with OAM and OID
• Recruitment and Appraisal of dbas
• Manage 24*7 production maintenance

Environment: Databases: 9i, 10g/11g/12c Oracle applications: 11.5.9/11.5.10.2 /12.1.3/12.2.3.12.2.4 OS: Linux, Solaris, Exadata X3/2, Supercluster T5/8

Confidential

DBA Consultant

Responsibilities:

• Establishing and administrating multiple environments for test and staging/QA instances and production.
• Error handling from databases to applications and rectification. Registering custom forms and reports for Oracle Apps.
• Planning and administration of backups and recovery strategies.
• Applying software patches, Patch Management. Using AD Administration and other AD Utilities.
• Database and Application cloning.
• Monitoring and handling Concurrent Managers related issues. Monitoring DB processes activities at OS level using top, glance etc.
• Creation of menus, request groups and responsibilities.
• Registration of new Oracle Apps users and system printers.
• Compilation of custom forms and libraries on UNIX, LINUX environments
• Support functional and development teams for customization or development requirements.
• Single-node Install & Multi-node Install