Databases Expert

Responsible for the design, implementation, support, and maintenance of all databases, datalake and ETL infrastructures of the Organization. Drives innovation within Data management by assessing new technologies and studying opportunities to introduce them within the infrastructure.

Responsibilities

• Manages the technical lifecycle of the databases used by the Organization.
• Maintains current knowledge on databases technology and recommends modifications of standards as necessary.
• Creates and proposes technical design documentation including database design models, mapping, and standards.
• Defines operational procedures to guarantee SLA and operational requirements.
• Manages the technical lifecycle of the datalake, data storage and data manipulation tools used by the Organization.
• Maintains current knowledge of datalake and data manipulation tools technologies and recommends modifications of standards as necessary.
• Participates in the definition of data governance rules (data life cycle, data security management, data quality).
• Enforces data governance rules through tools and operational procedures.
• Organizes data administration auditing procedures.
• Provides databases troubleshooting analysis skills (root cause analysis, alarm management, etc.).
• Defines standards for database performance management, data processing performance management, and monitoring management.
• Enforces data processing security requirements defined by the Organization.
• Defines roadmaps to prevent technological obsolescence and manage security of environments.
• Manages training of the data team around DRP management.
• Updates operational procedures around data management.
• Performs other duties as required by the supervisor.

Requirements

• University degree (3 to 4 years) in computer science, Engineering or equivalent field is preferred.
• Internationally recognized certifications in Database field.
• ITIL Certification.
• Minimum of 7 years in IT, including at least 5 years in Database design and operations in a multiple datacenters and mission critical environment.
• Experience in Lakehouse or Datamart design and implementation.
• Working knowledge of English is required.
• Fluency in English is highly desirable.
• Proficiency as second official working language of the Organization (Arabic, French or Spanish) would be an additional asset.
• Good overall knowledge of operating systems and networks; accurate knowledge of databases.
• High level of human relations skills.
• Organized, methodical, efficient.
• Ability to listen and to co-ordinate.
• Proactivity, ability to suggest database infrastructure improvements and optimizations.
• Efficiency in emergency, critical situations.
• Ability to deal with several issues simultaneously.
• Ability to understand and deal with priorities, in coordination with the ability to understand business rules and therefore business impacts of technical issues.
• Teamwork and reporting.
• Integrity and commitment.
• Knowledge about Relational Database Management Systems. Expert level knowledge of at least two of the following: Oracle Database, Microsoft SQL Server, Maria DB/MySQL, PostgreSQL.
• Knowledge of Non-relational DBs like MongoDB and Cassandra.
• Knowledge of ETL tools (Talend, Nifi, etc.) and Dataviz tools (Qlik, Tableau, Power BI).
• Advanced knowledge of structured query language (SQL) and Python.
• Advanced knowledge in the Hadoop technical stack (Datalake).
• Knowledge of General High Availability and data replication Technologies.
• Knowledge of Machine learning and artificial Intelligence Technologies.
• General understanding of data governance issues (data lifecycle, data quality, data security).
• Knowledge of ITIL methodologies and practices (change management, problem management, incident management, DRP, crisis management)

Skills

• Database Design
• Database Operations
• Relational Database Management Systems
• Oracle Database
• SQL Server
• MariaDB
• MySQL
• PostgreSQL
• Non-Relational Databases
• MongoDB
• Cassandra
• ETL
• Talend
• Nifi
• Data Visualization
• Qlik
• Tableau
• Power BI
• Structured Query Language
• SQL
• Python Programming
• Hadoop Technical Stack
• Data Lakes
• High Availability Technologies
• Data Replication Technologies
• Machine Learning Technologies
• Artificial Intelligence Technologies
• Data Governance
• Data Lifecycle Management
• Data Quality Processes
• Data Security
• ITIL Methodologies
• Change Management
• Problem Management
• Incident Management
• Disaster Recovery
• Crisis Management
• Database Infrastructure Optimization

Languages

English, Arabic, French, Spanish