SUMMARY

• Around 10 years of diverse professional working experience in the area of Information Technology as Information Specialist on Oracle Applications and Database Architecture, with highly proficient in Oracle e - Business Suite Implementation, Upgrade, Administration, Performance Tuning, Backup and Recovery Strategies.
• Implementing and Configuration of Oracle Applications 11i, R12 and R12.2 on various platforms such as Linux, HP-UX, IBM AIX, Solaris and Windows with various Architectures.
• Upgrade Oracle E-Business Suite Applications from Release 11i to R12 and earlier releases
• Upgrade Oracle E-Business Suite Applications from R12.1.3 to R12.2.4
• Handling large databases backups(10tb) and restoring them into new servers for testing purpose
• Experience and proficient in Application Patching using AD Utilities and strong analytical and problem solving skills in Patch Management
• Implement and Configure of Oracle Databases 9i, 10g,11g and 12c for small to large applications.
• Implement Oracle Single Sign On and Oracle Access Management using Oracle Internet Directory
• Design and implement Oracle Database High Availability solutions using Oracle Real Application Cluster(RAC) and Oracle Automatic Storage Management(ASM)
• Implement and Manage Oracle Golden Gate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Involving in handling several databases and applications like primavera, dot net applications, ebusiness suite
• Experience in Single and multi-node installation, configurations, patching and upgrade on Linux,IBM,AIX,Hpunix, Windows platforms
• Implement Oracle Disaster Recovery solution for Oracle e-Business Suite• Migrate single instance Oracle Database to multiple instance Oracle RAC database.
• Migrate file system based Database to Oracle ASM on all UNIX OS Platforms.
• Create and configure Databases for Data Warehouse, Data Mart and Reporting applications
• Clone Oracle E-Business Suite Applications and Databases Online using RMAN Active Duplicate
• Manage and Co-ordinate offshore team to provide 24/7 model production and development support for Oracle Applications and Oracle DBA activities like Cloning, Patching, and administration with Oracle RAC environment on Oracle ASM.
• Performed Auto configuration activities.
• Configure and Manage Oracle Data Guard for Disaster Recovery of Production Databases using Physical and Logical Standby Databases.
• Configure Parallel Concurrent processing and shared appltop in Oracle E-Business suite.
• Implementation of Oracle RAC with Oracle Apps 11i and Oracle E-Business Suite R12
• Scheduling Concurrent mangers and requests to improve performance throughput.
• Manage OLTP databases activities such as Performance Monitoring, Create and refresh, materialized views, Database security Management, Database Table Partitioning for large databases, Create DB links
• Knowledge on AD utilities (Ad patch, Admrgpch, Adctrl, AutoConfig, Adadmin, Adident, Adrelink etc)
• Managing Oracle Database Backup and recovery strategies with Oracle RMAN.
• Install and Configure OEM Grid Management server 11g and 12C for Oracle Databases and Oracle Applications Monitoring.
• Schedule and implement SQL advisors for performance Tuning of Oracle Database jobs.
• Performing SQL queries tuning to improve the query performance.
• Implement UNIX shell scripts for daily monitoring and placing them in crontab
• Installation and Administration of Oracle Business Intelligence Enterprise Edition 11g

TECHNICAL SKILLS

Databases: Oracle11g, Oracle10g, Oracle 9i,12c

Applications: Oracle E-Business Suite 11i, R12 and R12.2.4, OAM, SSO, Oracle Discoverer, OID,GoldenGate.

Programming: SQL, Unix Shell scripting.

Oracle Tools & Other Utilities: Oracle Diagnostics Tool, OEM Grid Control, RMAN, SADDM, AWR, Tkprof, Log Miner, Export/Import, Data Pump, Oracle SQL Loader, AD Utilities, Quest TOAD.

Operating Systems: Red Hat Linux, Sun Solaris, HP Tru64, HP-Unix Itanium, IBM AIX, Windows 2008

PROFESSIONAL EXPERIENCE

Oracle Application Dba

Confidential, Memphis, TN

Responsibilities:

