SUMMARY:

• Confidential is an information management professional with 14+ years of experience.
• He Specializes in Oracle Database Administrator/ Oracle Applications DBA & Enterprise Architect.
• Looking for a challenging position in a high quality IT environment where my resourceful experience and academic skills will add value to organizational operations.
• Proven experience in critical Oracle EBS Release 12.2.3 Production administration, support and monitoring to ensure a proactive problem recognition and resolution of EBS and database related issues.
• Expertise in Oracle Applications R12.2.3 upgrades from R 11i & R12.1 instances.
• Hands on Experiences in Oracle Application R12.1.3,
• Expertise in online patching in EBS 12.2.3 and trouble shooting of various issues.
• Hands - on experience of EBS 12.2.3 cloning and trouble shooting of various issues.
• Extensive knowledge of Oracle Fusion Middle Ware use in EBS R12.2.
• Hands-on experience in configuring DMZ and external server for Oracle EBS application and SSL configuration.
• Expertise in resolving ERP related issues like those of Concurrent Managers, workflow configuration, AD utilities, Online patching, fs clone, etc.
• Expertise in database & SQL tuning for EBS. Trace analysis and finding the root cause and providing the solution.
• Experience in installing, configuring and administering Oracle Databases and also in RAC.
• Hands on experience in Oracle Fusion Middleware Product Installation and configuration of WebLogic server, Implementation of EBS Single Sign On using OAM 11g (11.1.2.0) Oracle IDM 11.1.1.7.
• Hands-on experience in cloning of Oracle Applications R12.X and 11i instances; upgrading and migrating different releases of 11gR2, 11gR1, 10g, 9i and in applying database as well application patches and patch sets.
• Hands-on experience in writing Unix shell scripts to automate alerts as well as backups, performance monitoring scripts.
• Hands-on experience in supporting OTM, Oracle Agile, ASCP, VCP, Oracle Golden Gate Production instances.
• Configure RMAN Backup for Oracle EBS database. This include configuration of catalog database, Registration of Target Database, Setting of RMAN script for Backing of Production Database, Monitoring and trouble backup issue.
• Expertise in Oracle Access Management 11g which include Installed and implemented SSO for EBS 12.2.3 & 12.1.3

TECHNICAL SKILLS:

Hardware: HP 9000, PCS, DG Aviion, Sun Sparc, Supermax, PCs

Software Products:

Database: 11g (11.2.X, 11.1.0.7), 10g(10.2.0.5) 9i,8i

ERP: Oracle Applications R12 (12.2.3, 12.1.3, 12.1.2, 12.0.6), 11i (11.5.10.2, 11.5.10, 11.5.8) Oracle FMW OAM 11g, OID 11g, WebLogic 10g

OS: IBM AIX, HP Unix, REH Linux 5/6 SCO Unix, Sun Solaris, WindowsNT/2000/98

Language: C, Proc*c, PL/SQL, JSP, Java Script, HTML, Shell scripting, Perl Scripting

Application Server: Oracle App server 3.0 & 4.0

Web-Server: iPlanet web-server 3.0 & 4.0

Tools: GXS Application Integrator 3.0 & 4.0 (AI),Toad, Developer-2000, DBA Studio, PL/SQL developer, OEM, Deginer-2000

Technology: Oracle Database / Oracle Application 11i & R12 Administration as Apps DBA, PL/SQL Programming, C-Programming

PROFESSIONAL EXPERIENCE:

Lead Oracle Apps DBA

Confidential

Responsibilities:

• Performed solution architect of large sized mission critical EBS databases as well as E-business Suit R12.2.3 including the upgrade of EBS system
• Perform Apps DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.

Confidential, Louisville, KY

Responsibilities:

• Support of large sized mission critical EBS 12.2.3 environment Production and Non production along with 2 nodes RAC database.
• Day to day 12.2.3 patching and cloning and troubling shooting of various phases of online patching.
• Implementation of Oracle Enterprise Assets Management and Viziya Application in EBS 12.2.3.
• Monitoring the database using OEM 12C tool.
• Implementation of Oracle Management Pack for On line patching of EBS 12.2.3 in OEM 12C.
• Hands on experiences of EBS 12.2.3 patching using OEM 12C.
• Install, upgrade, maintain, monitor, patch and tune Oracle eBusiness, Oracle Application server, and related databases. RMAN configuration using Recovery catalog and maintenance. Performing RMAN backups .
• Providing support to developers with troubleshooting and performance tuning, including System Global Area (SGA) analysis, latch contention analysis, disk subsystem tuning, tuning of SQL and custom codes.
• Carry out independent assignments of upgrading Oracle Applications.
• Work on day-to-day problem solving tickets using Service Now ticketing system.
• Involved in Apps DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.
• Coordinate with stakeholders pertaining to future requirements.
• Create new database users as required and manage sharing of resources amongst applications.
• Played leadership role in resolution of outstanding issues, reduction of backlogs and coordinating with team members in controlling backlog in DBA queue.
• Successfully configured upgrade projects including planning, customer coordination and execution.   

Lead Oracle Apps DBA

Confidential

Responsibilities:

• Performed solution architect of large sized mission critical databases as well as E-business Suit including the upgrade of EBS system
• Perform Apps DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.

Confidential, Mason, Ohio

Responsibilities:

• 24 X 7 Production Oracle EBS R12 Application and database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Capacity planning, backup monitoring, job monitoring, performance monitoring, database migration/up gradation for Oracle databases.
• Perform cloning of non-production R12 instances as per the clone schedule.
• Performance monitoring and tuning using OEM.
• Apply CPU Patches on to the database as well as application tiers.
• Work on day-to-day problem tickets using Vantive (PeopleSoft) ticketing system.
• Work on change management cases using Change management tool as well as CVS
• Performance tuning using stats pack and AWR/ADDM reports (for Oracle 11g) at the application and Database server level
• Analyze and Rebuild Index to rectify segment fragmentation.
• Pursue and follow-up service requests with Confidential .
• Monitoring the User Session and killing them if needed.
• Data file Consistency using DB Verify.
• RMAN configuration using Recovery catalog and maintenance. Performing RMAN backups .
• Logical backup of database using DATA PUMP, EXPORT and IMPORT utility

Confidential

Senior Oracle APPS DBA

Responsibilities:

• Worked as Primary DBA for R12 upgrade
• Planning of upgrade strategy which includes R12 upgrade approach, Instance Strategy, Co-ordination between various stack holders who are involved in upgrade project.
• Installed various Linux RPM and packages.
• Upgraded the Database from 10g to 11.2.0.4 .
• Installed R12.2.0 file system and upgrade the EBS from 11i to 12,2,3
• Trouble shooting and solving the upgrade driver issue during upgrade process
• Setting of DMZ for IProcument and IStore
• Created Upgrade Play book
• Apply functional and Database patches as per project requirement.
• Performance of multi-tier clones of Oracle Applications R12 instances after upgrade
• Troubleshooting issues with concurrent managers, Apache, Jserv processes & database performance.
• Set up RMAN backup and ensure backup successful. Trouble shoot the RMAN issues encounter.
• System recovery from hot backup as well as cold backup.
• Performed space monitoring & planning, migration of Instances and assisting developers in coding PL/SQL.

Confidential

Responsibilities:

• Executed SSO implementation using Oracle Access Management 11g (11.1.2.2.0 ) with EBS 12.1.3
• Perform the Hardware requirement analysis such as hardware requirement analysis, OS requirement analysis, software feasibility study for OAM 11g implementation with EBS R12.
• Installing and configuring the OAM 11g.
• Evaluating the product and develop the best practices.
• In-depth knowledge of Oracle Fusion Middle ware.
• Plans and implements backup and recovery of the Oracle database and OAM instance.
• Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Confidential

Responsibilities:

• Implementation of Oracle Application R 12.1.3
• Patching and cloning as per schedule.
• Migration of EBS code using Kintana ITG.
• Trouble shoot user issues reported and solve the ticket within SLA.
• Installed OEM12C for EBS and Non EBS environment Monitor.
• Configure management pack like EBS, Database etc in OEM12C.
• Setting of OEM12C alert for Oracle Dataase, EBS Concurrent Manager, EBS Forms and Apache.
• Upgrade database from 10.2.0.4 to 11.2.0.4
• Analysis of Oracle AWR, ADDM report and took necessary action for performance tuning.
• PL/SQL Performance tuning expertise in reading Trace & TKPROF output files.
• Plans and implements backup and recovery of the Oracle database using RMAN.
• Involved in DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.
• Designed, planned interacted and implemented Oracle Enterprise manager cloud control 12C.
• Successfully configured upgrade projects including planning, customer coordination and execution.     
• Performed multi-tier clones of Oracle Applications 11i and R12 instances besides troubleshooting issues with concurrent managers, Apache, Jserv processes & database performance.
• Focus on database monitoring & tuning, RMAN back up configuration and monitoring in addition to system recovery from hot backup as well as cold backup.

