{"id":320,"date":"2010-11-15T16:11:41","date_gmt":"2010-11-15T21:11:41","guid":{"rendered":"http:\/\/www.monbug.org\/?p=320"},"modified":"2021-04-11T11:04:29","modified_gmt":"2021-04-11T15:04:29","slug":"architecte-de-bd","status":"publish","type":"post","link":"https:\/\/monbug.ca\/fr\/architecte-de-bd\/","title":{"rendered":"Architecte de BD"},"content":{"rendered":"<p><strong>Institution \/ D\u00e9partement:<\/strong><br \/>\n<a href=\"http:\/\/www.pharmacogenomics.ca\">Centre de Pharmacog\u00e9nomique Beaulieu-Saucier<\/a><br \/>\nU. Montr\u00e9al (Montr\u00e9al, Canada)<\/p>\n<p><strong>Description:<\/strong><br \/>\n(version fran\u00e7aise non disponible)<br \/>\nSummary<br \/>\nResponsible for all data manipulation and data management tasks for the center. This includes the design and maintenance of databases (Oracle, MySQL, SQL Server) to support internal software development; handling of very large data transformation tasks, often converting very large (100+ gB) flat files into a different format for analysis.  Development of internal reporting solutions from several different data sources, using SQL and web-based programmatic solutions (Perl). Needs to be comfortable with data manipulation from a wide variety of data sources (flat files, Excel Spreadsheets, MySQL, Oracle, SQL Server and custom sources).  <\/p>\n<p>Needed skills<br \/>\n&#8211; At least two years of professional experience as a data achitect<br \/>\n&#8211; Strong data architecture skills<br \/>\n&#8211; Strong SQL\/PLSQL<br \/>\n&#8211; Strong knowledge of Perl<br \/>\n&#8211; Strong knowledge of Linux<br \/>\n&#8211; Ability to write ETL code<br \/>\n&#8211; Knowledge of web-based programming<br \/>\n&#8211; Good knowledge of database administration tasks for  Oracle, MySQL and SQL Server (backup, restore, cloning and performance tuning)<br \/>\n&#8211; Working knowledge of french and english, but spoken and written<\/p>\n<p>Desired skill<br \/>\n&#8211; Knowledge of pharmacogenomics or genetics<\/p>\n<p><strong>Date de cl\u00f4ture :<\/strong><br \/>\n<span style=\"color: #3399CC;\">Vendredi, 19 novembre 2010<\/span><\/p>\n<p><strong>Contact :<\/strong><br \/>\nChristopher Beck<br \/>\ncbeck[at]pharmacogenomics.ca<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Institution \/ D\u00e9partement: Centre de Pharmacog\u00e9nomique Beaulieu-Saucier U. Montr\u00e9al (Montr\u00e9al, Canada) Description: (version fran\u00e7aise non disponible) Summary Responsible for all data manipulation and data management tasks for the center. This includes the design and maintenance of databases (Oracle, MySQL, SQL Server) to support internal software development; handling of very large data transformation tasks, often converting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":{"0":"post-320","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-emplois"},"_links":{"self":[{"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/posts\/320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/comments?post=320"}],"version-history":[{"count":3,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":2015,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/posts\/320\/revisions\/2015"}],"wp:attachment":[{"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/media?parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/categories?post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monbug.ca\/fr\/wp-json\/wp\/v2\/tags?post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}