{"id":3236,"date":"2017-02-05T18:33:37","date_gmt":"2017-02-05T17:33:37","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=3236"},"modified":"2017-02-05T18:33:37","modified_gmt":"2017-02-05T17:33:37","slug":"axa-direct","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=3236","title":{"rendered":"AXA Direct"},"content":{"rendered":"

\"\"<\/p>\n

Missions:<\/p>\n

-1 DBA Senior SQL Server Production<\/p>\n

-1 DBA Junior SQL Server Production 1er Projet\u00a0: R\u00e9alisation d\u2019un reporting matinal centralis\u00e9 de la plateforme L'objectif de ce rapport est de d\u00e9terminer l'\u00e9tat de la plateforme ainsi que la n\u00e9cessit\u00e9 ou non d'effectuer des actions avant ouverture du call center de Direct Assurance Espagne (Direct Seguros). Concernant la partie technique, centralisation des informations de collecte sur un serveur peu sollicit\u00e9 durant la matin\u00e9e. Le rapport, g\u00e9n\u00e9r\u00e9 par une t\u00e2che planifi\u00e9e Windows ex\u00e9cutant un script Powershell, regroupe les items suivants pour chaque serveur SQL de production\u00a0:
\n\u00c9tat des jobs de Maintenance (Backup, rebuild d\u2019indexes et Integrity check)
\nEtat du Mirroring
\nJournal d\u2019erreur SQL
\nDisponibilit\u00e9 des bases et leurs \u00e9tats
\nCapacity Planning avec estimation du nombre de jours restants pour chaque base en prenant en compte l\u2019espace disponible dans la base\/sur le disque, ainsi que la pr\u00e9sence \u00e9ventuelle de plusieurs bases sur un m\u00eame disque
\n2eme Projet\u00a0: R\u00e9alisation d\u2019une \u00e9tude sur la compression de donn\u00e9es concernant le gain de volum\u00e9trie attendu pour chaque base des 3 instances de production de la plateforme.<\/p>\n","protected":false},"excerpt":{"rendered":"

Missions: -1 DBA Senior SQL Server Production -1 DBA Junior SQL Server Production 1er Projet\u00a0: R\u00e9alisation d\u2019un reporting matinal centralis\u00e9 de la plateforme L'objectif de ce rapport est de d\u00e9terminer l'\u00e9tat de la plateforme ainsi que la n\u00e9cessit\u00e9 ou non d'effectuer des actions avant ouverture du call center de Direct Assurance Espagne (Direct Seguros). Concernant …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-3236","post","type-post","status-publish","format-standard","hentry","category-clients","no-thumb"],"yoast_head":"\r\nAXA Direct - TEAMVIDIA<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.teamvidia.com\/?p=3236\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"AXA Direct - TEAMVIDIA\" \/>\r\n<meta property=\"og:description\" content=\"Missions: -1 DBA Senior SQL Server Production -1 DBA Junior SQL Server Production 1er Projet\u00a0: R\u00e9alisation d\u2019un reporting matinal centralis\u00e9 de la plateforme L'objectif de ce rapport est de d\u00e9terminer l'\u00e9tat de la plateforme ainsi que la n\u00e9cessit\u00e9 ou non d'effectuer des actions avant ouverture du call center de Direct Assurance Espagne (Direct Seguros). Concernant …\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=3236\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-05T17:33:37+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"AXA Direct\",\"datePublished\":\"2017-02-05T17:33:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236\"},\"wordCount\":200,\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif\",\"articleSection\":[\"clients\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236\",\"url\":\"https:\/\/www.teamvidia.com\/?p=3236\",\"name\":\"AXA Direct - TEAMVIDIA\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif\",\"datePublished\":\"2017-02-05T17:33:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=3236\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#primaryimage\",\"url\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif\",\"contentUrl\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif\",\"width\":200,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3236#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AXA Direct\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.teamvidia.com\/#website\",\"url\":\"https:\/\/www.teamvidia.com\/\",\"name\":\"TEAMVIDIA\",\"description\":\"Experts Base de Donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.teamvidia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\",\"name\":\"teamvidia\",\"url\":\"https:\/\/www.teamvidia.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AXA Direct - TEAMVIDIA","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:\/\/www.teamvidia.com\/?p=3236","og_locale":"fr_FR","og_type":"article","og_title":"AXA Direct - TEAMVIDIA","og_description":"Missions: -1 DBA Senior SQL Server Production -1 DBA Junior SQL Server Production 1er Projet\u00a0: R\u00e9alisation d\u2019un reporting matinal centralis\u00e9 de la plateforme L'objectif de ce rapport est de d\u00e9terminer l'\u00e9tat de la plateforme ainsi que la n\u00e9cessit\u00e9 ou non d'effectuer des actions avant ouverture du call center de Direct Assurance Espagne (Direct Seguros). Concernant …","og_url":"https:\/\/www.teamvidia.com\/?p=3236","og_site_name":"TEAMVIDIA","article_published_time":"2017-02-05T17:33:37+00:00","og_image":[{"url":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif","type":"","width":"","height":""}],"author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=3236#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=3236"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"AXA Direct","datePublished":"2017-02-05T17:33:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3236"},"wordCount":200,"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3236#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif","articleSection":["clients"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=3236","url":"https:\/\/www.teamvidia.com\/?p=3236","name":"AXA Direct - TEAMVIDIA","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3236#primaryimage"},"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3236#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif","datePublished":"2017-02-05T17:33:37+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=3236#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=3236"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.teamvidia.com\/?p=3236#primaryimage","url":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif","contentUrl":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/01\/axa.gif","width":200,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=3236#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"AXA Direct"}]},{"@type":"WebSite","@id":"https:\/\/www.teamvidia.com\/#website","url":"https:\/\/www.teamvidia.com\/","name":"TEAMVIDIA","description":"Experts Base de Donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamvidia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96","name":"teamvidia","url":"https:\/\/www.teamvidia.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3236"}],"version-history":[{"count":1,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3236\/revisions"}],"predecessor-version":[{"id":3237,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3236\/revisions\/3237"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}