SUMMARY

• Around 16+ years of professional experience in the field of Information Technology particularly dealing with Oracle e - Business Suite Applications and Database Administration which includes upgrade, migration, installation, configuration, patching, troubleshooting, tuning, support, maintenance, backup and recovery, system admin activities of Oracle instances across various platforms such as Sun Solaris,AIX, HP-Unix & Red Hat Linux etc.
• Upgraded 100+ databases including ASM/RAC to 19c/20c.
• Applied quarterly security patches to all DC databases and os patches.
• Migrated several databases from AIX to Linux, Solaris to Linux using transport tablespaces, transport databases with less downtime.
• Worked extensively on performance tuning of BC/MC databases
• Installation of Oracle apps R 12.2/12.1/11 i on Multi Node environment.
• Upgraded E-business databases from 11i to R12.
• Extensive use of Oracle Application maintenance utilities AD utilities
• Managing Concurrent manager and concurrent processing from Oracle
• Patching at EBS Application and Oracle Database.
• Cloning of EBS Applications and Database using Rapid Clone, manual clone.
• Cloning and refreshing the database & APPL TOP whenever require
• Expert in Database backup and recovery.
• Moved all Data Centre database Rman backups to Actifio, EMC Data Domain.
• Worked on various versions of Oracle (8i,9i,10g,11g,12c) on UNIX and Windows
• Creating Database required for Production, Development and Test usage.
• Alert handling at Database and Operating system level
• Refresh/Clone of databases from Hot and cold backup.
• Implement Backup and Recovery strategy in various environments.
• Creation of Specialized Concurrent Managers, assigning work shifts.
• Setup Oracle Data Guard DR in Oracle Cloud and google cloud. .
• Setup OAM,OID and integrate with E-business suite databases.
• Worked on middle ware products like Weblogic,Jboss and BOBJ platforms
• Installed and upgraded Sabrix Tax ware.

TECHNICAL SKILLS

Operating System: UNIX (Sun Solaris, Linux, HP-UX, Windows)

Languages: SQL, C

RDBMS: ORACLE (8.1.7.4, 9.2.0.4, 9.2.0.6, 10g,11g,19c,20c,21c)

Tools: RMAN, SQL * Plus, SQL * Loader, Toad, OEM.

Packages: VB 6.0, Developer 6i.

PROFESSIONAL EXPERIENCE

Confidential

Staff engineer EBS DBA (lead)

Responsibilities:

• Experienced in support and maintenance of Oracle Applications R12 Prod instance on AIX, Solaris platform and Linux platforms in Data center.
• Installed R12.2/R1.1/11i on multiple nodes with shared apps tier, PCP setup on various platforms with ASM/RAC and Exadata.
• Setup EBS DR on Oracle cloud with Exadata 19c.
• Expertise in tuning E-business databases and oracle databases. Advise Developers in tuning long sql running queries and complex MViews.
• Upgraded E-biz suites databases from 11i to R12 on ASM/RAC.
• Upgraded SSO and OID 10g to OAM and OID 11g.
• Performed platform migration of E-biz suites databases from AIX to Linux using Transport tablespace to reduce downtime.
• Created documentation and provided guidance to fellow team members.
• Applied quarterly security patches RU/PSU/SPU/CPU releases from Oracle.
• Setup DR using Oracle Data Guard, Vmotion and Vplex in Data center.
• Applied patches with new R12.2 adop and ad patch.
• Installed and maintained jboss and weblogic servers.
• Troubleshoot Applications and database issues.
• Sysadmin activities like Creating Users, Assigning Responsibilities, Changing Profile Options, Request Groups, Registering Forms, reports etc.
• Migrate concurrent programs and register into PROD Applications.
• Migrate Alert definitions across Devp,Test and Prod.
• Management of Concurrent Processing, monitoring concurrent manager activities, defining work shifts and additional managers.
• Monitor locks, tablespaces, backups, long running queries via 11g Grid Control.
• Schedule concurrent requests such as Gather Schema Stats, Purge Concurrent Request and/or Manager Data, Purge SignOn Audit Data etc.
• Transfer form from a development instance & compile in production.
• Transfer reports files from a development instance.
• Patch Analysis and Application of patches.
• Cloning Oracle Applications using Rapid clone.
• Troubleshoot workflow notification mailer issues.
• Configure Workflow outbound (SMTP) and Inbound (IMAP) services.
• Maintenance of Oracle Applications using AD utilities.
• Refresh Schemas using datapump utilities on various databases .
• Performance tuning done by analyzing AWR,ADDM,ASH reports, TKPROF and SQL tuning advisor etc.
• Performed Data fixes and support BUI activities.
• Log TARwith Oracle Support for any Oracle bug related issues and apply the Oracle recommended fixes and patches on timely manner.
• Worked on SAP Digital transformation project. Build SAP Hana/S4 Hana databases.
• Worked on middle ware products like Weblogic,Jboss and BOBJ platforms
• Installed and upgraded Sabrix Tax ware.

Confidential

Applications DBA / Oracle DBA

Responsibilities:

• Refresh/Clone Oracle 9i/10g databases
• Setup Oracle Data Guard DR on HP Unix, Solaris platforms
• Cloned 11i EBS database using rman hot backup
• Applied product patches to 11i E-business suite databases using adpatch. Performed Data Fixes
• Create Specialized Concurrent Managers for particular Conc programs
• Creating Users and assigning responsibilities.
• Releasing Locks from the tables.
• Pinning Objects in the Memory, Analyzing Tables and checking index Height.
• Taking Backup on Tapes.
• Checking the Health of the Database
• System Admin activities like Creating Users, Assigning Responsibilities, changing Profile Options, Request Groups, Registering Forms, reports etc.
• Tuned E-business databases and concurrent managers.
• Migrate Alert definitions across Devp,Test and Prod.

Confidential

Applications DBA Consultant

Responsibilities:

• Installation of Oracle apps 11i on Multinode environment
• Extensive use of Oracle Application maintenance utilities like AD utilities
• Managing concurrent manager and concurrent processing from Oracle Applications
• Cloning of Applications and Database using Rapid Clone
• Cloning and refreshing the database & APPL TOP whenever required
• Handling database and application performance issues
• Periodically refreshing TEST instance from PROD
• Releasing Locks from the table.
• Responsible for general Database Administration activities including schema changes, table space management, user security management, memory/disk space management and import/export utility
• Applying Application patches like mini packs, family pack with Ad patch utilities
• Creation of Specialized Concurrent Managers, assigning work shifts
• Applying database patches using Opatch

Confidential

Oracle DBA

Responsibilities:

• Installation and maintenance of Oralce9i on Red hat Linux AS 4
• Managing table space and space related issues
• Implement Backup and Recovery in various environments using Rman
• Taking online and offline backups
• Regular Refresh/Clone of Stage and Dev instances from Production using both hot and cold backup.
• Creating Database Links, Snapshots and refresh.
• Releasing Locks.
• Creating and configuring Oracle 10g and Oracle9i databases using command line and DBCA.
• Upgrading and patching Oracle Homes.
• Implement and maintain database security (create and maintain users and assign roles)
• Database Migration.
• Importing data from other data sources into oracle using Sql Loader.
• Moving Data between Database using Export/Import utilities
• Upgrade patchset level from 9.2.0.4 to 9.2.0.6 of RDBMS HOME
• Upgrade database from 9.2.0.6 to 10g.
• Export/Import schemas, tables and transport tablespace.