Database Team Leader
ITS
Total years of experience :26 years, 5 Months
L2 Infrastructure Technical Consultant - Database Team Leader
Projects:
-Dubai Public Prosecution
-Zain Kuwait
-El-salam Bank Sudan
-Khalifa University
1.1 Administration Of Criminal justice (AOCJ)
• Designed, installation, configuration and Administration an Oracle Data guard in 3 sites.
• Designed, installation, configuration and Administration an Oracle RAC database in 3 sites.
• Designed, installation, configuration and Administration an MSQL Server 2008 database in 3 sites.
• Data Modeling, Designing and Architecture of Databases.
• Installing Database servers and clients' software, creating, upgrading and patching databases in Windows
environments.
• Worked closely with developers, provided DBA support and technical support for multiple
applications in development, Test, QA, UAT and production environments.
• Working with the Development team to fix Performance problems in Applications.
• Planning and scheduling backups using RMAN, Export/Import, Cold, Hot backups.
• Implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Installation, Configuration and deployment of Oracle 11gR2 database and Real Application Clusters
(RAC) on different nodes with Automatic Storage Management (ASM)
• Real Application Clusters monitoring, tuning, load balancing using OEM (Oracle Enterprise Manager), Stats pack.
• Fulfill DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table,
index, sequence etc.), space management (table space, undo segment), monitoring (alert log, memory, disk I/O, CPU)
1.2 Alexandria Port Integration Project (APA) - Database Administrator
Data Modeling, Designing and Architecture of Databases.
•Installing Database servers and clients' software, creating, upgrading and patching databases in Windows,
UNIX environments.
•Installation, Configuration and deployment of ASE 12.5.0.3 database on different nodes.
•Monitoring, tuning using 'sysmon' and MDA tables 'Monitoring Data Access', 'Monitoring and
Diagnostics for ASE'.
1.1 Ministry of Foreign Trade Data Warehouse (MOFT) - Database Administrator
My Responsibilities within the scope of this project: • Data Modeling, Designing and Architecture of Databases.
• Installing Database servers and clients' software, creating, upgrading and patching databases in Windows and
UNIX environments.
• Worked closely with developers, provided DBA support and technical support for multiple
applications in development, Test, QA, UAT and production environments.
• Working with the Development team to fix Performance problems in Applications.
• Planning and scheduling backups.
• Implemented physical standby databases using backup/restore batches in windows and UNIX shell.
• Installation, Configuration and deployment of ASE 12.5.0.3 database in Linux Fedora/Suse.
• Installation, Configuration and deployment of SQL Server 2000 database.
• Installation, Configuration and deployment of Teradata database.
• Monitoring, tuning using 'sysmon' and MDA tables 'Monitoring Data Access', 'Monitoring and
Diagnostics for ASE', profiler.
• Fulfill DBA daily activities including user management (creating users, privileges, roles, quotas, table, index,
etc.), space management (table space, segment), monitoring (alert log, memory, disk I/O, CPU)
1.1 Egyptian Customs Project - UNIX / Junior Database Administrator
My Responsibilities within the scope of this project: • Data Modeling, Designing and Architecture of Databases.
• Installing Database servers and clients' software, creating, upgrading and patching databases in Windows,
Linux and UNIX environments.
• Worked closely with developers, provided DBA support and technical support for multiple
applications in development, Test, QA, UAT and production environments.
• Working with the Development team to fix Performance problems in Applications.
• Planning and scheduling backups.
• Implemented physical standby databases using backup/restore batches using UNIX shell and windows
command shell.
• Installation, Configuration and deployment of ASE 11/12.5 database in 25 different sites.
• Monitoring, tuning using 'sysmon' and MDA tables 'Monitoring Data Access', 'Monitoring and
Diagnostics for ASE'.
• Fulfill DBA daily activities including user management (creating users, privileges, roles, quotas, table, index,
etc.), space management (table space, segment), monitoring (alert log, memory, disk I/O, CPU)
IT diploma ( Information technology and disaster recovery planning - ) in (I.G.S.R) INSTITUTE OF GRADUATE STUDIES AND RESEARCH. Alexandria University
1998 BSC. In Accounting and Business, Faculty of Commerce Accounting Dep. Alexandria University - Egypt