PROFESSIONAL SUMMARY:

• A detail - oriented and analytical information technology lead and manager with extensive experience in Oracle database administration and ERP application services, installations, migrations, upgrades and troubleshooting. Coordinates multiple complex project simultaneously, obtaining significant bottom-line contributions. A dedicated team lead who identifies best practices and leverages logical decision-making skills to increase overall efficiency. ensuring availability and performance of the databases through proactive monitoring of the database systems
• Over 18 years of extensive experience in Information Technology, including more than 13 years as Oracle Application DBA and 5 years as Oracle Database Administration primarily in UNIX, SOLARIS, LINUX, AIX and Windows NT environments.
• Expertise in Production support of Ebiz 11i and R12. 24/7 On Call Support and extensive experience in supporting multiple databases running 24x7 mission-critical/OLTP applications under multi-tier architecture demanding high availability and increased performance. Provide off-hours and weekend production support.
• Periodically Monitor Production databases from performance perspective, Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks. Work with application teams to explain critical production performance issues, Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals. Well conversant using various tools like ERwin Data Model, Db Artisan, Data Junction, OEM, DB Verify, Log Miner, Stats pack, UTLB-UTLE scripts.
• Application and database problem diagnosis, research, fix, testing and resolution. Knowledge of effective Project Management and Project Lead skills. Ability to successfully execute various projects and manage large teams. Managed several projects acting as Single Point Accountable (SPA) starting from Initiation/scope phase to planning, Implementing and closing the projects.
• Experience in Oracle System Development Life Cycle (SDLC) i.e. System Study, System Analysis & evaluating business process, Designing, Development, Testing, Implementation & Documentation of Client/Server applications. Managing multiple Production. Staging, test, development Oracle Applications environments of different releases. Good Exposure in working in shifts.
• Have In-depth knowledge and Hands on Experience on Oracle 10.7,11.0.3, 11i, Rel 12, 12.2.4, 12.2.7 on Oracle on Unix /Linux/AIX Platforms Oracle Applications Installation single node, multimode and enabling load balancing, Maintenance, Cloning, Patch Management. Worked on Very Large Databases over 2 TB with different Application Platforms.
• Experience is Oracle Applications Enterprise Business Suite: Oracle Applications ( 10.7- 11i,12.1.3, R12.) - GL,AP, AR, INV, FA, HRMS, OM, Manufacturing, BOM(Bill of Material), Asset Management, WIP, Payroll, and Purchasing.
• Good experience and knowledge in Oracle Applications system administration such as Manage Concurrent Programs and Requests, Configuring Printers, Reports, Report Review Agent, Administering and Customizing Concurrent Managers and Work Shifts, Application Security, User Registration, Customization and Assignment of Responsibilities, Incorporating Custom programs, Managing Profile Options, Defined Concurrent Processing Environment
• Have specific expertise in Release 12 and 11i Oracle Applications upgrade (from 10.7/ 11.0.2 to 11i and 11.5.10.2 to Rel12), Migration between various platforms and enabling of advanced features.
• Have good experience in upgrading oracle applications technology stack such as upgrading iAS, applying forms & reports server patches, enabling Discoverer server, configuring java and notification mailer.
• Experienced in Oracle Technology stack Installation ( 7x, 8x, 8ix, 9i & 10g, 11g and 12c) database design from logical model to the physical model and resulting database structures, cold & hot backups using RMAN, database restore, recovery, performance management strategy, identify internal disk contention, space and memory management, disk and tablespace utilization, trouble shoot performance bottlenecks, optimization, SGA tuning and network Administration.
• Experienced in upgrading and migrating of oracle databases between various releases also between various platforms.
• Part of Disaster Recovery Implementation Team and worked on various aspects DR Solutions such as High Availability Gap Analysis, develop Recovery Strategies., conduct the Business Impact Analysis (BIA), Identify Preventive Controls, developed the IT Contingency plan, Testing Plan, Training and Exercises plan
• Have good working knowledge from oracle point of view on Solaris, AIX, HP-UX and Red hat Linux operating systems and servers. Experienced in documentation of General Operating Procedures, Troubleshooting Guide, Fail over Scenarios and various operational tips and procedures an effective team player with proven customer centricity, interpersonal, team management, training and communication skills.
• Provided support to functional team in different modules Finance (GL, AP, AR, FA) Manufacturing (OM, BOM, MRP, WIP, Contracts), Distribution (PO, Procurement etc)
• Strong technical background, communication and presentation skills, excellent analytical and problem solving skills, quality focused team player and highly result oriented, positive attitude with a commitment towards excellence. Experience working with Oracle Support, opening, managing, and resolving Oracle SR. Extensive communications with customers, internal staff and also have excellent Client interfacing skills

