Mustafa El-Masry

Mustafa El-Masry Email and Phone Number

SQL Database Consultant (Team Leader) @ Al Rajhi Bank
Riyadh, SA
Mustafa El-Masry's Location
Riyadh, Saudi Arabia, Saudi Arabia
Mustafa El-Masry's Contact Details

Mustafa El-Masry personal email

About Mustafa El-Masry

Mustafa Elmasry SQL Server MCSA, MCSE and MCT a provider of remote SQL Server DBA consulting Service, Founder of https://mostafaelmasry.com/ I have over 10 years’ experience in the IT industry I work with Microsoft technologies for several years with a focus on SQL Server Currently I work as a Senior Database Consultant at the Information Technology Division of Bank Al Rajhi Bank. This role allows me to work with advanced database systems and develop complex data processing and reporting methods as well as to constantly design solutions for increasing and maintaining performance and stability Over the years I have been able to work in large companies My experience expands into multiple domains like Healthcare, Financial, Education, Consulting, Professional Services. I am the founder of the SQL Community: http://MostafaElmasry.com/ and http://www.sqlidol.com/.  Twitter Official account: https://twitter.com/Elmasrydba LinkedIn Group: hhttps://www.linkedin.com/groups/8406281/ Technical Author in SQL Shack community: http://www.sqlshack.com/author/mustafaelmasry/  Certification: SQL Server 2008,2016 Certified, Azure Certified (MCTIP, MCSA, MCSE, MCT) and planning for Azure Data Engineer certification and Big data as well https://www.youracclaim.com/users/mustafa-elmasry Organizer and Moderator for SQLGULF Events in KSA and Dubai: https://mostafaelmasry.com/event-and-gallery/ One of the Top bloggers on the Middle East in SQL Server: Around 300 SQL Server Article I published it in multiple SQL Server Communities in the Middle East, 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.aspxFor any other information I am ready to provide it to you at any time Kindly feel free to contact me at any time over email {Eng.Mostafa_Elmasry@WindowsLive.Com} or by phone {+966 543990968}

Mustafa El-Masry's Current Company Details
Al Rajhi Bank

Al Rajhi Bank

