SUMMARY:

• Overall 15 years of experience on Oracle database versions 7.x, 8i, 9i, 10g, 11g and Oracle Applications 10.7, 11.0, 11i and R12 in UNIX (Sun Solaris, HP - UX, AIX, and Red Hat Linux) based Client/Server environments.

TECHNICAL SKILLS:

Oracle EBusiness Suite: Oracle Applications 10.7, 11.0.3, 11i (11.5.1, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2) and R12

Relational Database Management: Oracle7.x, 8i, 9i, 10g and 11g.

Platforms: UNIX - HP 9000, AIX RS6000/SP2, Sun Ultra Sparc, Red Hat Linux

Operating Systems: HP UX B.11, B.10.20, A.09.04, AIX 4.x, Solaris 2.5/2.6/2.8,2.9,2.10, Red Hat Linux 3.0/4.0

Client Tools: Developer 2000, SQL Forms, SQL Reportwriter, SQL Plus, SQL Loader,Oracle 10g OEM, Platinum Tools, TSReorg/ DBVision,DBArtisan 4.01, Data Junction 6.0, Discoverer 4i/10g, ADI 7.x.Applications

Financials: AP-Payables, AR-Receivables, GL-General Ledger, FA- Fixed Assets.

Oracle Human Resource HRMS: Payroll, Benefits, Employee self service, OTL-Oracle Time and Labor, OLM-Oracle Learning Management, I Recruitment.

Distributions: INV-Inventory, OM-Order Management, I procurement, PO-Purchasing, ASCP.

CRM: Marketing Online, Sales Online, Quoting

Oracle Manufacturing Modules: WIP, WMS, Shipping, Depot Repair etc

PROFESSIONAL EXPERIENCE:

Senior Applications DBA

Confidential, Palo Alto, CA

Responsibilities:

• DBA support for production & support databases of sizes up to 10TB with high availability solutions like Oracle RAC/ Physical standby database / DR/ PCP/ DMZ/ Multiple Web servers.
• Monitoring concurrent manager /jobs, workflow and web applications server.
• Automated cloning process using shell scripts to reduce the time taken from 3 days to 24 hours.
• Wrote shell scripts to apply EBS applications patches.
• Audited Application & database to makes sure that they are compliant with security standards
• Updating database & system passwords periodically to be in compliance with SOX audit.
• Apply quarterly CPU patches.
• Hosted RCA meeting to address the repeated issues and to reduce the downtime by records the incidents and the resolutions.
• Support for Code migration for multiple complex projects during weekly and monthly product releases.
• Attending CAB meeting to reviewed RFC on the implementation & rollback plan.
• Helped to streamline operation and brought stability to the engagement by writing SOP.
• Worked closely with cross functional technical team of LINUX system and network administrators, middle ware administrators in located in offshore & onsite.
• Worked with middleware team & Portal admin team to setup connection to external applications like SFDC (Salesforce) & Custom Portal applications.
• Presenting KPI at weekly operations meeting with stakeholders on SLAs.

Technical Environment: Oracle Enterprise Linux 5.8, Oracle Applications 11.5.10 CU2/R12, Oracle database 9i/ 10g / 11g, Oracle 10g AS, SSO, OID, SOA

Senior Applications DBA

Confidential, Sacramento, CA

Responsibilities:

• DBA support during the implementation of Manufacturing, Supply Chain, Financials and Human Resource modules.
• Wrote SLAs for DBA activities like cloning, patching, creating new instances and Application availability.
• Monitoring DBA tasks to record the number of service requests completed by DBAs.
• Worked on automating cloning procedure. Reduced the time taken for cloning applications to 3 hours which was earlier taking 2 days.
• Worked with network and UNIX team to setup Applications on the load balancer.
• Prepared cloning procedure for RAC to RAC, RAC to Non-RAC and single node databases.
• Provided shell scripts to automate applying application patches using ADPATCH & DEFAULTS file.
• Helped developers to automate code migration using FNDLOAD.
• Wrote backup and recovery scripts using shell and RMAN.

Technical Environment: Oracle Enterprise Linux 5.8, x86 - VM, Confidential, Oracle Applications R12 / PCP / Load balancer (Citrix), 11g R2 RAC.

Senior Applications DBA

Confidential, Irvine, CA

Responsibilities:

