University of Waterloo

  • CCIN/PDC Web/Database Developer

    Requisition ID
    2018-3123
    Job Category
    IT
    Department
    2650 - Geography
    Job Status
    Temporary Appointment (Contract)
    Hiring Range
    $49,965 - $62,456
  • Overview

    Term: 1 year

     

    CCIN, Canada’s primary source for data and information on snow, ice, and cold regions for over two decades, manages the Polar Data Catalogue (https://polardata.ca), a searchable archive of data and information generated by Arctic and Antarctic researchers from ArcticNet, Canada’s Northern Contaminants Program, the Canadian High Arctic Research Station of Polar Knowledge Canada, the Nunavut General Monitoring Plan, and others. A critical component of this service is the development of web and database support for outreach and communication, data discovery, input, preservation and management. The web/database developer will have experience in full-stack web development and administration.

     

    This role is contingent on funding. 

    Responsibilities

    Technical Activities

    • Develop and maintain the web based functions and infrastructure for the CCIN and the PDC
    • Maintain and develop new functions for Java-based PDC applications, currently PDC Geospatial Search, PDC Metadata/Data Input, and PDC Lite Search, using the underlying PostgreSQL database and associated software such as GeoServer, OpenLayers, and others
    • Maintain interoperability functions and software, including GeoNetwork, GeoServer, and jOAI, and establish and configure new interoperability linkages with partner organizations
    • Maintain Apache and Tomcat and other web-relevant configurations, in collaboration with the CCIN Systems Administrator
    • Maintain and develop the CCIN Drupal website and included data visualizations
    • Apply updates and, with the support of content providers, add new content to the CCIN Drupal website
    • Administer the PostgreSQL databases for PDC applications and the CCIN Drupal website
    • Support the data management tasks of the CCIN data managers, as needed
    • Fix bugs in applications, websites, databases, or functions as identified by CCIN staff and users
    • Redesign and create new versions of the PDC applications and the CCIN website, as needed, using the latest technologies and responding to user demands
    • Perform weekly database health checks and monitor database activity to ensure problem-free operation
    • Refresh test and disaster databases from production on a regular basis
    • Perform regression testing on all new development, and coordinate regression testing by all staff for full analysis, on newly-developed applications and functions, prior to public release
    • Coordinate new or updated application/website deployment schedule and work with the Associate Director to assign tasks to all staff to support the deployment schedule
    • Oversee the work of junior web/database staff, including undergraduate co-op students
    • Responsible for Web application security policies, standards and implementation

    Group Activities

    • Work with other CCIN staff to support the overall aims of the organization and promote good security practice
    • Document work, in code and in supporting documentation such as the organizational wiki
    • Attend and contribute to regular CCIN team meetings

    Qualifications

    • Minimum Bachelor’s degree in Computer/Information Science, Geography/GIS, Natural or Mathematical Sciences, or equivalent education and/or experience
    • Minimum 2 years experience in a Web Development role using Drupal, Apache, Tomcat and Java,
    • Previous experience in administration of PostgreSQL databases and development and maintenance of interoperability functions and software, including GeoNetwork, GeoServer, and jOAI required
    • Proactive, innovative, and eager approach to problem solving and a desire to continue learning new technologies and practices for improving the organization and our products
    • Expertise in the following is required:
      • Java, Spring Framework and related web-based software stack, including Hibernate, Java JPA, JSP, etc.
      • Front-end JavaScript technologies, such as AngularJS and jQuery
      • Tomcat and Apache
      • PostgreSQL database and PostGIS, SQL, PL/SQL, and Python
      • Open-source GIS technologies such as OpenLayers and other geospatial tools
      • PHP for use in Drupal or other content management system
      • Linux/Unix operating systems and fluency in working at the command line
      • Object-relational databases
    • The ideal candidate will have expertise in the following:
      • GeoServer and GeoNetwork
      • Metadata and data sharing tools such as WMS and other web services, OAI-PMH, THREDDS, OPeNDAP, etc.
      • Geospatial data processing
      • XML
    • Additional desired skills and expertise include
      • Knowledge of environmental data and ability to manage it in the spatial domain
      • Ability to adapt quickly to new situations and analyze and solve problems promptly
      • Ability to work independently, successfully communicate, organize and present materials clearly, and manage time efficiently
      • Strong attention to detail

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed