Mohamed Bakr Mbrouk

Middleware

• Design High-available, configuration, and maintenance including clustering and load balancing for FMW (WLS, ADF, OTD, OSB, SOA, ADF, forms &reports, Analytics, OEMM, ODI, OHS, EMCC) in PCA & Exalogic.
• Install, configure and manage EDG for FMW.
• Develop automation scripts.
• Configure and maintain Oracle Scheduler for High-available FMW domains.
• Configure and maintain Security, OWSM and SSL (one way & 2 way) for FMW domains.
• Deploy codes (ADF apps, Web Service, SOA process, FMB, RDF, OSB projects……) on FMW domains and Co-operate with developers to migrate code between non-production and production Env's.
• Troubleshoot FMW correlated issue with database, application, networking and OS.
• Monitor and Co-operate with developers teams to solve FMW problems through heap and thread dump analysis using java mission control and Java Virtual Machine Diagnostics (JVMD).
• Configure metrics and alert thresholds.
• Plan, prepare and apply maintenance patches, security patches and fixes of FMW.
• Upgrade FMW environments to new versions.
• Provide On-Call support for production environments.
• Clone FMW in external environment outside PCA & Exalogic (T2P, Sync).
• Manage routine backup on 3 levels (storage, OS, FMW).
• Create & manage disaster recovery (DR) Site procedures.
• Ensures that FMW environments remain stable and available with least interruption and impact to business
• Use Oracle Cloud 13c & Dynatrace to monitor, configure, measure, and maintain Oracle FMW.

Database

• Install and configure DB single and RAC.
• Configure, monitor and manage Oracle Active Data Guard.
• Refine physical design to meet system storage requirements.
• Control objects access permissions and privileges.
• Apply business analyst needs.
• Protect database against unauthorized access.
• Develop metrics regarding usage and performance.
• Troubleshoot & solve Oracle MAA problems.
• Manage backup & disaster recovery aspects of database.
• Plan, prepare and apply patches.
• Perform Linux Server administration activities related to FMW & DB.
• Configure & manage network services (HTTP, ….)
• Create & manage shell scripts for FMW & DB tasks.

PCA & Exalogic

• Configure & run ExaBR, Exalog, Exachk utilities.
• Configure and manage PCA & Exalogic components (Ovm Manager, Exalogic stack, compute and management nodes, ZFS, switches, PDU's).
• Manage vm servers in Exalogic (Define new EoIB, Create new Exa user, Create new account, Create server type, Create new template, Allocate IP's).
• Manage vm servers in PCA (Create new VLAN, create new template, Create vm servers, Managed vm servers).
• Monitor PCA & Exalogic machine components using (emoc dashboards (Exa only), emoc incidents (Exa only), ZFS worksheets, ZFS logs & problems, ILOM for compute node& ZFS appliance& infiniband, Infiniband network connectivity).
• Manipulate Ovm Manager (Configure server pool, storage and repositories, create vm's).
• Configure ZFS appliance (ZFS service (nfs, dns, http, iscsi, .........), Projects, Shares, LUN's, workflows).
• Work with Oracle support for keeping PCA, Exalogic up and running.
• Install OCNE 1.8 (oracle Kubernetes distribution).
• Develop comprehensive documentation covering all work-related activities, including installation, configuration, troubleshooting, and other operational issues.
• Transfer PCA & Exalogic knowledge to FMW & DB section members.

• Monitor logs for servers, SAN Switch and Storage.
• Solve H/W problems in collaboration with Maintenance & Vendor teams.
• Solve O/S problems.
• Perform Unix/Linux and Windows administration that supports E-Suite tasks.
• Manage HP Cluster Serviceguard (11.19).
• Manage oracle and SQL servers database Admin tasks.
• Analysis of problems and solve them on time.
• Design Database procedure for Automation of database tasks.
• Monitor E-suite Performance.
• Handle Oracle E-suite System Admin tasks (Security, Conc. Manager, WF……..).
• Create Application Notification alerts.
• Apply all fixes patch for all modules (Automatically or Manually).
• Provide required support to consultation team during handling MetaLink SR.
• Help Business consultant's /Developers teams to solve their technical problems.
• Manage, Monitor and test of Apps & DBs backups (Oracle Servers & SQL server).
• Recover of database and O/S failures.
• Install and configure Oracle Data Guard 10g.
• Install Oracle Developer Suite.
• Create and modify reports (standalone, EBS) using report builder.
• Install and configure OBIEE R10g.
• Build OBIEE Layers, answers, Dashboards and delivers.
• Install and configure Oracle Golden Gate 11g.
• Install and configure Oracle EM cloud control 12c.
• Develop SQL, PL/SQL scripts for HR system.
• Modify and update HR reports and forms.
• Develop documentation and presentations to management and technical team.

• Managing multi environments of databases (production, test) over H/W (Compaq, Fujitsu, HP) & O/S (windows 2003, 2008, Linux Red Hat).
• Upgrade database thorough various version of oracle server (8,8i,9i,10g) on OS windows platform.
• Downgrade oracle database Version 10.2.0.1.0 to Version 9.2.0.1.0 on OS Windows 2003 platform.
• Analyze problems and identify root cause to reduce probability of reoccurrence.
• Solving Oracle Database & Oracle tools problems.
• Work with vendors where necessary to achieve timely resolution for apps problems.
• Tune ERP and BPCS apps databases.
• Plan and implement backup & recovery for databases.
• Manage users & apps security.
• Control & monitor database user access.
• Plan and allocate storage needs for database and apps.
• Create and modify database objects structure related to apps as developers advise.
• Install (IMPACT - BPCS - Compact) apps and upgrades them as required with other team.
• Install and Configure Oracle (8,8i,9i,10g,11g) on Windows (NT,2000,2003,2008) &Linux.
• Install and Configure Oracle Developer tools.
• Ensure compliance with Oracle license agreement.
• Develop SQL, PL/SQL scripts for HR system.
• Prepare Provision study for new IT Department Projects.

• Administrate DB and network to provide services (scientific, technical and service information) for Syndicate members.

• Administrate network devices (PC's, Plotters, Scanners …) and database handling to achieve timely schedule of journalism information.