Ahmed Reda

Oracle Database Administrator at Advanced computer technology

• Egypt - Cairo
• My current job since June 2015

Oracle Database Administrator Instrautor at New Horizons -Computer Learning Centers

• Egypt - Cairo
• My current job since April 2014

Taught the following classes

 Database systems concepts
 Oracle data modeling and relational database design
 Oracle database: introduction to SQL
 Oracle database 11g: Administration workshop I
 Oracle database 11g: Administration workshop II
 Oracle Database 11g: RAC Administration Release 2

Orbits Engineering at Orbits Engineering

• Egypt - Cairo
• July 2013 to March 2014

Installion & Migration
 Install Oracle, MYSQL database according to company standard .
 Install Oracle client and Oracle odac .
 Allocating system storage and planning future storage requirements for the database system
 Manage database storage structures (ASM)
 Configure and install Oracle Rac 11g.
 Plan and Perform migration from oracle 10g to oracle 11g.
 Install third party application like (Toad, Oracle sql developer )


Backup and Recovery
 Planning for backup and recovery of database information
 Backing up and restoring the database using RMAN
 Preform Schedule job for backup using expdp .
 Perform database clone.
 Backup MYSQL DATABASE with mysqldump.

Performance Tuning
 Monitoring and optimizing the performance of the database
 Deal with Oracle performance tuning.

Application Versioning
 Designing and developing the database application
 Designing the database structure for an application
 Specifying modifications of the database structure for an application
 Tuning the application during development
 Modifying the database structure, as necessary, from information given by application developers
 Responsible for appliaction versioning with database scripts
Secuirty
 Enrolling users and maintaining system security
 Manage users with required privilges

Oracle Database Administrator at Newway Software

• Egypt - Cairo
• June 2009 to June 2013

1- Oracle Database Administrator
 Provided Oracle database administrative support (9i, 10g.11g)
 Installed and configured Oracle Real Application Cluster (RAC) and OEM
Grid Control.
 Configure and manage ASM instance.
 Add new disk to ASM disk group.
 Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup.
 Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
 Having knowledge and practice of Oracle backup and recovery scenarios.
 Performed database tuning using Explain Plan, hints, Toad, Oracle sql developer, sql code and Enterprise Manager.
 Provided primary database support for New way application database systems
 Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
 Recovering the database in the event of a hardware or software failure
 Performing ongoing Oracle security management
 Defining standards for database documentation
 Good knowledge with sql and pl/sql.
1- Application Administrator (Newway ERP)
(Training plan, Implementation plan)
 Successfully Implemented, Administered, Customized, Troubleshooted and Maintained Newway ERP system. Maintained 100% system uptime and full system integrity
 Responsibilities include Newway General Ledger, Receivables Management, Payables Management, Sales Order Processing, POS . Purchase Order Processing, Inventory Control and Human Resource (Payroll)

I did trained many companies with various Activities (Industrial, Trading, tourist)
,
3- Oracle Apex Developer
 Created Oracle Apex Application from Scratch.
 Created sign in and signup process for the user login.
 Created Custom authorization and authentication for the application
 Created documentation, design and implemented rich user interfaces using Oracle Apex
 Created different type of Pages, Region, Items, Validations and Process
Environment: Oracle Apex 4.0
4- Techincal support
Responsibilities

 Server installion
 (Operating system, configuration, Oracle Database, Oracle application server, patches )
 Network Support
 ( Domain setup, manage active directory, users profiles
 , roaming profiles

Computer Teacher at 15th May High School

• Egypt - Cairo
• September 2008 to May 2009