SUMMARY

• Nearly 7 years of experience as an Oracle DBA, Applications DBA managing E - Business 11i and R12 with Financials, MFG, ASCP, Demantra, Istore and HRMS on LINUX, SOLARIS, AIX,HP-UX platforms.
• 4+ years of experience with RAC, Standby Database, Data Guard, Replication.
• Installation, configuration and maintenance of Oracle 11g RAC, 9iAS/10gAS and 11i applications and R12
• Implemented High Availability solutions with Oracle 11g RAC, ASM, FLASHBACK and Standby (DATAGUARD).
• Expertise in Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Expertise in dot release upgrades of E-Business 11i with maintenance packs.
• Experience in Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Expertise in Cross Platform Migrations of E-Business 11i & 10g Databases.
• Strong Experience in Cloning & Patching Oracle 11i Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i E-Business suite to R12 (12.0.4).
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Applied patches to update and security fixes to Oracle E-Business Suite 11.5.10.2,R12.0.4,R12.1.1
• Expertise in converting single instance database to RAC/ASM with E-Business 11i
• Superior support and maintenance of Concurrent managers (ICM) and Parallel concurrent Process (PCP).
• Installed and Configured ODI, OID, OBIEE,DRM, DMZ, Hardware Load Balancing
• Oracle 10g/11g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Installing, configuring and maintaining Oracle Grid Control (11g grid).
• OEM Grid Control was setup for monitoring Oracle fusion 11g infrastructure and Configured Oracle Web Logic Server 11g.
• Extensive knowledge in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS PACKAGE STATSPACK, TKPROF and Explain Plan.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR.
• In depth experience with UNIX administration, Project Management, and Technical documentation.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g ASOracle Application Server 9iAS

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

Operating Systems: RHEL, Sun Solaris, AIX, HP-UX, Oracle Linux

Languages: C, C++, Java, PHP, PERL, SQL

Performance Tools: TKPROF, STATSPACK, Explain Plan.

Others: AD Utilities, SQL * Loader, TOAD, XML/BI PublisherWorkflow Builder, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Sr. Oracle Apps DBA

Responsibilities:

• Implemented the UPGRADE Oracle Applications EBS from 11i, 11.5.3 to R12.1.3.
• Installed OEM Grid Control for monitoring the Applications, middleware services and database services.
• Implemented 11g (11.2.0.3) RAC in test and production environments.
• Experience on administration knowledge supporting WebLogic Server such as monitoring and bouncing the services.
• Applied Patches using ADPATCH and applied multiple patches on merging using ADMRGPCH, patch wizard in pre-installed and test modes.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family packs, CPU patches, Patch Sets.
• Setup OEM Grid Control to monitor Oracle databases and Application services.
• Experience in refreshing, cloning the application environments for 11i and R12.
• Worked on Exporting/Importing, sharing the folders and worksheets to user from one environment to another using Discoverer 10g and 11g.
• Worked on KINTANA (PPM) to migrate the custom code and objects from one environment to another.
• Applied patches using ADPATCH, ADCTRL utilities.
• Maintenance and support of Development, Test and Production environments.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Expert in trouble shooting Oracle Workflow notification mailer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Oracle OID/SSL/Single Sign-on Implementation and Support.
• Expert in configuring SSO for Oracle Applications 11.5.10.2 / R12.1.3
• Worked on configuring 11g OAM with R12.1.3 for SSO
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Configured DMZ for i-store and i-expense modules.
• Designed DR fail over concepts for Oracle Applications using Active Data guard.
• Planning for Backup and Recovery of database information and maintaining Hot Backups.
• Experience with Export, Import, and Data pump utility.

Environment: Red Hat Linux 5, OEL 6, 11g R2, Oracle Applications EBS 11i, R12.1.1 and R12.1.3, 11g RAC, TOAD, Discoverer 10g and 11g, KINTANA(HP PPM v. 9.20), Developer 10g.

Confidential, Ramsey, NJ

Sr. Oracle Apps DBA

Environment: HP UX 11.31, Red Hat Linux 5, OEL 6,11g R2, Oracle Applications EBS R12.1.3, 11g RAC, TOAD, Developer 10g

Responsibilities:

• Implemented 11g (11.2.0.3) RAC in both test and production environment.
• OEM Grid Control was setup for monitoring Oracle fusion 11g infrastructure.
• Configured R12 E-business suite in DMZ in test and production environment.
• Installed Data Relationship Management (DRM) and supported it.
• Installed Oracle Internet Directory in HA mode.
• Configured SSO in HA mode.
• Integrated OID with E-business suite.
• Installing and configuring Oracle applications Table space Model ( OATM) Migration utility
• Oracle applications databases Converting to OATM
• Oracle SOA 11g clustering setup was done and resolved all platform.
• Knowledge on administration experience supporting WebLogic Server including installation, configuration and monitoring.
• Adpatch and Admrgch, Patch wizard.
• HRMS/Payroll End of Year patching(EOY), Vertex tax updates
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• Installed, configured, and deployed Oracle Enterprises Manager repository(Grid Control) and OMS Server for Monitoring and sending alerts.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Configured RMAN backups.
• Determined the Oracle RAC architecture.
• Supported team members and ensured that established deadlines and client needs were met.
• Provided guidance on best practices and hardware configuration.
• Configured ASM using RAW devices for CRS and database files storage.
• Installed and tested Single Client Access Naming (SCAN) using DNS and GNS for connection failover.
• Extensive work on Oracle Apps Advanced topology including Multiple Middle Tier, DMZ setups, configuring Internet facing secured Self Service Tiers, Parallel Concurrent Processing, and Shared APPL TOP.
• Performed non-rac to rac and rac to non-rac cloning.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Applied patches using ADPATCH, ADCTRL utilities.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.