Confidential

Responsibilities:

• Installed R12.2.o and upgrade to 12.2.2
• Upgrade EBS 11. .2.2
• Troubleshoots with problems regarding the databases, applications and development tools.
• Performs ongoing tuning of the database instances.
• In-depth knowledge of Oracle AWR, ADDM report analysis.
• PL/SQL Performance tuning expertise in reading Trace & TKPROF output files.
• Plans and implements backup and recovery of the Oracle database.
• Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Plan the instance strategy such as hardware requirement analysis, OS requirement analysis, software feasibility study for 12.2.3implementation & upgrade.
• Involved in DBA activity including installation the 12.2.0 EBS application with Vision Demo as well as Prod Database and upgrade this to 12.2.3.
• Evaluated and prepare the documents for the new technology such as replacement of OC4J by Weblogic, online patching, Dual file system used in 12.2.
• Prepare various technical documents such Installation doc, Online patching doc, upgrade doc from 11i to 12.2.
• Explore & implemented the online patching technology which is new to EBS world.
• Successfully configured upgrade projects including planning, and execution.     
• Database monitoring & tuning, RMAN back up configuration and monitoring in addition to system recovery from hot backup as well as cold backup.
• Performance of multi-tier clones of Oracle Applications R12.2 instances besides troubleshooting issues with concurrent managers, Apache, Jserv processes & database performance.

Technology: Linux-86-64(Red Hat Enterprise Linux-5.6) Oracle database 11g (11.2.3), Oracle Application R12( 12.2.3)

Confidential

Responsibilities:

• Oracle Application upgrade in SPCTRUM is mainly deal with R12 upgrade from 11i which includes OPM migration.
• Involved in R12 upgrade planning which includes R12 upgrade approach, Co-ordination between various stack holder who are involved in upgrade project.
• Provide the direction to Functional/Technical Team on upgrade project.
• Hands-on experience of 12.1.3 upgrade from 11i.
• Preparation and Validation various upgrade documents.
• Fine-tuned upgraded 11gR2 database.
• Setting of External server and DMZ configuration for IProcument and IStore.
• Performance of multi-tier clones of Oracle Applications R12 instances besides troubleshooting issues with concurrent managers, Apache, Jserv processes & database performance.
• Involved in back up planning & monitoring, application of database & application.
• System recovery from hot backup as well as cold backup.
• Involved in space monitoring & planning, migration of Instances and assisting developers in coding PL/SQL.
• Maintenance of client coordination on various activities, assisting team members in implementation of new projects and participating in schedule call & planning activities.
• Involved in management of technical escalations.

Lead Apps DBA

Confidential

Responsibilities:

• In-depth knowledge of physical database design.
• Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments.
• Be able to provide a strategic database direction for the organization.
• Excellent knowledge of Oracle backup and recovery scenarios.
• Support of large sized mission critical databases in addition to problem management, service level management and technical escalations.
• Involved in DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.
• Installation of Oracle 11g Two Node RAC ASM Database with Oracle EBS 12.1.3.
• Installation of RAC and Managing RAC Environment.
• Highlights: Recipient of Top Performer in Oracle.
• Acknowledged for flawless planning & execution of projects and for single handedly upgrading Oracle Database across Prod & Non prod.      
• Played leadership role in resolution of outstanding issues, reduction of backlogs and coordinating with team members in controlling backlog in DBA queue.
• Successfully configured upgrade projects including planning, customer coordination and execution.

Technical Lead

Responsibilities:

• Involved in DBA activity including installation of Oracle, design & creation of database, database tuning, back up & recovery and data migration apart from execution of large scale projects.
• Coordinate with stakeholders pertaining to future requirements.
• Create new database users as required and manage sharing of resources amongst applications.
• Played leadership role in resolution of outstanding issues, reduction of backlogs and coordinating with team members in controlling backlog in DBA queue.
• Successfully configured upgrade projects including planning, customer coordination and execution.     
• Involved in support & maintenance of Oracle Applications R12 & 11i instances including production and non prod apart from managing all change management across prod & non prod environment.
• Implementation of large scale project including planning, preparation of implementation documents, setting backup plan & mitigation, co-ordination and final execution.
• Performance of multi-tier clones of Oracle Applications 11i and R12 instances besides troubleshooting issues with concurrent managers, Apache, Jserv processes & database performance.
• Involved in back up planning & monitoring, application of database & application patches using ITG tool Kantian as well as Manual.
• Focus on database monitoring & tuning, RMAN back up configuration and monitoring in addition to system recovery from hot backup as well as cold backup.
• Involved in space monitoring & planning, migration of Instances and assisting developers in coding PL/SQL.
• Planning of change implementation & assignment of resources to ensure successful completion.
• Maintenance of client coordination on various activities, assisting team members in implementation of new projects and participating in schedule call & planning activities.
• Involved in management of technical escalations and conducting knowledge sharing sessions with team members.
• Participate in resource haring process for the projects as well as oracle as general.

