Sara Fathy Email & Phone Number

Smart Village

Database Technical Lead - Test Environments Management - IT

Smart Village

# Main Roles & Responsibilities:1. Create and maintain all databases required for development, testing, education and production usage.2. Perform the capacity planning required to create and maintain the databases.3. Perform ongoing tuning of the database instances.4. Plan and implement backup and recovery of the database.5. Implement and enforce security for all of the Databases. 6. Administer all database objects, including tables, clusters, indexes, views, sequences… Show more # Main Roles & Responsibilities:1. Create and maintain all databases required for development, testing, education and production usage.2. Perform the capacity planning required to create and maintain the databases.3. Perform ongoing tuning of the database instances.4. Plan and implement backup and recovery of the database.5. Implement and enforce security for all of the Databases. 6. Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. 7. Assist with impact analysis of any changes made to the database objects.8. Troubleshoot with problems regarding the databases.# Achievements:1. Migrate all the Oracle databases from different platforms to the Supercluster (T5-8).2. Configuring data guard for most of the migrated databases.3. Configuring ZDLRA backup for all the migrated databases (production, standby & non production).4. Patching all the oracle databases residing on the Giza SC which is holding all the non production databases (around 60 databases) to the April-2017 patchset.5. Applying PCI requirements on the related databases.6. Received certificate of appreciation on:- Participating in migrating the T24 core banking database from JBASE to Oracle database.- Participaing in acquiring the PCI compliance certificate. Show less

2A Omar Makram, Cairo

# Main Roles and Responsibilities:1- Support the Oracle Lease & Finance Management module both technically and functionally.2- Work with the system implementer on analyzing and designing the lease business requirements.3- Conduct demos to test the implemented requirements and get UAT signoff.4- System Administration.5- Support the end users and mentoring them on how to use the system.

Smart Village, 6Th Of October, Egypt

Main Roles& Responsibilities:# Apply the below DBA tasks for both Oracle & SQL RDBMS:1. Create and maintain all databases required for development, testing, education and production usage.2. Perform the capacity planning required to create and maintain the databases.3. Perform ongoing tuning of the database instances.4. Install new versions and its tools and any other tools that access the database. 5. Plan and implement backup and recovery of the database.6… Show more Main Roles& Responsibilities:# Apply the below DBA tasks for both Oracle & SQL RDBMS:1. Create and maintain all databases required for development, testing, education and production usage.2. Perform the capacity planning required to create and maintain the databases.3. Perform ongoing tuning of the database instances.4. Install new versions and its tools and any other tools that access the database. 5. Plan and implement backup and recovery of the database.6. Implement and enforce security for all of the Databases. 7. Perform database re-organizations as required to assist performance and ensure maximum uptime of the database.8. Provides technical support to application development teams.9. Enforce and maintain database constraints to ensure integrity of the database.10. Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. 11. Assist with impact analysis of any changes made to the database objects.12. Troubleshoot with problems regarding the databases, applications and development tools.13. Create new database users as required.14. Manage sharing of resources amongst applications. # Administration of the Oracle E-Business Suite environment, including the normal DBA functions as mentioned above in addition to:1. Application upgrade.2. Application patches, Database patches, upgrade patches, etc.3. Concurrent Manager administration/tuning.4. System Administration. This includes creating a new Apps user, responsibility, definition of menus, forms, reports, printer installation and definitions etc.# Achievements:1. Recently upgraded the Oracle HRMS package to 12.1 RUP6.2. Applied performance tuning practices on MS Sharepoint SQL DB.3. Received a “Certificate of Appreciation” from the board of directors for the effort exerted in CR-ISP project implementation. Show less

B.Sc, Information Systems

V. Good Grade as well Excellent Grade in GP

Thanweya Amma, Mathematics