SUMMARY:

• Specialized in Oracle Applications R12/11i Database and System Administration with over 10 years experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Lead and maintain efficient and highly available operation of WebLogic, SOA suite and Portal environments.
• Manage, administer and control system responsibility.
• Lead, install, configure and manage user interface and application Program interfaces, certificate, keys and secure connections between external entities and EBS for B2B transactions.
• Lead, install, configure and manage the use of OAM/with web applications, including those of Oracle and Custom - built.
• Experienced and proficient with Oracle E-Business suite application (R 12 12.1.1/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Red Hat Linux, AIX and Windows environment
• Experience in Hang Analysis of Oracle Databases, Creating System State Dump, AWR analysis, SQL Tuning and Trouble shooting, RMAN configuration, Trace files analysis, Backup and Recovery skills DataGuard, Setup DB upgrades in very Complex PROD environments.
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1
• Familiarity with protocols - HTTP, ftp, sftp, certificate/key based authentication, ssl
• Expertise in Windows - batch files, scripting, setup/configuration of web applications on IIS
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing
• Expertise in Implementing SSL for Oracle E-Business Suite Applications
• Expertise in implementing Shared APPL TOP and PCP
• Expertise in troubleshooting Workflow and Notification Issues
• Implemented Vertex Taxing Software and integrated with 11.5.10.2 Applications
• Expertise in installing Discoverer and integrating to ERP Applications
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues
• Proficient in Oracle tools and utilities (Net8, Svrmgr, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, Confidential, IA, SQL Navigator, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in general troubleshooting, firefighting, development of scripts, documentation, issue resolution, and TAR/SR support
• Well versed in implementing System Management and Monitoring procedures
• Strengths include skills in Shell Programming, SQL, SQL*Loader, Import/Export and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings
• Experience in Security Management and Database Auditing
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX)
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues
• Applying RDBMS and Application patches. Sound knowledge in AD Utilities
• Monitor system performance, identify bottlenecks and ensure problem resolution
• Capable of tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Experienced in Space Management, Memory Tuning and Application Tuning
• Troubleshooting expertise for all tiers (client, middle-tier, database)

Hardware Platforms: Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), Dell poweredge

Operating Systems: RedHat Linux 4/3, UNIX (HP UX 11/10.1/10.20, Solaris 8/2.4/2.6/2.7, SCO, IBM AIX 5L/4.3), MS-WINDOWS XP/2000, MS-WINDOWS NT 4.0 Enterprise edition

Database: ORACLE 11g/10g (10.2.0.3), 9i (9.2.x), 8i (8.1.x)/8.0, 7.3.2, 6.0

Forms Servers: Developer 10g/9i, dev2000 (1.6.1 and 1.3.2, 1.5.1), Dev6i

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222)

Programming Languages: SQL, PL/SQL, Ksh scripts, Unix Shell Scripting

Applications: Oracle Applications R 12 12.1.1/12/0. x, 11i (11.0.3,11.5.7, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2), Vertex

Modules: AOL, GL, INV, AR, AP, PO, Iprocurment, HRMS, Supply chain modules, Order Management, Install Base, iStore, IPayments, BI Dash board

GUI DEVELOPER: 6i, ADI, OAM, Confidential, Kintana, Quest Stat

Tools and Utilities: Oracle Tools Confidential /OAM, SQL*PLUS And third-party tools like Quest Software (TOAD, SQL Lab) etc

Advanced Technology: Distributed Databases (Advanced Queuing, Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning)

PROFESSIONAL EXPERIENCE:

Sr. Oracle Apps DBA/ APPS DBA Team Lead

Environment: R12(12.2.3), R12(12.1.3),11i (11.5.10.2), Oracle 11gR2, Linux ES4, ES5 and ES6, Exadata Quarter RAC, Confidential 12c, SQL*plus, SQL Loader, Toad.

Confidential, Goleta, CA

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development, Patch, QA and Stage environments.
• Installed Oracle Enterprise Manager ( Confidential Cloud Control 12c) to manage around 100 Oracle databases.
• Cloning the Development and Test EBS databases from Production.
• Moving the Custom code to Production from QA.
• Experienced and proficient with Oracle E-Business suite applications (12.2.3 and 12.1.3) and Oracle Applications Server (11g) in Exadata Quarter RAC Machines.
• Expertise in implementing Shared APPL TOP and PCP.
• Very strong in Auto Patch(ADOP), Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.
• Exposure to Fusion Middleware components like SOA and Weblogic.

Sr. Oracle Apps DBA/APPS DBA Team Lead

Environment: R12(12.1.3), 11i (11.5.10.2), Oracle 11gR2, Linux ES4, ES5 and ES6, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer. SQL*Server 2008,2012.

Confidential, Dallas, TX

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development, Patch, QA and Stage environments.
• Installed Oracle Enterprise Manager ( Confidential 11g) Grid control to manage around 100 Oracle databases.
• Running backup scripts in SQL*Server using SSMS (SQL Server Management Studio).
• Managing Web Servers using IIS.
• Installing/Upgrade of Peoplesoft tools 8.49 and Managing Peoplesoft Databases HRMS, HRQC, HRDEV90.
• Cloning the Development and Test EBS databases from Production.
• Moving the Custom code to Production from QA.
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Experienced and proficient with Oracle E-Business suite applications (12.1.1, 12.1.2, 12.1.3) and Oracle Applications Server (11g) in Red Hat Enterprise Linux.
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.
• Mananging Peoplesoft HRMS 9.1 and MySQL databases.

Sr. Oracle Apps DBA

Environment: R12(12.1.2), Oracle 11gR2, Linux ES4, Linux ES-5.3, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Bristol, VA

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development, Patch, QA and Stage environments.
• Cloning the Stage EBS database from Production every weekend.
• Moving the Custom code to Production from QA using SVN Install utility.
• Managing the GRC databases CCG and AACG for Governance, Risk and Compliance Manager.
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Experienced and proficient with Oracle E-Business suite applications (12.1.1, 12.1.2, 12.1.3) and Oracle Applications Server (11g) in Red Hat Enterprise Linux.
• Experienced with Confidential, ASM, RAC and Data Guard.
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.

Sr. System Administrator/ Sr. Oracle Apps DBA

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Linux ES4, Linux ES-5.3, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Schaumburg, IL

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development environments.
• Lead and maintain efficient and highly available operation of WebLogic, SOA suite and Portal environments.
• Manage, administer and control system responsibility.
• Experienced and proficient with Oracle E-Business suite applications (11.5.7, 11.5.8, 11.5.9, 11.5.10.2 and 12.0.4,12.0.6,12.1.1,12.1.2,12.1.3) and Oracle Applications Server (9i/10g/11g) in Sun Solaris, Red Hat Enterprise Linux, AIX and Windows environment.
• Experienced with Confidential, ASM, RAC and Data Guard.
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Experience in administering Oracle Apps 11i, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10 and 11.5.10.2 to R12 (12.0.4,12.0.6,12.1.1,12.1.2,12.1.3).
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Troubleshoot problems related to Oracle databases and Oracle Applications 11i, R12 and perform root cause analysis.
• Experienced in Forms Load Balancing, Apache/Jserv upgrades SSL setups.
• Experienced in Multi Reporting Currencies, Multi Language Support, and Multi Organization Access Control and Multi Org setup.
• Experienced in Web technologies, coding the server side and client validation programs.

