Mustafa El-Masry Email & Phone Number

Riyadh, Sa

Riyadh, Saudi Arabia

Managing more than 200 Production Databases Server with different versions and design

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/

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

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

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)

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(

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/

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.

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

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.

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..