Basic Info

Mohamed khiry

8 years

Cairo, Egypt

Bachelor's Degree

Experienced

Work Experience

Database Administrator at EGID

Experience Details

Database Administrator

IT/Software Development, Banking

Experienced (Non-Manager)

-Administer, install, and troubleshoot issues for Oracle and Ms SQL Server
-Design, develop, and evaluate high availability database (Always ON Availability Group)
-Design, Planning, and create for Disaster Recovery (DR) and oracle data Gard
-Design and teste backup and restore plan
-Create and implement database virtualization and consolidations strategies.
-Evaluate and harden database security, Implements and enforces security for all of the Databases.
-Implements and assess routine database maintenance plans.
-Define, analyze and design database projects, construct conceptual schema and define the function analysis of the system.
-Worked heavily with relationship database models, schemas & entity- relationship diagrams (ERMs) to create technical/system design documents.
-Creates and maintains all databases required for development, testing, education and
Production usage.
-Developed complex reports multi-functioned, labeled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports


Company Details

EGID

New Cairo, Egypt

51-100 employees

Banking, Information Technology Services

N/A

Aug 2016 to present (4 months)
Database Administrator & Data analyst at Ministry of Administrative Development (MSAD)

Experience Details

Database Administrator & Data analyst

IT/Software Development, Project/Program Management

Experienced (Non-Manager)

• applying the data cleansing role and create data models
• using several data analysis and data governance techniques
• Established physical data base parameters.
Coded SQL data base descriptions and specified identifiers of SQL data base to data base management system or directs others in coding data base descriptions.
• Calculated optimum values for SQL data base parameters, such as amount of computer memory to be used by data base, following manuals and using calculator.
• Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
-Specified which users can access data bases and what data can be accessed by user.
-Tested and corrected errors and refined changes to data base.
-Entered codes to create production data base.
-Selected and entered codes of utility program to monitor data base performance, such as distribution of records and amount of available memory.
-Directed programmers and analysts to make changes to data base management system.
-Reviewed and corrected programs.
-Confered with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base.
Modified data base programs to increase processing performance, referred to as performance tuning.
• Administer, install, and troubleshoot issues for Oracle and Ms SQL Server
• experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Manage technical issues related to database, applications, and tools used in development process
• Handle database performance tuning, security, capacity planning, and space management
• Administration Task like installation, backup and recovery (Imp, Exp) Checking Database Performance tuning, user privileges, space management., applying update and security patches and all related administration tasks
• Plan and implement backup and recovery strategies
• Provide 24/7 support for critical database issues
• Creates and maintains all databases required for development, testing, education and production usage.
• Performs the capacity planning required to create and maintain the databases
• Performs ongoing tuning of the database instances.
• Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Implements and enforces security for all of the Databases.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database
• Define, analyze and design database projects, construct conceptual schema and define the function analysis of the system.
• Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
• Developed complex reports multi-functioned, labeled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports
• Load the data from MS Excel, Flat files, MS- access and Oracle Table


Company Details

Ministry of Administrative Development (MSAD)

Egypt

101-500 employees

Government, Telecommunications, Information Technology Services

www.ad.gov.eg

Jun 2007 to Jul 2016 (9 years 1 month)
Technical Support at Mobileshop Co.

Experience Details

Technical Support

IT/Software Development, Customer Service/Support

Entry Level

- Updating exist database by data we received from our other branches
- Transform the database from access to Oracle 9i
- Start building application to be used in the all branches to insert update the data into the database
- Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the
products that are most appropriate. Planning is also performed by the DBA, along with the application
developers and System administrators, to ensure that any new product usage or release upgrade takes
place with minimal impact.
- Define, analyze and design database projects, construct conceptual schema and define the function
analysis of the system


Company Details

Mobileshop Co.

Egypt

101-500 employees

Telecommunications, Information Technology Services

https://mobileshop.com.eg/

Aug 2006 to Jun 2007 (10 months)

Education

computer science in computer science

Education Details

computer science

computer science

El Shorouk Academy, Egypt

B / Very Good / 75 - 85%

N/A

N/A

El Shorouk Academy
2002 - 2006

Training and Courses

Training/Course Details

Oracle DBA Courses

Jan 2008

(Oracle Egypt).

N/A

Training/Course Details

General Management Diploma

Aug 2012

(Logodi North Korea)

N/A

This profile is fresh!
Last update 4 days ago.

Jobseeker photo

Profile Skills and Keywords

AnalyticalBankingBigdataComputer ScienceCustomer ServiceDatabaseDatabase AdministratorDatabase Administrator & Data AnalystDatabase DeveloperEnglishGeneral Management DiplomaGovernmentITInformation Technology ServicesLeaderMicrosoft SQL ServerNegotiatorOracle 10g 11gOracle DBA CoursesOrganizerPl/sqlProblem SolverProgram ManagementProjectSoftware DevelopmentSupportT-sqlTechnical SupportTelecommunications

Self-assesed Skills

Languages

English

English

: Advanced

: Advanced

: Advanced

: Advanced

Tools and Technologies

Oracle 10g 11g

Oracle 10g 11g

: Advanced

: High

:

More than 7 years

Microsoft SQL Server

Microsoft SQL Server

: Advanced

: High

:

More than 7 years

t-sql

t-sql

: Advanced

: High

:

3-5 years

pl/sql

pl/sql

: Advanced

: High

:

3-5 years

R

R

: Intermediate

: Extreme - I love it!

:

Less than 1 year

Fields of Expertise

database developer

database developer

: Advanced

: High

:

More than 7 years

database

database

: Advanced

: Extreme - I love it!

:

More than 7 years

bigdata

bigdata

: Intermediate

: Extreme - I love it!

:

1-3 years

Key Skills

Analytical, Leader, Negotiator, Organizer, Problem Solver

Online Presence

mkhiry

Like mohamed`s profile? Share it!

Get Your own Wuzzuf Profile Now !

Employer? If you're representing an organization or an enterprise, Signup here for FREE to see Mohamed's full profile and find more great talent and professionals to join your team.