PROFESSIONAL SKILLS:

Databases: Oracle database 7.3/8i/9i/10g/11g,12c Oracle OEM10g,12c, 13c Grid, RMAN, Real Application Clusters (RAC), High Availability (HA), Data Guard, MS SQL Server 7.0/2005, CASE tool (Oracle Designer, ErWin, Relational Rose), SQL, PL/SQL, TOAD, MS Access, Crystal Report.

Applications: Oracle ERP 10.7/11i/R12, R12.2.7, Oracle 9iAS, 10gAS, weblogic, Oracle Discoverer 4i/10g, Oracle Portal 10g, Oracle OBIEE, Oracle SOA, Oracle Workflow 2.5/2.6, PeopleSoft Application Servers, Oracle Application Servers(Apache, WebLogic ), Oracle SOA Suite, Oracle Warehouse Builder, Oracle Portal 10g, EDI Server, PVCS Server, Advanced Replication Server, HP-PPM (Kintana) for configuration migration. Demantra, Endeca, WMS. & Revpro.

Tools: Fusion Technology, Oracle Developer 10g, Oracle Developer 9i, Forms 4.5/6.i, Reports 2.5/6i, Workflow Builder, SQL, PL/SQL, Informatica PowerCenter, SQL*Loader, workflow builder, PL/SQL Developer, ETL, Visual Basic (Enterprise Version), Visual C++, HTML, XML, Java, JavaScript, COBOL, Pascal, Microsoft Visual Modeler, Rational Rose, Unix/Linux shell scripts.

Storage / Backup: VERITAS, SAN, EMC, Snapshot backups.

Hardware/OS: Sun Solaris, HP UX, AIX, Linux, VMS, NT4.0, Win95/98/2000/XP/7.0, MAC.

Network: Window NT, Citrix, LAN, TCP/IP, Client/Server, ODBC, OID, LDAP.

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OHIO

Environment: Linux, AIX, Oracle 12C, Oracle Application 12.1.3 and R12

Sr. Oracle Apps DBA Lead

Responsibilities:

• Managing DBA team.
• Implementing, managing and supporting Oracle ERP across various divisions of the company.
• Upgraded Oracle Application from 11.i to R12
• Installed R12.2.5 and upgraded to R12.2.7.
• Support and maintain 40 - 50 Oracle Applications R12 instances including production
• Work with the IT team to ensure that the associated hardware resources allocated to the databases ensure high availability and optimum performance.
• Done Database upgrade from 10g to 11.2.0.2
• Done Database upgrade from 11.2.0.2 to 12c
• Perform 2-tier and 3 tier clones of Oracle Applications R12 instances.
• Responsible for improvement and maintenance of the databases and ERP to support rollout and upgrades.
• I store, IAP maintenance and support
• BPEL, Web logic, APEX maintenance and support
• Demantra, Endeca maintenance and support
• WMS implementation maintenance and support
• Day to day database support code migration.
• Configure JVM and jserv processes for load balancing
• Troubleshoot problems with concurrent managers, Apache, Jserv processes and database performance, perform SQL tuning by pining best hash value by analyzing the sqlt report.
• Installed Oracle enterprise manager 10g grid control and upgrade, as well as OEM agents and Oracle application plug-ins. Managed and supported Oracle grid.
• Implemented Oracle ERP across various divisions of company, as well as introduced and coordinated standard operating procedures, definition of standards, and guidelines related to Oracle EBS environment.
• Conducted changes to relational database. Troubleshot Oracle database and application, including Oracle workflow and concurrent manager.
• Proven ability to work effectively and collaboratively with internal business and technical teams as well as vendors and consultants and the ability to take directions and plan and execute independently.
• Orchestrated changes to computer databases, testing and implementing database. Applied knowledge of database management systems. Provided day-to-day maintenance, troubleshooting, and performance tuning of code.
• Planned and instituted major releases, including application upgrades, Oracle critical patch updates, and security releases. Oversaw installation and configuration of Oracle 10G application server on Linux.
• Conducted standard application database administration responsibilities, including installation, upgrading, patching, tech-stack patching, cloning, and troubleshooting issues. Enabled advancement of features as required.
• Upgraded OEM from 10.2.0.5 to 11.2.0.2
• Upgrade OEM from 11.2.0.2 to R12c

Confidential, Denver, CO

Environment: Linux, AIX, Oracle 10G, Oracle Application 12.1.1

Production Support Lead

Responsibilities:

• Headed Oracle applications Rel 12.1.1 production, development, testing, and UAT databases support/maintenance. Installed Oracle enterprise manager 10g grid control and upgrade OEM agents and Oracle application plug-ins Installed and configured BI management tool on OBIEE server. Capacity planning of all the production databases.
• Directed and advised Oracle grid, as well as Oracle Rel 12 application on RAC configuration and parallel concurrent processing (PCP) configuration.
• Implemented Oracle ERP across various divisions of company, as well as standard operating procedures, definition of standards, and guidelines related to Oracle EBS environment, coordinating changes to relational databases.
• Troubleshot Oracle database and application, including Oracle workflow and concurrent manager. Partnered with technical and functional consultants to fix ongoing issues.
• Provided day-to-day support for maintenance, troubleshooting and performing tuning of code. Cloned every week development database from production.
• Planning and instated major releases, such as application upgrades, Oracle critical patch updates, and security releases. Produced and created Oracle 10G application server on Linux.
• Oversaw standard applications database administration responsibilities, ranging from installation, upgrading, patching, tech-stack patching, cloning, and troubleshooting. Enabled advancement of features.
• Managed backups (RMAN), recovery strategies, and disaster recovery plans. Organized change control meetings and built instance strategy/implementation plan.
• Supported PCP issues related to transaction managers, as well as OPP on RAC database. Ran OBIEE applications maintenance and support as well as OTM applications maintenance and support.
• Monthly cloning of dev, test, QA instances Diagnose and solve issues within the Oracle E-Business suite of technologies, including EBS Finance and Supply Chain modules, IPM, OAM, AD, and Weblogic
• Installing and configuring weblogic on forms node for revpro 606 project.

Confidential, Daytona Beach, FL

Environment: Linux, AIX, Oracle 10G, Oracle Application 11.5.10.2

Production Support Lead

Responsibilities:

• Implementing, managing and supporting Oracle ERP across various divisions of the company.
• Support and maintain 10 Oracle Applications 11.5.10.2 instances including production.
• Perform 2-tier and 3 tier clones of Oracle Applications 11i instances.
• Configure JVM and jserv processes for load balancing
• Oracle 10g to 11g database upgrades
• Troubleshoot problems with concurrent managers, Apache, Jserv processes and database performance, perform SQL tuning
• Worked with HP-PPM (Kintana) for configuration migration, supported PeopleSoft HR/ Payroll system
• Installed Oracle enterprise manager 10g grid control and upgrade, as well as OEM agents and Oracle application plug-ins. Managed and supported Oracle grid.
• Ran Oracle Rel 11i application on RAC configuration and parallel concurrent processing (PCP) configuration.
• Implemented Oracle ERP across various divisions of company, as well as introduced and coordinated standard operating procedures, definition of standards, and guidelines related to Oracle EBS environment.
• Conducted changes to relational database. Troubleshot Oracle database and application, including Oracle workflow and concurrent manager. Ran Discoverer 10.1.2.0.2 installation, configuration, and setups/support.
• Installed Oracle AS and configured Sabrix, BPEL, and Workbrain. Collaborated with technical and functional consultants to fix ongoing issues.
• Unitask installation and support. Agile and Weblogic administration and support
• Proven ability to work effectively and collaboratively with internal business and technical teams as well as vendors and consultants and the ability to take directions and plan and execute independently.
• Orchestrated changes to computer databases, testing and implementing database. Applied knowledge of database management systems. Provided day-to-day maintenance, troubleshooting, and performance tuning of code.
• Planned and instituted major releases, including application upgrades, Oracle critical patch updates, and security releases. Oversaw installation and configuration of Oracle 10G application server on Linux.
• Conducted standard application database administration responsibilities, including installation, upgrading, patching, tech-stack patching, cloning, and troubleshooting issues. Enabled advancement of features as required.
• Delivered Sabrix, Aventix, and Workbrain support. Initiated and managed backups (RMAN), recovery strategies, and disaster recovery plans.
• Contributed to change control meetings and building instance strategy/implementation plan. Created Oracle configuration manager. Configured and integrated Oracle application server 10g with Oracle Discoverer 10g.
• Troubleshot Oracle application Server 10g, Oracle Discoverer Plus 10g, and Oracle Discoverer Viewer 10g. Supported PCP issues related to transaction managers and OPP on RAC database.
• Maintained SOX guidelines on existing databases and OC4J instances post release.
• I was the Lead in the Change Manage process to migrate code and configurations successfully.
• Created and upgraded Oracle databases. Formed and tested disaster recovery system, using RMAN and custom-written shell scripts. Developed Oracle DataGuard configuration
• Worked closely with the Infrastructure Service team to configure server/storage/network components and support and perform database and application clones, refresh and trouble shoot performance issues.
• Created project plans and set priorities and provided management monthly reports on status, technical options, risks and issues.

Confidential, SFO, CA

Environment: Sun Solaris, AIX, Oracle 9i, Oracle 10G, Oracle Application 11.5.9, 11.5.10

Oracle Application DBA

Responsibilities:

• Coordinated Oracle application production, development, test, UAT, and QA databases support/maintenance. Collaborated with technical and functional consultants to fix ongoing issues.
• Provided day-to-day support for maintenance, troubleshooting, and performance tuning of technical environments.
• Maintained and supported applications, such as Domino, Metasolv, Portal, Ariba, Frontarena servers, Clear Quest, and web application servers, as well as JDE databases.
• Planned and implemented major releases, including application upgrades, Oracle critical patch updates, and security releases.
• Introduced, reviewed, and organized standard operating procedures. Defined standards and guidelines related to Oracle EBS environment, orchestrating changes to relational databases
• Experience with Data Management using Big Data Technologies

Confidential, HOUSTON, TX

Environment: Sun Solaris 5.8, Oracle 9i, Oracle 10G, Oracle Application 11.5.8, 11.5.10

Oracle Application DBA

Responsibilities:

• Oracle Apps Production, Development, Test, UAT and QA Databases Support and Maintenance
• Installation and Configuration of 10.1.2. Oracle Application Server on Solaris 10.
• Installation OID 10.1.2 version on Solaris 10
• Flashback database implementation.
• Cloning Oracle Applications using AD Clone, Auto Config, Rapid Clone utilities.
• Patch Management process for Apps instances
• Supporting SOX SOD ( Segregation of Duties ) Project
• Identifying Conflicts in functions to minimize the SOX issues.
• Working with APPLIMATION 3rd party tool to minimize the SOX issues across all the modules.
• Diagnostic segregation of duties by function, responsibilities and user level
• Managing concurrent programs and requests, reports, report review agent, administering and customizing concurrent managers and work shifts, application security, user registration, customization and assignment of responsibilities, incorporating custom programs, managing profile options, managing printers, incorporating custom help files and auditing system resources. Co-ordination with functional consultants to fix ongoing issues.
• Provide day-to-day support for maintenance, troubleshooting and performance tuning of the technical environments
• Plans, coordinates and implements security measures to prevent damage, unauthorized modification or disclosure of data, taking into account Sarbanes-Oxley mandates and requirements.
• Well versed in multi-node installs and networking requirements, AD Administration Tools, VPN security, DB security, X-Windows, TOAD, and problem resolution with Oracle and Metal ink . Managing and support of Oracle Grid.

Confidential, ATLANTA, GA

Environment: Sun Solaris, Oracle8i, Oracle 9i, Oracle Application11i ER

Onsite Lead

Responsibilities:

• Provided primary support for production environment and critical test/development instances.
• Planned and contributed to change control meetings, building instance strategy and implementation plan.
• Delivered day-to-day support for maintenance, troubleshooting, and performance tuning of technical environments. Earned experience in supporting multiple instances.
• Supported OLTP and ASCP, CMF, Global GL, reporting, APEX, 170, 4th Mirror, Sync Split, Chinese implementation, as well as quality instances. Led team of ten application databases at offshore from onsite.
• Directed work and initiated process improvements. Managed client engagement. Coordinated changes to computer databases, testing/implementing database and applying knowledge of database management systems.
• Obtained understanding requirements specifications and project scooping. Interacted with customer using various internal accessible methods and change control, providing 24x7 on-call support for production environments.
• Guided team members on scheduling, assignment, and review of project work. Organized major releases, such as application upgrades, Oracle critical patch updates, and security releases.
• Consulted extensively on critical issues, housekeeping, backup/archival process, development/testing clones, data cleaning, data reconciliation, data purging, and data statistics gathering.
• Carried out performance and tuning, identifying and suggesting database issues in proactive manner while working directly with Oracle to fix issues.
• Counseled on 11.03, 11.5.8, 11.5.9, and 11.5.10 applications and 8x/9x databases on Sun Solaris environment. Tracked, monitored, and communicated project progress against project plan.
• Attained experience in offshore/onsite model and managed customer expectations. Led Oracle applications system administration for instances of company energy.
• Directed concurrent programs/requests, reports, and report review agent, administering and customizing concurrent managers and work shifts, application security, as well as user registration.
• Customized and assigned responsibilities, incorporating custom programs and custom help files/auditing system resources as well as managing profile options/printers.
• Cloned Oracle applications using AD Clone, Auto Config, and Rapid Clone utilities. Supported implementation of Oracle applications 11i through go-live and production support.
• Oversaw SIT and production cutover tasks, change management calls, as well as releases of different instances such as CPG, BOP, and NRPS.
• Installed and configured of Oracle applications 11.5.8 and 11.5.9. Patched management process for application instances. Improved production instance by scheduling appropriate concurrent purge programmers.
• Orchestrated alerts, work flow, reports, and forms, as well as PO and time-card issues. Supported GL, OM, and HR modules. Identified patches and recommended patches to tech and functional managers.
• Solved notification mailer and Java mailers issues. Ran database alerts. Maintained multi-lingual and multi-org for different instances. Ran concurrent manager and concurrent requests.
• Troubleshot iAS and forms/reports server. Created OS user IDs, identifying OS patches and recommending OS patches. Wrote shell scripts for database backups, alert, and monitoring Database and OS performance.
• Used Oracle application tools for maintaining database and application, such as adpatch, adadmin, adctrl, adaimgr, adrelink, and adsplice. Upgraded Oracle applications from 11.5.7 to 11.5.10.
• Conducted troubleshooting of Oracle application problems. Upgraded Oracle application to existing releases and existing product-level with applying maintenance packs and mini-packs.
• Code Migration with Kintana.
• Led application AOL object setup, including users, menus, responsibilities, forms, reports, request groups, request set, and payment term creations while purging AOL tables. Contributed to GL quarterly and year-end activities.
• Monitored, troubleshot, and resolved technical problems while working directly with Oracle technical support. Collaborated with functional and tech team on integration projects.
• Opened, monitored, and resolved Oracle TARs with Oracle support via Metalink.
• Maintained 24x7 on-call rotation to provide database support to global user community.