Summary
Overview
Work History
Education
Skills
Certification
Languages
Training
Personal Details
Timeline
Generic

Mohamed Fawzy Ismail Abdelhalem

Riyadh

Summary

Cloud Solution Architect, Advanced SQL/T-SQL 15+ years of experience in designing, developing, and implementing database solutions using Microsoft SQL Server, leading to improved business functionality and increased revenue. Experienced senior database administrator with proven expertise in performance tuning, crisis management, and ensuring high availability. Skilled in improving reliability, increasing productivity, reducing license costs, and introducing system efficiencies. Demonstrated excellence in establishing disaster recovery plans and procedures. Strong problem-solving abilities and adept at building solid relationships with strategic partners while fostering consensus across multiple organizational levels.

Professional Database Specialist with a strong background in optimizing database systems and ensuring data integrity. Skilled in SQL, database design, and performance tuning, with focus on team collaboration and achieving impactful results. Known for adaptability, problem-solving abilities, and reliability in dynamic environments. Ready to contribute to innovative projects and drive success within forward-thinking organization.

Overview

15
15
years of professional experience
4
4
Certification

Work History

Cloud Solution Architect

Microsoft
01.2024 - Current
  • Technical Scope: Microsoft SQL Server 2000 to 2022; SQL; T-SQL; Azure VM; Azure SQL; Managed Instance; PowerShell; Microsoft’s C# .NET; SSIS; SSRS; SSAS; Oracle 12c to 19c; PL/SQL; Python 3.7; Windows Server 2008 to 2022; Red Hat 8 - 9; SQL Server under Linux
  • As a Microsoft SQL Server Customer Engineer, I serve as a trusted advisor and technical expert to enterprise customers, helping them unlock the full potential of their SQL Server environments. I bring deep, hands-on expertise across the SQL Server stack—including database performance tuning, T-SQL optimization, business intelligence tools (SSRS, SSAS, SSIS), and complex migration and upgrade strategies. My mission is to ensure customers achieve operational excellence, scalability, and resilience in their data platforms.
  • Analyze and optimize SQL Server workloads using advanced techniques such as execution plan analysis, index tuning, and query rewriting.
  • Identify and resolve bottlenecks in T-SQL code, stored procedures, and long-running queries.
  • Implement best practices for memory management, I/O throughput, and CPU utilization.
  • Design and refactor complex T-SQL scripts for scalability, maintainability, and performance.
  • Mentor developers and DBAs on writing efficient, secure, and modular T-SQL code.
  • Troubleshoot and resolve logic errors, concurrency issues, and transaction handling.
  • Architect and deploy SSRS reports with dynamic datasets, parameterized queries, and custom visualizations.
  • Design and optimize SSAS cubes and tabular models for multidimensional analytics.
  • Develop robust SSIS packages for ETL workflows, data cleansing, and transformation across heterogeneous sources.
  • Lead end-to-end migrations from legacy systems to modern SQL Server platforms, including Azure SQL and hybrid environments.
  • Design and execute upgrade plans with minimal downtime, ensuring schema compatibility and data integrity.
  • Automate migration tasks using PowerShell, Data Migration Assistant (DMA), and custom scripts.
  • Integrate SQL Server with other Microsoft technologies such as Azure Data Factory, Power BI, and Active Directory.
  • Collaborate with infrastructure teams to ensure high availability, disaster recovery, and security compliance.
  • Provide guidance on licensing, scalability planning, and cloud adoption strategies.
  • Deliver workshops, deep-dive sessions, and hands-on labs tailored to customer needs.
  • Create detailed technical documentation, runbooks, and knowledge base articles.
  • Act as a feedback conduit between customers and Microsoft product teams.

Team Leader: SQL DBA and Database Developer