• Initiated kick off meeting with Business, UNIX, network & technical team.
• Worked with network team to add web site to DNS entry and to route the request to the website to the internal web server using reverse proxy.
• Worked with UNIX team and made sure servers and new aliases were available to setup web servers on the DMZ.
• Technical steps were documented and followed to setup applications on the DMZ and on the WEB using reverse proxy.
• Above procedure was done in a test environment and released to users for validation. Upon approval from Business users the same procedure was followed to enable external access in production environment.
• During my stay I helped the client in applying bug fixes and to secure E-Business suite (R12 - 12.1.3)

Technical Environment: Red Hat Linux 5.0, Oracle Applications R12.

Senior Applications DBA

Confidential, North Canton, OH

Responsibilities:

• Lead DBA for the implementation of Brazil CRM project (E-Business Suite 11i /11g database).
• Lead DBA for setting up physical standby database (Data Guard) to meet 30 minutes fail-over SLA.
• Support for implementing Human Resource modules (E-Business Suite R12/11g database).
• Production support for E-Business Suite running on Release 11i (11.5.10.2).
• Worked on setting up applications on the web (DMZ), multi node configuration, shared APPL TOP, parallel concurrent processing (PCP).
• Production support for 11g SOA.
• Upgraded Oracle Applications database from 11gR1 to 11gR2.
• Regular maintenance like patching, cloning, code migration & backup using RMAN.
• Monitoring & tuning database using 11g OEM.
• Supported database of size 2TB with 400 concurrent users.
• Database backup using EMC time finder.
• Worked remotely for 1 ½ years communicating with infrastructure team/ Business users and attending weekly DBA technical / Project status meeting.

Technical Environment: Red Hat Linux 5.0, Oracle Applications R12, 11.5.10 CU2, Oracle database 10g/11g.

Senior Applications DBA

Confidential, Bay Minette, AL

Responsibilities:

• Fixed the performance issue after narrowing it down to a custom code that was utilizing JAVA memory. This was affecting Apache web server which ends up restarting web server.
• As a temporary solution we moved the job to run after hours using concurrent manager setup. Cloning steps were followed to separate WEB server from concurrent manager server as a long term solution.
• Migrated EBS applications from a single node to multi node.
• Backup support for Oracle Portal - Maintaining Application server 10g.
• Also helped in regular maintenance like patching, cloning, code migration, securing database.
• Monitoring & tuning database using 10g OEM.

Technical Environment: AIX 5.3, Oracle Applications 11.5.10 CU2, Oracle database 9i/ 10g, Oracle 10g AS, Oracle Portal.

Senior Applications DBA

Confidential, San Antonio, TX

Responsibilities:

• Monitoring and tuning E-Business Suite after upgrading E-Business Suite from Release 11i to R12 (12.0.6)
• Implemented procedures for maintaining and securing the database and Applications.
• Regular maintenance like patching, cloning, code migration, securing database.
• Wrote shell scripts to apply application patches in non-interactive mode.

Technical Environment: AIX 5/6, Oracle Applications R12/ 11.5.10 CU2, Oracle database 9i/ 10g / 11g, Oracle 10g AS

Lead Oracle Applications DBA

Confidential, Sterling Heights, MI

Responsibilities:

• Performance tuning for large (2 TB) database.
• Worked closely with the Security Compliance Team on audit projects and other client specific security related projects.
• Meeting client’s SLA for DBA support and security patching.
• Worked on improving Oracle applications cloning process, setup of web servers to support 2000 concurrent OTL users, MWA module support, Quarterly OCPU patch application, support for 30 instances which includes applying patches, cloning, maintaining concurrent managers, backup using RMAN, etc.,
• Updating database & system passwords periodically to be in compliance with SOX audit.

Technical Environment: Sun Ultra Sparc Solaris 10, Oracle Applications 11.5.10 CU2, Oracle database 9i/ 10g / 11g, Oracle 10g AS, Oracle Portal, SSO, OID, SOA

Lead Oracle Applications DBA

Confidential, Southfield, MI

Responsibilities:

