Mohammad Aqel, Database Consultant / Team Lead

Mohammad Aqel

Database Consultant / Team Lead

Saudi Arabian Monetary Agency - SAMA

Location
Saudi Arabia - Riyadh
Education
Bachelor's degree, Computer engineering
Experience
17 years, 4 Months

Share My Profile

Block User


Work Experience

Total years of experience :17 years, 4 Months

Database Consultant / Team Lead at Saudi Arabian Monetary Agency - SAMA
  • Saudi Arabia - Riyadh
  • My current job since December 2014

- Implement performance baseline monitoring.
- Perform efficient analysis of performance data.

- Help SAMA to review common disaster recovery scenarios, determine the risks posed to the business, and execute the recovery steps needed to recover from disaster.
- Developed and tested storage strategies and disaster-recovery plan for the operational database, delivering solution that guaranteed recovery performance and high availability.

- Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

- Ensure that proper SLAs are defined for database and managed services of upgraded or developed systems.
- Work on upgrading current infrastructure database to meet the best practice .

- Define database development procedures and database version and revision control practices
- Define database programming language required for application
- Define normalization rules and processes
- Document code, errors, and code modifications in detailed supporting documents
- Evaluate alternatives in code implementation and make decisions
- Debugging tools, unit testing procedures, and iteration design processes
- Define system testing procedures


- Define the structure and processes for the team.
- Assign team roles and responsibilities.
- Assess effective use of resources throughout the project.
- Assess effectiveness of team processes and communication.
- Provide feedback and coaching to team members.

Senior Database Administrator at IHorizons
  • Jordan - Amman
  • June 2012 to December 2014

1. Develop Structure
- Choose a database architecture
- Identify major subsystems and interfaces
- Select design tools and programming language
- Develop application models
- Integrate security requirements and features into the structure
- Validate design scheme and models

2. Implement Solutions
- Define database development procedures and database version and revision control practices
- Define database programming language required for application
- Define normalization rules and processes
- Document code, errors, and code modifications in detailed supporting documents
- Evaluate alternatives in code implementation and make decisions
- Debugging tools, unit testing procedures, and iteration design processes
- Define system testing procedures

3. Manage Database Development Environment
- Evaluate and recommend hardware, software, and third-party solutions
- Set up server database software
- Manage server at the database level
- Support disaster recovery

4. Training Database Stuff and trainees, on the following subjects :
- Database Fundamentals
- Administering Microsoft SQL Server.
- Implementing and Developing Microsoft SQL Server.
- Administering Oracle Database Server.
- Used Oracle New Technology.


Sample Projects:

• Aljazeera Net (Link) www.aljazeera.net:

The top news website on Arabic countries; my role on this project is to handle all database deliverables and development’s needs, Providing the top security level on the database, managing Microsoft CMS database, handling all cases appears on the live production environments, Migration processes, managing all administration tasks like Replication, Convert AJA system to the KS3 version including data migration, high availability etc.

• QPP Qatar General Prosecution :

Worked as Database Consultant, and Setup Database disaster recovery. database design, creating SPs, all database development tasks, backup polices.

 Used technologies:

- Oracle Database 11g
- Oracle Weblogic.
- Oracle Golden Gate
- Oracle Data Mask
- Database Firewall.

Senior DataBase Engineer at MADFOO3AT
  • Jordan - Amman
  • September 2011 to June 2012

✓ Microsoft SQL Server DataBase Engineer


Main Responsibilities:
- Install versions of the SQL Server RDBMS and other related tools.
- Plan and maintain sound backup and recovery policies and procedures
- Performs the capacity planning required to create and maintain the databases (including estimate sizing and growth requirements)

- Database tuning and performance monitoring
- Implement high availability and disaster recovery plan
- Analyze and develop ETL package for data migration. (From unstructured to structured databases)
- Implement and enforce security for all SQL Server databases.
- Administer all database objects, including tables, indexes, views, stored procedures and functions (including replication, database subscripting, views, , etc)
- Provides technical support to application development teams
- Setup and maintain documentation and standards.
- Database Centralization and centralization management.
- Controlling and monitoring user privileges on accessing databases
- Implementing operational automation using scripts. (script planning)

