10 years of experience building scalable high performance data warehouses systems, with expertise in query optimization, vectorized execution and columnar storage format.
Strong HW knowledge, good understanding of the effects imposed by the system at all levels (CPU, memory, network, I/O, OS, queuing effect, storage, database, runtime environment/container, etc.), optimization for multi core , optimization of IO
10 years of experience building scalable high performance data warehouses systems, with expertise in query optimization, vectorized execution and columnar storage format.
Strong HW knowledge, good understanding of the effects imposed by the system at all levels (CPU, memory, network, I/O, OS, queuing effect, storage, database, runtime environment/container, etc.), optimization for multi core , optimization of IO patterns.
Strong programming skills in C++, Java , C#, Powershell, TSQL, HQL, PL/SQL and other scripting languages.
Extensive experience with root causing and quantifying performance issues across the stack.
Software Engineer @ Impala SQL performance From September 2015 to Present (4 months) Senior Manager @ Identify and define performance and scale oriented features covering query execution, cost based optimization and supportability. From June 2014 to September 2015 (1 year 4 months) Lead Member of technical staff @ Analyze, understand, and improve Chatter's front-end and back-end performance.
Worked on optimizing the RDBMS schema and queries for Facebook like application Chatter, optimizations covered tuning indexes and Pl/SQL scripts to achieve better execution plans, implementing coherent caches to cut down DB CPU, various schema modifications which reduce on disk space and memory foot print.
Conducted several studies simulating customer data shapes to generate a list of to-do fixes & optimizations along with POC validation for prototypes.
Gained hands-on experience running and monitoring PAS.
Tools used covered Oracle SQL Developer, Eclipse , JMeter , YourKit, Java mission control and Splunk. From October 2013 to June 2014 (9 months) san francisco, californiaSenior Software Development Engineer @ Awarded Gold Star executive recognition 3 times.
Owned Data warehousing Performance covering low-end and high-end systems, Scale-up experimentation, showcasing and competitive benchmarking.
Strong performance engineering background, strong relational database optimization and tuning skills, passion for performance engineering.
Worked on development of various products covering OLTP Scale out , DW Scale out , Relational database on a single node , column store relational databases & High availability solutions.
Conducted several deep investigations into performance issues covering IO patterns & explain plans.
Partner engagement
Worked closely with 10 different OEMs/Partners on record breaking benchmark publications, validation and development of cutting edge technologies, white paper publication, launch demos and showcasing as well as Performance tracking.
Hardware configuration
Effectively and efficiently worked on qualifying, selecting and validating hardware to validate and track the performance of the product over the development cycle covering low-end, high-end, scale-up and scale-out.
Performance assurance
Identified numerous performance defects and ensured that they are resolved in a timely manner with the goal of delivering high quality robust software.
Analysis and Development:
Thorough study covering performance of various features, findings were detailed in a report which highlighted software bottlenecks, workarounds, prototypes and suggestions for fixes.
Virtual team lead
Mentored and lead virtual team for several releases to set performance release criteria , asses and validate performance of current features , identify and resolve performance bottlenecks. From March 2006 to October 2013 (7 years 8 months) Redmond,WA
Bachelor of Sceince, Communications and electronics @ Cairo University From 2000 to 2005 Mostafa Mokhtar is skilled in: Distributed Systems, Software Development, Microsoft SQL Server, Scalability, Databases, Performance Tuning, SQL, C#, Data Warehousing, Software Engineering, Operating Systems, High Availability, Object Oriented Design, C++, Hadoop
Looking for a different
Mostafa Mokhtar?
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension