SUMMARY

• Around 9 years of experience as an Oracle Applications DBA and Oracle core DBA with Oracle applications 11i and R12 . Experienced in 8i/9i/10g/11g Database administration & Oracle Applications 11i/R12 database administration.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS 9/10/11,UNIX, AIX and HP-UX Architecture, Installation, Cloning and Patching (version 11.5.8 to 11.5.10.2, 12.1.1 to 12.1.3). Installation, configuration and maintenance of Oracle 10g/11g RAC, 9iAS, 10gAS, 11i and R12 applications. Implemented High Availability solutions with Oracle 10g/11g RAC, ASM, FLASHBACK and Standby. (DATAGUARD). Experience in Oracle Financials HRMS R12. Experience in SOA management and experience in using VMWare.Expertise in OID installation and OID Configuration assistant. Good experience with performance tuning (OEM, Database Utilities). Good experience on OEM 11g grid control includes system monitoring. Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, INDEXES, EXPLAINPLAN, SQLTRACE, and TKPROF.
• Expertise in SSO in 10g and 11i environments. Experience in multi-lingual Oracle Application implementations on Oracle Applications 11i/R12.Experience in Schema Cloning, data loading and extracting using SQL Loader, oracleData pump Export (DPE)andData Pump Import (DPI).
• Expertise in OAM integration on 11gR1, 10gR3 (10.1.4.0.1-10.1.4.3.0). Expertise in planning, inventory, schedule, Q-gate in upgrading projects.Expertise on Solaris 9/10 Zones /11 platforms which include providing support to development and test databases on these platforms. Expertise in Database Tuning and backup and recovery. Expertise on Performance Tuning on Oracle E-Business suite, using OATM concepts post 11.5.10 versions. Worked with HANG Analyzer, system state dump, AWR analysis.
• Expertise on migrating database objects to the new tablespaces under OATM concepts Experience in platform migration from Sun Solaris to HP Linux as well as an upgrade from R11 to R12 and DB10G to DB11 and applying OATM. As an Oracle Apps DBA key responsibilities include Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers. Experience as Oracle Applications DBA providing support to many Production, Development, Test, CRP instances comprising some of the more complex and challenging environments from versions 11.0.3 through 11.5.10 and 12.1.1 through 12.1.3 with most effective modules being GL, Financials, AP, AR, BOM, HR/Payroll, OM, INV, OID, OWB, PA, PO, FA, MRP, MFG.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System Administration. Complete understanding in customization and workflow procedure for Oracle Apps Order to Cash (OTC) and Procure to Pay (P2P) life cycles. Experience in Implementation and Customization of Oracle Receivables. Experience in using Spreadsheet for the storage of financial data for remote computing and perform corporate consolidations with instant access to real-time data. Expertise in Importing Account Receivables data into Oracle Receivables. Strong Experience in Cloning & Patching Oracle 11i/R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite version 11.5.9 to R12 (12.1.1) and from versions before to 11.5.9 to 11.5.10 CU2 and then upgrading to R12 (12.1.1).
• Expertise in administering Oracle 11i/R12 Instances using AD utilities such as adadmin, adcntrl, adsplice, admerge, adpatch etc. Applied patches to update and security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2., 12.1.1, 12.1.2 & 12.1.3 and diagnostic patch sets prior to 12.0.6 using adpatch utility.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS, SOA
Databases: Oracle 8i, 9i, 10g RAC, MySQL 5.1
Operating Systems: Windows NT/2000/2003/XP, RHEL, UNIX Sun Solaris, AIX, HP-UX
Languages: C, C++, PHP, PERL, SQL.
Performance Tools: TKPROF, STATSPACK, Explain Plan.
Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer

EDUCATION : Bachelor of Technology.

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR Aug 2011-Till Date
Oracle Apps DBA
Responsibilities:

• 24x7 Production Oracle Applications Administration. Maintaining production, development& test databases and applications. Good knowledge on Oracle applications 11i and R12 Rapid Installation.
• Installation, maintenance, security, performance and tuning of Database Management Systems and related third party software, with emphasis on Oracle.. Ensured proper backup and recovery procedures (including standards) for the Oracle databases.
• Ensured close technical interchanges on database related issues with system administrators, hardware engineers, project managers, and operations personnel as necessary.
• Recommended and aided in the definition of database strategies, policies, standards, and procedures which are consistent with our mission. Promoted compliance with industry standards on database design/implementation issues. Provided estimates on human resource expenditures and hardware (disk, cpu, and memory) needed to support new projects or enhancements to existing our applications/products. Maintained industry awareness of database related products and provided feedback to vendors and management on database productivity/performance issues. Includes DBA support of database, daily maintenance and monitoring, upgrades and troubleshooting. Experience with Installation/Maintenance of Oracle ERP (R12,11i).
• Cloning, Patching, Code Migration, Performance Tuning, Capacity Planning, Database monitoring, User Management, Backup/Recovery Management, TAR Management, Monitoring Applications and its services.
• Responsible for the overall database administration, monitoring and control all of the organization\'s enterprise databases - RAC and Non-RAC (Oracle). Responsible for the creation, configuration, upgrade, backup, tuning, capacity planning & administration of multiple Oracle (8i/9i/10g/11g) databases. Understand and familiar with PCP, RAC, DataGuard, RMAN and other related technologies. Acted as liaison to Oracle ERP and other internal applications teams. Administered and maintain Oracle 8i, 9i, 10g and 11g on Solaris and Linux. Strong hands-on experience with scripting on SUN, HP, Linux using shell, perl.
• Responsible for providing database consultancy to internal groups in support of various applications (logical design, physical design, failover, DataGuard, etc.). Responsible for the day-to-day effective technical performance of the physical DBMS, including taking necessary action to improve performance and initiate recovery activities when system failure occurs. Responsible for database backup and recovery procedures to ensure the integrity of disaster recovery process using NetBackup, RMAN, DataGuard and/or SMO. Database Administration, tuning and support for the enterprise databases and systems. Maintain documentation and contribute to the ongoing development of new standards. Ensure that the proper disaster recovery procedures are in place and adhered to.

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(11.5.8,R12.1.3), Oracle 9i & 10g RAC, TOAD, Developer 6i, SOA, APEX.

Confidential, Carlsbad, CA Oct 2009-Jul 2011
Oracle Apps DBA
Responsibilities:

• 24x7 Production Oracle Applications Administration. Maintaining production, development& test databases and applications. Good knowledge on Oracle applications 11i and R12 Rapid Installation. Upgraded Oracle Applications R12 (12.0.4) Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Migrated Oracle Database to Oracle Database Gateway for Teradata to have full business enterprise features. Upgraded Oracle Applications 11.5.5.10 to 11.5.5.2 to 12.0.4 and Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows. Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities for upgrading R12 (12.0.4 to12.1.2). Created test environment through cloning production environment for developers to test on live data.
• Administration of Oracle ERP applicationsversion 11.5.10.2 and R 12.0.4. Good Knowledge in Data Modeling tools like Erwin. Setup and implementation of Oracle Financial Analyzer. Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement. Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, and INV. Validated different accounts and performed transformations in financial module using Financial Accounting Hub. Generated reports and financial consolidations with Oracle Hyperion Financial Management.
• Installed other supporting products for financial module like Oracle Essbase for modeling complex business scenarios and DRM/MDM. Experience in Implementation and Customization of Oracle Receivables.
• Generated several reports using Oracle iExpense (OIE) module in two projects. Advised and made recommendations to improve the overall database design.
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN). Involved in developing a disaster recovery (DR) plan. Perform SQL tuning and assist developers with coding PL/SQL. Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and productiondata feeds all via materialized views (replication). Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS.
• Automation of tasks like backup/refresh and other jobs using. Configuration of Workflow Notification Mailer, OAM, OEM10g. Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack). Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.

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, Ridgefield, CT Aug2008-Sep 2009
Oracle Apps DBA
Responsibilities:

• 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. Worked with Oracle On-Demand to apply HR RUP3 patch to development and production environments.
• System Administration responsible for application security, scheduling work shifts, registering new concurrent programs / request Sets. Participated in a team to maintain and support Oracle Applications in 24 X 7 environments. Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Supported and administered oracle discoverer 10g to resolve performance and other user issues. Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support. Upgraded JInitiator and other technology stack components in development environment.
• Researched various options for cloning of database and application environments using Rapid Clone and other cloning options to create an in house instance for internal research and development.
• Performance Monitoring, Space Monitoring / Capacity Planning, concurrent manager tuning. Configured Workflow Notification Mailer. Conduct Pre-patch analysis for different types of patches as requested by customer. Responding to different types of alerts related to Database and Applications. Troubleshooting / resolving issues with concurrent managers.
• Troubleshooting of Oracle Self Service Web Applications. Applied Oracle Projects Maintenance pack to Development environments. Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle 11i applications. Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Environment: Unix/Linux, SUN Solaris 8, Oracle Database 10g (10.2.0.4), Oracle Applications 11i (11.5.10.2), TOAD, SQL Loader, AD Utilities.

Confidential, Jacksonville, MI Dec 2006 - July 2008
Oracle Apps DBA
Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products. Evaluate Oracle features and Oracle related products .
• Establish and maintain sound backup and recovery policies and procedures. Take care of the Database design and implementation
• Implement and maintain database security (create and maintain users and roles, assign privileges). Perform database tuning and performance monitoring. Perform application tuning and performance monitoring. Setup and maintain documentation and standards. Plan growth and changes (capacity planning)
• Work as part of a team and provide 7x24 support when required. Perform general technical trouble shooting and give consultation to development teams
• Interface with Oracle Corporation for technical support. Patch Management and Version Control
• Implement and maintain the database design. Create database objects (tables, indexes, etc.)
• Write database procedures, functions and triggers. Assist developers with database activities
• Tune database queries. Monitor application related jobs and data replication activities

Environment: Unix/Linux, SUN Solaris 8, Oracle database 8i (8.1.7) & 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), HRMS, TOAD, SQL Loader, AD Utilities,

Confidential, Hyderabad, India Aug 2005 - Nov 2006
Oracle DBA
Responsibilities:

• Installation, configuration, and maintenance of Oracle 8i and 9i on both Windows NT and UNIX environments. Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Allocating system storage and planning future storage requirements for the database. Implemented Database Backup (Physical and Logical) and Recovery strategy.
• Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections.Creating Database objects like (Tables, views, indexes, procedures, triggers etc) and also monitoring Alert Logs. Using Database replication by shareplex.
• Creating & Maintaining Tablespaces.Choosing different types of data storages (Locally managed tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Utlbstat, Utlestat, Diagnostic and tuning packages.
• Plan and Implements backup and recovery of theoracle database Using Rman and Veritas Net backup.Creating and maintaining database cloning and database replication.Implementing Advanced Security in Databases using User, Roles etc. Data loads using SQL*Loader, export-imports for backing certain tables.
• Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.Back end Programming using SQL and PL / SQL and UNIX shell scripting. Modifies Oracle instance initialization parameters as necessary.
• Coordination with front-end developers in designing complex queries. Tuning of all the queries using Explain Plan, Tkprof and perfstat tuning of other objects in the database, tuning of database, tune the memory structure. Media Recovery (e.g.ww2 Hard disk failure, Block Corruptions) using archived logs.

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

Confidential, Hyderabad, INDIA Mar 2003 - June 2005
Jr.Oracle Apps DBA

Responsibilities:

• Responsible for managing production, development & test databases and applications. Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
• Involved in Upgrading of Oracle Version 8.1.7.4 &Oracle Applications 11.5.5, 11.5.2and supporting the production team. Cloning using Rapidclone, Autoconfig and adclone utility. Involved in database migrations cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
• In depth knowledge and experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adspliceandadctrl. Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps. Experience in web development using HTML, JavaScript, and XML. Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA, etc.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers. Using AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).
• Tuning the databases for optimal performance. Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts. Planning for storage spaces requirements and placing them for optimum I/O performance. Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Enabled Auditing featurefor tables such as FND_USER etc. Created new application messagesand then generated message filefor application. Created new concurrent managers, Purged concurrentrequests table.
• Wrote customPL/SQL packagesfor DBA related jobs such as purging custom tables, loading data into custom tables etc. Worked closely with users group to ensure timely implementation of an ERP.
• Provided application supportto users and created a log of all the problems with solutions for future reference. Good Knowledge of Oracle SQL & PL/SQL. Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
• Good experience and knowledge on Discoverer, Idiscoverer. Performed Patch Management.

Environment: Unix/Linux, SUN Solaris 8, Oracle database 8i (8.1.7) & 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), HRMS, TOAD, SQL Loader, AD Utilities,