Oracle Database Administrator/Developer.
Al-Wafa Technical Systems Services
Total years of experience :18 years, 11 Months
Perform oracle installations.
Design, implement, develop, and administrate oracle database.
Design, develop and create custom forms/reports based on business requirements.
Design, size and create storage structures context of the database and the platform on which it operates.
Facilitate training and identify the training needs of resources. Build and execute training plans.
Perform program management, project scoping, resource allocation, project scheduling and management.
Monitor application performance areas and tune the application code as necessary.
Serve as a system subject matter expert for supporting business processes.
Develop test cases and provide test support to ensure successful project execution.
Translate business requirements into technical requirements.
Write functional requirement specifications that provide the basis for technical development.
Provide regular project updates.
Provide troubleshooting support for business personnel and database restore and recovery when necessary.
Creation and maintenance of SQL queries.
Reviewing and tuning SQL and PL/SQL code.
Perform & Plan for database backups using RMAN.
Supporting the roll-out of new applications.
• Projects:
Design, Implement, Develop and Administrate Contracts, Inventory, Financial and HCM Modules for (Al-Wafa Technical Systems Services).
Design, Implement, Develop and Administrate Inventory, Financial and HCM Modules for (Grundig Sat Systems Middle East LLC).
Design, implement, develop, and administrate oracle database.
Design, develop and create custom forms/reports based on business requirements.
Perform & plan for database backups.
Restore & recover Database when necessary.
Install, update and configure computer hardware operating systems and applications.
Monitor and maintain the computer systems and networks of the group.
Manage tasks and requirements associated with the users.
Analyze and fix bugs and defects in the existing inventory system.
Diagnose hardware/software faults.
Replace parts as required.
Support the roll-out of new applications.
Set-up new users’ accounts and profiles and dealing with password issues.
Prioritize and manage many open cases at one time.
Test and evaluate new technology.
Perform weekly backups.
Insure IT systems is working continuously without any interruption.
• Project:
Design, implement, develop and administrate Financial and HCM modules for (KAA. Group).
• Personal responsibilities:
Design and develop Financial module.
Create all Financial, HR & Payroll reports based on business requirements.
Member of a team for designing, sizing and creating storage structures context of the database and the platform on which it operates.
Administer and support oracle database.
Responsible for ensuring availability and performance of the database that support the system.
Administer and support oracle 10g.
Perform oracle installations & updates.
Perform monitoring, tuning and capacity planning.
Perform database backup, restore and recovery.
Creation and maintenance of SQL queries and routines
Design, develop and create custom reports based on business requirements.
Provide assistance to the development team in designing, developing, testing, tuning and implementing the database applications.
Provide training services to the clients.
• Project in (Al-Ahram advertising department)
Design, implement and develop a reservation module for Al-Ahram advertising Agency to facilitate the tasks of the reservation department.
• Personal responsibilities:
Member of a team for designing, implementing and developing a reservation module.
Member of a Team for designing and developing all reports based on business requirements.
Design, size and create storage structures context of the database and the platform on which it operates.
Administer and support oracle database.
Monitor office network.
Manage tasks and requirements with the users.
Troubleshoot system and network problems.
Diagnose hardware/software faults.
Follow diagrams and written instructions to repair a fault or set up a system.
Set-up new users' accounts and profiles and deal with password issues.
Provide assistance and support to the end-user.
Create purchase requisitions for IT hardware/software
Test new technology.
Perform weekly backups.
Insure IT systems is working continuously without any interruption.