oracle apps dba
Resume:
Khaled Badr
Contact
********@*****.***
United States
Visa status : Green Card
Experience
Sr. Apps DBA Dec 2020- Feb 2021
Booz Allen Hamilton
Maintaining Oracle EBS Application and Database using AD Utilities.
Troubleshooting issues related to weblogic and SOA components.
Applying Patches using AD Patch Utility on Application file System and Technology Stack.
OEM, RMAN backup and Recovery.
Troubleshooting issues related to concurrent managers.
Managing System Configuration using Autoconfig.
Cloning and DataGrid tasks.
Sr. Oracle APPS DBA June 2019 - Apr 2020
E-finance
Upgrade EBS env from R12.1.1 to R12.2.8.
Upgrade Database from 11g to 12c,19c
Migration from physical machine (linux 4) to VM (linux 7).
EBS Administration, Cloning, Performance tuning, and patching.
Designing Backup/Recovery policies for EBS environment.
Configure mobile application, public DMZ and https migration.
Java and jinitiator upgrade and tuning (GC tuning).
Work on Parallel Concurrent Processing (PCP) Setups.
Interact with Network teams on network and load balancer setups.
Develop and customize forms and reports for EBS.
Oracle APPS & OBIEE DBA Lead Feb 2014 - May 2019
Oracle Corporation
Lead a technical team to migrate oracle customers to the cloud –IAAS ( LHR, Siemens, Arcadis, Peugeot ...etc).
Deploy the application to OCI Compute virtual machines and database to OCI or DBaaS or Oracle RAC.
Installing new EBS, OBIEE and WLS Application environments.
Work on DMZ setups to E-Business Suite
Design Cloning strategies.
Work on integration options of E-Business Suite with other environments such as (SOA, OSB, OBIEE …etc
Setting up E-Business Suite with Oracle Access Manager/OID to achieve Single Sign-On (SSO) Capabilities.
Work on Standby site setups for both applications and databases.
Lead an implementation team through multiple projects for Example
oOBIA upgrade from 7.9.6.3 to 7.9.6.4
oMigrate OBIEE12c to OCI.
oDBA support service for RTD application.
oInstallation, configuration and upgrading of Oracle server software and related products..
Principle APPS & OBIEE DBA Jan 2012 - Jan 2014
Oracle Corporation
Configuring and managing data warehouse, EBS, OBI presentation catalog and OBI repository, analysis and dashboard.
Configuring connection to external systems (EBS,Siebel ..etc)
Diagnosing and resolving issues in OBIEE and EBS .
Work as part of a team and provide 24 7 support for EBS, OBIEE and standalone technology stacks ( ODI, DAC,WLS, Informatica ..etc
OBIEE & OBIA upgrade, catalog and repository migration.
Support and troubleshoot DAC, Informatica, ODI, Essbase ..etc
Loading data from external system using EIM.
Design, develop and modify ETL routines for data warehouse.
Senior Apps DBA Nov 2007 – Dec 2011
Oracle Corporation
Install and configure Oracle Applications components (Oracle HTTP Server, oracle application framewark, HTML based application, forms services and Applet ..etc
Apps administration using AD utilities, OAM and CM.
EBS account management, access control (RBAC), delegation,assign & revoke role and printing with pasta.
Define function and data security (assigns responsibilities, menus, request groups and concurrent program …etc.
Manage, monitor and configure workflow (OWM), concurrent processing, notification mailer, background engine, agent listener ..etc).
Cloning Oracle Applications using adclone, Autoconfig, Rapidclone ..etc
Applied Latest CPU and PSU Maintenance Patches.
Architecture & Provisioning of environments (RAC, Standby DB (DR systems), multi-tier, DMZ and PCP configurations.
Housekeeping tasks like purge of workflow tables & logs.
Change Management tasks like applying patches for Oracle Applications, Database, Discoverer, weblogic, application server ..etc
Incident Management, Monitoring & Technical Assistance, including Production and Performance diagnostics, technology assessments and troubleshooting complex problems.
Configuring, administering, and Troubleshooting Oracle Fusion Middleware
Sr. Oracle DBA Nov 2001- Oct 2007
Alpha
Tuning the user defined SQL queries, procedures and functions using Toad, explain plan, tkprof.
Troubleshoot Database performance issues using EXPLAIN PLAN, TKPROF, SQL TRACE, Analyze, Hints, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) etc.
Worked on various database tools like AWR, Statspack, Data pump, Flashback tables, Oracle wallet manager (OWM), ASM and SQL Tuning Advisor etc.
Installation and Configuration of Oracle 10g Real Application Clusters (RAC) and Automatic Storage Management (ASM).
Configured and maintained Oracle standby DB and datagaurd.
Application Consultant Mar 1999 - Oct 2001
Cite
Implementing lodging toch application in more than 5 hotels.
Customize forms, report using visual basic 6 & crystal report.
MS sql server 97 and 2000 Administration and tuning.
Network Engineer Apr 1997 - Jan1999
Al sarraf
Network installation and administration for government projects using windows NT, windows 2000 server,unix,(sun solaries and hp), and linux (redhat).
Good experience in active directory, RAS, Exchance server, proxy server and ISA server.
Personal Summary
Over 20 years’ experience handling many products and cutting edge technologies.
During this period, I was able to participate in many successful projects and playing different roles (DBA, team lead, technical manager and project manager).
Certification
TOGAF foundation (part1)
TOGAF Certified (part2)
Oracle Cloud infrastructure (OCI )
Oracle DBA 10g (OCP)
Oracle DBA 11g (OCP)
Application Server 10g (OCP)
Workflow 11g (Certified Expert)
RAC 10g (Certified Expert)
Oracle on linux (Certified Expert)
R12 application DBA (OCA)
Tuning 11g (Certified Expert)
Linux Fundamental (OCA)
ITIL foundation (Certified)
Skills
PMP
IAAS, PAAS and DBAAS.
Database admin (OLTP &OLAP)
Tuning (SGA, AWR, ASH, tkprof, Execution plan, OS, Java and GC)
Backup & Recovery, Flashback, RMAN.
SQL & PL/SQL
UNIX & Linux.
Exadata, RAC, ASM, RMAN.
Datagaurd, DR & standby DB.
E-Business 11i & R12
EBS DBA, Autoconfig, adpatch, CM
Cloning, DMZ, MWA, https, load balancer F5.
BI Publisher, Data model, ETL & ELT.
Workflow 11i & R12
OracleAS10g (OID, LDAP, SSO, OHS)
SOA suite admin & BPEL.
FMW 11 & 12 (Weblogic, IDM, OAM, IDM, Accessgate, Webgate ..etc.
Oracle enterprise manager (OEM).
OBIEE, OBIA, DAC, informatica, ODI
Siebel CRM admin.
Xml publisher, java, jinitiator, J2ee, JVM, jserv, IMAP, SMTP
HFM, Essbase, Smartview.
Primavera P6 & Agile administration.
APEX 4.2 & 5 admin & Dev.
Accomplishment
Lead and manage technical team globally through production and implementation phase.
Migration 40+ OMCS customers to (OPC) successfully.
Initiation, provisioning and solution architect to 25+ OMCS Customers successfully which were using different products (EBS, OBIEE, Siebel, FMW, RAC, DR ...etc).
On-premises to OPC integration (Iaas, PaaS and SaaS)
Certified in many products (13+ Certification).
Attend and complete different trainings, LVC, seminars and workshops in many different topics
(technical, management, soft skills and languages).
Gain different skills and practice technical and management tasks.
Scheduled and staffed coaching sessions for new hired.
Education
B.Sc. in Telecommunication and Electronics Engineering Sep 1991 – Jun 1996
Ain Shams University Cairo, Egypt
Training
PMP (Project management professional)
TOGAF 1 & 2
Lead to achieve.
Oracle Database administration 10g, 11g, 12c.
R12 Oracle Application System Administrator Fundamental.
R12 Install, Patch, And Maintain Oracle Application.
Oracle Application Server 10g: administration.
Oracle SOA Suite 10g: Services Orchestration.
Primavera EPPM Technical Installation Boot Camp.
Siebel 8.1 application administration.
Oracle Business Intelligence Enterprise Edition.
Oracle ODI Integrator 11g: integration and administration
HFM Management 11.1.2: Create and Manage applications
Contact this candidate