PROFESSIONAL PROFILE:

• Leadership and managerial skills with result - driven, cost-effective orientation and ability to manage resources efficiently and mentor and motivate team to maximize level of productivity.
• Well-organized, self-motivated and dedicated with strong sense of responsibility in area of Oracle AppsDBA / RAC DBA / FMW Admin.
• Approx. 14 years of Oracle Database Manager focusing on Database Management and Administration (Oracle Core / Apps DBA / Middleware Admin) with experience in the Life Science and Health Care Health Care, Financials and Telecommunication industry as Database Manger/Lead/DBA
• Experience in Agile Technology and ITIL certified technical solutions and certified in Customer Training
• Professionally trained knowledge on Google Cloud Platform (GCP) Infrastructure Solution Architect
• Basic architectural knowledge on Oracle Cloud Infrastructure (OCI)
• Management and Administration of Oracle RAC (real application cluster) system from design architecture to Replication implementation
• Manage team of DBA’s (infra structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization
• Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems
• Managed 100 + enterprise-level Oracle 12c/11g/10g database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Experience in Business requirement, Use cases, External/Internal/Details Design, Implementation Plan and Support procedure documentation
• Spearheaded a company-wide innovation Cloud initiative resulting in 5 new products offerings in under 8 months
• Reduced incident of Oracle EBS DB issues by 25% globally by leading a testing initiative improvement program
• Work with business units such as users, managers, supervisors and team lead to understand the challenges and map out and implement a timely solution
• Extensive exposure on below 11i / R12 (12.1.x, 12.2.x).
• Completed 5 Oracle EBS (R12.2.8) implementation Completed 2 Oracle Upgrade projects EBS 12.1.3 to 12.2.6, 12.2.7, 12.2.8 Completed 3 Oracle EBS (R12) full life cycle implementations Worked on 2 Upgrade projects EBS 11.5.10.2 to 12.1.3 Worked on 25+ EBS production support (11i and R12.1.x, 12.2.x) engagements Extensive Experience on Oracle DBA/Apps DBA Performance Tuning Leading multiple teams on Core Database Administration (11g, 12c)
• Leading 15 members AppsDBA team for 5 Oracle EBS (R12) full life cycle implementations projects and support projects as well. Handling offshore team as Team Lead and manage project - task estimation, planning, risk mitigation analysis etc.
• Leadership Skills I have performed in current Lead Role
• Maintains database results by setting and enforcing standards and controls
• Supervise installation, migration and upgrade of databases.
• Budgeting and capacity planning, as well as systems performance and uptime management
• Drives continues improvement through optimizations of systems and processes for existing and new applications
• Manage multiple Oracle EBS applications projects simultaneously to ensure on-time response, quality delivery and resolutions
• Act as the single point of contact with cross teams, including technical, functional, 3rd party vendors
• Working with global teams
• Manage 24/7/365 operations in a business-critical environment
• Manage day-to-day database operations and DBA charters for production databases and projects. This includes database administration, planning, design, build/delivery, deployment, monitoring, standards, compliance, etc. for production, production operations, monitoring, project builds & delivery, deployments, etc
• Promotes career development and growth. Provide training to team members on IT Standards and corporate directives
• Review of team members performance and providing feedback on a periodic basis
• Monitors incident management processes minimizing the business impact and system downtimes
• Streamlines processes to improve efficiency and effectiveness of the team
• Support Problem analysis leading to architectural pattern re-development & continual service improvement activity
• Complete working experience in domain knowledge on Life Science and Health Care, Financial, Telecommunications sectors where Database admin skill can be utilized
• Good experience and knowledge on GxP process for Life Science Domain
• Experience in understanding about Software Development Life Cycle (SDLC), Working Experience Oracle Fusion products like in SOA 11g/12c and WebLogic Administration
• Upgraded from 12.1.3 to 12.2.4, Install and configure the 12.2.4 and upgraded from 12.2.4 to 12.2.6. Applied patches in 12.2.6 with ADOP utility with all the options
• Implemented OAM/OID and integrated with Oracle 12.1.3 and 12.2.6
• Experience in tools such as OEM13c, Advanced Supply Chain Planning (ASCP)
• Experience on incident management within SLA for all production issues, providing RCA for those issues, Written monitoring scripts for health check for Oracle Apps and Core DBA
• Oracle Database Performance tuning using (stats pack, tkprof, AWR), Advanced performance table compression experience on 11g, Expert on Oracle Memory, Storage, I/O internals, Expertise in explain plan and SQL Optimizer use to resolve the performance issues, Oracle Apps performance on Concurrent managers and workflow related issues
• Extensive experience with installing, upgrading, patching, migrating, troubleshooting, tuning and administering Core Oracle, Oracle RAC 10g, 11gR2, 12c and ASM
• Install, Upgrade, Support and maintain Oracle EBS applications with High Availability and DR and also worked on setup, configure, implement test and validate Oracle EBS modules and OID-OAM Single Sign On
• Worked on Parallel Concurrent Processing (PCP) as well as debugging concurrent managers and requests
• Complete work experience in Oracle Application full life cycle implementations, right through hardware recommendations / OS Installations DEV/UAT /PROD and Post GO-LIVE support.
• Extensive exposure in Oracle Apps DBA support projects as In-house / Onsite / Offshore support model.
• Expertise in installation of Oracle Apps, maintenance and support of application and database, patching, application troubleshooting, troubleshoot all the Oracle database related problems, Interact with clients on Oracle database related issues. Proficiency in managing high availability systems
• Strong knowledge of administration processes and controls to meet security and compliance audit requirements for SOX
• Troubleshooting experience for all tiers (Apache, Forms, Concurrent, Admin, Java and Database)
• As an Oracle Apps DBA I am involved in Oracle Applications 11i / R12.1.x / R12.2.x experience in Oracle Applications E-Business Suite having Consulting role, which encompasses; Oracle Applications E-Business Suite(11i) installation both for Linux and windows, Appling patches like RU, Maintenance, CU patch, Database patch etc, Changing Apps Password, Printer Installation in Apps, Maintenance of Database & Application of Oracle E-Business suit using OAM, AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, adpatch etc), Changing hostname of a Live Oracle Apps Production Server. Experience in handling Cloning Instances, Oracle Applications instance Administration.
• Astute planner / leader with exemplary communication, relationship management, analytical and organizational skills. Strong analytical, organizational, leadership and problem-solving skills.

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: Oracle EBS 12.2.8, Oracle RDBMS 12c, WebLogic 12c, Oracle SOA 11g, Oracle Linux 7.4

DBA Lead/Manager

Module: Finance, OTC, Projects, RTR, PTP

Responsibilities:

• Leading 15 members Apps DBA Team in off-shore/on-shore.
• Upgraded Oracle EBS 11.5.10.2 to 12.2.4
• Upgrade Oracle EBS from 12.2.4 to 12.2.8
• Installed, configured and integrated Oracle Access Manager 12c (OAM) with EBS for Single Sign-on (SSO)
• Installed and administered 11gR2 RAC clusters in 24/7 environments
• Installed, configured SOA and integrated with Oracle EBS 12.2.8
• Performed database performance assessments and provided recommendations
• Installed, configured and administered Oracle Enterprise Manager Grid Control 12c
• Installed Oracle Applications Management Pack on top of OEM 12c
• Performed Quarterly DR readiness exercises
• Performed assessments regarding current state of Patch sets and Family Packs in EBS compared to Patch sets released by Oracle Development, using Patch sets Comparison Utility
• Published and maintained DBA calendar detailing timelines for DBA team’s activities
• Collaborated with IT Infrastructure team to procure new hardware and upgrade existing hardware
• Developed and maintained strong working relationships among various teams
• Implemented Database Auditing Policy including Audit Requirements, Audit Maintenance and Audit Reporting
• Deployed custom RICEW objects according to GxP compliance
• Implemented procedures for SOX compliance

Confidential

Technologies: Oracle Applications 12.2.6, Oracle RDBMS 12c, WebLogic 11g, Integrated SOA Gateway, Oracle Linux 6.7, OBIEE, SOA Admin

Senior Consultant (DBA)

Module: Finance, OTC, Projects

Responsibilities:

• Leading 5 members Apps DBA Team in offshore.
• Providing Production Support of R12 and OBIEE database
• Installed, upgraded, maintained, tuned multiple Oracle Applications databases
• Created documents detailing DBA procedures to be used by offshore DBAs
• Led project to archive Oracle Applications data from many global applications environments into one environment
• Experience configuring/supporting various interface adapters ODBC, JDBC etc. Also experience on SOA 11g and WebLogic administration
• Experience in deploying SOA Suite, creation of data sources in OBIEE
• Installed, set-up and Integrated multiple 3rd party tools such as Config Snapshot, Flex Deploy, Excel4Apps with Oracle EBS 12.2.6
• Created Performance Assessment and Capacity Review documents
• Tuned the query and resolved many performance issue (Specially Auto Invoice Master program)

Confidential

Technologies: Oracle Applications 12.2.4, Oracle RDBMS 12c, WebLogic 11g, OAM / OID, Oracle Linux 6.7

Senior Consultant (DBA)

Module: Finance, HRMS, Time and Labor, Project Accounting.

Responsibilities:

• Implemented Oracle EBS 12.2.4 and provided production and development technical support
• Installed, configured OEM 13c and integrated with Oracle Database
• Implemented Backup and recovery strategies for RAC databases using RMAN according to SLA
• Monitoring and configuring RAC database using utilities like srvctl, crsctl, crs stat, ocrconfig
• Experience in adding multiple OACORE in WebLogic for Oracle EBS
• Proactive monitoring of table spaces, data files, logs and health checks
• Day to day troubleshooting of Oracle EBS environments which includes fixing all the issues coming and supporting various components of Oracle Applications - Forms, Apache, CM, DB, Listener
• Clone the non-prod instances from PROD with RMAN and Adclone utilities
• Scheduled automated back-end jobs and monitoring scripts
• Maintain Oracle Applications DB team offshore and onshore including vendor teams
• Performed logical backups using IMPDP/EXPDP, Data Pump
• Experience on resolving critical ADOP and FS CLONE issues
• Stabilizing the system after GO-LIVE, fixing the post go-live issues and performance issues.

Confidential

Technologies: Oracle Applications 12.1.3, Oracle RDBMS 11g, Linux 6

Senior Consultant / DBA Support

Module: Finance, CRM, HRMS, MFG.

Responsibilities:

• Leading 3-members Apps DBA Team in off-shore.
• Estimating downtimes for proper planned outages.
• Completed DB upgrade from 11.1.0.7 to 11.2.0.3
• Configuring Notification mailers, DBA Alerts etc.
• Responsible for availability of different kinds of services (reports, forms, apache etc)
• Applied Various Patches for Oracle Applications using Adpatch.
• Applied RDBMS patches using Opatch
• Have successfully installed Discoverer 11g with WebLogic 11g (Oracle FUSION).
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, adpatch etc).
• Performed cloning through RMAN.
• Performed cloning through HOT backup.
• Performed recovery from HOT backup.
• Tuning the database using the explain Plan, init.ora parameters
• SQL Tuning using explain plan, TKPROF with SQL trace
• Worked with Dev. Technical team for customization on EBS.
• Given KT to Client DBA regarding monitoring of Oracle Apps as well as DB.
• Troubleshooting performance related issue.

Confidential

Technologies: Oracle Apps 11.5.10.2, Oracle Applications 12.1.3, Oracle RDBMS 11g, Sun Solaris 5.10

Sr. DBA Specialist / DBA Support

Module: Finance, CRM, HRMS

Responsibilities:

• Execute migration scripts through FNDLOAD
• Applied the patches using ADPATCH and APATCH
• Reset ORACLE, APPS, and SYSADMIN schema passwords.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Tuning Concurrent Managers.
• Refresh of Test, Dev, and Stage from Prod.
• Performed database tuning by using tool like AWR Report
• Created Custom Manager
• Monitoring the Database Growth
• Monitoring the Table space Growth
• Monitoring Lock events & Resolve them
• Monitoring Blocking sessions
• Purging the trace files and log files regularly
• Finding Invalid Objects and compiling them
• Monitor the sessions which are Consuming High Resources
• Resolving user errors, monitoring the database
• Rebuilding the Indexes when necessary
• Analyzing the Objects when necessary
• Experience on troubleshooting in Concurrent manger, Apache, Form server.
• Working with Generating JAR file, Massage files, Form files.
• Working with Compiling invalid objects and flex fields.
• Provided 24x7 on call production support.

Confidential

Technologies: Oracle Applications 12.1.3, Oracle RDBMS 11g, IBM AIX 6.1

Module Lead / DBA Sol. Architect

Module: Finance, FAH, Projects, Procurement (Purchasing, Sourcing, iSupplier)

Responsibilities:

• Hardware Recommendations.
• Install Vision Instance. Install Fresh DEV / CRP / UAT / PROD instances
• Single Node to Multi Node Production Migration of R12 Application
• Worked on Information gathering requirement for client.
• Prepared EBS and database architecture for the client.
• Installed the complete Oracle EBS 12.1.1 on IBM AIX.
• Completed Applications Upgrade from 12.1.1 to 12.1.3
• Installed NLS languages (Arabic, French).
• Completed DB upgrade from 11.1.0.7 to 11.2.0.3
• Prepared MD120 documents as per design and requirement.
• Prepared multiple instances like (CRP, DEV, SIT, UAT, Pre-PROD, and PROD).
• Installed NLS language (Arabic).
• Have completed cloning for every instance before going to next milestone.
• Have successfully installed Discoverer 11g with Weblogic 11g (Oracle FUSION).
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, adpatch etc).
• Prepared completed Backup /Recovery Strategic planning and successfully executed.
• Worked with Dev. Technical team for customization on EBS.
• Given KT to Client DBA regarding monitoring of Oracle Apps as well as DB.
• Troubleshooting performance related issue.

Confidential

Technologies: Oracle Applications 12.1.3, Oracle RDBMS 11g, IBM AIX 6.1

Module Lead / DBA Sol. Architect

Module: Finance, FAH, Projects, Procurement (Purchasing, Sourcing, iSupplier, Services Procurement, iProcurement), HRMS.

Responsibilities:

• Hardware Recommendations.
• Install Vision Instance. Install Fresh DEV / CRP / UAT / PROD instances
• Single Node to Multi Node Production Migration of R12 Application
• Worked on Information gathering requirement for client.
• Prepared EBS and database architecture for the client.
• Installed the complete Oracle EBS 12.1.1 on IBM AIX.
• Completed Applications Upgrade from 12.1.1 to 12.1.3
• Installed NLS languages (Arabic).
• Completed DB upgrade from 11.1.0.7 to 11.2.0.3
• Prepared MD120 documents as per design and requirement.
• Installed HRMS global driver.
• Installed complete DMZ setup for i-recruitment and i-supplier module.
• Completed setup on learning management server for HRMS module.
• Have completed cloning for every instance before going to next milestone.
• Have successfully installed Discoverer 11g with Weblogic 11g (Oracle FUSION).
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, adpatch etc).
• Prepared completed Backup /Recovery Strategic planning and successfully executed.
• Given KT to Client DBA regarding monitoring of Oracle Apps as well as DB.
• Troubleshooting performance related issue.
• Coordinated and interfaced with Oracle support for issues and SRs
• Installed and supported Oracle SOA 11g, OBIEE 11g and integrated with Oracle EBS
• Implemented Parallel Concurrent Processing (PCP) and debugging concurrent manager issues
• Customizing autoconfig templates according to the environment requirements, Re-linking applications executables, Performed Discoverer Viewer setup, Workflow configuration

Confidential

Technologies: Oracle Applications 12.1.3, Oracle RDBMS 11g, Linux AS 5

Module Lead / DBA Sol. Architect

Module: Finance, HRMS

Responsibilities:

• Install Vision Instance. Install Fresh DEV / CRP / UAT / PROD instances
• Single Node to Multi Node Production Migration of R12 Application
• Prepared EBS and database architecture for the client.
• Configure port 80 for Apache in UAT and PROD.
• Installed NLS language (Arabic).
• Installed HRMS global driver.
• AD-administration (usage of ad utilities like adadmin, adctrl, adrelink, adpatch etc).
• Configured SOA gateway for EBS to communicate with Siebel Instances.
• Prepared MD120 documents as per design and requirement.

Confidential

Technologies: Oracle Applications 12.1.3, Oracle RDBMS 11g, Linux AS 5

Module Lead / DBA Support

Module: Finance, HRMS

Responsibilities:

• Execute migration scripts through FNDLOAD
• Applied the patches using ADPATCH and APATCH
• Reset ORACLE, APPS, and SYSADMIN schema passwords.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Tuning Concurrent Managers.
• Refresh of Test, Dev, and Stage from Prod.
• Performed database tuning by using tool like AWR Report
• Created Custom Manager
• Monitoring the Database Growth
• Monitoring the Table space Growth
• Monitoring Lock events & Resolve them
• Monitoring Blocking sessions
• Purging the trace files and log files regularly
• Finding Invalid Objects and compiling them
• Monitor the sessions which are Consuming High Resources
• Resolving user errors, monitoring the database
• Rebuilding the Indexes when necessary
• Analyzing the Objects when necessary
• Experience on troubleshooting in Concurrent manger, Apache, Form server.
• Working with Generating JAR file, Massage files, Form files.
• Working with Compiling invalid objects and flex fields.
• Provided 24x7 on call production support.

Confidential

Technologies: Oracle Applications 11.5.10.2, Oracle RDBMS 10g, Linux

Technical Analyst

Responsibilities:

• Leading on Purge Activity from DBA side for Production
• Responsible for making decisions in key configuration changes, ranged from small db parameter change to Apache Stabilization, performance review for parameter changes.
• Working with 2.5 TB + database.
• Estimating downtimes for proper planned outages.
• Configuring Notification mailers, DBA Alerts etc.
• Responsible for availability of different kinds of services(reports, forms, apache etc)
• Applied Various Patches for Oracle Applications using Adpatch.
• Applied RDBMS patches using Opatch
• Creating the required table spaces, users, profiles and roles
• Validate and compile APPS schema
• Creation of Schema objects and Space Management
• System Administration of 11i / R12
• Performed online re-org of various tables.
• Performed online index rebuild.
• Monitoring concurrent jobs for Oracle Applications
• Performed Application admin tasks using ADADMIN utility
• Completed export and import of different databases using Oracle Export / Import utilities
• Registering Concurrent Programs with Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance
• Working with Workflow related issues.
• SQL Tuning using explain plan, TKPROF with SQL trace.
• Performed Apache Stabilization.
• Provided 24x7 all kinds of DBA support to development teams as well as production support to various applications.