SUMMARY

• Consolidated 14 years of IT experience in Sr. Oracle Applications DBA / Lead Oracle Applications DBA.
• Upgraded Oracle E - Business Suite EBS from 11.5.10.2 to Release 12.x and database from Oracle 11g to 12c.
• Experience providing 24x7 and on call support of large high availability production databases.
• Handled weekend, night time and holiday outages with focused effort to minimize downtime.
• Expertise in Installing, and Configuring Oracle Applications in Multi-Node environment.
• Proficiency with Backup and Recovery methodologies.
• Proficient in using AD Utilities, ADOP.
• Expert in Oracle E-Business Suite Database/System administration including Installation/Upgrade/Troubleshooting and Performance Tuning of Oracle E-Business Suite, Oracle Business Intelligence/middleware solutions, Oracle Discoverer Administration.
• Experience in Database Administration and Performance Tuning.
• Performed various Oracle Applications SYSADMIN tasks like registering users, registering custom concurrent programs, Defining custom applications, Defining printers, Creating responsibility and Workflow.
• Excellent communication, interpersonal and business interaction skills.
• Friendly, cooperative attitude, detail-oriented, analytical and self-driven.
• Setup automated scripts to monitor Database and Applications.
• Proficient with UNIX Shell Scripting.
• Experience in Oracle Application server administration.
• Exposure of and ability to co-ordinate and work closely with various project teams involving Business Users/End Users, Project Managers, Datacenter, Unix SysAdmin and Network personnel for successful implementations.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications Release R12 (12.2, 12.1.3, 12.1.1, 12.0.6), 11i (11.5.x), 11.0.3, 10.7 NCA/SC, (Financials, Manufacturing, Order Management, Supply Chain, HRMS, Payroll, Projects, Grants, Service, Contracts, CRM, E-Business Intelligence)

Databases: Oracle 12c, 11g, 10g, 9.2.0.x, 8.1.x, 8.0.3, 7.x

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: SUN Solaris, HP-UX, AIX, LINUX, VMWARE and Windows

Software Tools: Precise, STAT, Confio, Oracle Enterprise Manager, Oracle Express, Oracle ADI, BI Publisher, TOAD, Rapid SQL, PL/SQL Developer, Discoverer, Hyperion, PVCS, Serena Manager, Service Now, ITRS, Service Now

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Lead Oracle Applications DBA/Sr. Oracle Applications DBA

Responsibilities:

• Supported various modules like Financials, Procurement, E-Business Intelligence, Projects, Service, Workflow and Self Service applications in Production.
• Tuned Oracle databases, application programs and operating system.
• Coordination, analysis, design, implementation, and administration of IT solutions.
• Troubleshooting Apache, Concurrent Managers, Forms, OID, SSO, AD and Workflow.
• Recommendation of best practices for improvements to current operational processes and procedures.
• Oracle EBS and Database server configuration and maintenance.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Expert in troubleshooting operational problems in the Database, Applications, Concurrent Managers, Apache, Forms, Admin Server, Weblogic.
• Applied Oracle Ebusiness and database patches (Including one off patches, Rollup patches, Quarterly CPUs, PSUs)
• Managed security of Oracle EBS and Databases.
• Supporting user community 24/7 Production Environment.
• Troubleshoot
• Expert in troubleshooting operational problems in the Database, Applications, OID and AD.
• Applied patches for Globalization, Localization and NLS language patches.
• Implement and maintain AutoConfig on Production, UAT and Development.
• Supported implementing of new modules.
• Administration of backup procedures and COB plans.
• Performed several database and application upgrades.
• Clone production Oracle Applications environments for refreshing QA, Development and Test environments.
• Moved Physical servers to VMWARE and Cloud.
• Hands-on with DB and Application performance Improvement, JVM tuning, CM tuning, resolving WFM issues etc.
• Resolve Parallel concur
• Performed Application sizing, Application tuning, Capacity Planning and Server performance.

Confidential, Ramsey, NJ

Sr. Oracle Applications DBA/Oracle EBS DBA Architect

Responsibilities:

• Installed and configured EBS R12 application in a multi node RAC environment with F5 Load Balancing.
• Upgraded / Migrated Oracle Applications from 11i HP-UX to 12.1.3 on Linux with and Applications Load Balancing.
• Applied various Database / Applications patches as required. Also applied Quarterly CPU patches and monthly vertex updates.
• Performed multiple dry runs of R12 Upgrade.
• Upgraded Oracle Applications from 11i to Release 12.1.3.
• Tuned Oracle databases, application programs and operating system.
• Worked with technical, functional, users and Oracle Support (TARs) to troubleshoot and resolve issues.
• Installed and configured OBIEE 11g/10g.
• Carried out migrations between different environments including production.
• Supported various Financials, Supply Chain, Manufacturing, HR and Payroll, Order Management Modules in 24x7 Production Environment.
• Experience in Oracle Fusion Middleware.
• Installed and configured 10g/11g Physical standby with Data Guard for DR.
• Carried out DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Wrote shell scripts to monitor Oracle Database / Applications
• Handled weekend, night time and holiday outages with focused effort to minimize downtime.
• Experience in database reorganization, migration, capacity planning capacity.
• Clone production Oracle Applications environments for refreshing QA, Development and Test environments.
• Installed and configured 10g / 12c Grid Control to monitor various Production and Development databases.
• Managed security of Oracle Applications and Databases.
• Applied patches for Globalization, Localization and NLS language patches.
• Supported implementing of new modules.

Confidential, King of Prussia, PA

Sr. Oracle Applications DBA

Responsibilities:

• Installed and configured R12 application in a multi node RAC environment with Parallel Concurrent Processing and application Load Balancing.
• Supported various Financials, Supply Chain, E-Business Intelligence, Manufacturing, HR, Projects, Workflow, Public Sector, CRM and Payroll Modules in 24x7 Production Environment.
• Worked with functional, technical and Oracle Support (TARs) to troubleshoot and resolve issues.
• Supported Development/Functional Team resolving issues.
• Assisted the developers with data conversion and performance tuning tasks.
• Cloned and maintained multiple Oracle Database environments for Development, Testing, and UAT.
• Supported implementing of new Modules.
• Applied numerous RDBMS and Oracle Applications patches as required.
• Tuned Oracle databases, application programs and operating system.
• Involved in various activities like Oracle Apps Sysadmin tasks, managing concurrent managers and requests, supporting customization, applying patches, cloning, converted database to Multi Org.

Confidential, Ramsey, NJ

Sr. Oracle Applications DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.9 to 11.5.10 and 11.5.10.2 and database from Oracle 9i to 10g.
• Performed multiple dry runs of 11.5.9, 11.5.10 and 11.5.10.2 upgrade.
• Applied numerous RDBMS and Oracle Applications patches
• Worked with technical, functional, users and Oracle Support (TARs) to troubleshoot and resolve issues.
• Shared 24/7 primary on-call responsibilities with a highly dedicated and cross-trained Applications DBA team.
• Handled weekend, night time and holiday outages with focused effort to minimize downtime.
• Clone production Oracle Applications environments for refreshing development and test environments.
• Supported various modules like Procurement, Financials, E-Business Intelligence, HRMS, Order Management, Manufacturing, Projects and Workflow.
• Managed security of Oracle Applications.
• Oracle Applications Administration includes creating users, printer setup, menu changes, custom responsibilities registration, Workflow etc.
• Implemented new modules and global implementation.
• Applied patches for Globalization, Localization and NLS language patches.
• Performed Backup and recovery, performance tuning.
• Tested Backup solutions using EMC Clones.
• Migrated customizations from DEV, Test, and UAT to Production.
• Proficient in using AD Utilities
• Tuned SQL and databases using TKPROF, STATSPACK, and Explain plan, AWR / ADDR, Grid Control and Confio.
• Created and maintained multiple Oracle application database environments for Development, Testing, UAT and production.
• Handled day-to-day Applications DBA activities in Dev, TEST, UAT and Production environment.
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
• Testing and analyzing Oracle applications environment after patch application.
• Managed Concurrent managers in applications and managed its performance.
• Troubleshooting Apache, Concurrent Managers, Forms and Workflow.
• Performed installation of Application Express and upgraded Application Express from 2.2 to 3.0.
• Installed Release 12 Vision Demo.
• Configuration of Workflow Notification Mailer and Workflow Administration.
• Applied CPU security patches to Oracle Applications and Database.
• Performed patch analysis through Oracle Applications Manager.

Confidential, New York, NY

Sr. Oracle Applications DBA

Responsibilities:

• Supported various modules like Financials, Procurement, E-Business Intelligence, Projects, Service, Workflow and Self Service applications in Production.
• Upgraded Oracle Applications from 11.5.7 to 11.5.10.
• Upgraded Oracle Database from 9.2.0.2 to 9.2.0.6.
• Formulated a detailed plan on the Rel 11.5.10 upgrade.
• Applied various patches to Applications and Database.
• Managed security of Oracle Applications.
• Oracle Applications Administration includes creating users, printer setup, menu changes, custom responsibilities registration etc.
• Backup and recovery.
• Performed patch analysis through Oracle Applications Manager.
• Applied quarterly CPU patches to Oracle Applications.
• Migrated customizations from DEV, Test, and UAT to Production.
• Performed multiple dry runs of 11.5.10 upgrade.
• Proficient in using AD Utilities (adaimgr, adpatch, adctrl, adsplicer, admrgpch, adadmin)
• Troubleshooting performance issues and bugs.
• Carried out DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Configuration of Java Notification Mailer and Workflow Administration.
• Identify existing problems and rectify it by through necessary actions and Oracle support.
• Created and maintained multiple Oracle application database environments for Development, Testing, UAT and production.
• Refreshed and cloned Oracle Applications system for Test, UAT and Development using Rapid clone.
• Wrote shell scripts to monitor Oracle Database / Applications
• Worked with functional, technical and Oracle Support (TARs) to troubleshoot and resolve issues.
• Performed patch analysis through Oracle Applications Manager.
• Handled day-to-day Applications DBA activities in Production environment.
• Testing and analyzing Oracle applications environment after patch application.
• Troubleshooting Oracle Applications and using TAR.
• Supporting user community 24/7.
• Managed Concurrent managers in applications and managed its performance.
• Troubleshooting Apache, Concurrent Managers, Forms, Workflow.

Confidential, Atlanta

Lead Oracle Applications DBA

Responsibilities:

• Supported multiple implementations of 11.5.9 for various clients.
• Upgraded various applications from 11.5.7 to 11.5.9.
• Handled day-to-day Applications DBA activities.
• Worked closely with clients functional and development team during implementation.
• Created and maintained multiple Oracle Application Database environments for Development, Testing and UAT.
• Converted database to Multi Org.
• Performed multiple dry runs of 11.5.9 upgrade.
• Co-ordinate / Delegated tasks to DBA Team members.
• Handled day-to-day DBA activities using oracle utilities and tools, monitoring space and memory requirements and Memory tuning.
• Experienced in Cloning Oracle applications.
• Supporting user community 24/7
• Setup automated scripts to monitor Oracle Database Applications.
• Proactively searching and applying patches.
• Proficient with UNIX Shell Scripting.
• Created Applications Users, Custom Responsibilities, Request Sets, Menus, Functions and Registered Printer.
• Managed security of Oracle Applications.
• Supported various modules like Financials, Procurement, Workflow, HRMS, Sales, Grants, Service, Public Sector, CRM, Self Service applications.
• Installed and configured 11.5.9 application in a multi node RAC environment with PCP and application Load Balancing.
• Worked closely with functional and development team during implementation.