Recommended expert

Mahmoud (Ahmed) Reda

Oracle Database and Cloud Administrator

Mahmoud Reda
Unterhaching, Germany

Experience

Oct 2023 - Present
2 years 4 months

Database Administrator

Deutsche Pfandbriefbank

  • Provision and operation of Oracle databases within the agreed service levels.
  • Storage administration using Oracle ASM feature.
  • Oracle Grid Infrastructure and database patching.
  • Ensure SLAs and operational KPIs are met, coordinating internal and external support during major incidents.
  • Create and exercise reliable backup strategies and periodic restorations.
  • Plan and execute migrations from non-multitenant to multitenant architectures and consolidate databases into multiple containers.
  • Configure Oracle database authentication with Kerberos.
  • Deploy and administer Azure Database for PostgreSQL (Flexible Server) including configuration, scaling, and high availability setup.
  • Migrate on-premises PostgreSQL databases to Azure using pg_dump/pg_restore, pg_dumpall, and Azure Database Migration Service.
  • Configure backup and point-in-time restore policies for compliance and recovery objectives.
  • Implement monitoring and alerting with Azure Monitor, Log Analytics, and custom dashboards.
  • Perform query performance tuning by analyzing execution plans, optimizing indexes, and adjusting parameters (work_mem, shared_buffers, autovacuum).
  • Collaborate with developers to implement schema design improvements, partitioning, and connection pooling (PgBouncer) for scalability.
Oct 2021 - Sep 2023
2 years

Senior Oracle Database Administrator

Getnet-PagoNxt Merchant Solutions

  • Support database instances according to defined policies, processes, and procedures.
  • Develop and document standard operating procedures and general technical documentation.
  • Monitor running database systems and related products.
  • Design and implement database architecture, including high availability.
  • Coordinate day-to-day tasks with developers to meet project deliverables and schedules.
  • Support and maintain data and database systems to meet business requirements.
  • Perform patching and upgrades of databases and Exadata machines.
  • Administer Kafka using GitLab and command line.
  • Install and configure Liquibase using GitLab.
  • Apply basic Ansible scripting and CI/CD practices.
Dec 2020 - Sep 2021
10 months

Senior Support Engineer

EnterpriseDB (EDB)

  • Provide in-depth technical troubleshooting and recommend workarounds for all EDB and open-source PostgreSQL products.
  • Collaborate with and mentor junior and mid-tier support engineers to triage issues, create reproducible test cases, file development requests, and offer patches when possible.
  • Work with development teams, including core PostgreSQL community contributors, to identify bugs and performance bottlenecks.
  • Serve as the primary point of contact for premium customers on priority engagements.
Jun 2019 - Nov 2020
1 year 6 months

Senior Oracle Database Administrator

Wirecard Service Technologies GmbH

  • Support database instances according to defined policies, processes, and procedures.
  • Develop and document standard operating procedures and general technical documentation.
  • Monitor running database systems and related products.
  • Design and implement database architecture, including high availability.
  • Conduct proof of concept for Oracle GoldenGate replication from Oracle Database to Kafka using Oracle GoldenGate Handler.
  • Migrate and upgrade databases from 11.2.0.4 to 19.6 multitenant using Data Guard, including manual upgrades and conversion to PDB.
  • Execute near-zero-downtime migrations using GoldenGate during data center server switches.
Apr 2011 - May 2019
8 years 2 months

Principal Oracle DBA Advanced Support Engineer

Oracle Corporation

  • Provide specialized DBA technical and functional assistance to Oracle customers worldwide.
  • Troubleshoot and support highly complex technology and software application implementations.
  • Manage and resolve customer service requests on Oracle products, contributing to proactive support activities.
  • Own problem resolution and manage customer expectations throughout service request life-cycles according to global standards.
  • Contribute to process and tool improvements and to knowledge management content (Metalink).
  • Work with development on product improvement programs, including testing and beta programs.
  • Operate in line with bug diagnosis and escalation guidelines.
  • Participate in remote patching for Oracle Platinum customers (AM&R team).