Confidential, Adrian, MI

Oracle Apps DBA

Environment: Red Hat Linux 4/5, SUN Solaris 10, 9i (9.2.0) & 10g (10.2.0), 11g R1, Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i.

Responsibilities:

• 24x7 Production Oracle Applications Administration with E-Business 11i and R12
• Successfully upgraded 11.5.10.2 to R12 with 9.2.04 to Oracle 10g.
• Maintaining production, development & test databases and applications.
• Upgraded Oracle Applications database 9.2.0.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Applications 11.5.10.2 to R12
• Converted single instance e-business database to Oracle 10g RAC
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Applications/Database Cloning & Refresh using RAPIDCLONE
• Administration of Oracle ERP applications version 11.5.10.2 and R12
• Good Knowledge in Data Modeling tools like Erwin & Oracle Financial Analyzer.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, HRMS and INV.
• Conducted pre patch analysis for the patching of the Oracle E-Business Suite 11i.
• Applied the HRMS RUP 3 patch and OracleHRMSQ1-2009 SQWLpatches to development and production environments.
• Configured Clusters on WebLogic using WebLogic Console.
• Upgraded 10g SOA Cluster to 11g SOA Cluster.
• 24*7 on-call production support for high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Involved in developing a disaster recovery (DR) plan.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family packs, CPU patches, Patch Sets.
• Planning and Administration of backup and recovery strategies & configuring backups using RMAN & hot and cold backups using Net App snapshots.
• Installed and configured Single Sign-On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Oracle OID/SSL/Single Sign-on Implementation and Support.
• Oracle Data Guard Implementation for HA and remote DR site.
• Performance tuning of Oracle Database, applications and queries.
• Installation & Integration of Demantra with ASCP environment

Confidential, Westport, CT

Oracle Apps DBA

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

Responsibilities:

• Provide production support for Phase I, which included the Financials Suite on HP UX 11i using 11.5.10.2 CU2 on 11gR1.
• Implemented RAC for test environment.
• Patch analysis, planning and application to all environments per client request.
• Provide weekly clones of production for development and test instances.
• Created post clone procedures that include modifying sensitive production data.
• Configured and implemented OEM to manage all instances.
• Implemented RMAN for production and test environments
• Created and implemented change management procedures for all environments.
• Resolve performance issues with custom code (reports, forms, workflow, concurrent reports, mviews etc)
• Wrote shell scripts to email and alert Production DBA team of server status.
• Successfully upgraded Oracle Applications Database from 10.2.0.2 to 11.1.0.7
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Upgraded JInitiator and other technology stack components in development environment.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Configured Workflow Notification Mailer for inbound and outbound processing

Confidential, Alabama

Oracle Apps DBA

Environment: Unix/Linux, SUN Solaris, Oracle database 9i (9.2.0), 10g (10.2.0.3) Oracle Applications 11i (11.5.10, 11.5.10.1, 11.5.10.2), TOAD, SQL Loader, AD Utilities.

Responsibilities:

• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Monitored the growth of Table spaces to seize the fragmentation and available space for growth. Check for log and trace files.
• Applying patches for enhancement and fixing bugs using Adpatch, Opatch. Clone 11i instances for developing and testing purposes.
• Creating the custom Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent Manager operations.
• Implemented more effective backup procedures of databases
• Enrolled users, maintained system security, monitored user access to the database by assigning profiles and roles
• Administered and supported Oracle Application Manager (OAM).
• Responsible for maintenance and troubleshooting the database
• Planning for Backup and Recovery of database information and maintaining Hot Backups
• Experience with Export, Import.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of SysAdmin.
• Registering the new Forms, Reports, SQL loader, PL/SQL scripts as concurrent programs as part of technical.
• Trouble shoots the database related issues.

Confidential

Oracle DBA

Environment: Unix/Linux, SUN Solaris, Oracle database 9i (9.2.0), 10g (10.2.0.3), TOAD, SQL Loader.

Responsibilities:

• Responsible for managing production, development & test databases.
• Experience in web development using HTML, JavaScript, and XML.
• 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.
• Wrote custom PL/SQL packages for jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Involved in writing statements in Oracle SQL & PL/SQL.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Performed Patching using Opatch.

Confidential

Oracle DBA

Environment: Linux 2.4, Oracle database 9i and 10g, OEM, PLSQL, SQL Loader.

Responsibilities:

• Responsible for managing and support all Development and Test instances of Oracle databases.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 9i to Oracle Release 10g
• 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.
• Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.