Summary:

• Oracle Team Leader/Architect with 17 years of IT experience primarily in ORACLE Database Technologies working in Applications 11.0.3/11i/12i and other applications running on Unix and Windows based Operating Systems. Has performed roles of Database Architect, Applications administrator and System Administrator.
• Total 17 years of experience in IT Industry as an Oracle Apps DBA / Developer in Administration, Testing, Maintenance and support. Extensive experience as an ORACLE Applications DBA in a variety of different environments like AIX, SUN SOLARIS, Linux, HPUX
• Experience in Vendor Management. Very well versed with Offshore and Onshore model
• Experience in Change Management Processes. governance processes, and development and release procedures driving improved efficiency and satisfaction, and meeting SOX requirements
• Experience in the implementation of Tier 1 ERP Solution where more than 20 sites has gone live on the Oracle ERP Global System. Managed single global instance.
• Mentored, coached, and managed junior DBAs also helped them with technical issues
• Planned and provided guidelines for Database security, capacity plan, and DR service
• Worked as a bridge between senior management and technical staff to escalate and resolve any urgent issues and take ownership of Sev1 DBA issues and follow through Oracle support service
• Prioritize the work and assign work based on business criticality and functionality.
• Oracle Applications Release R12, 11i installation Configuration Good problem-solving capabilities.
• Responsible for installation, upgrades, patches, TAR support, concurrent manager administration,
• Duties included database creation, database tuning, Web Server, backup/recovery General, troubleshooting, script development, and documentation.
• Installed and patched R12.1.1, 11.5.8, 11.5.9, 11.5.10.2 instances.
• Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig
• Cloning R12, 11i databases using through oracle applications and rapid clone technique.
• Appling the OS patches for Linux R12, 11i and Oracle Application patches and upgrade the Application databases from 9.2.0.4 to 9.2.0.5/10g/11g.
• Performed backups and tested crash recoveries using conventional Hot Cold backups
• Expertise in installing, maintaining and administering Oracle Applications 11i 11.0.3, 11.5.9, 11.5.10, R12 instances. Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Upgraded the Oracle Applications from 11.5.8 to 11.5.10.2. Upgraded the database from 9.2.0.8 to 10g to 11g.
• Export and Import of Database, DB link creation. Expertise in handling Many Oracle Applications Databases with sizes varying from 500 GB to 4 TB. Providing application support and backend database support. Experienced in Oracle Apps Administration and Sysadmin tasks
• Family Pack Patching for the 11.5.10.2 Modules
• Implementation of High Availability solutions with Oracle 11g RAC, Physical Standby Databases Data Guard . Thorough Experience with supporting the Production Database with Complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery.
• System Administration of Oracle Application using Application Object Library and System administration module, using listed tasks: Registering New Application, Registering New schema, Registering Customized Tables using Application Standards, Creating new customized responsibilities, Menus, Request group, Functions, Concurrent programs. Administering Concurrent Processes and Managers and Automating the Request
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Monitor system performance, identify bottlenecks and ensure problem resolution.

Technical Skills:

ORACLE Apps: ORACLE Applications 11.03/11i 11.5.x, 11.5.10 , 12i AOL, Sys Admin, OLTP, Data Warehousing applications, Apache

Databases: ORACLE Enterprise Server 7.x, 8.0.x and 8i, 9i releases, 10g releases.11g releases

DBA Tools: ORACLE Enterprise Manager, ORACLE Management Server, ORACLE Dataguard, ORACLE Stats pack, AWR, ADDM, SQLT, Toad,

Operating Systems: SUN SOLARIS 10 HP-UX 10.2/11.0,LINUX,SCO UNIX, MS WINDOWS NT / 2000, Windows 2008, Windows 2008

Application/

Development Tools: Oracle E-Business suite R12 Supply Chain, Manufacturing OPM DM , Oracle Financial GL/AP/AR/CE/FA/FSG/SLA ,Inventory, BOM, iReceivable, OM, Expenses, Developer 2000, Oracle10g iAS, JDeveloper, APEX, WorkFlow, AQ, HTML DB, Oracle Portal, B2B, WebCache. Oracle Transportation Manager 5.5/6.2.8/6.2.10

Datawarehousing

