SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with over 8+ years of 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.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3.
• Expert in upgrading Oracle Databases 10g to 11g, 10g to 11gR2 for 11.5.10 Instance, 9iRAC to 10gRAC for R12 Instance.
• Able to see applications in full context, from end user, to the database, OS and back to the hardware.
• Experienced with Disaster Recovery planning, testing and implementation
• Works with minimal direction and within a cross functional team.
• Experienced in Working as a team, Lead a team or working individually on various projects according to the requirement.
• Leadership skills to build and guide Infrastructure and production support teams. Experience in working with global teams in onshore/offshore model.
• Experienced in planning, coordinating and implementing infrastructure/operational projects in support of business goals and objectives.
• Performing Concurrent Manager Setup and trouble shooting.
• System Administration of Oracle Apps.
• Managed major hardware and database upgrades, database migrations for multiple applications in heterogeneous environments.
• Knowledgeable in PM methodologies and project management best practices.
• Proficient in communicating with management, vendors, and internal departments to coordinate overall IT efforts.
• Experience in analyzing the model and architecture for the Oracle Database and Oracle Applications implementations.
• Role of BI admin as well to perform the installations and configurations of the whole Reporting structure.
• Experience in installation and configuration of Informatica(ETL) and DAC on 11g.
• Expert in opening up service request with Oracle support and working on it.
• Expert in analyzing the upgradation and migration strategies for Oracle Applications and Oracle databases.
• Experienced in Implementing and working with Oracle & VMWARE VM manager.
• Experienced in Working with the F5 Load Balancing Techniques (GTM).
• Extensive experience in tuning the Oracle Applications implementation.
• Extensive experience in installing/creating Oracle databases and Oracle Applications in RAC environment.
• Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning).
• Good experience and knowledge in Oracle Applications system administration such as Managing Concurrent Programs and Requests, Configuring Printers, Reports, Administering Concurrent Managers and Work.
• Expert in Cloning using Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow mailer Notification Issues.
• Sr. Oracle Applications DBA with 7+ years of IT experience as an Oracle Apps DBA and Good experience in Oracle E - Business Patching, upgrading and Load Balancing.
• Proficient Experience with Standby Database, Data guard, Installation and implementing RAC Database as an Oracle core DBA.
• Being a Oracle DBA/APPS DBA has worked on all releases of Oracle and Experienced in Oracle database 8i/9i/10g/11g Database administration &Oracle Applications 11i, R12.
• Can effectively and efficiently handle any implementations.
• Experienced and skilled in working with different environments/versions and server administration including Solaris, Linux and Windows System Administration.
• Proficient in Multiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade from 11i to R12.
• Architecture, Installation, Cloning and Patching (version 11.5.5 to R12)
• Pre-Patch analysis for the patches and document preparation with pre and post patch installation steps.
• Proficient in installation, maintenance and upgrading Oracle Applications 11i e-business suite to R12 Versions successfully within the stipulated timeframe and allocated Budget.
• Oracle Applications cloning from production to Test, Dev and Patch instances using Rapid clone.
• Oracle Database Infrastructure experience on Single node, multi-node and RAC
• Installation and configuration of Single or multi node APPS Middle Architecture with Load Balancing.
• Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Implemented, supported and upgrades on various modules such as Financials,I-Store, MFG,WMS, CRM, AR, AP, GL, QA, PO, and INV.
• Skilled in handling upgrades on various modules including Human capital management,Financial management and payrolls.
• Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink
• Administrate the forms and reports using with AU utilities
• Application’s sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, Alerts.
• Experienced with database design, creation, security, operation and maintenance
• Expert on SQL*Net - distributed Oracle
• On-call 24x7x356, rotated when other DBAs present
• Sound knowledge of application life cycles including requirements, design, development, support and maintenance.
• Provided sr. level technical expertise in system administration, application administration and automation using Unix shell scripting.
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• In depth understanding in UNIX administration, Project Management, Perl Scripting and Technical documentation
• Skilled in OID installation and configuration assistant
• Experience in general troubleshooting, fire fighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Strengths include skills in Shell Programming, SQL and PL/SQL.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Performing R&D and analysis to benefit from new releases/features of Oracle Database.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

Applications: Oracle EBS 11i, R12, Oracle Application Server 10gAS, Oracle Application Server 9iAS

Databases: Oracle 8i, 9i, 10g RAC, 11g, MySQL

Network Storage: Confidential, EMC Symmetrix and Clarion storage systems.

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX

Languages: C, PHP,SQL/ PL/SQL, UNIX Shell programming

Other Software: Oracle Enterprise Manager(OEM), NetBackup, F5, DAC, Autosys, NDM RMAN,Toad, SQL*Loader, SQL*Import/Export, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps DBA

Responsibilities:

