SUMMARY:

• Over 14+ years of experience as an Oracle Application R12/11i Database Administrator wif 11g RAC&12c on Exadata.
• As an ORACLE APPS DBA had handled cloud production database along wif development and testing instances.
• TEMPHas installed and configured OEM13c and TEMPhas been involved in teh provisioning of Database, Middleware and EBS Application using OEM.
• Expertise in implementation, upgrade, applying patches, cloning, and troubleshooting of Oracle apps 11i/R12 wif cloud, SOA, OTM, TDE, OCI, OMC and WebLogic concept.
• Good exposure on Fusion Middleware Products WebLogic SSO/OUD Oracle Unified Directory, Oracle database vault, SSL configuration and Web Gate.

TECHNICAL SKILLS

• Database Administrator ERP: Oracle E - Business Suite R12.2, R12.1.1,12.1.2,R12.1.3,11i
• DB Tools: Recovery manager (RAM), Oracle RAC, ASM, Toa, SQL Developer, Dataguard, Exp/Imp and Data pump
• Operating System: Red Hat Linux 7, Sun Solaris SPARC 10.5, HP-UX PA-RISC 11.31 and Windows 2000.
• Oracle-Application DBA
• Oracle Cloud (OCI) Migration
• ODA (Oracle Data Appliance)
• OUD/OID/OAM
• OMC (Oracle Management Cloud)
• OTM (Oracle Transportation Management) Infrastructure
• WebLogic Administrator
• TDE (Transparent Data Encryption)
• Performance tuning of Application and Database
• Terraform for cloud
• Oracle-Database Admin
• Oracle-Enterprise Manager
• Integration of OID/OAM wif EBS using web gate.
• Oracle RAC
• PCP configuration in R12.2
• Application and database Upgrades
• Database Vault
• Migration of on premises database and application to cloud
• Configuration of Standby Database on Cloud
• Oracle-Data Guard-Database
• Oracle-Security
• Security Patch Management
• SSL Configuration
• Oracle Enterprise Manager (OEM)

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Senior Oracle Apps DBA

Responsibilities:

• Fulfill DBA including user management (creating users, synonym, privileges, roles, quotas, table, index etc.) space management (tablespace. rollback segment), monitoring (alter log, memory, disk me/O, CPU)
• As a DBA lead, worked wif Oracle Utility products implementation project.
• Responsible for teh complete architecture setup for CG client.
• Upgrade, grid teh database from 12c to 19c.
• Involved in Data center migration.
• Integration of OID OAM wif EBS suite.
• Involved in bulk password reset using ld. modify in OID.
• Bulk user migration in OID.
• Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
• Involve in Database and Application performance issues including WebLogic issues.
• Configuring DB alerts using Crontab.
• Responsible for database restoration and recovery using RMAN.
• Configuring RMAN backups.
• Installation and configuration of OEM13c.
• Provisioning of Database, Middleware and EBS Application using OEM.
• Motoring Database and Database Administration using OEM.
• Analysis of top SQL using OEM.
• Installed Oracle 11gR2 RAC
• Hands on experience wif 12.2environments.
• Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node.
• Involved in using RAC to Non RAC and RAC to RAC using Rapid Clone.
• Expertise in Oracle Apps 12.2 patching using ADOP.
• Working in an Oracle AppsR12.2 Implementation project wif Exadata and ExaLogic architecture.
• Installed and configured ASM, migrated Non-ASM Databases to ASM and implemented Oracle RAC.
• Installed and configured Oracle Data Guard Physical Standby.
• Perform Database/Schema level Refreshes using expdp/impdp and RMAN and automated teh process of Daily Schema Level Refresh from Production DB to Replica DB.
• Completed Oracle Exadata Database Machine 2014 On-Demand Implementation Boot Camp.
• Completed Oracle Exadata 2014 Certified Implementation Specialist Practice Assessment. Plus, Export, Import and SQL.
• Administer all database object, including tables, clusters, indexes, views, sequence, packages, and procedures.
• Implementation of Oracle Backup and Recovery strategies using Cold Backup, Hot Backup and RMAN.
• Good understanding of Exadata features like smart scan, HCC, flash cache.
• Monitor File system thresholds for all Exadata server, non-Exadata server, cluster database.
• Manage Exadata database for non-prod/prod environment.
• Maintaining RAC database.
• Relocation Services belonging to RAC database.
• Storage and database migration from teh file system to ASM.
• Managed WebLogic Server.
• Installation and configuration of WebLogic.
• Performance tuning on WebLogic manage server.
• WebLogic deployment like war file.
• Work closely wif developers providing Oracle DBA support and technical support for multiple applications in development, test, and production environment
• Involve in database schema refresh activities from production to stage.
• Experience in tuning: Used Explain Plan, AWR and TKPROF for SQL/PLSQL Tuning, Performance tuning me.e. Tuning SGA, me/O distribution using STATSPCK.
• Troubleshooting (local, network connection etc.) and document database problem as they raise.
• Strong analytical, technical, research, technical writer, general business, and functional skills are blended wif excellent communication skills wif around 12 years of working experience
• Configuration and creation of databases and upgrades.
• Creating physical backup script using RMAN.
• Creating and implementation of RMAN, wif or wifout Recovery Catalog.
• Upgrade EBS application and database.
• Creating and maintaining standby database.

Confidential

Lead Oracle Apps DBA

Responsibilities:

• Worked wif Oracle Utility products implementation project as a DBA lead. Responsible for teh complete Architecture setup for CG client.
• Integration of OID OAM wif EBS suite.
• Database restoration and recovery using RMAN.
• Configuring RMAN backups.
• Oracle 11gR2 RAC installation.
• Installation and configuration of SOA 12c
• Performance tuning in SOA suite
• Hands on working experience on 12.2environments.
• 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.
• Expertise in Oracle Apps 12.2 Patching using ADOP.
• Working in an Oracle AppsR12.2 Implementation project wif Exadata and ExaLogic architecture.
• Installed and Configured ASM, Migrated Non-ASM Databases to ASM. Implemented Oracle RAC.
• Completed Oracle Exadata 2014 Certified Implementation Specialist Practice Assessment. Plus, Export, Import and SQL
• Loader as well as traditional UNIX command dat requires for Oracle/Exadata DBA
• Managing Exadata database for non-prod/prod environment.
• Relocation Services belonging to RAC database
• Managed WebLogic Server
• End to End configuration of Exadata
• Creation of VM on ExaLogic and File system, user creation on OS level.
• Upgrade FMW from 11.1.1.6 to 11.1.1.9
• Apply Delta 10 and Txk 10 on database and involved in RAC configuration.
• Export and export of database 3.7 TB database
• Apply patches to reduce teh import and export timing
• PCP configuration and upgrade database from 11.2.0.3 to 12.1.0.2
• Creation of standby database on cloud
• Migration of critical HR instance from Solaris to Exadata.
• Monitoring File system thresholds for all Exadata server, non-Exadata server, cluster database
• Managing Exadata database for non-prod/prod environment.
• Maintaining RAC database.
• Storage and database migration from teh file system to ASM
• Managed WebLogic Server
• Work closely wif teh developer provides Oracle DBA support and technical support for multiple applications in development, test, and production environment
• Involves in database schema refresh activities from production to stage
• Experienced in tuning: Used Explain Plan, AWR and TKPROF for SQL/PLSQL Tuning Performance tuning me.e.
• Tuning SGA, me/O distribution using STATSPCK
• Troubleshooting (local, network connection etc.) and document database problem as they raise
• Strong analytical, technical, Research, technical writer, general business, and functional skills are blended wif excellent communication skills wif around 12 years of working experience
• Configuration and creation of teh database and upgrades
• Creating a Physical backup script using RMAN

Confidential

ORACLE APPS DBA

Responsibilities:

• Responsible for complete configuration of ODA.
• Configured RAC Database on ODA.
• Created of VM on ODA box and configuration of network
• Migration of database and application. Maintained RAC database.
• Involved in Storage and database migration from teh file system to ASM and managed WebLogic Server.
• Worked closely wif developers providing Oracle DBA support and technical support for multiple applications in development, test, and production environment
• Involve in database schema refresh activities from production to stage.
• Fulfill DBA daily activities, including user management (creating users, synonym, roles, quotas, table, index, sequence etc.
• Maintaining teh oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to teh instance to resolve few application issues.
• Maintaining teh Oracle Application using Auto Patch, Ad Admin, Ad controller, Auto configure, Rapid Clone, Ad Relink, License Manager and Ad Splicer etc. Application utilities
• Cloning teh instance from production to Test, Development instance to test & simulate few technical challenges, coordinate wif testing and development teams. Participate in a team to maintain & support for multiple oracle database and application in high availability (24*7) heterogeneous environment.
• Generating Stats pack report and running taproot to analyze performance related issues.
• Performed System administration activities like creating users and assigning responsibilities.
• Implementation of EBS 12.1.3
• Loader as well as traditional UNIX command dat requires for Oracle/Exadata DBA
• Administer all database object, Including tables, clusters, indexes, views, sequence, packages, and procedures.
• Implementation of Oracle Backup and Recovery strategies using COLD BACKUP, HOT BACKUP and RMAN
• Monitoring File system thresholds for all Exadata server, non-Exadata server, cluster database
• Configuration and creation of teh database and upgrades
• Creating a physical backup script using RMAN.
• Creating and implementing RMAN, wif and wifout Recovery Catalog.
• Upgrade EBS application and database and created, maintained standby database

Confidential

ORACLE APPS DBA

Responsibilities:

• Provide development and design assistance to development and other application support teams
• Providing support to developers working on SQL, including development of best practices, hands on demos, and knowledge transfer
• Continuously manage performance through trending analysis and work wif development teams on identified tuning opportunities
• Create new database systems and makes recommendations to improve teh performance and efficiency of existing systems
• Provide database performance tuning, database security, and promote process improvement
• Work wif teh system DBAs to implement changes and performance improvements
• Supported and maintained of 11i and R12 Applications wif PCP configured.
• Involved in supporting and maintaining all types of instances which includes 11i/R12 Apps, 9i/10g/11g Databases, Discoverer servers etc.
• Installed and supported of Non-RAC, Single Node RAC and Multi Node RAC environments.
• Provided database performance tuning, database security, and promote process improve regular maintenance works and Configuration tasks Such as Code Promotions, Patching, Performance Tasks etc.
• Involved in weekly based refreshes as requested by Customer. Refreshes includes Multi Node to Single Node, Multi Node to Multi Node, Single Node to Single Node, Single Node to Multi Node, RAC to Non-RAC, Non-RAC to RAC
• Involved in Database related activities like Refreshes, Patching, DB Performance issues.
• Involved in CPU Patching, DST Patching and Mass patching.
• Involved in Discoverer installation and Configuration.
• TEMPEffectively involved in managing Post refresh documentation as per Customer requirements.
• Involved wif teh Support/Development Teams for getting any workarounds on issues.
• Managed in creating teh SR's and Efficiently involved in transferring teh SR's across other teams and getting teh work done.
• Managed OWC sessions across Customers and Other team members.