Bank Albilad
11.2021 - 12.2023
  • Technical Scope: Microsoft SQL Server 2012 to 2019; Azure VM; Azure SQL; SSIS; SSRS; SQL; T-SQL; Oracle 11g to 19c; PL/SQL; MySQL 5.5; PostgreSQL; MongoDB; Microsoft’s C# .Net; Python 3.7; PowerShell; Windows Server 2008 to 2019; Red Hat 7 & 8; Ubuntu 20.04
  • I lead the Database Engineer and Operations team at Bank Albilad, managing big data and the T24 core banking system with strict SLAs and continuous on-call support. Bank Albilad is the Middle East’s first bank to implement Microsoft SQL Server for core banking.
  • Configure various types of High Availability and Disaster Recovery solutions for Microsoft SQL Server.
  • Skilled at designing and managing indexes to improve queries and maintain data integrity.
  • Automate tasks with SQL agent jobs, SSIS, PowerShell, and Python.
  • Migrating both homogeneous and heterogeneous databases.
  • Proficient in T-SQL, including DMWs, stored procedures, functions, triggers, and SQL tuning.
  • Restore previously deleted records, incorrect updates, or reinstate data online without incurring downtime—even in large-scale databases (such as those of 100TB or 250TB)—by converting hexadecimal records from transaction log files or backups and re-inserting them as needed.
  • Experience in managing and configuring Windows clusters and conducting detailed troubleshooting.
  • Managing large databases over 200TB.
  • Encouraging the team to complete tasks within set timeframes.

Senior Database Architect

Wipro
04.2020 - 11.2021
  • Technical Scope: Microsoft SQL Server 2012 to 2019; SSIS; SSRS; SQL; T-SQL; Oracle 11g to 19c; PL/SQL; MySQL 5.5; Microsoft’s C# .NET; Python 3.7; PowerShell; Windows Server 2008 to 2019; Red Hat 6, 7 & 8; Ubuntu 20.04
  • I served as Team Leader for Database Administration and Development at Riyadh Airports Company, overseeing diverse MS SQL Server and Oracle database servers. I led program and data migrations, database consolidation, and daily automation/reporting initiatives, while ensuring system performance and availability met SLA standards. Additionally, I managed Linux system administration tasks for both application and database servers.

Senior SQL DBA and Database Developer

Saudi Telecom Company
11.2013 - 03.2020
  • Technical Scope: Microsoft SQL Server 2008 to 2016, SSIS; SSRS; Oracle 11g & 12c; MariaDB 1.3; MySQL 5.5; Microsoft C# .Net; Python 3.7; Windows Server 2008 & 2012; Red Hat 6.7
  • As a Senior Database Administrator and Developer, I manage over 1000 database servers across various MS SQL Server configurations (Standalone, Failover Cluster, Always-On, Replication, Mirroring, Log Shipping) and Oracle platforms. I lead migrations, changes in programs, databases, and reference data through the development lifecycle, consolidating SQL Server and Oracle environments. My role includes performance tuning, optimization, capacity planning, troubleshooting, application tuning, and ensuring design compliance with site standards. I produce technical documentation, oversee impact analysis for database modifications, implement security patches and custom encryption, and support development teams while handling operating system tasks.

Senior SQL DBA and Database Developer

ITSC
05.2011 - 10.2013
  • Technical Scope: Microsoft SQL Server 2000, 2005 & 2008; Oracle 11g; MySQL 5.5; Microsoft C# .Net; Windows Server 2003 & 2008; Red Hat Linux 5.5; ITIL Foundation
  • Managed wide-ranging remittance database and other money collection databases operations and ensured compliance with system security standards. The led database schema performed maintenance checks and troubleshot performance issues. Created environment design, table structure, and indexing strategies to maximize performance and minimize maintenance. Formulated and structured database failure contingency plans for disaster recovery and enforced security for databases. Partnered with database developers to develop and implement procedures, functions, triggers/complex SQL queries, and T-SQL or PL/SQL for operational team use which supported the business from the database side. Validated customer backup and recovery strategies and delivered effective recommendations.
  • Successfully led database administration and database developer projects with competing demands in e-Post service to collect money and integrate with many systems.
  • Conceptualized and developed program by leveraging T-SQL techniques for encryption with a dynamic generator which produced different encryption for the same data.
  • Created scripts for the replication between two SQL server clusters and automated new object development which changed with the T-SQL process to reduce the high cost of a license for Always-On Availability Groups configuration.

