Database Consultant / Team Lead
Saudi Arabian Monetary Agency - SAMA
Total years of experience :17 years, 4 Months
- 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.
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.
✓ 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
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
Hashemite University B.Sc. Electrical and Computer engineering GPA. 3.41 Rating very good.
Hussein High school- Jordan / Amman Scientific stream GPA. 91.2 Rating excellent.