Database Administrator L3

Posted Date about 1 year ago
Location Saudi Arabia
Discipline Information Technology
Job Reference 31256
Salary 0.0
Database Administrator L3 - Managed Services
Location: Riyadh, KSA
Role Type: Permanent

Description
The proposed position will be for a member of a managed services technical team, which is responsible Data Base Administration, functions and services related issues (operations, 3rd & 2nd level support).
The engineer will be working in a group of IT experts locally and within multiple projects to cover the required services functionalities and availability.

Role and Responsibilities
  • Requires travelling based on work needs, when not on site, Engineers will be assisting in the development of project plans, designs and documentation for future sites.
  • Up to 5 years’ experience in administering Microsoft SQL server databases.
  • Experience in building databases.
  • Ability to deal with different operating systems (Microsoft-Linux-HP unix4).
  • Experience in dealing with servers & backup devices.
  • Experience in Database Management (SQL, MongoDB, PostgreSQL)
  • Experience in Database Development (SQL, MongoDB, PostgreSQL)
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction.
  • systems.
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Experience in SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies.
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases.
  • Monitor and analyse database performance and ensure effective and efficient utilization of database systems/processes.
  • Organizing and managing the database archiving process.
  • Ability for planning and implementing Backup and recovery for database.
  • Ability to specify the required resources such as storage media space and memory size and recommend updating or modifying them based on performance.
  • Build data infrastructure such as tables and indexes by communicating with the development team.
  • Impalement security and encryption.
  • Create shell scripts for task automation.
  • Analyse, consolidate and tune database for optimal efficiency.
  • Monitor database performance and solve its issues.
  • Monitor database users and ensure from efficiency of the permissions.
  • Develop database utilities and automated reporting.
  • Design and document database architecture & Data Modelling.
  • Design Data Warehousing (SSAS, Azure Data Factory) and Business Intelligence platform.
Job Requirements
  • Bachelor’s degree in computer engineering or science
  • +8 years of experience in the same field
  • Professional certifications are required.