• Implemented Oracle Applications on the web with BIG IP as the load balancer on the DMZ.
• Upgraded Oracle Applications from Release 11i to R12.
• Installed Oracle Applications Vision Demo R12.
• Upgraded Oracle Applications from 11.5.9 to 11.5.10.2
• Implemented NLS for Oracle Applications (US, ESA, JA)
• Configured Oracle Discoverer 4i integrated with E-Business Suite.
• Upgraded Oracle Discoverer 4i to 10g.
• Upgraded Oracle database 9i to 10g.
• JVM tuning to support huge number of OTL and employee self service users.
• Extensive knowledge of ad utilities: adpatch, adctrl, adadmin & autoconfig
• Applied Vertex updates and updated legislative data by running Data installer and hrglobal
• Migrated Oracle Applications from single node to multi-node.
• Installed Oracle Applications server 10g to support Oracle Discoverer 10g.
• Wrote Shell Scripts to automate applying patches in non-interactive mode.
• Wrote Shell Scripts calling FNDLOAD to migrate custom responsibilities/menus from development to production instances.
• Developed scripts using oracle API to create/ end date, add/delete responsibility for application users.
• Extensive work experience with User Management Responsibility.
• Create View only System administrator responsibility for functional users to validate the migrated custom menus, responsibilities, concurrent program.
• Managed user accounts from User Management responsibility
• Wrote shell scripts to take hot and cold backups of database using RMAN.
• Worked on securing database. Implemented database listener password.

Technical Environment: Red Hat Linux 3.0/4.0, Oracle Applications 11.5.10, R12 Oracle database 9i/ 10g RAC.

Senior Oracle Applications DBA

Confidential, Buffalo, NY

Responsibilities:

• Implemented Business Intelligence System and EDW (Embedded Data Warehousing)
• Implemented Daily Business Intelligence System (Financial Intelligence, Human Resource Intelligence, Supply Chain Intelligence).
• Upgraded Oracle database to release 9i (9.2.0.4) which was a part of DBI implementation.
• Configured Oracle portal which is a pre-requisite for DBI implementation.
• Installed and configured Discoverer 4i with Oracle Applications which is a part of Business Intelligence implementation.
• Gained knowledge of OWB (Oracle Warehouse Builder) during BI & EDW implementation.
• Developed scripts to automate the cloning process of Oracle Applications Release 11.5.8
• Support for Oracle Applications with modules - Human Resource, Manufacturing, purchasing, financials.

Technical Environment: HP-UX 11.11, Oracle Applications 11.5.8, Oracle 9i, 8i

Senior Oracle Applications DBA

Confidential, Rockville, MD

Responsibilities:

• Installed Oracle Applications 11.5.8 for Public Sector - federal financials
• Upgraded Oracle financial Applications from Release 11.5.8 to 11.5.9
• Cloned Oracle Applications 11i using Rapid Clone.
• Cloned Oracle Applications 11i from single node to multi node using Rapid Clone.
• Helped the client in monitoring and tuning the Applications Release 11i and database 8i.
• Wrote Shell Scripts to automate applying patches in non-interactive mode.
• Worked on the maintenance of Oracle 9ias (Apache web server, Reports server, Forms server)
• Worked on Application System administration activities like using AD utilities, creating custom responsibilities, concurrent programs, printers and maintaining concurrent managers

Technical Environment: Sun Solaris 2.9, Oracle Applications 11.5.9, Oracle 8i

Senior Oracle Applications DBA

Confidential, Cleveland, OH

Responsibilities:

• Installed Oracle Applications 11i (11.5.7) for financials & CRM modules and patched them to 11.5.8.
• Cloned Oracle Applications 11i using autoconfig.
• Installation and maintenance of 9i database
• Upgraded Oracle RDBMS from version 8.1.6.3 to 8.1.7.4
• Configured Oracle Applications 11i (11.5.7) with Portal.
• Setup Discoverer 4i with Oracle Applications 11i (11.5.7)
• Worked on Application System Administration activities like creating custom responsibilities, menus and concurrent managers, registering users/ printers/ concurrent programs.
• Setup CRM users for Sales Online and Marketing Online.
• Wrote Shell Scripts to automate applying patches in non-interactive mode.
• Wrote Shell Scripts to migrate custom responsibilities/menus from development to production instance.
• Worked on the maintenance of Oracle 9ias (Apache web server, Reports server, Forms server)
• Monitoring and administering the database using Oracle Enterprise manager version 9.2.0.1
• Worked on tuning the Application 11i and database 8i.
• Wrote shell scripts to reduce the time taken to gather statistics of schemas/ tables.
• Wrote shell scripts to backup database using EMC Time finder.

Technical Environment: Sun Solaris 2.8, Oracle 9i (9.2.0.1), Oracle 8i (8.1.7.4)

