University of Waterloo

Information Systems Specialist (Systems and Database Administration)

Requisition ID 2022-8573
Department
Polar Data Catalogue, Interdisciplinary Centre on Climate Change
Employment Type
Temporary
Time Type
Full-Time
Hiring Range
$63,737 - $79,672
Job Category
Other
Job Location : Location
CA-ON-Waterloo

Overview

Term: 1 year

 

The Interdisciplinary Centre on Climate Change (IC3) provides digital research infrastructure that supports its member organizations, as well as UW faculty and researchers. The Information Systems Specialist manages the implementation, operation, security, and enhancements of the unit’s core infrastructure and associated assets (e.g. servers, databases, virtual machines, software, licenses, domains, staff computers, and office equipment) throughout their entire lifecycle. The responsibilities and assignments of Information Systems Specialists include several key specializations, as described in the following section.

Responsibilities

Systems Administration

  • Design, test, deploy, monitor, and maintain both physical and virtual Windows and Linux servers
  • Implement, monitor, and maintain server hardware, including storage and networking appliances
  • Implement, monitor, and maintain strong controls to ensure and mitigate potential security risks
  • Perform scheduled server backups to ensure business continuity (disaster recovery)
  • Deploy, test, and monitor server patches and updates, in coordination with Waterloo’s central IT
  • Assist in the planning and execution of server related maintenance and upgrades
  • Develop and archive documentation of activities and processes

Database Administration

  • Design, test, deploy, monitor, and maintain all internal and external databases and data stores
  • Monitor and optimize database performance, including refactoring internal data models
  • Perform scheduled database backups to ensure business continuity (disaster recovery)
  • Support data extraction, transformation, and loading (ETL) services
  • Provide management reports, client reports, and data extracts
  • Assist in the planning and execution of database related maintenance and upgrades
  • Develop and archive documentation of activities and processes

Application Support and Administration

  • Administer and support all technical activities related to IC3 operations and projects
  • Ensure newly developed applications are thoroughly tested prior to production deployment
  • Troubleshoot existing Java based applications deployed on Apache Tomcat web servers
  • Investigate, test, document, and support all new software required for IC3 operations and projects
  • Support and maintain staff computers and associated office equipment
  • Maintain organizational knowledgebase and ensure proper archiving and secure storage of all documentation related to IC3 processes, policies, and practices

Qualifications

  • University degree in computer science or engineering, or equivalent industry experience required
  • Demonstrated experience working as a Linux systems administrator
  • Demonstrated experience  working with Enterprise grade database systems, such as PostgreSQL
  • Experience with VM creation and management using Hyper-V or VMware
  • Experience with Apache Tomcat configuration and application deployment
  • Experience with OS-level virtualization tools, such as Docker
  • Experience with issue tracking tools, like Jira
  • Experience supporting a Windows office environment
  • Excellent shell scripting and automation skills
  • Strong understanding of SQL and RDBMS topics
  • Familiarity with procedural programming languages, like Postgres PL/pgSQL
  • Familiarity with NoSQL storage paradigms, such as MongoDB
  • Familiarity with web technologies and formats, like Drupal, JavaScript, JSON, XML, HTML, CSS
  • Strong understanding of server hardware components and ability to assemble hardware
  • Strong investigative skills with the ability to identify and diagnose complex technical problems
  • Strong organizational skills coupled with proven ability to effectively document work, handle multiple tasks, meet deadlines, and excel in a fast-paced environment characterized by changing priorities
  • Demonstrated ability to thrive in and contribute to an integrated and collaborative team environment, along with the ability to apply a positive team approach to working with colleagues
  • Demonstrated level of competence, discretion, and professionalism appropriate for interacting articulately and persuasively with a wide range of stakeholders
  • Excellent written and oral communication skills

Vaccination Requirement Statement

Effective May 1, 2022, the University suspended its Vaccination Requirement. Prior to May 1, pursuant to this Requirement, all University employees were required to submit proof of full vaccination against COVID-19 (subject to the University’s obligations under the Human Rights Code to accommodate employees who were unable to receive a vaccination). The University’s Vaccination Requirement website can be found here: https://uwaterloo.ca/coronavirus/return/vaccination-requirement.

 

The pandemic is ongoing and public health advice continues to evolve. Accordingly, the University reserves the absolute right to reinstate the Vaccination Requirement on short notice, and upon such reinstatement you will be required to comply. You shall also be required to comply with any new health and safety policies/requirements implemented by the University from time to time, including new policies/requirements related to mandatory employee vaccination. As the University may need to reinstate the Requirement on short notice, it will continue to collect and maintain up-to-date information on employee vaccination status. Please submit your Covid-19 vaccine status (QR code) to: https://checkin.uwaterloo.ca/

 

Failure to comply with the Vaccination Requirement if it is reinstated, including failure to comply with any future amendments to the Vaccination Requirement, or failure to comply with new health and safety policies/requirements implemented by the University, including those related to new mandatory employee vaccination, shall result in discipline up to and including termination of employment.

 

The requirement to be vaccinated, if reinstated, will be subject to the duty to accommodate pursuant to the Human Rights Code. If you are unable to be vaccinated for reasons related to a ground protected under the Human Rights Code, you may submit a written request for accommodation with an explanation of the reasons and/or any supporting documentation. If you request accommodation, the University may follow up with you for further information if necessary.

Equity Statement

The University of Waterloo is committed to implementing the Calls to Action framed by the Truth and Reconciliation Commission. We acknowledge that we live and work on the traditional territory of the Neutral, Anishinaabeg and Haudenosaunee peoples. The University of Waterloo is situated on the Haldimand Tract, the land granted to the Six Nations that includes six miles on each side of the Grand River.

 

The University values the diverse and intersectional identities of its students, faculty, and staff. The University regards equity and diversity as an integral part of academic excellence and is committed to accessibility for all employees. The University of Waterloo seeks applicants who embrace our values of equity, anti-racism and inclusion.  As such, we encourage applications from candidates who have been historically disadvantaged and marginalized, including applicants who identify as First Nations, Métis and/or Inuit/Inuk, Black, racialized, a person with a disability, women and/or 2SLGBTQ+.

 

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

 

The University of Waterloo is committed to accessibility for persons with disabilities. If you have any application, interview, or workplace accommodation requests, please contact Human Resources at hrhelp@uwaterloo.ca or 519-888-4567, ext. 45935.

Options

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