✓ Used technologies:
1- Database: -
SQL server 2000, 2005, 2008

2- Application Server:
- Tomcat
- IIS

SQL Server and Oracle Database administrator at REALSOFT ADVANCED APPLICATIONS
  • Jordan - Amman
  • October 2006 to April 2011

✓ SQL Server and Oracle Database administrator


Main Responsibilities:
- Installation, configuration and upgrading of SQL Server software and related
products
- - Install and configure SQL Server database
- Install and configure Linux operating system
- Implement and maintain database security (create and maintain users and roles,
assign privileges)
- Provide real-time technical support to the project users during the implementation Phase
- Making database backups and performing recovery when necessary
- Performing upgrades of the database and software to new release levels.
- Identify, prioritize, diagnose and resolve user problems in a timely fashion during
The implementation phases.
- Assist in preparing the implementation plans and work procedures
- Install and configure IIS, Oracle application Server and Oracle Weblogic.
- Interface with Oracle Corporation for technical support.
- Plan growth and changes (capacity planning)


Sample Projects:

• Oman census 2010 (Establishment, Dwelling and Population):

Client: Government of Oman, Census department 2010
Period: September, 2010 - December, 2010
My Role: SQL SERVER and Oracle database administrator
 Managing users and security
 Making database backups and performing recovery when necessary
 Proactively monitoring the database's health and taking preventive or corrective action as required
 Monitoring and tuning performance

Project Description:
The project aims to automate whole census activities and processes to cover all census stages: pre-listing, listing, update stage, Establishments census, dwelling and population census.

Used technologies:
 Oracle RAC database
 SQL SERVER Database (Mirroring technology).
 Oracle BIEE
 Oracle Data guard
 TOMCAT application server


• Abu-Dhabi census 2010 (Establishment, Dwelling):

Client: Government of Abu-Dhabi, Census department 2010
Period: January, 2010 - April, 2010
My Role: SQL SERVER AND Oracle database administrator
 Install and configure SQL SERVER Database.
 Managing users and security
 Making database backups and performing recovery when necessary
 Monitoring and tuning performance

Project Description:
The project aims to automate whole census activities and processes to cover all census stages: pre-listing, listing, update stage, Establishments census, and dwelling census

Used technologies:
 Oracle BIEE
 SQL SERVER Database .
 Oracle Application server

Education

Bachelor's degree, Computer engineering
  • at Hashemite University
  • June 2006

Hashemite University B.Sc. Electrical and Computer engineering GPA. 3.41 Rating very good.

High school or equivalent, Scientific stream
  • at Hussein High school
  • June 2002

Hussein High school- Jordan / Amman Scientific stream GPA. 91.2 Rating excellent.

Specialties & Skills

Training
Database Design
SQL Server
Database Administration
experience in providing technical customer support services to diverse users
Linux and Unix OS skills
Networks set up and configuration
Training Database Stuff and trainees , on (Administering,Implementing,Developing SQL Server)
Ability to perform both SQL SERVER , Oracle and operating system performance tuning and monitorin
Good experience on Oracle Golden-Gate, and Oracle Database Security and Tuning

Languages

Arabic
Expert
English
Expert

Training and Certifications

Designing Database Solutions , Developing Databases (Training)
Training Institute:
Microsoft® Certified Solutions Expert - Data Platform MCSE
Date Attended:
October 2013
Administering , Querying , Implementing a Data Warehouse (Training)
Training Institute:
Microsoft® Certified Solutions Associate MCSA
Date Attended:
July 2013
IT Professional (Training)
Training Institute:
MCTS -- SQL Server 2008 implementation and maintenance
Date Attended:
April 2012
IT Professional (Training)
Training Institute:
MCITP SQL Server 2008 : Database Administrator
Date Attended:
September 2012
SQL Server Training (Training)
Training Institute:
Implementing a Microsoft SQL Server 2008 R2 Database
Date Attended:
April 2012
SQL Server Training (Training)
Training Institute:
Maintaining SQL Server 2008 R2 Database
Date Attended:
March 2012