Mustafa Elmasry
Expert Database Consultant
Saudi Arabia
Summary
Expert database consultant with over 14 years of experience as a Database Administrator, specializing in database migration, consolidation, performance tuning, and automation using T-SQL and PowerShell. Proficient in cloud database technologies, with multiple Microsoft certifications, including SQL Server 2008 and 2016 (MCTS, MCITP, MCSA, and MCSE).
Certified Microsoft Trainer (MCT) with additional Azure certifications as an Azure Administrator, Database Administrator, and Data Engineer. Recognized by Microsoft as an Azure Content Hero, Azure Community Hero, and Azure Mentor.
For a detailed overview of my achievements, contributions, and certifications, please visit my website: https://mostafaelmasry.com/about-me/.
Overview
2025
2025
years of professional experience
15
15
Certifications
2
2
Languages
Work History
Database Subject Matter Expert (Team Leader)
Al-Rajhi Bank
9 2021 - Current
- Managed Nutanix Database Clusters using Nutanix Database Platform (NDP) to optimize database operations, scalability, and high availability.
- Designed and implemented performance improvement strategies and plans to drive continuous improvement in database systems.
- Applied critical thinking to analyze complex problems, evaluate solutions, and make informed decisions.
- Managed a portfolio of over 300 SQL Server instances, handling high-transaction environments and databases exceeding terabyte sizes.
- Administered and maintained additional database platforms, including PostgreSQL, Oracle Cloud, and Azure SQL.
- Oversaw the management of mission-critical core business databases, such as T24, CRM, and CTF.
- Developed automation solutions using advanced PowerShell scripting to streamline database operations.
- Designed and implemented ETL solutions utilizing SSIS, SSAS, and SSRS for robust data integration and analysis.
- Expert in performance tuning, employing advanced techniques to optimize database efficiency.
- Demonstrated exceptional troubleshooting skills, resolving complex database issues at a deep technical level.
- Specialized in all aspects of database administration and development tasks, ensuring seamless operation and scalability.
- Proficient in implementing and managing high-availability and disaster recovery solutions, including clusters, Always-On multi-subnet failovers, and EMC storage replication.
Senior Data Engineer
Bank Albilad
11.2018 - 08.2021
- Managed core business and core banking (T24) SQL Server databases, ensuring optimal performance and reliability.
- Implemented best practices for core banking databases, including configuration, security administration, alert management, and encryption.
- Oversaw approximately 200 SQL Server instances (Production, Development, Testing, and UAT environments) across Primary Data Center (PDC) and Secondary Data Center (SDC).
- Automated administrative tasks for 200 SQL Server instances using SQL PowerShell scripting.
- Configured centralized alerts and administration jobs with PowerShell scripts to efficiently monitor and manage all banking SQL Server instances.
- Administered and maintained SSIS, SSAS, and SSRS services in PDC and SDC environments.
- Managed Data Hub ETL and database servers for T24 Core Banking, ensuring seamless data integration and operations.
- Supervised and optimized CRM and SharePoint databases to support enterprise applications.
- Demonstrated advanced troubleshooting skills to resolve complex issues across network, operating systems, and virtual machines using the latest diagnostic techniques.
Principal Database Administrator
Ministry of Health
04.2015 - 10.2018
- Managed all MOH database services, including SSIS, SSAS, DWH, and SSRS, across Development, Testing, and Production environments.
- Ensured all database servers were backed up according to the business's Recovery Point Objectives (RPO) and tested backups to meet Recovery Time Objectives (RTO).
- Diagnosed and resolved SQL Server service outages, including after-hours and weekend incidents.
- Configured SQL Server monitoring utilities to reduce false alarms and improve system reliability.
- Collaborated with the systems team for monthly OS patching and updates.
- Generated and delivered Operational Support and Analysis (OSA) reports daily and weekly, as well as weekly Planning, Protection, and Optimization (PPO) reports.
- Installed and configured new SQL Server instances and maintained high-availability and disaster recovery solutions, including clustering, Always-On Availability Groups, mirroring, replication, and log shipping.
- Deployed database change scripts provided by third-party vendors while ensuring they met company standards for readability, reliability, and performance.
- Conducted full database assessments for new deployments, ensuring optimal performance and compliance with best practices.
- Analyzed and tuned T-SQL queries to improve database performance and efficiency.
- Designed and optimized indexes for existing applications, managing weekly assessments to identify missing, duplicated, or unused indexes.
- Worked with developers to enhance query performance, providing weekly reports on the top 10 most resource-intensive queries and offering optimization recommendations.
- Wrote DMV queries to analyze server-level performance and troubleshoot hardware and server issues.
- Determined the most effective ways to boost performance, including hardware upgrades, server configuration changes, and query or index adjustments.
- Documented the company’s database environment to support scalability and maintainability.
- Built data engineering solutions to improve the performance of data warehouses (DWH), data marts, and online archiving systems.
Senior Database Architect
Ministry of Higher Education
07.2013 - 03.2015
- Managed over 35 SQL Server clusters across Testing, Staging, and Production environments, including 13 production clusters.
- Administered 1,200 databases in the Ministry of Higher Education (MOHE) environment, with 500 production databases, including large-scale databases (sizes of 5 TB, 2 TB, and 1.5 TB).
- Oversaw 3 High-Availability Groups (HAG) built on clustered and standalone SQL Server environments, managing more than 20 replications and 5 log shipping setups.
- Installed, configured, and maintained SQL Server versions from 2005 to 2014, performing side-by-side and in-place upgrades with online data migration and archiving.
- Designed optimal database architectures tailored to application requirements, ensuring performance through efficient file structures, multiple file groups, and high-availability solutions, including clusters, mirroring, and log shipping.
- Conducted weekly analyses of the top 10 most resource-intensive queries, implementing optimizations to improve query performance.
- Periodically evaluated and optimized indexes, analyzing design, usage, size, and fragmentation to decide on retention, modification, or maintenance strategies.
- Monitored and improved database implementations and health status in production environments, ensuring high performance and reliability.
- Enhanced T-SQL performance and maintained robust data warehouse (DWH) operations, contributing to streamlined database operations and system efficiency.
Senior Database Administrator and Laserfiche Admin
Ministry of Social Affairs
01.2013 - 06.2013
- Installed and configured SQL Server, including system upgrades, clustering, and instance configurations.
- Managed and monitored SQL Server security across 20 databases supporting 120 branches in KSA for the Ministry.
- Created and configured databases, file groups, constraints, indexes, stored procedures, triggers, and views to optimize functionality and maintain data integrity.
- Developed and managed SQL Server Agent jobs, alerts, operators, and implemented comprehensive backup strategies to ensure reliable recovery.
- Performed system and SQL Server performance monitoring using tools such as Trace, Monitor, DMV, SQLIO, and SQL Deadlock Detector, focusing on T-SQL performance and data warehouse (DWH) optimization.
- Served as Laserfiche (LF) Administrator, managing all T-SQL tasks related to archiving, and implemented enhancements at the T-SQL level to improve performance.
Database Engineer
Safe ERP Solution, SAFE
05.2010 - 10.2012
- Developed and maintained backup strategies and recovery procedures to ensure data integrity and availability.
- Implemented database mirroring in SQL Server 2008 to enhance system reliability and minimize downtime.
- Prepared and drafted internal documentation for database systems, including views, high availability solutions, disaster recovery plans, and database security implementation and auditing.
- Configured and managed SQL Server features such as log shipping and replication to support high availability and scalability.
- Administered and maintained servers, including installing and configuring Windows Server releases from 2003 to 2012.
- Performed daily system monitoring, reviewed system and application logs, and maintained data center environmental conditions and monitoring.
- Utilized Windows Server PowerShell for automation and troubleshooting tasks, including managing and troubleshooting Active Directory.
- Configured and resolved network services issues, including DNS, TCP/IP, DHCP, and NAT, ensuring seamless network operations.
- Demonstrated expertise in PC hardware troubleshooting and maintenance, including migration and OS upgrades.
- Managed LAN and WAN network administration, ensuring optimal connectivity and performance.
- Installed and troubleshot Microsoft Office applications, maintaining seamless functionality across organizational systems.
Database Engineer
Business Analysis Group
06.2008 - 03.2010
- Installed, troubleshot, and maintained SQL Server databases, including versions 2005 and 2008.
- Designed and maintained database architectures to support application requirements and system scalability.
- Created and configured databases, file groups, constraints, indexes, stored procedures, triggers, and views to ensure optimal functionality and performance.
- Implemented high availability systems and disaster recovery solutions, including database security measures, auditing, log shipping, and replication.
- Developed and maintained backup strategies and recovery plans to ensure data protection and availability.
Education
Ecommerce
Mansoura University
Egypt 06.2002 - 2008.04
Skills
Team leadership expertise
SQL database expertise
Team collaboration and leadership
Data Technology
SQL expertise
Database troubleshooting
Data privacy compliance
Query optimization
Database design
Data migration
Capacity planning
Automation
Accomplishments
- My Azure Articles: https://lnkd.in/edn6nyY/#AllAzurePosts.
- Microsoft Azure Hero 3X: https://mostafaelmasry.com/about-me/#MicrosoftAzureHero.
- Founder of Database Cloud Tech blog: https://mostafaelmasry.com/.
- Founder of SQLIdol website: http://www.sqlidol.com/team/mustafa-el-masry/.
- My Articles on SQLShack: https://www.sqlshack.com/author/mustafaelmasry/.
- Founder of LinkedIn Group: https://www.linkedin.com/groups/8406281/.
- My Certifications: https://www.youracclaim.com/users/, /badges.
- Other Certifications: https://skillsoft.digitalbadges.skillsoft.com/profile/mustafaelmasry/wallet.
- One of the top bloggers on the Middle East in SQL Server: Around 300 SQL Server Article, also I have Arabic posts on Microsoft MSDN.
- Https://msdn.microsoft.com/ar-sa/library/dn974980.aspx.
- Https://msdn.microsoft.com/ar-sa/library/mt131032.aspx.
- Https://msdn.microsoft.com/ar-sa/library/mt147014.aspx.
- Https://msdn.microsoft.com/ar-sa/library/mt131033.aspx.
- Https://msdn.microsoft.com/ar-sa/library/mt131034.aspx.
Certification
Microsoft Azure Administrator AZ-103
Timeline
Senior Data Engineer
Bank Albilad
11.2018 - 08.2021
Principal Database Administrator
Ministry of Health
04.2015 - 10.2018
Senior Database Architect
Ministry of Higher Education
07.2013 - 03.2015
Senior Database Administrator and Laserfiche Admin
Ministry of Social Affairs
01.2013 - 06.2013
Database Engineer
Safe ERP Solution, SAFE
05.2010 - 10.2012
Database Engineer
Business Analysis Group
06.2008 - 03.2010
Ecommerce
Mansoura University
06.2002 - 2008.04
Microsoft Azure Administrator AZ-103
Microsoft Azure Database Administrator
Microsoft Azure Data Engineer
Microsoft Azure Data Fundamentals
Microsoft Certified Trainer 2020-2021
Microsoft Certified Trainer 2021-2022
MCSE: Data Management and Analytics — Certified 2020
MCSA: SQL 2016 Database Administration – Certified 2020
Microsoft Certified: Azure Fundamentals
Microsoft certified technology specialist
SQL Server 2008 Microsoft certified technology specialist
SQL Server 2008 Database Development
SQL Server administration MCTIP 2008
SQL Server Development MCTIP 2008
Microsoft certified professional
Database Subject Matter Expert (Team Leader)
Al-Rajhi Bank
9 2021 - Current
Similar Profiles
Sultan Al-AskarSultan Al-Askar
Operations Manager at Al Rajhi BankOperations Manager at Al Rajhi Bank
HAMAD AL-HZEMHAMAD AL-HZEM
Cooperative Training at Al Rajhi BankCooperative Training at Al Rajhi Bank
Khayal AbalkheilKhayal Abalkheil
Small &Micro Business Sales Manger at Al Rajhi BankSmall &Micro Business Sales Manger at Al Rajhi Bank