SUMMARY

• Overall 7+ years of professional experience as Oracle Fusion middleware DBA,Oracle Apps DBA and Oracle Core DBA
• Experienced in 10g and 11g Database administration & Oracle Applications 11i and R12
• Experienced in oracle Weblogic components OAM,OID, oracle Webcenter portal, Webcenter imaging and Endeca
• Experienced in various Unix Platforms like HP - UX, Sun Solaris, IBM-AIX, RHEL X86-64 and Windows System.
• Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (shell scripting) and documentation
• Proficiency in standby database (Data guard) installation, upgrading, configuration, maintenance, backup and administration for disaster recovery on 10g/11g RAC
• Expertise in converting single instance database to Real Application Cluster (RAC)
• Experience in upgrading SOA suite (BPEL, ESB and OWSM) from 10.1.3.1 to 10.1.3.3 and 10.1.3.4.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.
• Applied quarterly CPU security patches to Oracle E-Business Suite 11.5.x and R12.x
• Experienced in working with adutilities like adadmin, adpatch, adctrl and adsplice and also resolving the issues during patching.
• Proficient in cloning the Oracle Apps and database using rapidclone and autoconfig.
• Done version upgrades in oracle weblogic components like OAM,OID and Oracle webcenter portal
• Experience in working and tuning with Oracle Workflow.
• Experience in using 11g features such as real application testing, sql plan baselines.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Experience in Installing Oracle 11gR2 GRID Infrastructure, 11gR1 CLUSTERWARE, 10g CRS on RHEL.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 trace, 10053 trace, AWR, ADDM, to collect and maintain performance statistics and improve the database performance.
• Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Profound knowledge in Oracle utilities including export/import, Toad, SQL*PLUS, Data Loading using SQL Loader.
• Adept in data modeling, Physical and Logical Database design, partitioning of tables and indexes, management of schemas.
• Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.
• Proven ability to combine project and staff management with technical expertise to consistently exceed corporate goals.

TECHNICAL SKILLS

Applications: Oracle Release 12 and 11i instances (11.5.5-11.5.10 ), Oracle Application Server 10g, Kofax/Mark View

Databases: Oracle 10g, 11g and 12c

FMW: Oracle Weblogic server 12,10.3.6, 10.3.5, 10G SSO,OAM,OID,Portal,Imaging,Endeca

Modules: GL, AP, FA, PO, AR, INV, Iprocurement, FND, AU, AD, AK, SYSADMIN

Tools: TOAD, SQL Developer, Putty, Vnc

Operating system: Oracle Linux 5.5, 6.2, H.P UNIX, IBM AIX, Sun Solaris

Languages: SQL, PL/SQL, C, UNIX Shell Scripting, HTML

PROFESSIONAL EXPERIENCE

Oracle Fusion Middleware and Apps DBA

Confidential, Tampa,FL

Environment: Oracle 11g, OEM 12c, weblogic 10.3.6,RHEL 6.2,Solaris, SQL*Plus, SQL * Loader, PL/SQL Developer, Import, Export, Toad

Responsibilities:

• Configured dataguard for RAC and standalone databases
• Installed Oracle weblogic 10.3.6 server and deployed custom java war files
• Created WLST scripts for monitoring weblogic server 10.3.6
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager 12c
• Created automatic portioning of tables and indexes to increase the performance
• Used datapump feature to migrate data from oracle 10.2.0.5 to 11.2.0.4 database
• Created shell scripts to monitor oracle database services
• Applied latest quarterly CPU patches to oracle database and oracle grid control 11g

Oracle Fusion Middleware and Apps DBA

Confidential, Tampa,FL

Environment: s: Oracle E-business suite 12.2.4,12.1.3,12.0.6,oracle 11g, RHEL 5 and 5.5, 10G SSO, OID,OIM, Oracle portal 11G, SQL*Plus, SQL * Loader, OEM, PL/SQL Developer, Import, Export, Toad,Weblogic 10.3.5,10.3.6.

Responsibilities:

• Working on POC implementation of Oracle Ebiz R12.2.4
• Working on POC implementation of Oracle Mobile security suite
• Worked on POC implementation of OAM 11.1.2.3 and OID 11.1.1.9 integration with Ebiz
• Production Support of ERP R12 environment Database 3 - Node RAC, 8 Node Application Tier with load balancer in DMZ configuration
• Installed and Integrated OAM 11gR2 with OID,Ebiz other weblogic components like Webcenter content Imaging and oracle Webcenter portal 11g
• Integrated webcenter imaging with ebiz suite using 11g Accelator
• Installed and configured ODC and OFR 10g in DEV,UAT,PROD and integrated with webcenter imaging
• Created Custom authentication schemes for Netegrity Siteminder integration with OAM
• Installed and configured Webcenter portal 11.1.1.7 on a single node, clustered in PROD and DR.
• Expertise in Installing and configuring Oracle Webtier 10g,11g, enable Weblogic proxy, SSL
• Installed and configured oracle Webgate with Webtier
• Implemented IDM solution for Ebiz with OAM and OID using Oracle EBS access gate.
• Implemented SSO solution for the ODSM console for OID user maintenance
• Migrated users and groups from 10G OID to 11G OID using ldap bulkload
• Expertise in trouble shooting issue with Endeca extension for EBS
• Installed OAM 11.1.1.7 with OID 11.1.1.6 on Weblogic 10.3.5 and 10.3.6 on RHEL 5.6
• Integrated OAM 11.1.1.7 with OID 11.1.1.7 and Ebiz 12.0.6 using webgate and accessgate
• Implemented OAM, OID on two node cluster with virtual URLs right from designing and implementing
• Integrated 11.1.1.5 OAM with Siteminder R12 using a custom JSP
• Worked with the Dev team to create custom portal login page and Multi factor Authentication
• Performance tuning of Weblogic and other OFMW products
• Successfully performed Dr testing for OAM,OID and other Fussion Middleware components
• Upgraded oracle E-business suite Accessgate to latest patch version
• Upgraded oracle database 10.2.0.4 to oracle 11.2.0.2 with datagaurd
• Upgraded oracle database from 11.2.0.2 to 11.2.0.3 with datagaurd
• Performed Database character set conversion from UTF8 to AL32UTF8 to support additional language requirement using DMU,CSCAN, and expdp/impdp utilities
• Implementation of GL, AP, FA,PO modules in R12.1.3 Ebusiness Suite & configured and used PPM tool for code migrations
• Refresh/cloning of ebiz from production
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Created the backup policy document and also Unix shell script for backup
• Created RMAN backup, cloning and recovery scripts
• Implemented 10g IDM, Installed 10g OID, 10g OSSO,10g portal
• Integrated 10g OID,OSSO, 10g Portal with ebiz
• Integrated 10g OSSO with ebiz and siteminder r6
• Frequent patching activities in ebiz and database
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
• User support and production support.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Experience in recovering the database in case of failure (Complete/Incomplete recovery)
• Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
• Wrote WLST scripts for Weblogic JDBC connections, threads and Weblogic service monitoring.

Oracle APPS DBA

Confidential, Seattle,WA

Environment: RHEL, SUN Solaris 8, Oracle database 10g, 11g, Oracle Applications R12 (12.1.3),Discoverer 11g, OID 11g, OEM 11g, Toad

Responsibilities:

• 24x7 Production Oracle Applications Administration with E-Business 11i and R12
• Responsible for cloning and patching the E-Business environment by utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Installation and configuration of discoverer11g on weblogic server 10.3.6
• Installed and configured OID 11g with Ebiz 12.1.3
• Migrated users from 10g to 11g using ldap bulkload
• Created users and roles for the other applications integrated with OID
• Oracle database upgrade from 11.1.0.7 to 11.2.0.3 and Applications upgrade from Oracle Applications (E-Business Suite) 12.1.1 to 12.1.3
• Supported major projects like HR Portal migration and Open Enrollment.
• Cloned Oracle home to all non prod instances and made sure everything is in sync with production.
• Upgraded Java from 1.6.0.17 to 1.6.0.35 and supported application team in resolving the post-upgrade issues.
• Upgraded the existing HRMS and Payroll Module to RUP1
• Applied HRMS latest patchsets in 11i
• Involved in Cloning and patching of oracle applications R12.
• Supported merchandising databases with Golden gate and RAC set up
• Provide technical assistance to all internal/ external customers and team members during system problems and implementation.
• Implemented Oracle Directory services and configured Oracle Internet Directory 11.1.1.5.0
• Applied patches using adpatch, adctrl and opatch utilities. Applying Oracle security patches within 30days of their release.
• Providing oncall Production support for various production databases.
• Being Involved troubleshooting various issues related with web logic issues.
• Registering the new Forms, Reports, pl/sql scripts as concurrent programs, analyzing the performance and coordinating with application teams regarding the same.
• Tuning the database with AWR, Tkprof, TRACE, Execution plans, SQL profiles, SQL Plan Baselines, SQL HINTS
• Coordinating and working with offshore DBA team regarding various day to day tasks and following up through completion.
• Configuration of Workflow Notification Mailer, OAM, OEM10g. Coordinated with the application team for the migration of mail servers from .
• Worked on the user and data security issues. Worked closely with users group to ensure timely implementation of an ERP.
• Providing the technical support to the Users on HRMS module implementation
• Took active role in communication with various development and test teams.
• Preparation and maintenance of documentation of all the activities according to the team standard.

Oracle Core/APPS DBA

Confidential, San Jose,CA

Environment: Oracle Server 10g/11g,Weblogic 10.3.5, OID 10g, IDM,Oracle EBS 12.0.6, RHEL, Solaris 10, TOAD, OEM 10g&11g.

Responsibilities:

• Supporting Oracle Databases 10g/11g RAC on Linux/UCS( Confidential linux version)
• Experience in troubleshooting Oracle EBS hosted databases on R12 and 11.5.10.2
• Installed oracle weblogic server 10.3.5 and OID 10g
• Integrated EBS with the 10g SSO
• Performed Cloning and Patching of R12 EBS and database
• Created logical and physical database using 11g data guard.
• Designing the security and database access strategies.
• Performing backups and recoveries using RMAN and conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Creating and dropping of users, granting and revoking rights as and when required..
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting and reorganizing those objects
• Written Unix shell scripts, Korn and Perl scripts.
• Partitioning R12 E-business suite large tables with range, list partitions, hash sub partitions
• Diagnose and troubleshoot Database problems and failures
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Performed and Monitored Database using OEM 10g and 11g.

Oracle APPS DBA

Confidential, Dearborn, MI

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to 12.0.4.
• Upgraded Database from 9.2.0.5 to 10.2.0.2, 10.2.0.2 to 10.2.0.3 and 10.2.0.3 to 11.2.0.2
• Preserved the customizations of 11.5.10.2 instance during the upgrade process.
• Tuned the upgraded Release 12 instance by assigning the number of OC4J’s and sizing there memory.
• Migrated 10.1.2 application server from Solaris to Linux.
• Integrated Infra, SSO and Portal with Release 12 EBIZ.
• Implemented High Availability replication and OC4J clustering for Infrastructure tier services.
• Implemented Siteminder netegrity single sign on along with Oracle single sign on.
• Implemented shared appl top in 11.5.10 environments
• Extensive patching and cloning of 11.5.10 instances.
• Production support Maintenance activities, written shell scripts for Monitoring production activities.
• Perform general technical troubleshooting and working with Functional teams for possible solutions for various issues.
• Concurrent manager administration and Oracle Apps sysadmin functions.
• Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.
• Troubleshooting RMAN backup and recovery related issues.
• Worked with Oracle Corporation to resolve applications/database issues by opening TAR/SR

Environment: Oracle 9i, 10g Database, Oracle Apps 12.0.4, 11.5.10.2, 10gAS Application, Redhat LINUX, Sun Enterprise Servers, RMAN.

Oracle Core/APPS DBA

Confidential, VA

Responsibilities:

• Migrated oracle applications middle tier from Sun Solaris to RHEL
• Installed oracle CRS 10.2.0.1 and upgraded it to 10.2.0.4
• Installed oracle database 10.2.0.1 and upgraded to 10.2.0.4
• Installed oracle Application server 10.1.3.1 and upgraded to 10.1.3.3
• Automated the tasks with the shell scripting and constant monitoring on the production and development instances with the shell scripts
• Reorganization of segments (tables, indexes) to release space and increase the performance.
• Installation and administration of the oracle E-business suite 11.5.10/12.0.6
• Cloning the Oracle Apps and database using rapidclone and autoconfig.
• Cloned both single instance and RAC from production to test instances in order to fix the issue
• Cloned Oracle CRS from one server to another in a RAC during the crash recovery of the server
• Responsible for installation, maintenance and trouble shooting of databases on 2 node RAC.
• Upgraded the database from 9.2.0.4 to 10.2.0.3 and applied patches when required.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Statspack, Explain plan and SQL*Trace.
• Partition of tables and indexes to increase the performance.
• Populated staging tables with data using SQLLDR and PL/SQL.
• Created database objects, users, roles and profiles.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN. Installed and configured Recovery Manager.
• Configuration of Oracle streams for replication between two databases.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager. Hence responsible for setup and configuration of OEM.
• Involved in Data refresh from production to test and development.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
• Experience in recovering the database in case of failure (Complete/Incomplete recovery)
• Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
• Troubleshooting of Database replication issues.