Sr. Oracle Apps DBA

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Linux ES4, Linux ES-5.3, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, King of Prussia, PA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.1.2 and R12.1.1
• Good Knowledge on SOA, RCU, JDeveloper, Weblogic Server, Managed Servers and Oracle Fusion middleware including BPEL, Business rules and ADF development using JDeveloper.
• Architected, installed and administered SOA Middleware components 11g Database on SOA Fusion Middleware for both SOA and BAM Servers.
• Configuring JVMs and Proxy servers for Load balancing.
• Upgraded Oracle AS from 10.1.3 to 10.1.5
• Database Upgrade from 9.2.0.6 to 10.2.0.4
• Database Upgrade from 10.2.0.4 to 11.1.0.7.0
• R12.1 Implementation on Single node and Multi node setups
• R12.1.1 to R12.1.3 Upgrade with 11gr1 to 11gr2 Database
• DMZ Setup and DMZ Clones.
• Migration of 32 bit EBS Database to 64 Bit on Linux Platform
• WebCenter 11g Installation and configuration
• SOA Suite 10g & 11g Installation and configuration.
• OA Clone from one node to another
• Performed various Apps DBA tasks
• Performance tuning of Oracle databases and EBS 11i instances.
• Rebuilding of Standby databases from Production.
• Upgrading JDK (java development Kit) & JRE
• Applying different types of Application and Database patches as per the requirements.
• Cloning of Oracle applications of Shared Appl Top and Shared Oracle Home
• Configuring Workflow mailer.
• Cloning of Oracle Applications 11i and R12.
• Taking Backups using RMAN.
• Upgraded JDK, Upgraded Jinitiator.
• Resolving the issues in RMAN Backup.
• Resolving day to day issues of the database and applications.
• Production support of 15+ clients under Managed Services
• Performance tuning of Oracle Database and Applications.
• Implementing and troubleshooting of forms server, report server, Discoverer server, Web Server.
• Maintenance of Concurrent managers and Parallel Concurrent Process (PCP).
• Worked on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• 24x7 on call support for Oracle ERP applications and production databases

Sr. Oracle Apps DBA

Environment: Oracle Applications R12 (12.1.1/12.0.6 ), 11i (11.5.10.2), 11.0.3 Apps, Oracle 8i,9i/10g, Linux, Windows NT, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Lexington, KY

Responsibilities:

• Monitoring of multiple production instances of versions R12 & 11i residing on various Operating systems such as Linux, Windows NT.
• Multi-node installation of R12 applications.
• Upgraded applications from 11.5.10 CU2 to R12.
• Patching and Cloning of Oracle Applications using adpatch &Rapid clone utility.
• Monitored databases and applications using Oracle Enterprise Manager ( Confidential ) /Oracle Applications Manager (OAM)
• Installing RPMs and Changing Kernal parameters in the Unix Operating systems.
• Using Unix operating system utilities top, sar and iostat to monitor the server performance.
• Maintaining the cluster ware components OCR and Voting Disk etc.
• Implemented CRM, AP, AR, GL, IProcurement, ASCP, Fixed Assets, Cash Management, PO, BOM, WIP, ONT, HR, Workflow, Tele sales, Time and Labor Etc.
• Implementing Load Balancing between Oracle Application Servers.
• Running TUMS report for Upgrading 11.5.9 to 11.5.10 Technology stack.
• Running Patchsets.sh regularly to get the latest Mini-packs available and apply them if required.
• Generate AWR, ADDM, Stats pack reports regularly to know the bottlenecks in the system and send them to Oracle support for analysis.
• Generate stats pack report regularly to know the bottlenecks in the system and send them to Oracle support for analysis.
• Changing the Various parameters in init.ora to improve the performance of the Oracle Applications database
• Configuring and tuning concurrent managers. Perform system administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups, request set etc.) and Purge AOL tables.
• Assisting users in resolving the printer related issues and setting up new printers.
• Developed Unix Shell scripts and SQL queries
• Worked on TAR, coordinating with Oracle for SEV 1/2 issues.
• Provided 24 x 7 on call support for Production databases.

Oracle Apps DBA

Environment: Oracle Applications 10.7, Oracle Applications 11i (11.0.3), Oracle 7.3.2/8.0.6, AIX RS-6000, Confidential, SQL*plus, SQL Loader, Toad, Oracle Discoverer

Confidential, Terre Haute, IN

Responsibilities:

• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities
• Troubleshooting and on-call support (7x24)
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK (advanced version of UTLBSTAT and UTLESTAT).
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Cloning of Database and Applications

Sr. Oracle DBA

Environment: E4000 Sun Solaris, E3000 Sun Solaris, Confidential, SQL*plus, SQL Loader, Toad

Confidential, Vancouver, WA

Responsibilities:

• Installation, creation and maintenance of oracle databases for Data Ware Housing Project.
• Administered the databases EHDW, DWH, OLTP, STOR on E4000 Sun Solaris Systems and DWDV, FINANCE databases on E3000 sun Solaris 2.5.1 Unix systems.
• Created additional table spaces, Rollback Segments, Redo log Groups for production support.
• Configured SQL*Net for Oracle
• Created additional table spaces, Rollback Segments, Redo log Groups for production support