{"id":2225,"date":"2022-12-08T16:12:11","date_gmt":"2022-12-08T15:12:11","guid":{"rendered":"https:\/\/azara.ma\/?p=2225"},"modified":"2025-02-21T07:41:26","modified_gmt":"2025-02-21T06:41:26","slug":"expert-bases-des-donnees-sql-server-cons-3582","status":"publish","type":"post","link":"https:\/\/azara.ma\/en\/expert-bases-des-donnees-sql-server-cons-3582\/","title":{"rendered":"Expert bases de donn\u00e9es SQL server [CONS-3582]"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Objectif de la mission&nbsp;<\/h2>\n\n\n\n<ul>\n<li>Il g\u00e8re et administre les syst\u00e8mes de gestion de donn\u00e9es de l\u2019entreprise, en assure la coh\u00e9rence, la qualit\u00e9 et la s\u00e9curit\u00e9<\/li>\n\n\n\n<li>F\u00e9d\u00e9rer les projets, les outils et l&rsquo;administration de toutes les Bases De Donn\u00e9es<\/li>\n\n\n\n<li>Mettre en place des proc\u00e9dures d&rsquo;exploitation pour les serveurs, sauvegardes et Bases De Donn\u00e9es<\/li>\n\n\n\n<li>Piloter les ressources d&rsquo;exploitation<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Prestations demand\u00e9es&nbsp;:<\/h2>\n\n\n\n<ul>\n<li>Prestations demand\u00e9es :\n<ul>\n<li>Administration :<\/li>\n\n\n\n<li>Mettre en place des standards en ce qui concerne les bases de donn\u00e9es, pr\u00e9coniser des bonnes pratiques \u00e0 usage des \u00e9quipes de d\u00e9veloppement<\/li>\n\n\n\n<li>Effectuer les choix d\u2019impl\u00e9mentation des bases de donn\u00e9es dans le respect du cahier des charges et en collaboration avec les diff\u00e9rents acteurs du projet<\/li>\n\n\n\n<li>Cr\u00e9er les bases et implanter les donn\u00e9es sur les supports physiques<\/li>\n\n\n\n<li>D\u00e9finir de mani\u00e8re optimale les param\u00e8tres de la base de donn\u00e9es<\/li>\n\n\n\n<li>Administrer les autorisations d\u2019acc\u00e8s pour les utilisateurs ainsi que les probl\u00e9matiques de s\u00e9curit\u00e9 des donn\u00e9es avec l\u2019ing\u00e9nieur s\u00e9curit\u00e9<\/li>\n\n\n\n<li>Mod\u00e9liser la base et concevoir les tables et les clefs<\/li>\n\n\n\n<li>Garantir la disponibilit\u00e9 et la qualit\u00e9 des donn\u00e9es par le maintien et l\u2019am\u00e9lioration des performances (\u00ab tuning \u00bb) et fonctionnalit\u00e9s (en am\u00e9liorant leur automatisation, optimisant les traitements et les requ\u00eates, les param\u00e9trages\u2026)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Exploitation :\n<ul>\n<li>D\u00e9finir des r\u00e8gles de s\u00e9curit\u00e9 (physique et logique) des donn\u00e9es ainsi que des normes d\u2019utilisation des bases<\/li>\n\n\n\n<li>Assure l\u2019int\u00e9grit\u00e9 des bases de donn\u00e9es existantes en garantissant la s\u00e9curit\u00e9 physique (proc\u00e9dures de sauvegarde, restauration, journalisation, d\u00e9marrage apr\u00e8s incidents\u2026) et logique (confidentialit\u00e9, acc\u00e8s)<\/li>\n\n\n\n<li>Dimensionner le serveur<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Support et s\u00e9curit\u00e9 :\n<ul>\n<li>Prendre en compte les sp\u00e9cificit\u00e9s du client interne ou externe en collaboration avec l\u2019architecte infrastructure en ce qui concerne notamment la taille de la base (capacity planning)<\/li>\n\n\n\n<li>Gestion des mont\u00e9es en charge (suivi de la volum\u00e9trie\u2026) sur l\u2019aspect acc\u00e8s aux donn\u00e9es<\/li>\n\n\n\n<li>G\u00e9rer des migrations de version<\/li>\n\n\n\n<li>Mettre \u00e0 jour les programmes et corriger ses \u00e9ventuels bugs (passer des patches) et donner son aval avant les mises en production<\/li>\n\n\n\n<li>Pr\u00e9coniser des dispositifs de sauvegarde (backup) \u00e0 r\u00e9aliser par les services d\u2019exploitation pour assurer l\u2019int\u00e9grit\u00e9 de l\u2019ensemble des donn\u00e9es de la base, notamment, l\u2019archivage et la purge des donn\u00e9es<\/li>\n\n\n\n<li>Assurer le suivi des outils de supervision et \u00e9tudier l\u2019ensemble des incidents survenus afin de comprendre leur gravit\u00e9 et leurs origines<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Contr\u00f4le et reporting :\n<ul>\n<li>Assurer une veille technologique afin de maintenir l\u2019ad\u00e9quation des performances et des sp\u00e9cificit\u00e9s des bases de donn\u00e9es aux besoins de l\u2019entreprise<\/li>\n\n\n\n<li>Suivre et contr\u00f4ler les \u00e9volutions de version des bases existantes pour faire \u00e9voluer les bases de donn\u00e9es<\/li>\n\n\n\n<li>Tester et valider les syst\u00e8mes de gestion de bases de donn\u00e9es dans le cadre de migrations ou d\u2019\u00e9volution technologique<\/li>\n\n\n\n<li>D\u00e9finir les normes et standards d\u2019utilisation et d\u2019exploitation des syst\u00e8mes de gestion de bases de donn\u00e9es<\/li>\n\n\n\n<li>Assurer la mise \u00e0 jour de la documentation sur la structure de la base, et les proc\u00e9dures d\u2019exploitation et de production<\/li>\n\n\n\n<li>Pr\u00e9senter de nouveaux produits ou de nouvelles versions \u00e0 son entreprise<\/li>\n\n\n\n<li>D\u00e9finir des normes qualit\u00e9 et \u00e9laborer des tableaux de bord et pour en assurer le suivi<\/li>\n\n\n\n<li>S\u2019assurer que les sauvegardes sont bien effectu\u00e9es (en allant faire des tests dans un centre de back-up) et contr\u00f4ler les mouvements sur les donn\u00e9es<\/li>\n\n\n\n<li>Elaborer et ex\u00e9cuter les proc\u00e9dures et programmes de test, lors des migrations ou \u00e0 la suite d\u2019un incident<\/li>\n\n\n\n<li>Assurer la r\u00e9cup\u00e9ration des donn\u00e9es et la remise en condition op\u00e9rationnelle des bases de donn\u00e9es (disaster recovery) suite \u00e0 incident grave<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Comp\u00e9tences m\u00e9tier :\n<ul>\n<li>Connaissance des op\u00e9rations bancaires courantes<\/li>\n\n\n\n<li>Connaissance des risques et sensibilisation aux risques<\/li>\n\n\n\n<li>Connaissances en mati\u00e8re de Data<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Outils, technologies, m\u00e9thodes :\n<ul>\n<li>Expertise en gestion des syst\u00e8mes de gestion des bases de donn\u00e9es : Microsoft SQL server<\/li>\n\n\n\n<li>Gestion des bases de donn\u00e9es IBM et Oracle, MySQL<\/li>\n\n\n\n<li>Bonne maitrise des syst\u00e8mes d\u2019exploitation serveur : Microsoft Windows server\/Linux Redhat\/IBM AIX<\/li>\n\n\n\n<li>Bonne maitrise des aspects de licensing Microsoft SQL<\/li>\n\n\n\n<li>Connaissances en solutions de virtualisation (Vmware et Hyper-v) et de sauvegarde\/restauration (Networker, TSM, Netbackup, Veeam)<\/li>\n\n\n\n<li>Connaissances transverses en architecture d\u2019infrastructure IT<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Comp\u00e9tences comportementales :\n<ul>\n<li>Disponibilit\u00e9 et engagement<\/li>\n\n\n\n<li>Esprit d\u2019\u00e9quipe et savoir travailler sous pression et r\u00e9sister au stress<\/li>\n\n\n\n<li>Organisation, autonomie et rigueur<\/li>\n\n\n\n<li>Capacit\u00e9 d\u2019analyse et de synth\u00e8se<\/li>\n\n\n\n<li>Sens de la communication et de la p\u00e9dagogie<\/li>\n\n\n\n<li>Discr\u00e9tion et confidentialit\u00e9<\/li>\n\n\n\n<li>Force de proposition et de conviction<\/li>\n\n\n\n<li>Savoir identifier les besoins des clients et r\u00e9pondre dans les d\u00e9lais \u00e0 leurs demandes<\/li>\n\n\n\n<li>Facult\u00e9 d\u2019adaptation et capacit\u00e9 \u00e0 g\u00e9rer des situations de conflit<\/li>\n\n\n\n<li>Excellente communication \u00e9crite et orale<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Date limite de r\u00e9ponse<\/h2>\n\n\n\n<p>La date limite pour postuler est le<strong>  16\/12\/2022 avant 12h<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Objectif de la mission&nbsp; Prestations demand\u00e9es&nbsp;: Date limite de r\u00e9ponse La date limite pour postuler est le 16\/12\/2022 avant 12h<\/p>","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[155],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azara.ma\/en\/expert-bases-des-donnees-sql-server-cons-3582\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting\" \/>\n<meta property=\"og:description\" content=\"Objectif de la mission&nbsp; Prestations demand\u00e9es&nbsp;: Date limite de r\u00e9ponse La date limite pour postuler est le 16\/12\/2022 avant 12h\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azara.ma\/en\/expert-bases-des-donnees-sql-server-cons-3582\/\" \/>\n<meta property=\"og:site_name\" content=\"AZARA Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-08T15:12:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T06:41:26+00:00\" \/>\n<meta name=\"author\" content=\"A. Ennabo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@AzaraConsulting\" \/>\n<meta name=\"twitter:site\" content=\"@AzaraConsulting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"A. Ennabo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/\"},\"author\":{\"name\":\"A. Ennabo\",\"@id\":\"https:\/\/azara.ma\/#\/schema\/person\/bf27c1ed90f3b229c217aeefb947f348\"},\"headline\":\"Expert bases de donn\u00e9es SQL server [CONS-3582]\",\"datePublished\":\"2022-12-08T15:12:11+00:00\",\"dateModified\":\"2025-02-21T06:41:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/\"},\"wordCount\":845,\"publisher\":{\"@id\":\"https:\/\/azara.ma\/#organization\"},\"articleSection\":[\"Offres de missions \u00e9chues\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/\",\"url\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/\",\"name\":\"Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/azara.ma\/#website\"},\"datePublished\":\"2022-12-08T15:12:11+00:00\",\"dateModified\":\"2025-02-21T06:41:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/azara.ma\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert bases de donn\u00e9es SQL server [CONS-3582]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azara.ma\/#website\",\"url\":\"https:\/\/azara.ma\/\",\"name\":\"AZARA Consulting\",\"description\":\"Transformation Digitale et Agile\",\"publisher\":{\"@id\":\"https:\/\/azara.ma\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azara.ma\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azara.ma\/#organization\",\"name\":\"AZARA Consultng\",\"url\":\"https:\/\/azara.ma\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azara.ma\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azara.ma\/wp-content\/uploads\/2021\/03\/azara-consulting-logo-nouveau.png\",\"contentUrl\":\"https:\/\/azara.ma\/wp-content\/uploads\/2021\/03\/azara-consulting-logo-nouveau.png\",\"width\":1034,\"height\":244,\"caption\":\"AZARA Consultng\"},\"image\":{\"@id\":\"https:\/\/azara.ma\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/AzaraConsulting\",\"https:\/\/www.linkedin.com\/company\/azara-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azara.ma\/#\/schema\/person\/bf27c1ed90f3b229c217aeefb947f348\",\"name\":\"A. Ennabo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azara.ma\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/11accfc0e8bfc13a38f3b0949e68683d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/11accfc0e8bfc13a38f3b0949e68683d?s=96&d=mm&r=g\",\"caption\":\"A. Ennabo\"},\"url\":\"https:\/\/azara.ma\/en\/author\/aennaboazara-ma\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azara.ma\/en\/expert-bases-des-donnees-sql-server-cons-3582\/","og_locale":"en_US","og_type":"article","og_title":"Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting","og_description":"Objectif de la mission&nbsp; Prestations demand\u00e9es&nbsp;: Date limite de r\u00e9ponse La date limite pour postuler est le 16\/12\/2022 avant 12h","og_url":"https:\/\/azara.ma\/en\/expert-bases-des-donnees-sql-server-cons-3582\/","og_site_name":"AZARA Consulting","article_published_time":"2022-12-08T15:12:11+00:00","article_modified_time":"2025-02-21T06:41:26+00:00","author":"A. Ennabo","twitter_card":"summary_large_image","twitter_creator":"@AzaraConsulting","twitter_site":"@AzaraConsulting","twitter_misc":{"Written by":"A. Ennabo","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#article","isPartOf":{"@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/"},"author":{"name":"A. Ennabo","@id":"https:\/\/azara.ma\/#\/schema\/person\/bf27c1ed90f3b229c217aeefb947f348"},"headline":"Expert bases de donn\u00e9es SQL server [CONS-3582]","datePublished":"2022-12-08T15:12:11+00:00","dateModified":"2025-02-21T06:41:26+00:00","mainEntityOfPage":{"@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/"},"wordCount":845,"publisher":{"@id":"https:\/\/azara.ma\/#organization"},"articleSection":["Offres de missions \u00e9chues"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/","url":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/","name":"Expert bases de donn\u00e9es SQL server [CONS-3582] - AZARA Consulting","isPartOf":{"@id":"https:\/\/azara.ma\/#website"},"datePublished":"2022-12-08T15:12:11+00:00","dateModified":"2025-02-21T06:41:26+00:00","breadcrumb":{"@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/azara.ma\/expert-bases-des-donnees-sql-server-cons-3582\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/azara.ma\/"},{"@type":"ListItem","position":2,"name":"Expert bases de donn\u00e9es SQL server [CONS-3582]"}]},{"@type":"WebSite","@id":"https:\/\/azara.ma\/#website","url":"https:\/\/azara.ma\/","name":"AZARA Consulting","description":"Transformation Digitale et Agile","publisher":{"@id":"https:\/\/azara.ma\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azara.ma\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azara.ma\/#organization","name":"AZARA Consultng","url":"https:\/\/azara.ma\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azara.ma\/#\/schema\/logo\/image\/","url":"https:\/\/azara.ma\/wp-content\/uploads\/2021\/03\/azara-consulting-logo-nouveau.png","contentUrl":"https:\/\/azara.ma\/wp-content\/uploads\/2021\/03\/azara-consulting-logo-nouveau.png","width":1034,"height":244,"caption":"AZARA Consultng"},"image":{"@id":"https:\/\/azara.ma\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/AzaraConsulting","https:\/\/www.linkedin.com\/company\/azara-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/azara.ma\/#\/schema\/person\/bf27c1ed90f3b229c217aeefb947f348","name":"A. Ennabo","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azara.ma\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/11accfc0e8bfc13a38f3b0949e68683d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/11accfc0e8bfc13a38f3b0949e68683d?s=96&d=mm&r=g","caption":"A. Ennabo"},"url":"https:\/\/azara.ma\/en\/author\/aennaboazara-ma\/"}]}},"_links":{"self":[{"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/posts\/2225"}],"collection":[{"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/comments?post=2225"}],"version-history":[{"count":2,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/posts\/2225\/revisions"}],"predecessor-version":[{"id":2228,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/posts\/2225\/revisions\/2228"}],"wp:attachment":[{"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/media?parent=2225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/categories?post=2225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azara.ma\/en\/wp-json\/wp\/v2\/tags?post=2225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}