Oracle Applications DBA

Confidential, Salt Lake City, UT

Responsibilities:

• Helped the client in the maintenance of Oracle database version 9i.
• Upgraded Oracle database from version 8.0.6 to 8.1.7.3.
• Wrote Shell Scripts to automate applying patches in non-interactive mode.
• Cloned applications to have a copy of Production to test the upgrade and to test bug fixes 11.0.3, 11.5.7.
• Helped the client to move the application 11.0.3 hosted by Confidential to the client’s site.
• Provided support for Financials and Distributions Modules - AR, AP, GL, FA, PO, INV, and OE.
• Wrote shell scripts to update the inventory tables using export/import in Oracle Release 9i.
• Wrote shell scripts to backup the database and application file system.
• Worked on tuning the financials applications 11.0.3 and database 8.0.6

Technical Environment: Sun Solaris 2.6, Oracle 9i (9.2.0.1), Oracle 8i (8.1.7.3) / 8.0.6.

Senior Oracle Applications DBA

Confidential, Troy, MI

Responsibilities:

• Lead DBA for the implementation and maintenance of Oracle Applications 11i and 11.0.3
• Upgraded Oracle Applications 11.0.3 to 11i (11.5.6).
• Upgraded Oracle Applications 11.5.1 to 11.5.6.
• Provided support for financial and distribution modules.
• Cloned Applications using adclone from production to development to test bug fix.
• Worked on tuning Applications 11i and 11.0.3 and database 8i, 8.0.5.
• Carried out recovery of the production instance from backup.
• Setup printers to be used in Oracle Applications and setup user accounts for file transfer process, and modified kernel parameters recommended by support to run Oracle database and Applications using system administration tool (SAM).
• Wrote Shell scripts using FNDLOAD utility for moving the responsibilities, menus and concurrent programs created in development instance to QA instance and then to Production instance.
• Wrote Shell Scripts for Hot and Cold database backups and implemented in EMC Timefinder backups.
• Wrote Shell Scripts to automate applying patches to Applications.
• Implementing EMC Service Guard for fail over of Production database from one system to another in HP Clusters
• Managing locally managed tablespaces and locally managed temporary tablespace in 8i database
• Cloning of 8i database
• Maintaining Concurrent Managers running multiple modules
• Creating custom responsibilities, menus and forms
• Creating view only Sys Admin responsibility for the support team to troubleshoot the issues to help support the Production

Technical Environment: HP-UX 11.0, Oracle 8i / 8.0.5.

Oracle Applications DBA

Confidential, Los Angeles, CA

Responsibilities:

• Worked on tuning Oracle Applications Release 11.0.3 and Oracle database Release 8.0.5.
• Assisted during the implementation of the OE module.
• Modified the Kernel parameters using SAM to increase the SGA for production database.
• Generated reports on Kernel parameters using SYSDEF and KMTUNE UNIX commands.
• Monitored HP UNIX for Memory, CPU, Disk I/O utilization using VMSTAT, IOSTAT.
• Resized other INIT parameters such as LOG BUFFER, SORT AREA SIZE, and LOG CHECKPOINT INTERVAL according to the database activity.
• Resized Rollback tablespace, Rollback Segments, and Temporary tablespace.
• Increased the Redo log file size to avoid frequent switching.
• Reorganized the whole database; distributing the data files across file systems to balance disk I/O, and recreated fragmented tables and indexes, with optimal storage parameter.
• Created separate the listeners for Application users and Non-Application users.
• Created separate workshift for Concurrent Managers to reduce the numbers of FSGs run in the daytime.
• Applied the required patches for EDI and OE as per Oracle recommendation.
• Performance tuned Customized Codes by enabling trace option and used TKPROF.
• Maintained the Web Server 4.0.8/3.0.2.
• Upgraded the database from 8.0.5.1 to 8.0.5.2.
• Pinned frequently executed packages for improving the performance.
• Scheduled concurrent program to purge FND CONCURRENT REQUEST table.
• Worked on purging the workflow tables as it grew rapidly and as the tables were in APPLSYS tablespace.

Technical Environment: Sun Solaris 2.6, Oracle 8.0.5.

Oracle Applications DBA

Confidential, Milwaukee, WI

Responsibilities:

• Provided support for Oracle Applications Release 10.7 and Oracle 7 database Release 7.3.4.
• Upgraded Oracle Server 7.3.3 to 7.3.4 for Oracle Applications Release 10.7.
• Provided support for production and development databases running Oracle Applications.
• Assisted during the implementation of AP, AR, GL and PA modules.
• Performance tuned financial databases.
• Created and maintained databases of size 120GB, which required support for 500 users
• Enabled auditing of database and wrote shell scripts to give a report of the same.
• Worked on ADSM backup and restoration process.
• Wrote Shell Scripts for Hot and Cold backups of Oracle database to ADSM Storage.
• Automated the process of replicating the production Oracle Application database to remote system for reporting purpose, using EMC Timefinder.
• Created the reporting database to reduce the load of production database during month-end processing.
• Worked on a Metrics project to get reports of critical values of parameters from different systems.
• Wrote Shell Script, which evoked SQL*Loader and Oracle procedures for the project.
• Installed Oracle Server Release 8.1.6 /8.0.5 in HP-UX B.11.0.
• Migrated Oracle database 7.3.4 to 8.0.5 using migration utility.
• Upgraded and applied required patches for all databases of lower version to 7.3.4 to get support from Oracle for undocumented and new problems.
• Monitored database growth and estimating the size of the same.

Technical Environment: HP 9000, B.10.20, Oracle 7.3.4, 8.x.

Oracle Applications DBA

Confidential, Milwaukee, WI

Responsibilities:

• Installed and maintained Oracle Database version 8.0.4 and 7.3.4.
• Provided support for a financial modules - General Ledger, Accounts payable, Accounts Receivables.
• Worked on tuning financial database for batch jobs.
• Modified kernel parameter SHMMAX using smit to increase Oracle SGA.
• Monitoring AIX Unix for Memory, CPU, Disk I/O utilization using vmstat, iostat, aiostat, top
• Performed backup and recovery where the database was on archival mode.
• Utilized platinum tools TSREORG for database re-organization and DBVISION for database monitoring.
• Upgraded Oracle database from 7.3.4 to 8.0.4.
• Cloned Oracle database versions 7.3.4 and 8.0.4.
• RS6000 AIX 4.2.1, Oracle 8.0.4/8.0.5/7.3.4

Oracle DBA

Confidential, Raleigh, NC

Responsibilities:

• Installed and maintained Oracle Database version 8.0.4
• Implementation and maintenance of Oracle database version 8.0.4
• Designed Data-Warehouse set up.
• Implemented STAR SCHEMA.
• Transferred data from SQL-Server to Oracle using Data Junction.
• Utilized Platinum Tools for re-organization of large tables.
• Utilized Oracle PQO, Parallel Query Option, to improve long running queries.
• Tuned SQL statements of long running queries.
• Recovered database under data file corruption.
• Cloned of database version 8.0.4.
• Changed archive destination when the destination device is full without shutting down the database.
• Selected software and hardware for the project.
• Supported Test/Development/Production databases.

Technical Environment: Sun Sparc, Sun Solaris 2.5, Oracle 8.0.4.

Oracle DBA

Confidential, RTP, NC

Responsibilities:

• Monitored and tuned the database by changing the init parameters.
• Migrated Oracle database from HP-Unix to Sun Solaris.
• Reorganized the database using Platinum Tools.
• Analyzed tables on regular basis for updating statistics.
• Created Shell Scripts to take backup of database.
• Cloned the Oracle database version 7.3.2.

Technical Environment: HP9000, Sun Sparc, HP B.10, Sun Solaris 2.5, Oracle 7.3.2.

Oracle DBA

Confidential

Responsibilities:

• Performed database administration for 260 databases.
• Cloned the database.
• Worked on tuning Oracle database versions 7.x.
• Reorganized the databases.
• Planned for backup and recovery.
• Performed systems administration tasks for HP and Sun Solaris systems.
• Created utilities for hot and cold backup of Oracle database.
• Created utilities to re-generate various objects such as tables, indexes, constraints, synonyms, which could be utilized during reorganization of database.
• Coded all programs with porting features to run in systems Sun, Solaris, and HP.
• Coded C & Pro*C programs to monitor & migrate Oracle database and also coded other custom applications.
• Created Shell Script used to shutdown and startup different Oracle instances.

Technical Environment: Sun OS 4.1.3, Solaris 2.0/2.3/2.5, HP - A.09.04/ B.10, Oracle 7.x/8.x.