University of Waterloo

Returning Candidate?

Database Administrator

Database Administrator

Requisition ID 
2018-2376
Job Category  
Analytics
Department 
8073 - Ctr for Ocular Research & Educ
Job Status 
Regular Full-Time
Hiring Range 
$53,120 - $66,400

More information about this job

Overview

This position is responsible for maintaining the integrity and security of all Centre for Ocular Research & Education (CORE) study data as well as preparing it for analysis according to Good Clinical Practice requirements and the needs of each study.

 

This role is contingent on funding.

Responsibilities

Development and Support of Multiple Databases

  • Design, develop and test database schema using RDBMS (Relational Database Management System) tailored to specific study data collection needs based on study case report forms for data entry or data transcription
  • Create and maintain documentation of database design, validation, changes, lock and data query for each study database
  • Develop/modify customized codes/scripts to perform edit checks
  • Assess, troubleshoot, and resolve problems related to the data collection applications
  • Assist with the entry and checking of study data as required
  • Create randomization schemes for research studies based on provided requirements

Administration and Maintenance of Database Systems

  • Set up and maintain logins for the users of databases
  • Monitor and implement security procedures to limit and ensure the appropriate access to the databases systems
  • Implement database upgrades when needs arise
  • Coordinate, monitor and oversee the backing up and archiving of study image data

Development and Maintenance of Datasets

  • Implement and perform data queries
  • Create, organize, store, document, extract/export, convert, merge, and manipulate data files
  • Tailor data files for statistical analysis (Statistica, SPSS, SAS or others as required)
  • Apply knowledge to the process of data cleaning and resolving data problems

Support of CORE Research

  • As required, work with UW IT support and external IT consultants for maintenance and troubleshooting of equipment, seeking guidance, where appropriate, from study investigators and CORE Senior Administrative Team
  • Consult with CORE staff, investigators and graduate students regarding data management needs
  • Perform modifications, such as addition and debugging of features, on Star Tracker custom software
  • Provide testing and/or support for system development activities when needs arise
  • Provide administrative support to Data Team as required

Communication

  • Respond to queries from study investigators and data analysts, with guidance where appropriate
  • Respond to requests from data management personnel and/or study investigators for database changes
  • Communicate with internal and external data users for sending data or image files
  • Provide database specific training to data entry personnel
     

Qualifications

  • Degree in Computer Science or related field
  • Training on the management of data sets using RDBMS
  • In-depth working experience with designing, developing, administrating and troubleshooting databases and their applications using REDCap, MS Access or other equivalent RDBMS
  • Experience querying and manipulating data sets
  • At least 2 years’ development experience using PHP, JavaScript, jquery, Codeigniter and/or Linux Cent-OS 7 would be an asset
  • Good oral and written communication skills with demonstrated decision-making, organizational and time management skills
  • Knowledge of Good Clinical Practice guidelines is an asset
  • Extensive knowledge of Relational Database Management Systems (RDBMS), including MS Access
  • Familiarity with PHP, JavaScript, HTML, MySQL, MS Excel, SPSS and SAS
  • Working Knowledge of IT infrastructure, network servers, and the configurations of databases and software applications
  • Knowledge of REDCap database would be an asset