SUMMARY:

I am an expert Oracle EBS / Fusion Middleware DBA Architect having acquired over 20 years of experience working with and administrating wide spectrum of enterprise applications, databases and operating systems.

AREA OF EXPERTISE:

• Oracle E - Business Suite Applications 11i, R12, R12.2
• Oracle Cloud Infrastructure, Amazon Web Services (AWS), Azure (Setting up cloud infrastructure services)
• Oracle WebLogic (Implementation of HA environments)
• Oracle Web Center Sites (WCS), Oracle Web Center Content (WCC), Oracle Web Center Portal (OWP)
• Oracle Universal Content Management 11g
• Oracle SOA Suite, OSB,
• Oracle HTTP Server, Apache, Tomcat
• Oracle Apex all versions.
• Oracle Fusion Middleware
• Oracle Internet Directory 10g, 11g
• Oracle OBIEE 10g, 11g
• Oracle Forms, Reports and Discoverer 10g 11g
• Oracle Access Manager 11g
• Oracle Identity Manager 11g
• Oracle SOA Suite 10g, 11g - BPEL Integration EBS-RETAIL
• Oracle Retail (rms,sim,rdw,rib,reim) 12.0.7/9
• Oracle Database Administration (7,8,8i, 9i, 10g, 11g,12c,18c,19c)
• Oracle Clusterware Grid Infrastructure 11g, 12c, 18c, 19c
• Oracle Database RAC administration
• Oracle Discoverer
• Oracle Bi Publisher Microsoft SQL Server 2007
• Manhattan WMS
• Assyst Incident Management
• HP-UX 11.23 / 11.31 System Administration
• HP-UX Service Guard Administrator
• Microsoft Windows Server Administration
• Redhat and Oracle Enterprise Linux Administration
• CVS, Bugzilla, LDAP administration
• ITIL Configuration, Change, Incident, Service and Release management
• Microsoft Exchange 2003 Server

KEY STRENGTHS:

• Excellent communication skills.
• Strong analytical and problem-solving skills.
• Efficient in learning and implementing new technologies.
• Reputation as a dedicated professional who works well with a team.
• Natural leadership skills, detail oriented and a conscientious flexible professional.
• Works well under pressure, able to meet demanding deadlines.
• Capable of good coordination with inter department and upper management.

TECHNICAL SKILLS:

HP

O/S

UX 11i, Linux, Windows

Oracle RDBMS

Oracle 9i, 10g, 11g

Oracle Applications 11i

11.5.9, 12.0.6 (R12)

Oracle Retail

12.0.9

Storage

HP SAN EVA 6000

Number of Servers

60

Backup Tools

HP Open View

WORK HISTORY:

Confidential, Michigan

Senior Oracle Apps DBA

Responsibilities:

• I am a senior Oracle Applications DBA / Architect providing a production support to high availability Oracle EBS 12.2.7 and Weblogic 12c (SOA/OSB) environments.
• I’ve successfully upgraded Oracle EBS from 12.1 to 12.2 and database from 12c to 19c.

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Implement, upgrade and support many different kind of Oracle software technologies such as Oracle EBS, Oracle Fusion Middleware, Oracle Databases / RAC, Oracle Identity Management, Oracle SOA, Oracle Fusion Applications.
• Providing support on Oracle Fusion Middleware products.
• Implementing FMW Products such as WebLogic, SOA, OSB, Web Center Sites, Web Center Portal, Web Center Content.
• Involved in Workload Management (WLM) using cloning and clustering techniques including Horizontal and Vertical Scaling for failover and backup/recovery processes. Proactively monitor and review application performance.
• Study the Client’s project requirements for Oracle solution technical implementation and generate the documentation for project tenders. Provide the time estimations for the technical implementation phase of the projects.
• Provide solutions and POCs to the clients with supporting documentation and certification information.
• Provide expert advice and solutions to the client’s reported issues remotely or onsite.
• Support junior DBAs in resolving the issues that require expert’s intervention and resolutions such as EBS upgrade issues, Oracle performance issues or advanced database crash recovery scenarios.

Confidential

Oracle EBS Production Support

Responsibilities:

• Implement, upgrade and support many different kind of Oracle software technologies such as Oracle EBS, Oracle Fusion Middleware, Oracle Databases / RAC, Oracle Identity Management, Oracle SOA, Oracle Fusion Applications.
• Study the Client’s project requirements for Oracle solution technical implementation and generate the documentation for project tenders. Provide the time estimations for the technical implementation phase of the projects.
• Provide solutions and POCs to the clients with supporting documentation and certification information.
• Provide expert advice and solutions to the client’s reported issues remotely or onsite.
• Support junior DBAs in resolving the issues that require expert’s intervention and resolutions such as EBS upgrade issues, Oracle performance issues or advanced database crash recovery scenarios.

Confidential

Oracle Apps DBA - Team Lead

Responsibilities:

• Migrated the Oracle EBS DB Tier from poor performing old Fijitsu server to HP DL series windows server.
• Tuned the Oracle EBS DB server to improve the performance on Windows Machine.
• Tweaked the Windows memory settings to allow extra Giga byte of PGA to form in order to accommodate more Oracle session without which the concurrent programs were failing due to 32bit architecture limitation.
• Upgraded the Oracle Applications 11.5.9 (Windows) to Oracle 12.0.6 (R12) HP UX 11.31.
• Installed the Oracle EBS R12 on Redhat Linux server for development, training and Oracle Retail integration purpose.
• Installed and Configured Oracle BPEL on Redhat Linux for Oracle EBS + Oracle Retail integration.
• Installed and Configured Fusion Middleware, Oracle BI, Weblogic, Oracle SSO.
• Implemented Oracle Web Center Portal
• Implemented Oracle SOA - B2B solution
• Rectified the printer configuration issue on the Oracle EBS 11i Server.
• Fixed the corrupted Apache by recreating the service on Windows based EBS 11i server.
• Performed the Windows operating system clone on HP DL 380 server using Acronis.
• Providing support and training to Oracle DBAs at other Confidential sites like Oman, Jordan, Bahrain and Lebanon.
• Written several Korn Shell based scripts to automate and schedule various tasks in Linux and Unix.
• Upgraded the Oracle Retail 12.0.4 development instance to 12.0.7
• Oracle E-Business Suite HCM Implementation and support.
• Configured the HPUX operating system kernel parameters to suite the Oracle EBS requirement.
• Administrating Oracle Retail Production and Development servers.
• Managing the 3 HP service guard cluster on HPUX
• Administrating the Manhattan Warehouse Management Application running on the HPUX server.
• Managing HP Openview backup library, configuration and scheduling backups and monitoring on daily basis, this also includes troubleshooting the issues with MSL Library.
• Planning and documenting the power and air conditioning requirement of the datacenter and working with the administration department to ensure seamless run of the datacenter.
• Planning and coordinating the deployment of the new servers in the datacenter, these are mainly HP servers.
• Carrying out the role of the “Configuration Manager” as part of the ITIL implementation project, this was started from the scratch where I’ve constructed the CMDB and written several procedural documents to implement the agreed and approved governance polices.
• Installed and Configured Oracle BI Publisher for various reporting purpose.
• Insalled and Configured Assystnet ticketing system Application and Database as part of ITIL project.
• Installing and maintaining many Oracle Databases for various third party applications.
• Performance tuning of Oracle databases.
• Installed and Configured the CVS on Linux Server.
• Installed and Configured the Bugzilla on Linux Server by building Apache from source.
• Performing HW/SW compatibility analysis for various applications/servers.
• Performing the HPUX os backup using the ignite tool.

Confidential

Oracle Apps DBA

Responsibilities:

• Cloned Oracle Applications 11.5.10 from Production to Test using Rapid clone.
• Performed sysadmin related activities like setting profile options, creating users and assigning roles etc.
• Changed Oracle Applications 11i and its schema passwords using FNDCPASS utility.
• Tuned databases for optimal performance.
• Created and managed Database schemas and objects.
• Created website for monitoring Oracle Applications 11i services online and for other factors like CPU load, top 5 CPU consuming users etc.
• Wrote a shell script to automate Pre-clone procedure and archives all the Oracle Apps TOP directories using CPIO and send it to DR (Disaster Recovery) site, wrote several other scripts to automate various processes.
• Trained other DBA’s
• Resolved privileges/grants related issues.
• Resolved Informatica load jobs performance issues.
• Completed documentations.

Confidential

Oracle Apps DBA, Project Lead

Responsibilities:

• Performing sysadmin related activities like, creating and managing users, creating responsibilities, creating and administrating concurrent managers, concurrent programs and report sets, generating a trace for concurrent programs/forms to identify bottlenecks in applications performance, Creating and managing printers, setting up profile options.
• Updating Applications tech stack with latest patch sets, migrating enhancements to production systems via kintana tool. Applying Oracle recommended AD patches for enhancements and bug fixing.
• Cloning production Oracle Applications system using rapid clone for testing patches and enhancements.
• Monitoring and tuning Databases performance using OEM, Toad, statspack, session tracing.
• Created new database for WebMethods Tools Manager.
• Managing database security, pro-actively identifying and fixing the database vulnerability.
• Reorganizing and rebuilding database objects to improve database performance.
• Identifying and tuning resource intensive SQLs, creating indexes that would improve query performance.
• Administrating 2 instances of Oracle 9iAS for one for Production OLTP application and another for Global Data Warehousing.
• Improved the procedure of cloning a reporting database from production database.
• Improved the backup strategy for 4 productions databases.
• Written several shell scripts to automate various processes, e.g. monitoring “Planning Data Collection” concurrent program, monitoring dead session f60webmx forms process.
• Critical Territory Management related data recovered from more than 10 tables using flashback query, which was accidentally deleted by data admin.
• Tuned the production databases SGA to maximize database throughput and to utilize the available memory efficiently.
• Performed test recoveries of production databases from RMAN backup sets for validating the backups.
• Running data fixes to fix incorrectly entered data into the production databases.
• Fixed many database locking issue with was the cause of delay in concurrent programs and data warehousing and reporting instances, resolved several library cache locks issues.
• Implemented a small website that gives a quick overview of the applications and database availability, this webpage calls a shell script using cgi-bin which gathers the info about various services running on different servers and converts it into a HTML format.
• Fixed the problems related to dead session process in the forms server.
• Documents the standard operating procedure and enhancements in the production system.
• Workflow administration.
• Creating project weekly status report and applications availability report.
• Creating RCA (Root cause analysis reports) for incidents.

Confidential

Oracle Apps DBA

Responsibilities:

• Implemented cloning strategy for Oracle Applications.
• Improved backup strategy for production database.
• Tuned the database instance.
• Carried out database health check.
• Provided training to onsite DBAs.

Confidential

Oracle Apps DBA

Responsibilities:

• Administering Oracle E-Business suite 11i and Oracle 9iAS release 2 applications.
• Administering Discoverer server 4i & 6i.
• Applying standard patches (ad patches) and custom patches (for Oracle’s internal use) to the production system.
• Working on priority 1 service requests twice a week.
• Configuring BIG-IP router for load balancing of Applications servers, creating new virtual servers and adding pools to it.
• Wrote shell scripts for replication of files and to monitor discoverer server processes. Deployed centralized script for start/stop of all the DSS (decision support system) applications from centralized server.
• Prepared SOPs (Standard Operating Procedure) documentation and uploaded it on ‘Files Online’ suite which is Oracle’s collabsuite file management application.
• Carried out Oracle apps 11i sysadmin related activities like, user auditing, printer setup, concurrent manager administration.
• Installed 9iAS applications like marvel, gmrp.
• Cloning of Oracle Apps 11i with rapid clone.