Senior Oracle Application Database Administrator
vodafone
مجموع سنوات الخبرة :11 years, 9 أشهر
A. Providing Global DB support for Vodafone Enterprise for around 15 service.
B. Performing all DB technical troubleshooting to resolve customer problems and service requests.
C. Administrating and troubleshooting Oracle RAC Database & Data guard on Linux.
D. Perform database and application queries tuning and performance monitoring.
E. Support application databases deployment/upgrades activities.
F. Establish and maintain backup and recovery policies and procedures with cooperation with DC Backup Teams.
G. Work with developers to design and build new structures to support application enhancements and promote database changes throughout the Dev, Test, UAT and Prod databases.
H. Set up, manage and monitor application related jobs.
I. Maintaining up-to-date service documentation and knowledge base.
J. Participating in 24x7 on-call rotation and be available to perform periodic after-hours support.
k. created alerts scripts and daily reports to send an email notifications
-Manage Oracle RAC under Linux
-Clone Oracle RAC
-Perform security process on Web logic and Oracle Database
-manage Web logic under Linux
-install oracle Database.
-Manage Oracle Data guard
-rebuild Data Guard
-solve any issue related to Web logic, Data guard, RAC.
- Installing Linux operating system.
- Configure Linux operating system to install oracle database.
- Installing & managing oracle database on Linux
- Using Rman in backup and restore
- Using Rman duplicate to synchronize between live server and test server
- Support more than oracle database (single and data guard)
- Write queries to check the gaps between oracle database inside and outside Egypt
- Check the queries that affect the performance and enhanced it.
- Using data pump to export and import schema
- Supports and maintains ECG database system, and ensure its reliability and availability.
- Maintain data integrity and security (manage roles and permissions of database users).
- move the data between the database servers
- create execution plan for query & views that take a long time
- audit any new objects created
-INSTALL Oracle Database
-solve database problem & trouble shoot database
-implement Data guard
-backup and recovery database using rman
-Installing, supporting and administrating micros opera application and micros Fidelio suite 8 application.
-install windows and create raid for a server
--cloning the oracle database from cluster to single server to implement dataguard
-perform oracle upgrade on database 10g
-move the database between the servers
-solving oracle performance problem
-support oracle database 9i, 10g, 11g
install oracle database 11g
perform export/import files
perform backup and recovery using rman
install windows server 2008
write a queries to help the developer
modifying a database parameters
write a PL-SQL to create procedures and triggres
take backup for a PC and server
manage database .
using datapump to export schema and import it.
-set up the application and testing it
-work on SDK library and use its function with :
1-C# samples
2-java programming language samples
3-asp.net C# samples
4-javascript samples
-prepare SRS and documentation about solution and some product
-support customers with a problem in SDK and company software product
- Graduation Grade: Very Good with Honor - Rank: The 5th - Project: 3D Interactive web-based show Room - Project Grade: Excellent - Oracle Database 11g course - Oracle Database 11g Administrator Certified Associate - Local TOEFL certificate at the American university in Cairo - 2 Levels in English at ELS LANGUAGE CENTER - 3 Levels in English at AmidEast """""""""""""""""""""""""""""""""""""""""""""""" - NOW I AM PREPARING A MASTER DEGREE IN COMPUTER SCIENCE AT arab academy for science and technology and maritime transport """"""""""""""""""""""""""""""""""""""""""""""""