SUMMARY:

• Certified Associate Oracle Professional with14+ years of working experience in Oracle Application E - Business Suite Versions R12/11i.
• Done R12Upgrade (11.5.10.2 to 12.1.3) Along with Migrations from SOLARIS to LINUX
• Good experience of Oracle Applications DBA activities, Core Database activities, Real Application Clusters Database administration, OBIEE 11g Application Administration.
• Extensive working knowledge in Performance tuning of Oracle Databases, SQL tuning, PL/SQL tuning, Instance tuning.
• Installed and Configured oracle 11g RAC, distribution of workload across nodes, fixed many performance issues of RAC by using the AWR and analyzing the wait events.
• Exposure to Oracle 12c multi-tenant architecture and support for 12c databases.
• Good knowledge on administering Standby Database using Data Guard for large financial applications.
• Experience in working with ASM for RAC and non-RAC setups.
• Experience with design and implementation of database backup and recovery procedures using RMAN and Grid control. Worked with storage administrators for Storage level snapshot backups etc.
• Experience with installing/administering OBIEE 11g weblogic Fusion middleware serverand BI publisher services, Node manager, OBIEE cluster, RPD migrations etc.
• Worked extensively on Oracle Application performance tuning of Concurrent managers, concurrent requests, scheduling of concurrent jobs through Tidal tool, JVM tuning.
• Working knowledge in Patching including Oracle HRMS module patches for global legislation,Country specific localization patches, Cloning, Upgrades & Fresh installation of Oracle Applications 11i & R12 environments.
• Involved in Installation/Configuration/Maintenance of Oracle Applications Tech-stack.
• Setup/configure/Support/maintenance of multi-node 11i/R12 Environments
• Involved in Installation/Implementation/Configuration/Upgrades/Support of 11i/R12 instances.
• In-depth Knowledge of Oracle Apps Administration 11i/R12 like setup users/managing user responsibilities, registering custom applications etc.
• Experience in working with SSL and software level load balancer on EBS server.
• Code migrations of Forms/Reports/Java/ADF objects across SDLC and finally to Production environments through PCM/DELL STAT tool.
• Involved in Platform migration of Oracle Applications 11i/R12 using Transportable Tablespaces.
• Ownership of the quarterly maintenance security patching, providing SOX Audit reports and being responsible for managing technical quality deliverable/resource/schedule/risks throughout the project, working extensively under onsite-offshore model.
• Strong understanding of operating system (OS) like SOLARIS,HP,LINUX Oracle Linux and storage technologies like, NAS, SAN, Data domain to effectively work with Unix and Storage system administrators.
• Good knowledge of UNIX shell-scripting for automation of tasks and implementation of Custom monitoring alerts.
• Proficient in administering/installing/configuring of Monitoring tools such as OEM 10g,11g, grid console for monitoring hosts, databases and Oracle applications through AMP plugins and Oracle OBIEE environments through OBIEE plugins
• RAC to RAC cloning Oracle 11g R2
• Automating clone and other processes using schell scripts
• Installed New languages: German, Portugese in R12 and in 11i
• Having Extensive experience in writing Unix Schell scripts.
• R12 Single and Multinode cloning
• Application Clone from RAC to Non RAC clone

TECHNICAL SUMMARY:

ERP: Oracle E-business Suite (11.5.9, 11.5.10 and R12) administration

FMW: Oracle Weblogic server 11i, Oracle OBIEE 11g middle ware.

Work Areas: Installation, Upgrades, Cloning, Patching, Backup AND Recovery, Performance tuning

Database: Oracle RDBMS 9i/10g/11g

Languages: UNIX Shell Scripting

Monitoring Tools: OEM 10g, 11g and Schell scripts

Tools: and Utilities TOAD, SQL Developer, Putty, VNC

Operating Platforms: Oracle Linux 5.5, 6.2, HP UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Lead Oracle Applications DBA

Responsibilities:

• Application of tools and database (RDBMS) patches to Oracle Applications.
• Concurrent manager administration.
• Applied of current level patches and upgraded the oracle database and oracle applications.
• Creation of users and give the responsibilities.
• Creating Snapshots
• Production Support of EBS 11i environment on 2 Node RAC cluster with 2 Node Application tier on SUNSOLORIS platform.
• Installed/Configured/Stabilized OEM 11g grid console a
• Configured multiple Jservs, forms, report and concurrent managers for PCP.
• Involved in patching, refresh and upgrading the system to the latest RUP levels.
• Resolved concurrent request issues including printer and output post processing issues.
• Worked with Oracle Support to resolve issues pertaining Database and EBS issues.
• Worked on Oracle datapump utilities and imp/exp tool to migrate schemas/tablespace between different environments.
• Involved in day to day Oracle Applications DBA activities like patching,cloning etc
• Resolved locks and performance issues on RAC nodes.
• Timely fashion adding additional space to database on ASM.
• Applied patches on RAC Instances.
• Support for code deployments, long running reports by working with development team to and fixing critical reports performance issues using using SQL baseline, profiling, OEM tuning pack, and AWR
• Automating clone and other processes using schell scripts
• Working on Weblogic server

Environment: Oracle Applications 11.5.10, R12, Oracle Database 9i,10g,11g, Oracle RAC 11g, ASM,OEM 12c, OBIEE 11g, Linux servers, H.P Unix Machines

Confidential, New Jersey

Responsibilities:

• Configured 4 node R12 Application node configurations with shared TOPS for EMEA Project.
• Done PCP Configuration
• Done SSL Configuration with self-service s at Application side
• 4.Multi Node cloning done
• Scheduled DB activities using crontab on Linux servers.
• Compiled apps schema and validating invalid objects using utlrp script and adadmin utility.
• Coordinated with oracle metalink to issues on database and oracle application.
• Fixed oracle Apps User related issues.
• Documented RCA for various issues and deployed on solutions among various environment.
• Installed Oracle RDBMS server software and version upgrades on Oracle EBS server.
• Fixed forms related issues of Oracle EBS.
• Performed refresh and cloning of EBS instances for test, development servers.
• Scheduled and minimized the down time of the production system by resolving issues on a test system.
• Created request group, data group on EBS servers.
• Created concurrent managers, programs, and request sets for specific requirement.
• Automated manual day-to-day activities using shell scripts.
• Managed the Concurrent Managers and its operations on EBS like starting, stopping the concurrent managers, re-schedule the requests, tuning of concurrent managers and monitoring of the concurrent manager operations.
• R12Upgrade
• R12 Single and Multinode cloning
• RAC to RAC cloning Oracle 11g R2
• Application RAC to Non RAC clone
• Worked on replication, security, back-up and recovery, logical and physical database design, tuning, capacity planning and data retention
• Worked on 11G Data guard
• OEM Administration
• RMAN backup and Recovery for RAC database
• Using RMAN RAC to RAC clone and RAC to NON RAC clone has been performed.
• Oracle database Tuning
• Automating clone and other processes using schell scripts

Environment: Oracle Applications 11.5.10, R12, Oracle Database 9i,10g,11g, Oracle RAC 11g, ASM,OEM 12c, OBIEE 11g, Linux servers, H.P Unix Machines

Confidential

Team Lead

Responsibilities:

• Been part of Oracle Database upgrade from 9.2.0.4 to 10gR2.
• Applied CUP patchset 2 to 11.5.10 environment and upgrade to 11.5.10.2 version.
• Installed SQLT tool to analyze slow running SQL queries due to database upgrade. Created outlines for few critical sql to have plan stability.
• Configured SSL mode for Oracle HTTP server in EBS 11i environment.
• Production support of EBS 11i with Single Node Database and 2 Node application tier.
• Configured Parallel Concurrent Processing (PCP) and Shared APPL TOP.
• Converted forms server from servlet to socket mode to improve the performance.
• Created Oracle application users, assigned responsibility, Created custom's menus and responsibility for Oracle Apps.
• Installed and upgraded Oracle (10g, 11g) software in different environments, created and maintained Oracle development and test databases
• Maintaining of SAN storage and giving recommendations to the management
• Maintaining of H.P servers and all its AMC related issues
• Done some automation activities of Cloning Oracle Databases, finding run away process on the server, alert log monitoring etc. by writing scripts in Perl and in Unix Shell scripting.
• Installed O.E.M 10g grid console and agents and configured various alerts to proactively monitor Databases, H.P Servers etc.
• For Business Intelligence project have installed Oracle Warehouse Builder and Oracle Database 10.2.0.1.
• Performance tuning of concurrent requests, long running reports and SQL tuning.

Environment: Oracle Applications 11.5.10, R12, Oracle Database 9i,10g,11g, Oracle RAC 11g, ASM,OEM 12c, OBIEE 11g, Linux servers, H.P Unix Machines

Confidential

Team Lead

Responsibilities:

• Created users, assigned roles, and privilege management. Maintained user accounts and privileges to maintain application security.
• Worked with the application team and the business team in determining the requirements and solved all kinds’ database and data issues.
• Migrated data using RMAN transportable tablespace.
• Created and maintained materialized views for replication.
• Developed the shell scripts to load the data coming from the vendor in to the databases.
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Interacted with development team in fine-tuning the SQL and PL/SQL code.
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Migrated the code as well as the data from one environment to another depending on the application team's request
• RAC to RAC cloning
• Maintaining CSR (Change service requests) and Helpdesk cases.
• Trouble shooting
• Managing concurrent managers identifying / troubleshooting performance issues in Production Env.

Confidential

Team Lead

Responsibilities:

• R12 Installation On sunsparc
• R12 cloning single to single and single to multinode
• Production support.
• Responsible for maintaining and supporting complex production environment. Also supporting 4 development environments on 11.5.10
• Responsible for Production Builds
• Solving the tickets.
• Managed and troubleshooting Concurrent manager
• Created File system with ASM
• Comfortable with Linux (Redhat Advance Server) OS / Windows OS / Cron Scheduling in Linux.
• Should we able to run Explain plans and Sql analysis.
• Tuning Oracle queries PL/SQL packages, procedures and functions.
• Should we able to use AWR to identify issues.
• Knowledge of Oracle Applications Server (single and clustered env)
• Written custom shell scripts at OS level (C, bash, kshell).
• Installed R12 on Linux

Confidential

Team Lead

Responsibilities:

• Installed Oracle Application Server.11.5.10 on Linux 4
• Gather requirements from the end-user.
• Maintain the database and application and provide application functional and technical support.
• Performance Tuning (Database and Application).
• Maintaining a team of 3
• Database Administration
• Production support.
• Resolving snapshot too old alerts because of long running queries
• Resolving temporary tablespace issues
• Resolving alerts for the segments approaching
• Resolving Blocking Sessions
• Resolving 100% CPU consumption alerts of nodes
• Resolving Runaway Process alerts
• Resolving TableSpace full alerts
• Resolving Stand By database issues
• Resolving RMAN issues
• Automation of monitoring activities by developing shell scripts
• All miscellaneous issues regarding database.
• Responsible for maintaining and supporting complex production environment.
• Responsible for Production Builds supporting development/production environments on 11.5.9 and 11.5.10
• Production support.
• Responsible for maintaining and supporting complex production environment. Also supported 4 development environments on 11.5.9 and 11.5.10
• Rapid clone
• Migrated data using RMAN transportable tablespace.
• Created and maintained materialized views for replication.
• Developed the shell scripts to load the data coming from the vendor in to the databases.
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Interacted with development team in fine-tuning the SQL and PL/SQL code.
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Migrated the code as well as the data from one environment to another depending on the application team's request

Confidential

DBA

Responsibilities:

• Worked on cloning, various type of patches.
• Upgraded Oracle Database from 9.2.0.4 to 9.2.0.8 running on HP UNIX machine.
• Monitored and managed the Storage Usage by resizing Tablespaces for better Disk I/O.
• Scheduled DB activities using crontab on Linux servers.
• Compiled apps schema and validating invalid objects using utlrp script and adadmin utility.
• Coordinated with oracle metalink to issues on database and oracle application.
• Fixed oracle Apps User related issues.
• Applied apps patch using adpatch utility for various EBS modules.
• Documented RCA for various issues and deployed on solutions among various environment.
• Installed Oracle RDBMS server software and version upgrades on Oracle EBS server.
• Fixed forms related issues of Oracle EBS.
• Performed refresh and cloning of EBS instances for test, development servers.
• Scheduled and minimized the down time of the production system by resolving issues on a test system.
• Created request group, data group on EBS servers.
• Created concurrent managers, programs, and request sets for specific requirement.

Confidential

Team Leader

Responsibilities:

• Worked as an oracle Apps DBA for EBusiness suite 11.5.9
• Resolved tickets sent by users.
• Worked on OEM (alerts, monitoring, administration, and performance)
• Managing and troubling Concurrent manager
• Sql Performance Tuning
• Installing new Product IZU TOP using adsplice supporting development/production environments on 11.5.9
• Performed Event Tracing
• Users creations And Assigning responsibilities
• Creating Functions, Menus.
• Applied various Patches, and set of patches using admrgpatch.

Confidential

Sr.Oracle DBA

Responsibilities:

• Cloning of instances from production and acceptance instances
• Upgraded the oracle database 8.2.1 to 9.2.0.
• Creation of users and give the roles.
• Sql performance tuning.
• Database Tuning by seeing Hit Ratio.
• Created database links for test to development databases.
• Created snapshots for replication for some important tables.
• Created standby database for the production database.
• Extensively done Export and Import.
• Extensively used sql*Loader