SUMMARY:

• Software Engineer / Senior Oracle Apps DBA with total of 15 years of experience in Analysis, Design, Development, Testing and maintaining Business Software Applications along with their Databases. Worked in many high profile projects in KSA and Pakistan and contributed in the success of many implementations/Upgrades and Migration in Oracle EBS with its different releases.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Installation, Upgrade and maintenance of Oracle 10g, 11g, 12c databases with EBS release 11i, R12.12.1, 12.2.0 - 12.2.8 Application in Linux/Unix/HPUX environment.
• Hands on Knowledge of Installation, Maintenance and support of Oracle RAC Databases, ASM.
• Configuration, Support and Maintenance of Disaster Recovery Sites DR / Data Guard with RAC / Non RAC EBS Databases.
• Experience in taking regular off-line, online backups using RMAN(Hot Backup).
• Installation and Configuration of RHEL/OEL Linux Servers to be used with R12/11g or 12c Databases.
• Upgrade of Oracle EBS 11i to R12, 12.1.1 to 12.1.3 and from 12.1.3 to 12.2.8
• EBS Database Upgrade from 10.2.0.4 to 11.2.0.4 (11g) and 11.2.0.4 to 12.1.0.2 (12c)
• Configured and enabled Secure Socket Layer - SSL in Oracle EBS R12
• Configuring iRecruitment/ iSupplier Portal in Demilitarized Zones (DMZ).
• Oracle E-Business Suite integration with Single Sign On - SSO / Active Directory.
• Planned and applied Regular Patches, CPU and HRMS RUP 5, 6, 7 and 8 patches along with Legislative Data Installation. / HR Global Patch.
• Upgraded Java 6 to latest certified version at EBS R12 Server side and Client.
• Java Applet signing with trusted for avoiding Java Applet warnings and prompts.
• Database Patching and Application Patching.
• Cloning SSO / Non SSO / SSL / Non SSL enabled -11i/R12 Apps and Database from Production to Test.
• Administration and /Trouble shooting Concurrent Manager.
• Experience of using ADADMIN Utilities like ADOP, ADADMIN, ADPATCH, ADCTRL, ADRELINK.
• Experience in Managing Fusion Middleware and Weblogic Administration Console configurations.
• Overall operations and support for ERP - Production, Development and Test Environments.
• Enterprise Manager Installation and configuration.
• ERP, upgrades, patches (Hot/Cold), User Management, Backup/Recovery Management, Service Request Management, Monitoring Applications and its services on Linux platform.
• Installed and configured Production Oracle E-Business Suite Release - 12.1.3 on Shared File System with RAC Database 11.2.0.4.
• SSL Deployed over DMZ to enabling External Access on Self Service HR Module
• Production Oracle Fusion Middleware Upgrade:
• Upgraded Oracle EBS Fusion Middleware 11G 11.1.1.6 to 11G 11.1.1.9 on RHEL being Part of the EBS Release Upgrade process from R12.2.4 to R12.2.5
• Jun 2016
• Production EBS 12.2.4 - Java Code Signing Deployment
• Successfully Deployed Java Code Signing on IPA's Production E-Business Suite
• Production Oracle Database Upgrade:
• Upgraded Oracle EBS R12.2.4 Database 11G 11.1.0.7 to 11G 11.2.0.4 on RHEL 64Bit
• Apr 2016
• Production Oracle Database Upgrade:
• Upgraded Oracle EBS R12 Database 11G 11.1.0.7 to 11G 11.2.0.4 on RHEL 64Bit
• Sep 2014
• Production Oracle Database Upgrade
• Upgraded Oracle EBS R12 Database 10G to 11G 11.2.0.3 on RHEL 64Bit

Confidential

Responsibilities:

• Migrated Production EBS 12.1.3 from Windows Server 2008 to Red Hat Enterprise Linux 7. SAUDI BIN LADEN GROUP - Jeddah KSA:
• Successfully Upgraded & Migrated Production Oracle EBS 11.5.10.2 to 12.2.8 & Database 9.2.0.7 to 12.1.0.2.

  The EBS 11i Application was in a split configuration as below:

  (Concurrent & Admin Node was on HPUX 64 bit

  With Forms and Web node running on Windows Server bit)

  The Database 9.2.0.7 was on HPUX 64 bit.

  Both Application and Database Upgraded and Migrated to Enterprise Linux 7.6

• Installation & Upgrade: Oracle E-Business Suite R12.1.1 toR12.1.3 March 2013 Completed a Project (on freelance basis) in Atlas Batteries Manufacturing Company.

  It was a 2 Node Configuration where the following was accomplished (Independently):

Confidential

Oracl e Apps DBA / Assistant Manager

Responsibilities:

• Maintenance and Support of Oracle Application and Database - Oracle E-Business Suite R12.1.3.
• Oracle Apps Techno Functional support to Oracle Financials and other integrated modules.
• Development and Performance tuning of complex business reports with SQL and PL-SQL.
• Analysis, Design and Deployment of Custom XML Reports in Oracle E-Business Suite R12.
• Administration and /Trouble shooting Concurrent Manager.
• Oracle Alerts / Workflow Mailer configuration.
• Table space growth management and scheduled recovery of free space .

  Coordinate with Oracle Metalink (Knowledge Base/ Service Request) to resolve bugs etc.

• Daily monitoring, analysis and ensuring smooth execution of Concurrent requests.
• Cloning of ERP Application and Database from Production to Test Environment.
• 24/7 & emergency support on site or Remote Support for Production ERP environment.
• Overall operations and support for ERP - Production, Development and Test Environments.
• ERP, upgrades, patches (Hot/Cold), capacity planning, User Management, Backup/Recovery Management, Service Request Management, Monitoring Applications and its services on Linux platform.

Confidential

Oracle Apps DBA / Assistant Manager

Responsibilities:

• Installation and maintenance of Application and Database Servers - Oracle E-Business Suite R12.1.1 (Single/Multi Node) both on Linux/Windows on Physical/Virtual Machines (VMware Esxi 4.0 and other flavors’).
• Used Oracle Maintenance Utilities like Adadmin, Adpatch for Forms Compilation, Patching (Hot/Cold), Relinking etc.
• Applying patches/Release Update Packs in Test and Production Environment.
• Server Virtualization Technologies, VMware, Exsi 4(Vsphere)
• Troubleshoot Operational Apps/database issues.
• Administer/Trouble shoot Concurrent Manager.
• Implement valid node checking to restrict database access from client machines.
• Performance tuning by ‘Statistic update’ of all oracle Products.
• Rapid Cloning of Production to Test Environment on need basis.
• Looking after Production down issues.
• Database Backup and Recovery using both Oracle and third party tools.
• Table space growth optimization &management
• Daily monitoring, analysis and ensuring smooth execution of Concurrent requests.
• Over all operations and support for Production, Development and Test Environments.

  • Experience of Implementing Virtual Oracle Real Application Cluster (voluntarily basis).

• Have schema knowledge of financials and other modules.
• Analyzed, Designed and Deployed Customized Reports in Oracle E-Business Suite R12 using Oracle BI Publisher for AP, AR, GL and other integrated modules .
• Manage Concurrent Programs and registration of new Reports.
• Troubleshooting and resolving Workflow issues.

Confidential

Software Programmer

Responsibilities:

• Discussions with the users of the department to gather requirements.
• Designed and developed the forms using VB6.
• Writing new program code using prescribed specifications
• Code, test and troubleshoot programs utilizing the appropriate hardware, database, and programming technology.
• Refine data and format final product.
• Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes.
• Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of supervisor.
• Write and maintain programming documentation.
• Maintain confidentiality with regard to the information being processed, stored or accessed.
• Document programming problems and resolutions for future . Resolving backend issues.
• Environment: VB6.0, Oralce 10g, Crystal Report 8.