Oracle DBA and Forms & Report Developer

ORATECH
08.2008 - 05.2011
  • Technical Scope: Oracle 9i; Oracle 10g; Oracle 6i Forms and Reports; Windows Server 2003; Red Hat Linux 5.5
  • Managed database operations to ensure availability, scalability, and performance. Designed storage and disaster recovery plans for reliable data protection. Optimized legacy systems, coordinated resource sharing, and updated existing databases.
  • Supported the development team in designing and implementing PL/SQL modules and replication scripts across four instances, integrating with four ERP system applications to optimise processes and minimise Oracle replication licensing costs.
  • Implemented a security control system using Oracle 6i forms in the ERP to grant user access within the form.

Customer Service

New Horizons
08.2007 - 07.2008

Microsoft ASP .Net Web Developer & Database Developer

Freelancer
03.2005 - 07.2007
  • Technical Scope: Microsoft C# & Visual Basic; HTML; CSS; Microsoft SQL Server 2000 & 2005; Microsoft Access; Windows Server 2003
  • After graduating, I collaborated with numerous clients to develop web services and implement enhancements for their applications. I facilitated the migration of several systems from Procedural to Object-Oriented Development and converted applications from Visual Basic to .Net C#. Additionally, I created, modified, and optimized a variety of reports on both the application and database levels, and managed database migrations from Microsoft Access to Microsoft SQL Server.

Education

Bachelor's degree - management information systems (MIS)

Egyptian Higher Institute of the Alexandria Academy of Administration and Accounting

Skills

  • Software & Hardware: Microsoft SQL Server 2000 till 2022, SQL Server Architecture & Internals, Failover Cluster, Always On, Replication, Log Shipping, Mirror, SQL Developer, SQL Tuning, Performance Tuning, Integration Service, Reporting Service, Windows Server 2003 - 2022; Oracle 9i - 19c; SQL; T-SQL; PL/SQL; Red Hat Linux 5 - 9, Servers, MariaDB 13 - 14, MySQL 55, Microsoft’s C# NET; Python 37; Oracle 6i Forms & Reports; Shell Script; PowerShell, Azure VMs, Azure SQL, Azure Managed Instance, SQL Server under Linux
  • Languages: Arabic (C1), English (B2), and German (A2)
  • Automation scripting
  • Solution implementation
  • Problem-solving abilities
  • Multitasking Abilities
  • Decision-making
  • Database troubleshooting
  • SQL expertise
  • Data migration
  • Performance tuning
  • Replication strategies

Certification

  • Microsoft Certified Professional (MCP)
  • Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 / 2014 Database Administration
  • Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration
  • Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development
  • Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics

Languages

Arabic (C1)
English (B2)
German (A2)

Training

  • Oracle Database 11g SQL
  • Oracle Database 11g PL/SQL
  • Oracle Database 11g Administration I & II
  • Oracle Database 10g Application Server
  • Oracle Database 12c Administration I & II
  • Oracle Database 12c Administration - RAC & Data Guard Integration

Personal Details

  • July 12th, 1982
  • Place of Birth: Egypt
  • Nationality: Egyptian Male
  • Civil Status: Married
  • Location: Saudi Arabia

Timeline

Cloud Solution Architect

Microsoft
01.2024 - Current

Team Leader: SQL DBA and Database Developer

Bank Albilad
11.2021 - 12.2023

Senior Database Architect

Wipro
04.2020 - 11.2021

Senior SQL DBA and Database Developer

Saudi Telecom Company
11.2013 - 03.2020

Senior SQL DBA and Database Developer

ITSC
05.2011 - 10.2013

Oracle DBA and Forms & Report Developer

ORATECH
08.2008 - 05.2011

Customer Service

New Horizons
08.2007 - 07.2008

Microsoft ASP .Net Web Developer & Database Developer

Freelancer
03.2005 - 07.2007

Bachelor's degree - management information systems (MIS)

Egyptian Higher Institute of the Alexandria Academy of Administration and Accounting

Similar Profiles

CREATE PROFILE
Mohamed Fawzy Ismail Abdelhalem