Tools: Oracle Discoverer 4i/10g/11g, OWB, Oracle Express

Servers: Sun V890, Sun v245, Sun T200, SUN Ultra Enterprise Class Servers up to E10000 , SUN Workstation Servers, HP V Class, HP K Class, HP 9000 Servers, and Intel based servers, Sun T42 servers.

Web Servers: ORACLE Web Application Server, Netscape Enterprise Server, Apache HTTP Server and Oracle Enterprise Server. WebLogic Server

Data warehousing

Tools: Oracle Discoverer 4i/10g/11g, Oracle Web DB. Oracle Portal 3.0/10g

CASE Tools: ORACLE Designer 2000 1.3.2 2.1.2

Software: ORACLE 7.x/8.0/8i,9i,10g,11g,10giAS,9iAS,TOAD,SQL Plus, PL/SQL, SQL Loader,

Languages: PL/SQL, and UNIX Shell Scripts.

Backup: Veritas, BCV, Oracle Export/Import and Oracle Datapump

Tools: Unitask Code Migration Director, Unitask Output Director, Loftware 10.2,PC Miler,Rateware

Professional Experience:

Confidential

Lead/Architect Oracle Apps DBA

Responsibilities:

• Leading a team of 16DBAs both core and application DBAs who are responsible for the day to day Operations of the single global instance
• Well versed with Offshore/Onsite Model, Managed Services Shared model concepts
• Provide Global Support for Oracle Applications which includes maintenance activities with site team, troubleshooting issues and manage Concurrent Processing related to global processes.
• Upgrade of the Oracle Database from 10.2.0.4 to Oracle 11.2.0.3
• Currently working on the latest release of Oracle Apps 12.2.
• EBS R12 Administration for our pilot instance ASCP module and Demantra 7.3
• EBS 11i Administration including all sysadmin responsibilities
• Oracle 10g Forms and Reports Development and Administration
• Patch Oracle Applications 11i and R12 and databases with quarterly PSU/CPU and ATG
• Implement/maintain/configure Enterprise Grid Control for monitoring all production and test Instances
• Performance Tuning and Analysis which includes identification of bottlenecks and elimination of database contention, Memory Tuning, Gathering Statistics, Application Tuning where long running jobs are identified and sent to the Development team for remediation or scheduling the batch jobs after peak working hours.
• Set policies and procedures for Production, Quality Assurance and Development environments which has different architecture and hardware requirements. Thorough understanding of the results found in one environment to make prediction on another environment.
• Ensure global IT process management via policies, controls and metrics and ensure effective management of change associated with process changes
• Engage with Oracle Corporation by closely working with Oracle for any major production issue or initiative.
• Developing Purge/Archive criteria for historical application data
• Respond to and coordinate data requests for information from various system users, developers, trainers and help desk personnel
• Provide third level of escalation for local system issues related to the Oracle Applications environment
• Disaster Recovery and Business Continuity Planning. Putting processes in place that ranges from providing inputs and support, to putting the plan into action during an emergency.

Confidential

Lead/Architect Oracle Apps DBA

Responsibilities:

• Was responsible in the upgrade of the instance from 11.5.3 to 11.5.9 instance three iterations of the upgrade was done prior to Production upgrade. Was responsible in the complete execution of the upgrade on Production set up New apps test environment, patches, project plan tech details outline
• Upgrade of database from 8.1.7.4 to 9.2.0.4
• Migrating of Apps Release 11.5.3 on Sun Solaris to different machines upgraded 11.5.3 to 11.5.10 apps. The upgrade was a dual node upgrade.
• Apps 11i cloning on weekly basis for dev, Test, training 11.5.9 instances.
• Monitoring of Concurrent Managers
• Used 11i utilities ad utilities, adbugs, adpatch, adclone, admerge, adsplice, adctrl
• Troubleshoot application environment. Coordinate with different teams UNIX, storage, change control and topology

Environment: Oracle apps 11.5.3,11.5.10 sun solaris2.6,8,9 Sun E450, 6800, DB- 8i, 9i Fin- AP, GL, AR, CM, FA,PA,HRMS BEN,BNE,HR,Discoverer4i.

Confidential

Oracle Apps DBA