• Installation and configuring latest Release R12.2
• Upgrade Oracle E-Business Suite Applications from R12.1.3 to R12.2.4
• Implement Oracle Single Sign On and Oracle Access Management using Oracle Internet Directory
• Restoring the large databases(10tb) point time recovery for testing the production backups
• Implementing SHA1, SHA2 certificates and applying required cpu and psu patches
• Restore and refresh database and applications
• Applying NLS patches and performance patches.
• Implement and Configure of Oracle Database 11g and 12c
• Implementing Oracle Database High Availability solutions using Oracle Real Application Cluster (RAC) and Oracle Automatic Storage Management( ASM) for e-Business Suite
• Implement and Manage Oracle Golden Gate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Moving CRD files from one mount point to another to resolve space issues.
• Preparing shell scripts for monitoring purpose
• Provide OS and storage layout and specifications to build servers required for the Application and Database implementation
• Installation and Administration of Oracle BI and Oracle Discoverer 11g with Oracle WebLogic
• Co-ordinate with OS team, Network team and Storage team to build and integrate the Servers.
• Manage the implementation life cycle of the Oracle Applications and upgrade support activities.
• Performance monitoring of Oracle Concurrent programs and analyzing the trace files for issues.
• Cloning and refreshing Oracle Applications R12 Instances with Databases using RMAN Duplicate also using hot clone.
• Troubleshooting issues and performance bottleneck in Oracle Applications R12 and Databases.
• Patching R12 instance for product enhancements, resolving bugs etc.
• Involved in DMZ configuration.
• Setting up of Physical Data guard.
• Applying latest releases of the RDBMS patches using Opatch utility from Oracle on Production and test instance to resolve few technical challenges & issues.
• Involved in SYSADMIN activities like creation of users, assigning responsibilities
• Involved in PCP configuration.
• Installing OEM agent in Data warehouse database for OEM grid control.
• Configuring the workflow notification mailer and testing the alerts.
• Configure Printer in EBS.
• Restore and Refresh database and applications.
• Maintaining Archive logs and their space for routine administration alert and trace monitoring.
• Performed Rman backup in catalog and no catalog mode and scheduling them in crontab
• Mounting from one server to other server in HP Unix itanium
• Generating AWR, ADDR, ASSH reports and analyzing them.

Environment: HP-Unix Itanium, IBM AIX, SQL, PLSQL, Oracle E-Business Suite 11i and R12, R12.2.4, OBIEE, OAM, OEM, Oracle11g, Oracle10g, Remedy.

Oracle Application Dba

Confidential - Troy, MI

Responsibilities:

• Installation and configuration of Oracle Ebusiness suite R12.1.1 and R12.2
• Analyzing and applying Oracle PSU and CPU released patches in RAC and Databases
• Creating shell scripts for all monitoring activities and sending them to mentioned mail ids in a HTML format.
• Performance monitoring of Oracle Concurrent requests and analyze the trace files for the issues.
• Creating Custom tops in R12
• Cloning and refreshing Oracle Applications R12 Instances with Databases using Hot clone and Rman.
• Troubleshooting issues and performance bottleneck in Oracle Applications R12 and Databases.
• Applying patches to the Oracle Applications Tech Stack and to Oracle Databases.
• Handling Clients Service Requests for various patching and other issues.
• Monitoring the performance of the Applications and Databases Scheduled jobs.
• Installation of oracle applications R12 on Unix titanium, Installation on single node and multi node(database and concurrent manager on one node and remaining on other) • Creating SRs for production environments and following them.
• Involving in customer customization activities
• Manage all database issues including database capacity, re-orgs, backup & recovery, scripting and Performance tuning.
• Installation and Administration of Oracle BI and Oracle Discoverer 11g with Oracle WebLogic
• Configuring the Oracle Golden Gate 11g to generate flat files upon Data changes in the source.
• Installation and administration of Oracle 12C OEM
• Installation and configuration of Oracle RAC with Oracle ASM Instances.
• Applying HRMS Global Drive patches.
• Managing Redo logs and Data files like adding, renaming and resizing.
• Performing and monitoring RMAN backup and Recovery processes.
• Configure and Test the DR setup for the Oracle Applications R12 database and other Databases.
• Creating DB links from Oracle Database to Microsoft SQL server Database using Oracle transparent gateways.
• Analyzing and applying Oracle Opatches and application patches using ad patch.
• Installing OEM agent in Data warehouse database for OEM grid control.
• Configuring the workflow notification mailer and testing the alerts.
• Configure Printer in EBS.
• Restore and Refresh database and applications.
• Installing and configuring the Oracle Golden Gate to replicate the Microsoft SQL server database tables as well as Oracle database tables to Oracle Data warehouse Database.
• Converting standby to primary
• Resolving payroll performance and runtime issues

Environment: Red Hat Linux, IBM AIX, Sun Solaris, SQL, PLSQL, Oracle10g, Oracle 9i,: Oracle E-Business R-12.1.3,12.2, SSO, Oracle Discoverer, Remedy

Oracle Application Dba

Confidential - Newyork city, NY

Responsibilities:

• Installation of oracle applications R12 on Unix titanium, Installation on single node and multi node(database and concurrent manager on one node and remaining on other)
• Applying NLS patches and performance patches
• Configuring OEM in 11g database
• Creating shell scripts for all monitoring activities and sending them to mentioned mail ids in a HTML format
• Up gradation R12 instance form 12.1.1 to 12.1.3
• Hot cloning of R12 from Production
• Rman cloning of R12 application
• Creating Customs Top in R12
• Setting up of Data guard
• Managing Redo logs and Data files like adding, renaming and resizing
• Troubleshooting Apache logs, opmn logs
• Applying HRMS global drive patches
• Doing the pasta settings as well as troubleshooting the alignment issues in rtfs
• Expert in Configuring the workflow notification mailer and testing the alerts
• Involved in SYSADMIN activities like creation of users, assigning responsibilities
• Performing autoconfig
• Configuring printer in EBS
• Restore and Refresh database and applications
• Maintaining Archive logs and their space for routine administration alert and trace monitoring
• Performed Rman backup in catalog and no catalog mode and scheduling them in crontab
• Mounting from one server to other server in hp unix itanium
• Date and time synchronizing from server to server
• Crontab scheduling using shell scripts
• Converting standby to primary
• Generating AWR, ADDR, ASSH reports and analyzing them
• Running logminor on archive logs to test why they are generating high
• Resolving payroll performance and runtime issues

Environment: HP Unix Itanium, C, SQL, PLSQL, Oracle E Business R12, SSO, OEM, OAM, Oracle 10g, Oracle 11g, Siebel.

Oracle Application Dba

Confidential - Philadelphia, PA

Responsibilities:

• Installation of oracle applications R12 on Windows 2008, Installation on single node and multi node(database and concurrent manager on one node and remaining on other)
• Checking the disk space available in the server and clearing the old logs according to clients retention period• Cloning of multi to multi node
• Applying opatches and application patches
• Trouble shooting long running concurrent requests
• Files migrations using fndload, wfload
• Checking the file versions according to user requirements using adident
• Supporting the entire production, dev, test environments.
• Doing all sysadmin activities
• Exporting full database and importing it
• Export and import activities (tables, schemas etc)
• Increasing buffer cache and resizing the db parameters by running CBO.sql to increase performance issues.
• Manage all database issues including database capacity, re-orgs, backup & recovery, scripting and Performance tuning.
• Installation and Administration of Oracle BI and Oracle Discoverer 11g
• Installation and configuration of Oracle RAC with Oracle ASM Instances.
• Applying HRMS Global Drive patches
• Managing Redo logs and Data files like adding, renaming and resizing
• Performing and monitoring RMAN backup and Recovery processes.
• Configure and Test the DR setup for the Oracle Applications R12 database and other Databases.
• Creating DB links from Oracle Database to Microsoft SQL server Database using Oracle transparent gateways.
• Analyzing and applying Oracle Opatches and application patches using adpatch

Environment: Windows 2008, Oracle E Business R12, C, SQL, PLSQL, SSO,10g,11g

Oracle Application Dba

Confidential

Responsibilities:

• Installation and configuration of Oracle Applications 11i instance on HP-UX IA-64 11.23
• Applying database patches and application patches
• Configure the Disaster Recovery setup for Oracle Applications 11i.
• Cloning and Refresh of the Oracle applications for development and testing purposes.
• Patching application for various bugs and updates
• Registering and Maintaining Custom Applications.
• Performance tuning of Oracle Applications 11.5.10.2
• Migration of AOL and Database changes done in Development instance to production.
• Development phase implementation support till the go-live.
• Coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle applications and Databases.
• Upgrade the Oracle applications database from 10g to 11g using DBUA.
• Applying ATG Family Pack, HRMS Family Pack, and eTDS patches on Production.
• Cloning from Production instance for various development purposes.
• Increasing buffer cache and resizing the data base parameters by running CBO.sql to increase performance issues.
• Troubleshooting issues with concurrent Managers performance, Forms server, and Workflow mailer.
• Performance tuning of Oracle Database 10g.
• Coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle applications and Databases.
• Production administration support of Oracle Applications 11.5.10.2 and 11.0.3 versions.
• Monitoring and Administration of Concurrent Managers.
• Creating Users, Creating Responsibilities, Menus as per Developers requirement.
• Report performance issues and problems to Oracle support to get fixes.
• Export and import activities using expdp and impdp.

Environment: SQL, PLSQL, C++, Oracle E-Business Suite 11i, R12, OAM, OEM, Oracle 9i, 10g, 11g, Red hat Linux, Kintana.