Senior Database Analyst / Database Administrator

We Have a Big Name – and a Big Mission

We’re the Canadian Centre for Occupational Health and Safety. But you can call us CCOHS.

We’re a federal government corporation that’s focused on a single mission: we believe everyone in Canada has the right to a healthy and safe workplace where they can thrive. Our tools and resources are designed to give employers and workers across the country the information they need to stay healthy and safe, both physically and mentally, on the job.

We need rock solid information technology infrastructure and platforms to get this important information into the hands of users. Without this in place, we wouldn’t be able to deliver the many courses, fact sheets, databases, podcasts, guides, and other tools that workplaces across Canada need – especially during this pandemic.

And that’s where you come in. You will play a role in analyzing and translating data requirements into functional database systems based on CCOHS data strategy and industry best practices. You’ll be part of our IT Digital Innovation and Development team to help make these plans a reality.

If you’re excited about helping to make a difference and being part of a culture that values innovation, professional growth, and your overall well-being, we definitely want you to read on.

About the Role
  • As a Senior Database Analyst/ Database Administrator you will be involved in CCOHS data strategy implementation and systems design to ensure compliance with federal government data strategies and policies. You’ll leverage the latest technology and industry standards to build high performance databases that support our products and services, and our external clients.
  • Reporting to the Manager, IT Digital Innovation and Development, you will conduct database administration functions such as user management, database monitoring, troubleshooting, database tuning, query optimization, database backup and recovery, as well as database systems updates, upgrades, and migration. You’ll review database changes, assess code, and make recommendations to ensure data security, integrity, privacy, performance, and scalability.
  • As a member of the IT Digital Innovation and Development team, you know how to work collaboratively with other database administrators to review existing database and data structures, and make recommendations on database design, data processes, and data integration. You’ll work with development teams to build database access application programming interfaces and modules to integrate multiple data sources through web services.

What You Have
  • A university degree in Computer Science, Information Systems or Mathematics, or college diploma with concentration in computer technology or an equivalent combination of education and experience.
  • 5+ years experience in MySQL database design and administration; extensive experience in MySQL user management, access control, data security, database performance monitoring and tuning, troubleshooting, database backup and recovery strategy, database upgrade and migration.
  • Experience in other RDBMS such as SQL Server or FileMaker is desired, and experience in setting up and managing MySQL or other databases in AWS RDS is preferred.
  • 5+ years working experience in Unix/Linux or AWS cloud environment and familiarity with Unix/Linux command lines or AWS RDS configurations.
  • Hands-on experience in writing SQL queries, Stored Procedures, Functions and Triggers, as well as analyzing and optimizing queries.
  • Thorough comprehension of highly scalable database architecture and experience in implementing database replication and database caching.
  • Experience in Redis or AWS cloud solutions is an asset.
  • Experience in developing APIs or data access modules using one of the following programming languages or frameworks: PHP, Python, NodeJS and Microsoft C#.
  • Experience in integrating multiple sources into a centralized data platform or Enterprise Data Warehouse is preferred; knowledge of NoSQL databases such as MongoDB is an asset.

Who You Are
  • A supportive, respectful team member who provides guidance, treats others equitably, and thrives in an environment where new ideas and collaboration are encouraged.
  • An IT professional with technical writing skills in documenting systems analysis, data flow, database processes and procedures.
  • An excellent communicator who connects well with stakeholders and clients.
  • An enthusiastic believer of providing exceptional, efficient service to internal and external clients in a clear manner.
  • A lifelong learner of leading IT best practices and the latest technology.

Job Description

IT-127 Senior Database Analyst / Database Administrator PDF [146 KB]

Salary

Within the range of

$93,133 to $112,855 (CCOHS-11) per annum.

Full-time, permanent, unionized position

Application Deadline

Tuesday, November 9, 2021

Quote File Reference Number: IT-127

Vacancies: 1

To Apply

If you are excited by this opportunity, we want to hear from you. Send us your application in confidence to ​jobs@ccohs.ca.

Attach resume as an MS Word or PDF document.

This competition is open to residents of Ontario only.

Notes

Here at CCOHS, we promote work-life balance, encourage personal development, and foster respect, civility, and inclusion. For more reasons why this is a great place to work and information on our comprehensive benefits and federal public service pension plan, visit our Careers page.

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please contact Human Resources at jobs@ccohs.ca. All information received in relation to accommodation will be kept confidential.

Note: Attaining Reliability Status Security Clearance is a condition of employment for all CCOHS positions. This position is temporarily remote – future travel to facilities may be required. All resumes are maintained confidential and are kept on file for a period of six months.

We thank all applicants for their interest, however only those selected for an interview will be contacted.