Key support areas:

  • General database administration and maintenance
  • Patch installation and upgrades
  • Troubleshooting and emergency issue resolution
  • Backup, recovery, and database security procedures
  • Oracle Net services configuration and tracing

Key projects:

  • Vodafone Egypt: Private Cloud implementation, grid infrastructure and database home installations and patching on SuperCluster (T8/M8), database provisioning for 30 databases.
  • MTN Nigeria and Ghana: Migrations and upgrades of large databases to RAC and Exadata with minimal downtime, data compression using HCC.
  • Commercial Bank of Africa (CBA Kenya): Cross-platform migrations of 30 core banking databases to SuperCluster.
  • QNB Qatar: Migration of 8 databases to Exadata using various methods, TDE implementation.
  • Vodafone Egypt: InfiniBand bond changes and Exadata cluster expansions, onsite support for large telecom databases, Exadata patching across EMEA customers.
  • Ageas Portugal, Morrisons UK, Network Rail UK, MTN Côte d'Ivoire, Equity Bank Kenya, ADDC UAE, Etisalat UAE: Exadata and backup appliance configurations, high availability tests, replication and ODS solutions using GoldenGate and Veridata.
  • Kuwait Finance House (KFH), HMC Qatar, EMasary Egypt, Qatar Central Bank (QCB): Advanced security, ASM reconfigurations, Oracle Audit Vault, Database Firewall implementations.
Nov 2006 - Apr 2011
4 years 6 months

Senior Technical Consultant

Egabi Solutions

  • Perform database consultation tasks for customers including Ministry of Industry, Bank Misr, and others.
  • Implement and configure Oracle Real Application Cluster (RAC) and Data Guard solutions.
  • Use import/export utilities for logical backups and SQL*Loader for bulk data loads.
  • Configure RMAN for full and incremental backups on various platforms.

Training responsibilities:

  • Conduct courses in Oracle RAC 10g, Oracle Database 10g Workshop 1 & 2, Oracle10g Security, and Oracle 10g Enterprise Manager Grid Control.

Key projects:

  • Ministry of Industry (Egypt): Configuration of Oracle Collaboration Suite 10 and RAC 10g on Windows Server.
  • Bank Misr (Egypt): RAC 10g on AIX HACMP.
  • Exports and Development Bank (Sudan): Data Guard for ATM application.
  • Military Information Data Center (Egypt): RAC and ASM on AIX HACMP.
  • Central Bank of Egypt (Egypt): RAC 10g on Solaris over Sun Cluster.
  • Bank of Alexandria (Egypt): AIX support for Oracle Database 9.2.
  • Ministry of Interior (Egypt): Oracle Fail Safe and RMAN backups on Tivoli.
  • MediTel (Morocco): RAC 10g on HP-UX Serviceguard.
  • National Security Authority (Egypt): Multi-node RAC and Data Guard on AIX HACMP.
  • Egyptian Arab Land Bank (Egypt): Database Vault implementation for PCI compliance.
  • Egyptian Credit Bureau (Egypt): RAC and Database Vault on Solaris.
  • National Water Company (KSA): Oracle ERP R12 multi-tier installation.
  • Saggaf Pharmacies (KSA): ERP cloning and site support for Oracle 10g and 11.5.9.
  • Du Mobile Network (Dubai): RAC on Solaris with QFS.
  • Saudi Snacks Foods (KSA): Upgrades and support for Oracle 9i/10g.
  • Ministry of Water and Electricity (KSA): Upgrades, migrations, RMAN with NetBackup, cross-platform migrations, and security management.
  • Ministry of Health (KSA): RAC migrations and materialized view replication.
  • Orascom Telecom (Algeria): Grid Control disaster recovery and integrations with SQL Server, DB2, and HP OpenView.
  • Mediterranean Smart Cards Company (Egypt): RAC health checks and load balancing.
  • Multiple training engagements for Oracle partners and academies in the Middle East and India.
Jan 2006 - Oct 2006
10 months

Oracle DBA Specialist

EMAK International Academy

  • Conduct Oracle technology training for clients such as Oracle GPS and Arab Construction Bank.
  • Teach courses in Oracle SQL 10g, Oracle Database 9i Fundamentals 1 & 2, Oracle Database 10g Workshops 1 & 2, 10g New Features for Administrators, and Oracle Enterprise Manager 10g Grid Control.
  • Install and configure Oracle Application Server 10g on multiple platforms.
  • Implement and configure Data Guard high availability solutions.
  • Administer Oracle security solutions.
Nov 2005 - Dec 2005
2 months

Training

Emak International Academy

  • Oracle Database 10g: SQL
  • Oracle 10g Database Administration Workshop I
  • Oracle 10g Database Administration Workshop II
  • Oracle Database 10g: Develop PL/SQL Program Units
  • Oracle Enterprise Manager 10g Grid Control
Oct 2004 - Oct 2004
1 month

Training

Cairo University

  • Cisco Certified Network Associate (CCNA)
  • Linux RedHat Administration

Skills

  • Unix
  • Oracle
  • Windows Nt
  • Ccna
  • Visual Basic

Languages

Arabic
Native
English
Advanced
German
Intermediate

Education

Oct 2000 - Jun 2005

Mansoura University

B.S., Communications and Electronics Engineering · Communications and Electronics Engineering · Mansoura, Egypt

Certifications & licenses

ITIL 4 Foundation

Cisco Certified Network Associate (CCNA)

Oracle Database Cloud Service Certified Associate

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Jakub Szepietowski
Jakub Szepietowski

Oracle Consultant

View Profile
Kai Pankatz
Kai Pankatz

Oracle Project Management and DBA

View Profile
Serkan Kaya
Serkan Kaya

Operation and Maintenance of Oracle Middleware Products

View Profile
Adrian Hollay
Adrian Hollay

Interim Consultant for Oracle Database Migrations to the AWS Cloud

View Profile
Bahriye Eser
Bahriye Eser

Freelance

View Profile
Tan Pham
Tan Pham

DevOps Engineer in the DevOps Team

View Profile
Janusz Mazurek
Janusz Mazurek

IT Senior Software Engineer

View Profile
Jozef Kapicak
Jozef Kapicak

Application and Database Designer; AI Solutions Architect

View Profile
Ernst Höfler
Ernst Höfler

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

View Profile
Stefan Moisa
Stefan Moisa

SAP Basis Administrator

View Profile
Rodrigo Herrán
Rodrigo Herrán

Data Engineer

View Profile
Harald Laschitz
Harald Laschitz

Project Management

View Profile
Nils Meyer
Nils Meyer

Database Architecture for PostgreSQL

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Werner Hendricks
Werner Hendricks

Oracle Database Migration Consultant

View Profile
Matthias Barfknecht
Matthias Barfknecht

Database Developer / Database Architect

View Profile
Stefan Freundt
Stefan Freundt

Oracle Consultant

View Profile
Roland Millonig
Roland Millonig

Oracle DBA (Remote)

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Sebastian Dörr-willken
Sebastian Dörr-willken

Senior IT System Administrator

View Profile
André Görst
André Görst

IT Consulting Project Management / Engineering Subproject Management

View Profile
Younes Hadrous
Younes Hadrous

Senior Backend Developer

View Profile
Jürgen Bargmann
Jürgen Bargmann

Database Administrator and Performance Tuning Specialist

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Dirk Behringer
Dirk Behringer

Senior Consultant Database Administration and SQL

View Profile
Frank Eppink
Frank Eppink

DevOps

View Profile
Jens Rehsack
Jens Rehsack

Technical Product Owner

View Profile
Christian Hacker
Christian Hacker

Qualifications Profile

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile