Skip to Content »

 DB Architect

Institution / Department:
Beaulieu-Saucier Pharmacogenomics Center
U. Montreal (Montreal, Canada Area)

Description:
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 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).

Needed skills
– At least two years of professional experience as a data achitect
– Strong data architecture skills
– Strong SQL/PLSQL
– Strong knowledge of Perl
– Strong knowledge of Linux
– Ability to write ETL code
– Knowledge of web-based programming
– Good knowledge of database administration tasks for Oracle, MySQL and SQL Server (backup, restore, cloning and performance tuning)
– Working knowledge of french and english, but spoken and written

Desired skill
– Knowledge of pharmacogenomics or genetics

Application deadline :
Friday, November 19th, 2010

Contact :
Christopher Beck
cbeck[at]pharmacogenomics.ca