View
SQL Database Consultant (Team Leader)
Riyadh, SA
Employees:
11995
Mustafa El-Masry Work Experience Details
  • Al Rajhi Bank
    Sql Database Consultant (Team Leader)
    Al Rajhi Bank
    Riyadh, Sa
  • Al Rajhi Bank
    Senior Database Consultant
    Al Rajhi Bank Sep 2021 - Present
    Riyadh, Saudi Arabia
    Managing more than 200 Production Databases Server with different versions and design
  • Db Cloud Tech
    Founder
    Db Cloud Tech Jan 2011 - Present
    Https://Mostafaelmasry.Com/
    DB Cloud Tech Website founded by Mustafa Elmasry for Helping the IT People to learn the new technologies in Database and Cloud Keep Learning and Spread the Knowledge https://mostafaelmasry.com/
  • بنك البلاد | Bank Albilad
    Senior Database Engineer
    بنك البلاد | Bank Albilad Nov 2018 - Nov 2021
    Saudi Arabia
    Managing the Main Core Business and core banking (T24) the central core banking SQL Server Applying all of the best practices on core banking DB from Configuration, security administration, alerts, encryption Manage the other SQL Server services around 200 SQL servers (Prod, DEV, TEST, UAT) in PDC (Primary data Center) and SDC (Secondary Data Center)Using SQL Server T-SQL for automated the administration tasks on 200 SQL Servers Configure Centralized Alerts and administration jobs Using T-SQL and Powershell to manage all of the banking SQL Server instancesManaging all of the SSIS, SSAS, SSRS in PDC and SDCManaging DATA Hub ETL and DB Servers for T24 DB Core BankingManaging CRM, SharePoint Databases High Skills with a deep level of troubleshooting (Network, OS, VM) using the latest techniques
  • Ministry Of Health Saudi Arabia
    Principal Database Administrator
    Ministry Of Health Saudi Arabia Apr 2015 - Oct 2018
    Saudi Arabia
    Managing all MOH DB services (SSIS, SSAS, DWH, SSRS) on development, Testing, ProductionEnsure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)Troubleshoot SQL Server service outages as they occur, including after-hours and weekendsConfigure SQL Server monitoring utilities to minimize false alarmsMonthly OS patching and updating with collaboration with system teamDaily OSA (Operational support and Analysis) reportWeekly OSA report, weekly PPO (Planning, protection, and optimization) Install and configure new SQL ServersInstall and troubleshooting all the Disaster Recovery technology (DR, Cluster, HAG, Mirroring, Replication, Log Shipping)Deploy database change scripts provided by third-party vendorsDetermine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changesDocument the company’s database environmentWriting DMV queries to answer questions about server-level performanceTuning T-SQL queries to improve performanceTroubleshooting hardwareEnsure that new database code meets company standards for readability, reliability, and performance Doing Full Database Assessment Process for any new DeploymentEach week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on eachDesign indexes for existing applications, choosing when to add or remove indexesWeekly Index Assessment Process (Missing Index, duplicated index, index size, unused index..etcHelp developers improve the performance of that query by tweaking it or modifying indexesBuilding Data Engineer Solution to Improve the performance of DWH, Data Mart, and online archiving solution
  • Waja Information Technology
    Microsoft Technical Remote Db Consultant Data Platform (Freelancer)
    Waja Information Technology Jan 2016 - Aug 2018
    Saudi Arabia
    Worked as Remote DB Consultant in so many SQL Server projects in the most significant government sector and semi-government sector in KSA managed all of the customer requirements with a high level of support 24/7 samples of the projectsDisaster Recovery and performance tuning and SQL to Oracle Migration Project in MOJ (Ministry of Justice)Migration and Consolidation Project in (SAPTCO)Migration, consolidation, and performance tuning project in (Abdullah AlOthaim Markets)Performance tuning Project in (Tatweer Co. for Educational Services)Remote DB operation in (Alfursan Saudi Airline)Troubleshooting Courrption DB and disaster DB in (Al Ahlia for Cooperative)Performance tunning project in (Saudi Electricity Company)
  • Alnafitha International For Information Technology
    Microsoft Technical Db Consultant (Freelancer)
    Alnafitha International For Information Technology Jun 2017 - Jun 2018
    Saudi Arabia
    Working as a remote Technical DB consultant and responsible for fixing all of SQL Server issues can happen in the client production servers, also accountable about leading all of SQL Server projects and manage all of the customer requests related to SQL Server in many levels (Troubleshooting, Administration, Performance, BI, Applying SQL Server new feature, Disaster recovery) Leaded 3 Projects in 3 clients (AL Jazirah Vehicles Agencies Co.Ltd. , GCS- General Cars Syndicate, Consultative Assembly of Saudi Arabia(
  • Apexsql
    Sql Server Technical Author In Sqlshack
    Apexsql Nov 2016 - Nov 2017
    London, United Kingdom
    Microsoft SQL Server Technical Author in one of the biggest community in the world ApexSQL (SQLShack)Check my articles herehttps://www.sqlshack.com/author/mustafaelmasry/
  • Ministry Of Higher Education,Riyadh,Ksa
    Database Architecture
    Ministry Of Higher Education,Riyadh,Ksa Jul 2013 - Apr 2015
    Riyadh ,Ksa
    Manage more than 35 SQL Server Cluster (Testing, Staging, and Production), 13 of them, are Production SQL Cluster.Mange 1200 databases across the Ministry of Higher Education (MOHE) environment, 500 databases out of them on production with High DB Sizes (5 TB, 2 TB, 1.5 TB).Mange 3 HAG build on Cluster and standalone SQL Server, more than 20 Replication, 5 DB Log shipping.Install, Configure and maintain all SQL Server versions (2005 > 2014), Upgrade SQL Server (Side by Side and on Site) with online Data Migration, online Data Archiving, improving T-SQL performance, DWH.Design the best DB Architecture that matches Application design, Checking and optimizing weekly the top 10 expensive queries, designing the optimal DB files structure through multiple File Groups, Designing Database clusters, and troubleshooting HAG, Mirroring, Log Shipping.Check periodically indexes for their designs, usages, sizes, and fragmentation to determine the best decisions for them in terms of disposing, alter or maintain them, Checking periodically expensive queries status performing necessary action to improve query performance, Checking DB implementations and general health status on production periodically to make sure they are matching with staging and testing and no impact on live systems performance.
  • Ministry Of Social Affairs
    Senior Database Administrator
    Ministry Of Social Affairs Jan 2013 - Jun 2013
    Riyadh Saudi Arabia
    Install and configures SQL Server, including system upgrades, clustering, configure instances. Manages and monitors the security of SQL Server on 20 DB for 120 Branches in KSA of the Ministry, Creates and configures databases, file groups, Constraints, Indexes, Stored Procedure, Triggers & views.Creates and manages the work necessary to perform SQL Server Agent jobs, Alert, Operators, and Creates and maintains the strategy of backup procedures and preparing for recovery.Performs the allocation and performance monitoring system and SQL Server through Trace, Monitor, DMV, SQLIO, SQL Deadlock Detector, hard work on T-SQL performance, DWH.Working AS LF admin (Laserfiche archiving tool) and managing all of the T-SQL related to the archiving with adding Extra enhancement on T-SQL level from performance-wise
  • Safe Computer System
    Database Administrator
    Safe Computer System May 2010 - Oct 2012
    Riyadh , Saudi Arabia
     Creates and maintains the strategy of backup procedures and preparing for recoveryImplementing Database Mirroring in SQL Server 2008 Infrastructure.Preparation and drafting of some internal documents: views, High Availability systems, and Disaster Recovery, Database security implementation and auditing, Database Log Shipping, replication Manage and maintenance Servers, Install and Configure All Windows Server Release From 2003 to 2012, Perform daily system monitoring, reviewing system application log, Maintain data center environment, and monitoring. Using Windows Server Power Shell, managing and Troubleshoot Active Directory, Configure, and troubleshoots {DNS.TCP IP, DHCP, DNZ, Router, NAT}, Knowledgeable with PC hardware, troubleshooting, and maintenance. Knowledge with network administration involving LAN and WAN usage, Migration and Upgrade OS, Installing, troubleshoots Microsoft Office.
  • Business Analysis Group Software Company
    Sql Server Implementer And Technical Support
    Business Analysis Group Software Company Jan 2009 - Apr 2010
    Egypt
     Creates and maintains the strategy of backup procedures and preparing for recoveryImplementing Database Mirroring in SQL Server 2008 Infrastructure.Preparation and drafting of some internal documents: views, High Availability systems, and Disaster Recovery, Database security implementation and auditing, Database Log Shipping, replication Manage and maintenance Servers, Install and Configure All Windows Server Release From 2003 to 2012, Perform daily system monitoring, reviewing system application log, Maintain data center environmental and monitoring. Using Windows Server Power Shell, managing and Troubleshoot Active Directory, Configure and troubleshoots {DNS.TCP IP, DHCP, DNZ, Router, NAT}, Knowledgeable with PC hardware, troubleshooting and maintenance. Knowledge with network administration involving LAN and WAN usage, Migration and Upgrade OS, Installing, troubleshoots Microsoft Office..

Mustafa El-Masry Skills

Databases Microsoft Sql Server Sql Database Design Disaster Recovery Database Administration Windows Server Performance Tuning T Sql Sharepoint Data Migration Oracle Iis High Availability System Administration Troubleshooting Active Directory Ssrs Servers Operating Systems Sql Tuning Xml Technical Support Security Data Center Sql Server Transact Sql Software Installation Network Administration Dns Administration Replication Database Management Database Development Clustering Sql Server 2000 2008 Solaris Oracle 11g Network Security Windows Server 2008 Windows Server 2003 Microsoft Certified Professional Powershell Firewalls Database Consolidation Database Migration Business Intelligence Microsoft Excel Microsoft Azure

Mustafa El-Masry Education Details

  • Mansoura University
    Mansoura University
    Accounting And Finance

Frequently Asked Questions about Mustafa El-Masry

What company does Mustafa El-Masry work for?

Mustafa El-Masry works for Al Rajhi Bank

What is Mustafa El-Masry's role at the current company?

Mustafa El-Masry's current role is SQL Database Consultant (Team Leader).

What is Mustafa El-Masry's email address?

Mustafa El-Masry's email address is el****@****ail.com

What schools did Mustafa El-Masry attend?

Mustafa El-Masry attended Mansoura University.

What are some of Mustafa El-Masry's interests?

Mustafa El-Masry has interest in Science And Technology, Education, Health.

What skills is Mustafa El-Masry known for?

Mustafa El-Masry has skills like Databases, Microsoft Sql Server, Sql, Database Design, Disaster Recovery, Database Administration, Windows Server, Performance Tuning, T Sql, Sharepoint, Data Migration, Oracle.

Who are Mustafa El-Masry's colleagues?

Mustafa El-Masry's colleagues are Zamzurina Kholil, Kishore Sp, Abdulelah Alanazi, Turki Al Enazi, King Almousa, Aryam Al-Anzi, Jana Alrubaish.

Not the Mustafa El-Masry you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.