SUMMARY

• Oracle Applications DBA / Oracle DBA professional with over 7+ years of progressively strong experience in Oracle Technologies under Solaris, Linux, AIX, HP - UX and Microsoft Windows.
• Expertise in installing, maintaining and administering Oracle Applications 11i/R12 instances.
• Involved in application upgrades with Oracle Applications (11.5.8, 11.5.9, 11.5.10, R12.0.6,R12.1.3)/ Oracle eBusiness Suite, Oracle Database Installations/Upgrades (9i, 10g, 11g) and Maintenance using Ad Utilities.
• Worked on most of the Application modules like Oracle Manufacturing (INV, PO, OM and BOM), Oracle Financials (AP, AR, GL, FA) & Oracle HRMS.
• Very strong in Auto Patch, Upgrade, AdAdmin, AutoConfig, ADCTRL, Adsplice, Adrelink, AdMergePatch, ad License Manager, Cloningand Oracle Applications Manager(OAM).
• Production Experience in administering Oracle Apps 11i/R12, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10, R12.0.6 and R12.1.3.
• Specialization in administering RAC Databases, OEM, Grid Control and working in high availability environment in UNIX setup.
• Expertise in Oracle EBS System Administration to manage concurrent managers, application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration & printer setup.
• Monitoring long running jobs and eventually solving them by working closely with the application development team, query tuning (sqltrace, tkprof, explain plan) and troubleshooting performance related issues by tuning.
• 9i/10g RAC implementations (under test condition). Hands on experience in maintaining the RAC environment with 11i and R12.
• Database Recovery using Hot & Cold Backup, RMAN, OEM, and 10g DataGuard.
• 24/7 Production Database Support and maintenance.
• Expertise in performance tuning using Statspack, TKprof, OEM (Oracle Expert, SQL Analyzer) and Quest TOAD as well as performance tuning of Oracle APPS (Concurrent Manager, Server and client).
• Affected performance-tuning using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Expert in configuration and administration of Oracle 10g AS, OID, Infrastructure, 10gAS Portal, and Single Sign-on.
• Experience on implementing SOA (service oriented architecture suite) Middleware Fusion and OBIEE.
• Used KINTANA, Quest stat for patching 11i instances and migration of custom programs, responsibilities.
• Excellent knowledge in installation and maintenance of Oracle Application Server(10g/9i)
• Well versed at Unix operating System, Shell and Perl Scripts
• Good understanding and hand-on experience with Oracle Discoverer under Oracle11i Applications.
• Knowledge of Oracle identity management (IDM) suite.
• Experience implementing Oracle Single Sign-on (SSO), Oracle Internet Directory (OID), Oracle Identity Management, Oracle Grid Control, Oracle SOA Suite, Oracle Transportation Management(OTM), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator, Oracle Business Accelerators (OBA), Oracle Collaboration Suite, Real Application Clusters(RAC) or high availability oracle operating environment, SOA Suite with SSL.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite

R 12 12.1.3/12.0.6: 11i: Ver 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2.

RDBMS: Oracle Server 8i/9i/10g/11gR1,11gR2 for Sun Solaris, Linux, AIX,HP-UX

Operating Systems: Sun Solaris 2.6/2.5.1(SUN OS 5.5.1), AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 Server, Linux env.

Languages: SQL/ PL/SQL, UNIX Shell Programming (Bornshell, Csh, Ksh) Crontab

Software Tools/ GUI: Oracle Developer2000, Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM), SQL Navigator, SQL*Plus and TOAD, TKPROF, STATSPACK, Discoverer, SQL loader, Export/Import Utility, Kintana

Application Servers: Oracle 10g/9ias R2.

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to 12.1.1 and applied 12.1.3 patchset
• Upgraded the Oracle Apps Database from 11.1.0.7 to 11.2.0.3
• Configured DR Solutions from R12 ERP Applications.
• Working on building Physical and Logical Standby Databases and configured DataGuard Broker.
• Worked closely with user groups to ensure timely implementation of an ERP.
• Installed 11g Database for SOA implementation.
• Installed and Maintained Oracle Service SOA Suite 11g technology stack including BPM, Oracle Service bus 11g (OSB), AIA 11G R1 PS5 and PIP needed for SOA implementation in single node cluster as well as multi node cluster environment using Big I.P for load balancing.
• Apply Required Patches Before Installing AIA Foundation Pack 11.1.1.6
• Creation and configuration of Managed servers and admin servers as per business requirements.
• Configuring Node manage to control and manage Managed servers.
• Manage and Monitor a BPEL Process.
• PIP Configuration and deployment.
• Created users, roles and granted privileges according to the business requirements.
• Creation of Installation Document which includes a description of the steps and different procedures used to implement the installation.
• Created users, roles and granted privileges according to the business requirements.
• Configuration of Workflow Notification Mailer.
• Created SR's through metalink for troubleshooting issues related to Fusion Middleware Product Installation.
• Performance tuning of Oracle Database(Memory tuning by altering PGA and SGA values)
• Performance tuning of SQL queries using AWR
• Cloning of Environment.
• Monitoring Remote JVM using JvisualVm.

Environment: Oracle SOA 11.1.1.6, Oracle ERP R12, Weblogic server, Linux.

Confidential, Santa Clara

Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to 12.1.1 and applied 12.1.3 patchset
• Upgraded 10g database to 11gR2 (11.2.0.3) database
• Installed and configured 3 node 10g RAC Databases for EBS Database.
• Implemented dataguard to build the standby databases
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of oracle 11g,10G database.
• Implemented Multi node architecture with a Load Balancer set up.
• Integrated the 10g AS SSO/OID with ERP R12.1.3 with build 6.0 integration patch
• Upgraded Database from 10.2.0.4 to 11.2.0.1
• Installed 11g OEM Grid Control for monitoring of Oracle Databases
• Configuration of Workflow Notification Mailer, OAM, OEM11g.
• Performance tuning of Oracle Database, applications and queries.
• Created new Concurrent managers, Purged concurrent requests table and implemented PCP on 4-node
• Expert in cloning, patching and maintenance tasks
• Configured workflow mailer and resolved the notification issues
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Very good experience in creating SR’s through Metalink
• Performance tuning of Oracle Database, applications and queries.
• Provided application support to users and created a log of all the problems with solutions for future reference with Root Cause.
• Worked on Nexus and DTEC requests.
• Installation and configuration of Weblogic Server.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).

Environment: Oracle Ebusiness 11.5.10.2/ R12.1.3, Sun Solaris 10/9, HP-UX, AIX, RHEL, Oracle 11gR2/11gR1/10g, RAC, Data Guard, Weblogic server, Timesten DB.

Confidential - Washington, Seattle

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.
• Upgraded 9i database to 10g (10.2.0.4) database.
• Post go-live support of Oracle Applications R12.
• Maintenance of 10g databases and other non-ERP Databases.
• Cloning DEV and UAT instances from Production for testing.
• Implemented Data guard (Physical Standby database set up in production).
• Migrated the Production database from Old servers to new servers.
• Configured load balancing on Apache and Forms Servers.
• Applied the patch sets, one-off patches, opatch to the Development and production servers.
• Monitoring of databases using 10g OEM grid control
• Worked on new data pump utilities (expdp and impdp) for parallel migration of bulk data.
• Implemented the Oracle E-business suite Application Management Pack on OEM
• Implemented Shared APPL TOP.
• System Administration tasks also includes creating and defining the concurrent programs and executables.
• Applying Patches as per Oracle support to troubleshoot various errors
• Resolved various Problems that occurred while re-linking the application executables and generating report files.
• Troubleshooting the issues raised by oracle ERP from both user community and development
• Taking care of the performance issues both at the database level and applications level.
• Scheduled the backups using RMAN and disk backups
• Recovering the databases at critical situations.
• Installation and Maintained SOA/BPEL (10.1.3.4) in non RAC database as single node cluster containing 3 managed servers with single Admin server.
• Manage and Monitor a BPEL Process.
• Configuration of SOA Workflow Notification Mailer.
• Worked with Oracle Support on resolution of SRs
• 24x7 on call support for Oracle ERP applications and production databases

Environment: Oracle ERP R12 (12.1.1, 12.0.4) /11i (11.5.10.2), Oracle 11g/10g, RHEL 5, Windows 2000/2003, 10gAS/9iAS, Oracle Financial modules, Weblogic server.

Confidential, Westport, CT

Oracle DBA/Applications DBA

Responsibilities:

• The work involves overall Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Day to day Performance Monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and table spaces.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Wrote PL/SQL subprogramsPackages, Procedure, functions and DB triggers..
• Creation of Data base links in the distributed databases.
• Physical as well as Logical Backups and maintaining the databases using RMAN.
• Maintaining data integrity and tuning of database for optimum performance and availability
• Configuring network components like TNSNAMES, Names Server etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Created and maintained Snapshot sites and Master site with Replication Groups.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Experience on setting up the DMZ and configuring the Application Server with reverse proxy.
• Monitored and maintained OC4J’s of Markview 170 systems integrated with Oracle Applications.
• Applied Tech-stack, RDBMS patches and Critical
• Review, analyze and evaluate business requirements and transform business requirements into software requirements.
• Responsible for the design and instantiation of the physical data model, design data models to meet the analytical requirements of the data warehouse.
• Responsible for maintaining, enhancing data model.
• Developed scripts to process and load mutual fund pricing, performance, holdings data for various Investment applications including fixed income, marketing external web application and equities analytics.
• Developed, enhanced and maintained reports using Business Objects, ad-hoc reports.
• Load data into warehouse utilizing SQL loader, shell scripting, and Oracle PL/SQL.
• Developing SQL, SQL tuning, database objects creation, indexes, views and synonyms.
• Provided Data warehouse production support during and after work hours on escalated tickets.
• Responsible for reviewing and implementing critical data change request.

Environment: Oracle Server 8i, SQL, PL/SQL, SunOS 5.7, Shell scripting, EXPORT/IMPORT, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/DBA

Responsibilities:

• Installed Applications 11.5.9, 11.5.10 for single Node and Multi node environments.
• Upgrading customers databases from 8i to 9i and 10g and Applications upgrades from 11.5.8 to 11.5.9,11.5.10 and 11.5.10.2
• Worked on Discoverer configuration
• Worked on Kintana tool to migrate concurrent programs, menus, responsibilities and Kintana setup
• Applied various patches using both adpatch and used lot of techniques in minimizing the patching downtimes
• Troubleshooting Apache and Concurrent manager issues and issues after patching and Auto configurations.
• Performance tuning of SQL queries using AWR and ADDM tools of Oracle 10g.
• Troubleshooting Database performance, locks and any backup issues
• Part of my curriculum worked on various Performance Issues.
• Effectively monitoring the instances and solving the p1 issues
• Part of daily monitoring activities used to perform daily health checkups on the databases.
• Support the SR process and document problem resolution via Metalink.

Environment: Oracle 9i, Oracle 10g, Oracle applications 11.5.10, 11.5.10.2, OEM, Toad, Solaris 9/10, Red Hat Linux.

Confidential

Oracle Applications DBA

Responsibilities:

• Responsible for both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers in the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4.
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment: Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Jr Applications DBA

Responsibilities:

• Responsible for both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers in the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4.
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment: Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader