Recommended expert
Mahmoud (Ahmed) Reda
Oracle Database and Cloud Administrator
Experience
Oct 2023 - Present
2 years 4 monthsDatabase 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 yearsSenior 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 monthsSenior 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 monthsSenior 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 monthsPrincipal 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 monthsSenior 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 monthsOracle 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 monthsTraining
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 monthTraining
Cairo University
- Cisco Certified Network Associate (CCNA)
- Linux RedHat Administration
Skills
- Unix
- Oracle
- Windows Nt
- Ccna
- Visual Basic
Languages
Arabic
NativeEnglish
AdvancedGerman
IntermediateEducation
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