• Involved in installation, administration, configuration and implementation of OracleApps11i, 8.1.7 servers on Sun E450 using Oracle rapid install.
• Implemented GL, AR, AP, OM and CE. Involved in Physical and Logical database design, system design, Data modelling using Erwin
• Involved in moving tables pace- locally /dictionary managed, cloning of 11i, Self service, Log miner, refresh TEST from prod, forms /web servers, autopatch, adadmin, set-up concurrent managers/process in sysadmin, workflows, debug mode for capturing forms server diagnostics.
• Supporting the apps, DB and UNIX system admin on sun E450, and solaris 2.6.
• Performance and Tuning Apps 11i- CBO stats gathering on the schema objects, Methods- per table/schema/, Tool used coe stats.sql , FND STATS, DBMS STATS, ANALYZE command, DBMS UTILITY . Using the 'Gather Table Statistics' concurrent program, FND STATS procedures from SQL Plus to gather CBO stats for one or all schemas. Transaction Tuning, Back-End Tuning, Tech-Stack Tuning

Environment: Oracle Apps 11i, Oracle 8i, GL, AP, AR, FA, Sun Solaris 2.6, Noetix

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Implementation of GL, AR, AP, FA, OM, Purchasing, inventory, HRMS/Payroll, Project Accounting with business re- engineering
• Oracle 11i Application installation and implementation, maintenance, system administration applying patches to fix bugs, application
• Application configuration, performance tuning, backup and recovery,
• Diagnose and troubleshoot Oracle application issues.
• Perform tasks such as creating, monitoring and managing database
• AD Utilities, AD Administration, AutoUpgrade, AutoPatch, AD Relink, Oracle
• Installations setting up of Oracle Financials 11i, HRMS, SSHR
• Documenting Implementation Steps, Checklist, Post Install Steps,
• Applying the latest Hrglobal drivers as when it is released by Oracle. This is done in concurrence with the HR Functional team.
• DataInstall, AutoPatch adpatch
• Installation and configuration of vertex Quantum software
• Create a EUL and Enable User Access to Database Tables and Views
• Running of the PYUPIP trace in order the debug the various HR related issues
• PYUGEN batch process for Payroll Processes, Fast Formula Application Dictionary

Environment: Oracle Applications 11.5.8, Oracle 9i, HP UX11, 9iAS

Confidential

Oracle Apps DBA

Responsibilities:

• Responsible for upgrade of system from 11.5.3 to 11.5.7 on Sun Solaris and production support. Responsible for Upgrade, Setup, maintenance, and support of multiple Oracle Applications database test/production systems. Worked with application analysts and other DBA's to solve production and test issues. Installation of Oracle Applications Release 11.5.7 Maintenance Pack and implemented related updated tasks. Maintaining Oracle Applications 11.5.5 Oracle Application 11i suite maintenance which includes - AD Minipack F, Forms and Reports Developer 6i patch set, setting for JOB QUEUE PROCESSES in the init.ora file, Upgrading JInitiator, Configure database for new products and new tablespace requirements, Generate message files, Regenerate Flexfield Views
• Involved in all the aspect of Oracle Apps installation, production support, upgrade Apps from 11.5.3 to 11.5.7
• Responsible for adding new printers at the OS level and applications side and configuring them.
• Resolving all the production issues found by users and issues entered into issue logs. Supporting production environment after it went live.
• Interacting with users and technical/functional teams in the weekly meetings.
• Transferred all the dba related knowledge to DBAs team and system admin tasks to internal system administrator. Applied patches to test and production environment.
• Coordinated with UNIX administrators for hardware upgrades and replacements.
• Install, administration of Oracle applications server, Upgrade of Jinitiator from 1.1.7 to 1.1.8, JDK, trouble shooting with JDBC, dbc files creation, Oracle HTTP server with Apache, mod ssl, mod jserv, SSL config for Self-service applications, DAD configuration. Client-server communication in Web environment. Cloning of TEST and PATCH instances regularly.
• Working with Financial modules - AP, AR, GL, INV, OM, FA and PO.
• Applying patches, patch sets like AP.F, GL.F , maintenance packs, cumulative patches, merging patches and applying them in non-interactive mode.
• Version control using Visual Source Safe

Environment: Oracle Applications 11.5.3/11.5.7,Oracle 8.1.7.4, Sun solaris2.8