• Worked as Sr. DBA, OBIEE administratorand production support lead.
• Hands on experience with database administration for several Oracle database instances in Unix environment including Oracle (9i, 10g and 11g) installs, database creation, database upgrades and data migration.
• Worked with EBS( R12,11i), OBIEE (10G and 11G), ASCP ( R12) applications .
• Provided on call support for OBIEE, database and EBS application support.
• Worked as application DBA to resolve performance issues, user issues and network related issues.
• Worked extensively to resolve performance issues around WMS module Warehouse guns and scanners.
• Participated in devising and implementing backup-recovery strategy for database, application and servers.
• Worked extensively with the technical team to implement standard Code Migration process across the environment and documenting the same.
• Provided sr. level technical expertise in system administration, application administration and automation using Unix shell scripting.
• Lead several critical issue resolution calls including coordination and detailed follow-up with cross functional teams across organization.
• Worked extensively to implement proactive monitoring for database and application services.
• Performed R12 Upgrade from version 12.1.2 to 12.1.3 and database upgrade from 11.2.0.1 to 11.2.0.3
• Lead the Team successfully in one of the main project Data Center Migration.
• Extensive work in Cloning of Database and Applications and come up with a detailed Cloning documentation.
• One of the Major project I had to deal with was PCI compliance Project, Made sure we followed the norms and the company was PCI complaint.
• As part of it, I had to list out all the servers in the scope of PCI, apply Encryption patches before the data center Migration.
• Performed and Involved in numerous application and database tuning assignments on Oracle Applications, OBIEE application, ETL jobs, legacy, custom and third party systems..
• Creating Test environment through cloning production environment for developer to test on live date.
• Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink
• Responsible for coming up with an APPS READONLY access, tested it on one of the Test environments and moved it to Production.
• Provided lead support for Capacity Planning, Performance Tuning, Database Architecture, Data Modeling, Logical-Physical Design, and backup-recovery of enterprise-wide database applications.
• Worked closely with BI architect to come up with a new Reporting structure and helped in Securing an Environment.
• Worked in Implementation of BI APPS, Responsible for Installation and configuration of various applications of BI as part of reporting Project namely Informatica, OBIEE 11G, DAC and BI APPS(on Windows).
• Implemented and supported enterprise standards in use, management and deployment of database technology.
• Deployed Oracle Enterprise Manager (OEM) to monitor database instances, to improve database and application availability.
• Use of Data pump extensively to move data across the environments.
• Played a key role for the end to end Upgrade of Oracle Application 11.5.10.2 to R12.1.3 & DB from 10.2.0.4 to 11.2.0.3 with OATM migrated. OPM up-gradation was a key factor for this upgrade.

Environment: Oracle Enterprise Linux 5/6,AIX, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0), 10g (10.2.0) 11g (11.2.0.1), Oracle Applications EBS 11i/R12, Oracle ASCP R12, Oracle RAC 11g, OBIEE 11.1.x, Informatica 9.1.0, DAC, TOAD, Developer 6i .

Confidential

Oracle Apps DBA

Responsibilities:

• Worked as Sr. DBA, Informatica administrator and production support lead.
• Hands on experience with database administration for several Oracle database instances in Unix environment including Oracle (9i, 10g and 11g) installs, database creation, database upgrades and data migration.
• Provided on call support for ETL, database and application support.
• Worked as application DBA to resolve database performance issues.
• Implemented measures to enhance database availability and performance.
• Participated in devising and implementing backup-recovery strategy for database, application and servers.
• Provided sr. level technical expertise in system administration, application administration and automation using Unix shell scripting.
• Lead efforts to optimize several processes used within support team to improve team efficiency.
• Lead several critical issue resolution calls including coordination and detailed follow-up with cross functional teams across organization.
• Led efforts to implement proactive monitoring for database and application services.
• Worked with Oracle to successfully Integrate Oracle Applications 11i andR12.1.2 on AIX to RHEL 5.7.
• Performed 11i to R12 upgrade with migration Oracle Database from AIX to RHEL 5.7 to have full business enterprise features.
• Experience in Cloning of Database and Applications.
• Install and upgrade to 11.5.10 with the Forms, Web Server, Reports and Concurrent Mangers on Sun Solaris node.
• Performed and Involved in numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Integrating and maintenance of Oracle Applications 11i and R12 on AIX and RHEL.
• Creating Test environment through cloning production environment for developer to test on live date.
• Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink
• Responsible for setting up and maintaining different ETL environments.
• Provided lead support for Capacity Planning, Performance Tuning, Database Architecture, Data Modeling, Logical-Physical Design, and backup-recovery of enterprise-wide database applications.
• Implemented and supported enterprise standards in use, management and deployment of database technology.
• Completed Informatica upgrade project in record time of 2 months.
• Successfully negotiated Informatica and Oracle licenses to save significant dollars for the company.
• Completed Oracle 10g upgrade in house without any consulting help, thus saving a company around $125,000.
• Deployed Oracle Enterprise Manager to monitor database instances, to improve database and application availability.
• Evaluated and standardized query tool enterprise wide.
• Data migration across Oracle schema using Import/Export.
• Configuring more than 500 targets for monitoring by Oracle Grid control & defining notifications for critical alerts
• Configure SOA, OBIEE, Demantra, Aventex, Markview, and Approwx

Environment: Red Hat Linux 4/5,AIX, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, 11g, Informatica 9.0.1, DAC, TOAD, Developer 6i .

Confidential

Oracle Apps DBA

Responsibilities:

• Worked with Oracle on-Demand to successful Upgraded Oracle Applications R12.1.0 to R12.1.2 and R12.1.2 to R12.1.3 on RHL and Solaris versions
• Performed 11.5.8 to 11.5.9 upgrade with migration Oracle Database from Windows NT to Sun Solaris 9 to have full business enterprise features.
• Applied patches for R12.1.0 and R12.1.2 and patches using ADPATCH,ADCTRL,ADADMIN
• Install and upgrade to 11.5.10 with the Forms, Web Server, Reports and Concurrent Mangers on Sun Solaris node.
• Performed and Involved in numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Installed and configured an Oracle Applications Release 11i (11.5.10) environment with Oracle database 9i Release 1 (9.2.0.5).
• Installing and maintenance of Oracle Applications 11i on Windows NT/2000 and Sun Solaris
• Creating Test environment through cloning production environment for developer to test on live date.
• Cloning of application and the database by using autoconfig.
• Coordinating with Oracle Technical assistance Team to resolve any issue relating to ERP
• Using AD utilities to maintain applications by compiling Apps Schema, Maintain Application Object menu, maintaining snapshots of the application using adamin and adpatch utilities for application of patches.
• Configuring notification mails from application to send it across to the user Inbox in Microsoft exchange for users for Purchase Orders and Quotation approvals as per the hierarchy set in the application.
• Configuring and setting printer setting and printer style for check Printing and other application Program
• Implemented and supported on various modules such as Financials, MFG, CRM,AR, AP, GL, QA, PO, and INV
• Validated different accounts and performed transformations in financial module using Financial Accounting Hub
• Troubleshooting of Oracle self Service Web Applications.
• Involved in Frequent Monitoring of alert log, system log, for information or errors and resolve the same based on the logs
• Monitoring database for fragmentation and de-fragmenting of tables. Reorganization of the tables, table space Refreshing development database from production for testing
• Online / Offline backup of database using the archive logs and the sun operating system backup using at command.
• Planning and Administration of backup and recovery strategies and Involved in the Disaster recovery Plan in the event of database crash to recover without any loss of any data.
• Improving performance of enterprise Manager by Analyze, drop and recreate indexes and manually through command prompt.
• Implementation, Upgrade and Support of Oracle 10g Applications server and Database .
• Performance tuning of Oracle database, Applications and queries.

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i .

Confidential

Oracle Apps DBA

Responsibilities:

• User management and work as part of a team and provide 24x7 production support of type on-call operations.
• Supported and administered oracle discoverer 10g to resolve performance and other user issues
• Worked with Oracle On-Demand to successfully upgrade Oracle Applications Database from 10.2.0.2 to 10.2.0.4
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics
• Handled weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• Responsible for support, upgrade and maintenance of Oracle Applications 11.5.5.on Linux and Solaris(version 8) operating systems
• Provide regular status reports and support/maintain project plans.
• Cloning Oracle Apps instances (11.5.5, 11.5.9) multiple times using Rapid Clone utility.
• Applying patches (family packs, mini-packs), install new products.
• Extensively used Oracle AD utilities on a day-to-day basis.
• Enabling autoconfig for Oracle Apps Instances.
• Managing forms server, forms metrics server, Apache web server.
• Provided on-call support for production applications.
• Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule and purge requests.
• Troubleshooting & Diagnosis of Sysadmin activities (including User management,
• Concurrent Manager Admin, APPL TOP Management, Schema Analyze, Report/forms server management).
• Responsible for research and installation of Critical patch updates every quarter.
• Use FNDCPASS to change APPS, APPLSYS and other application schema passwords.
• Migrating objects from Test to UAT and UAT to Production, representing changes as necessary in Change Management.
• Responsible for creating automated scripts and setting up jobs in Autosys and crontabs.
• Strong understanding of the Oracle technology stack and architecture for Oracle Applications.
• Perform instance monitoring, analysis, debugging, and tuning.
• Design procedures for business continuation planning (daily backup and recovery as well as backup integrity checks) as required by system-availability agreements for each application.
• Strong technical expertise on data issues and independently performs analysis, design, testing, and monitoring of databases across multiple platforms, technologies, and computing environments.
• Responsible for system administration functions: setup executables, users, responsibilities, concurrent programs, backup, tuning, monitoring, patching, cloning, and upgrades.
• Performance tuning of the Application and Database.
• Use of Oracle export and import utilities to get objects from Production to Test and UAT.

Environment: Oracle Applications 11i(11.5.9), Oracle 8i/9i, HP UNIX TRU-64, Precise, OEM, SQL* plus, SQL Developer, Toad, Oracle Discoverer, JDK 1.1/1.3.1