Head of Engineering, Systems and Database Architecture
The Egyptian Credit Bureau "I-Score"
Total years of experience :15 years, 9 Months
.
.
• Oracle Database Administration and Support.
• Create, Manage and administer database objects, including tables, indexes, views, sequences, functions, packages and procedures provided by development team.
• Implement and maintain database security.
• Monitor disk & table space alerts, database wait events, hang analysis, locks using OEM Grid control and proactively optimize system performance.
• Mysql Database Administration and Support.
• Installation, Configuration of Oracle Server Software and Related Products.
• Perform Application & SQL Statements Tuning.
• Monitor DB Datafiles and Tablespaces growth.
• Monitors system performance & data processing efficiency by conducting reviews of application functions in operation. Maintain good level knowledge of application function.
• Development cycle of the application and roll out to production (code review, schema design using Database Designer, production implementation).
• Review, test and audit internal developed software before delivering to application and end-user for testing business/function requirements fulfillment, to assure quality assurance of delivered task.
• Performance tuning (analyzes AWR reports and analyzes dump files).
• Stress-test of code and fine-tuning of SQL/PLSQL to maximize query response time and get optimal execution plan.
• Generating & Design the top management reports.
My responsibility was to direct and enhance design and implement of system's functionalities, both in GUI layer (Oracle Forms, Reports 10g + WebUtil) and on the server side (PL/SQL).
• Design database ERD, tables and relations (Including critical ones).
• Implement a huge number of stored procedures and functions, triggers, views and other database objects.
• Development cycle of the application and roll out to production (code review, schema design using Database Designer, production implementation).
Master of business administration in Digital Transformation