senior database administrator
souq.com
مجموع سنوات الخبرة :16 years, 7 أشهر
major learned lesson in this experience is continuous improvement, there is always way to do it better.
as Souq.com is the largest E-commerce platform in the Arab world, our team always run in Consistent way to serve our customers and deliver best online service, as DBA am working to deliver big events in smart and pretty user experience on website ans mobile app such as
1) White Friday http://saudi.souq.com/sa-en/white-friday/c/
2) He sale, She sale http://egypt.souq.com/eg-en/he-sale-she-sale/c/
in addition to provide DB services to for internal projects like DWH, affiliate, recommendations and search teams
Working with MySQL Database Server with the following skills:
- Build main structure for data, such as schedules and indices in liaison with development staff.
- Amend and upgrade the database according to programmer’s requirements
- Monitor performance of the database and solve its problems
- Provide technical support for all parties dealing with the database each in their own specialization
- Determine the database structures dealing with applications and Discuss the resources required with the database manager, such as storage, RAM, CPU and etc.
- Write inquiries and issue reports manually
- Plan and execute database copy and recovery process
-Determine the required resources for storage media and memory size; recommend upgrading or modifying it according to performance
major learned lesson in this experience is e-commerce and it's critical DB transactions and contribute in start ups.
N2v was new and special experience mainly e-commerce concepts; as team we worked on http://vanillaeshop.com/, as local e-commerce based in KSA, it is really promised market, with well structure using mysql innodb engine to maintain ACID transactions.
main role is operational DBA which include tune mysql server performance, monitor the logs like slow log query and general log, provide how to make "with mysql" for team members, make plans for scalability and availability like setup replication (master-master, master-slaves), sharding data( divide and conquer)
build the structure of database to fit the requirements of the projects
database fireman for hot issues in mysql servers, maintain back-ups and import data, enhance the database Security to support the data confidentiality and privacy
major learned lesson in this experience is MySQL restructuring, tuning, transfer, mysql replication.
From the first day that maktoob became yahoo we work in following major projects
1) build hot-cold master master replication of all database to switch to yahoo data centers
2) maintain database tuning enhancing performance after moving process is finished
3) restructure and rebuild some database to be align with yahoo standards
4) design and build video.maktoob.com which is now http://maktoob.screen.yahoo.com/
main role is operational DBA which include tune mysql server performance, monitor the logs like slow log query and general log, provide how to make "with mysql" for team members, make plans for scalability and availability like setup replication (master-master, master-slaves), sharding data( divide and conquer)
build the structure of database to fit the requirements of the projects
database fireman for hot issues in mysql servers, maintain back-ups and import data, enhance the database Security to support the data confidentiality and privacy
Major learned lesson in this experience is mysql database troubleshooting.
Maktoob.com was the largest web portal in MENA region was serving Arab world, which form it's 15 millions Users .
in Maktoob.com, the one of the best success stories is using DB sharding to increase DB capacity specially for As7ab.maktoob.com and blogs.maktoob.com.
--to see full list of maktoob sites and services visit https://en.wikipedia.org/wiki/Maktoob
in addition to my roles and responsibilities as DBA in the following major areas
1) database full recovery, include DB backups and archiving, maintain DB Capacity for VB forums
maktoob had 14 forums but all of them are shutdown by yahoo as strategic decision
2) design and build database for new Maktoob channels like
news.maktoob.com which is now https://maktoob.news.yahoo.com/ where main role is to make mapping of news feeds from new resource to our local DB
3) contribute in process of yahoo acquisition of Maktoob.com, we were work as IT team to make plan for moving DB from the hosting company to yahoo data centers
very comprehensive and deep program to prepare you to become leader in business world starting from finance to operations ,marketing, economics ,and quality management , with pay attention to globalization and ethics in world wide level . TAGSB’s motto of “Where the Gifted Become Leaders” focuses on bringing excellence, creativity and innovation to graduate leaders and equip them with the latest skills.
