SUMMARY

• Having 8+ years of experience asan Oracle Application R12, 11i DBA&Oracle DBA 11g providing 24x7 support for both Production & Development on Various Platforms.
• Installation, Configuration & Deployment ofOracle E - Business Suite R12.2.4, R12.1.3, 11.5.10 on Linux.
• Apply regular maintenance and critical patch updates in a timely manner; Proactively research potential issues that may be encountered as a result of infrastructure upgrades and share that information with the affected groups.
• Experience in usingOracle EBS utilities ADOP, ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADCONFIG and ADMRGPCH.
• Cloning single node and multi node instance’s from source to target instance.
• Installation and Configuration of Oracle GoldenGate software with heterogeneous environments.
• Managing cold, hot, logical and RMAN backups.
• Implemented Oracle Apps 11.5.10.2 withOracle RAC and ASM.
• Excellent experience in Installation and configuration ofOracle 12c,11g,10g and 9i rdbms software on UNIX,LINUX and Windows environment.
• Experience in Oracle Apps shared appltop, multi node and single node Cloning using rapid clone and manual cloning.
• Installation and configuration of Oracle EBS R12.2.4 on Amazon AWS servers.
• Configuring Parallel Concurrent Processing and Load Balancing in Oracle EBS R12, R115102.
• Strong in Oracle EBS R12 Suite Architecture with working experience in Multi-node Architecture and Shared APPLTOP.
• Installing and configuration of FusionMiddleware components and integrating with oracle database 11g.
• Configuring MWA services on application tier for SCM module.
• Applying Application patches, FMW patches, developer6i for 806OracleHome, iAS patches, Critical Patch Update, JRE Upgrade and database patches.
• Working with Oracle support: opening, managing, and resolving Oracle SR's.
• Request and coordinate changes to the Application Tier and Database Tier through change management and code migration process.
• Configuring Demilitarized zones (DMZ) for Oracle EBS external servers.
• Experience in Oracle Applications sysadmin tasks.
• Troubleshooting Apache services, listener and concurrent managers.
• Documenting and applying Oracle application patches using adop, adpatch on single node, multi node environments.
• System administration responsibilities including creating application users and assigning roles and responsibilities.
• Writing unix shell scripts to monitor and maintain the Oracle Applications and Database.
• Creating oracle EBS profiles and assigning values to the profiles.
• Autoconfig customization for EBS application.
• JRE upgrade on 115102 EBS.
• Tablespace management and archivelog management for improving the performance of database server.
• Experience in deploying the code using FNDLOAD, SQLLDR.
• Weekend maintenance of all production servers.
• Interact and coordinate work with System Administrators, Project Managers and peers to support various project requests.
• Installation and configuration of WebLogic Server on Linux.
• Installation and configuration of Oracle 11g DataGuard and ASM on unix environment.
• Monitoring alerts including tablespace, dbblocks, high temp tablespace usage and filesystem.
• Refreshing database from production to development instances for development and testing.
• Experience in working with Transparent Data Encryption.
• Supporting service requests for the developers.
• Migration of application and database, upgrading application and database.

TECHNICAL SKILLS

Oracle EBS Applications: R12.2, 11.5.10.2, Fusion Middleware.

Databases: Oracle 12c, 11g and 11g RAC & ASM.

Hardware & Operating Systems: Red Hat Linux, OEL, Sun Solaris, AIX and HP-UX.Windows NT/2000/XP

Skills: Installation, Configuration, Patching, Cloning, Backup, Upgrade and troubleshooting.

Tools: OEM, Export, Import and SQL* Loader.VNC, Putty, Core FTP, WinSCP, Toad, Remote Desktop.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Apps DBA

Responsibilities:

• Installing and Configuration of Oracle 12c on Linux.
• Installing and Configuring Oracle EBS R12.2.4 application on RHEL 6.1.
• Installing and Configuration of RHEL and Operating System administration activities.
• Upgrading EBS application from 11.5.10.2 to R12.2.4.
• Monitoring the database and application services of Production environments.
• Monitoring filesystem, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Configuration of Oracle 11g ASM and RAC on Linux.
• Upgrading oracle database from 11.2.0.3 to 11.2.0.4 and integrating with Oracle EBS 11i.
• Experience working with Transparent Data Encryption
• Applying the application and database patches in testing, quality and production servers.
• Monitoring daily hot backup and weekend cold backups.
• Cloning from production servers to test servers for testing the modules by functional team.
• Installation and configuration of Oracle EBS R12.2, R12.1 and Oracle database 11g and 10g on Amazon AWS servers.
• Setup shared APPL TOP and shared application tier on 11i and R12.1.3.
• Troubleshooting the apache, concurrent manger issues facing by the developers and endusers.
• Supporting the service requests raised by the users.
• Creating the database and application users and assigning the roles and responsibilities.
• Managing the archive files and database files.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Refreshing Applications Database every weekend from production to development.
• Autoconfig customizations for EBS application node.
• Installation and configuration of Oracle Weblogic Server 10.3.6 and integrating with the oracle database 11g on Linux.
• Monitoring the invalid sessions, process and long running concurrent requests.
• Preparing the shell scripts for housekeeping the log files, old unused files and large files.
• Monitoring and tuning application and database performance by proactively and reactively.

Confidential

Oracle Apps DBA

Responsibilities:

• Daily checks of the database and application services of Production environments.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Applying the application and database patches in testing, quality and production servers.
• Maintaining daily hot backup and weekend cold backups.
• Installation and configuration of Oracle Weblogic Server 10.3.6 and integrating with the oracle database 11g on Linux.
• Cloning from production to test servers for testing the compounds by development team.
• Troubleshooting the apache, concurrent manger issues facing by the developers and endusers.
• Supporting the service requests raised by the users.
• Creating the database and application users and assigning the roles and responsibilities.
• Managing the archive files and database files.
• Upgrading the database from 10.2.0.4 to 11.1.0.7
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Refreshing Applications Database every weekend from production to development.
• Autoconfig customizations for EBS application node.
• Monitoring the invalid sessions, process and long running concurrent requests.
• Preparing the shell scripts for housekeeping the log files, old unused files and large files.
• Tuning application and database performance by proactively and reactively.

Confidential

Oracle Apps DBA

Responsibilities:

• Oracle applications 11.5.10.2, R12.2.3, FMW installations, Cloning, Patching, Monitoring, and Troubleshooting.
• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle application patches using adop, adpatch on single node, multi node environments.
• Monitoring Concurrent requests and troubleshooting.
• Service Request management and working with Support for issue resolution.
• Upgrading Applications from 11.5.9 to 11.5.10.
• Refreshing Applications Database.
• Installation, configuration, cloning & administration of Oracle RDBMS 10g, 11gr2 and RAC environment on Linux, Solaris and Windows platforms.
• Proficiency in DBA tools like Export & Import Utilities, OEM, DBCA and DBUA.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply patches using opatch tool for RDBMS Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• JRE Upgrade.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• DB Refresh through export and import utility.
• Autoconfig customizations for EBS application node.

Confidential

Oracle Apps DBA

Responsibilities:

• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle application patches using adpatch on single node, multi node environments.
• Service Request management and working with Support for issue resolution.
• Refreshing Applications Database.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply opatches using opatch tool for Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• Autoconfig customizations for EBS application node.
• Creating Application users and assigning responsibilities.

Confidential

Oracle Apps DBA

Responsibilities:

• As a part of Cloud IT, Responsibilities include supporting various tasks.
• Oracle applications 11.5.10.2, FMW installations, Cloning, Patching, Monitoring, and Troubleshooting.
• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle application patches using adop, adpatch on single node, multi node environments.
• Monitoring Concurrent requests and troubleshooting.
• Service Request management and working with Support for issue resolution.
• Upgrading Applications from 11.5.9 to 11.5.10.
• Refreshing Applications Database.
• Installation, configuration, cloning & administration of Oracle RDBMS 10g, 11gR2 and RAC environment on Linux, Solaris and Windows platforms.
• Proficiency in DBA tools like Export & Import Utilities, OEM, DBCA and DBUA.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply patches using opatch tool for Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• JRE Upgrade.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• DB Refresh through export and import utility.
• Autoconfig customizations for EBS application node.
• Creating Application users and assigning responsibilities.

Confidential

Oracle Apps DBA

Responsibilities:

• Daily checks of the database and application services of Production environments.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Applying the application and database patches in testing, quality and production servers.
• Maintaining daily hot backup and weekend cold backups.
• Cloning from production to test servers for testing the compounds by development team.
• Troubleshooting the apache, concurrent manger issues facing by the developers and endusers.
• Supporting the service requests raised by the users.
• Creating the database and application users and assigning the roles and responsibilities.
• Managing the archive files and database files.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Refreshing Applications Database every weekend from production to development.
• Autoconfig customizations for EBS application node.
• Monitoring the invalid sessions, process and long running concurrent requests.
• Preparing the shell scripts for housekeeping the log files, old unused files and large files.
• Tuning application and database performance by proactively and reactively.

Confidential

Oracle Apps DBA

Responsibilities:

• Daily checks of the database and application services of Production environments.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Applying the application and database patches in testing, quality and production servers.
• Maintaining daily hot backup and weekend cold backups.
• Cloning from production to test servers for testing the compounds by development team.
• Troubleshooting the apache, concurrent manger issues facing by the developers and endusers.
• Supporting the service requests raised by the users.
• Creating the database and application users and assigning the roles and responsibilities.
• Managing the archive files and database files.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Refreshing Applications Database every weekend from production to development.
• Autoconfig customizations for EBS application node.
• Monitoring the invalid sessions, process and long running concurrent requests.
• Preparing the shell scripts for housekeeping the log files, old unused files and large files.

Confidential

Oracle Apps DBA

Responsibilities:

• Daily checks of the database and application services of Production environments.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Applying the application and database patches in testing, quality and production servers.
• Maintaining daily hot backup and weekend cold backups.
• Cloning from production to test servers for testing the compounds by development team.
• Supporting the service requests raised by the users.
• Creating the database and application users and assigning the roles and responsibilities.
• Managing the archive files and database files.
• Tablespace Management, Managing Invalid objects. ReOrganisation of tablespaces.
• Refreshing Applications Database every weekend from production to development.
• Monitoring the invalid sessions, process and long running concurrent requests.
• Preparing the shell scripts for housekeeping the log files, old unused files and large files.
• Installation and configuration of OEL, Red hat Linux Server for Database and Oracle Applications.
• Create users, groups and directory structures with appropriate permissions.
• Regularly monitoring the System Statistics at Operating System level using commands like vmstat, iostat, sar, top and shell scripting.