Technology: IBM AIX/ HP UX/ Oracle 11g & 10g database, Oracle Application R12 as well as11i (11.5.10.2)

Lead Apps DBA

Confidential

Responsibilities:

• Designed DB in new hardware environment and provided technical support for existing Oracle application.
• Analyzed application management process, procedures, identification of areas for improvements and implementation of the same.
• Appraised performance of subordinates, recommended pay hikes & promotions; coordinated with clients & stakeholders and participated in strategy meetings & periodical business meetings.
• Managed change management across the prod and non prod environment.
• Played key role in design & migration of Oracle database and EBS Suit application, new hardware environment in EBS refresh project of Confidential.
• Successfully implemented Oracle Project accounting Module of EBS in Confidential.
• Significant contributor in Production support DBA in Confidential.
• Implement new hardware and migrate existing oracle application instances (Prod and Dev).
• Project Leader/ Apps DBA involved in hardware planning, designing of DB in new hardware environment and performance of 2-tier clones of Oracle Applications 11i instances.
• Migrated Netbackup from old server to New server besides being involved in Veritas Net Backup Configuration and activity monitoring.
• Installed Oracle discover server & clear-orbit, monitored & tuned database apart from configuration & monitoring of RMAN back.
• Involved in system recovery from hot backup as well as cold backup, space monitoring & capacity planning and application of Oracle security patch release for database & Oracle application.
• Ensured 24/7 support to Severity-1 server requests; analyzed entire application management process, procedures for identification & implementation of areas of improvement.
• Involved in tracking & mitigation of risks, performance appraisal of junior team members and recommending increments and promotions.
• Determined resource requirements, hired required resources for the project and ensured proper utilization of human resources.
• Coordinated with clients & stakeholders, participated in strategy meeting & periodical business meeting.
• Involved in & mentoring, management, coordination, planning and execution of project.
• Managed knowledge, process & configuration, conducted status staff meetings, monitored project progress.

Technology: HP Unix, Oracle 9i database, Oracle Application 11.5.10, PL/SQL, Report 6i

Confidential

Responsibilities:

• Performed 2-tier clones of Oracle Applications 11i instances apart from Oracle project patching across various development, test, QA and prod instances.
• Managed & monitored Service request open in Metalink.
• Applied database and applications patches using ITG tool Kantian as well as Manual apart from troubleshooting of problems with concurrent managers, Apache, Jserv processes and database performance.
• Involved in backup planning, monitoring, Veritas Net Backup configuration & activity monitoring in addition to database monitoring & tuning, RMAN back configuration & monitoring, system recovery from hot backup as well as cold backup, space monitoring and capacity planning.
• Assisted developers with coding PL/SQL; administered 10g DRAK Discover server and applied Oracle security patch release for Database as well as Oracle Application.
• Ensured 24/7 support to Severity-1 server request.

Technology: HP Unix, Oracle 9i database, Oracle Application 11.5.10, PL/SQL, Report 6i

Confidential

ERP Oracle Application Implementation & Maintenance, Production Support

Responsibilities:

• Oracle Application in Confidential is mainly dealing with 11i implementation and maintenance.
• Involved in support & maintenance of 37 Oracle Applications 11i8, 11i10 instances including production, performance of 2-tier clones of Oracle Applications 11i instances.
• Troubleshot issues with concurrent managers, Apache, Jserv processes & database performance apart from backup planning, monitoring, Veritas Net Backup configuration and activity monitoring.
• Monitored system process using HP Open View Operation (OVO); applied database & applications patches using ITG tool Kantian as well as Manual.
• Involved in database monitoring & tuning, RMAN back configuration & monitoring, system recovery from hot backup as well as cold backup, space monitoring & planning besides monitoring of UNIX service guard.
• Ensured Help Desk support on Sysadmin/AOL and workflow.
• Focused on migration of Instances, assisting developers with coding PL/SQL.

Technology: HP Unix, Oracle 9i database, Oracle Application 11.5.10, PL/SQL, Report 6i