Internal Job Title : Operations Analyst/Database Administrator

　　Job Type: Permanent, Full-time

　　Location: Sault Ste. Marie, ON

　　Work Model: Hybrid or Remote

　　Deadline for Submissions: January 22nd, 2024

　　Position Summary

　　As a n Operations Analyst/Database Administrator in our Lottery and Gaming division you will have the opportunity to broaden your skill set as you work to support our custom applications that are deployed across countries and governments throughout North America, the Caribbean and South America . You’ll also be in touch with our customers on a regular basis and you’ll be working with people of both technical and non-technical backgrounds. You’ll be part of a team that allows charitable organizations, both locally and across North America, to raise funds in a secure, fair, and fun way.

　　What We Can Offer You

　　Compensation: We seek long term relationships with our employees and recognize and reward them with a competitive total compensation package that includes :

　　An industry leading defined contribution pension plan with company matching contributions (up to 5%) and payment of service fees,

　　B est-in-class health , medical and life insurance benefits ;

　　Access to virtual and telehealth services and apps; and

　　Very progressive fertility, adoption and surrogacy benefits to support all definitions of family .

　　Career: A s a knowledge-based organization we will provide you with a wealth of learning opportunities and challenging work that will grow your knowledge, skills and abilities. At CBN, we encourage and empower our employees to chart their own career path, putting you in control of your future .

　　Culture : Personal character is the foundation of our culture. CBN’s 7 Core Principles shape and guide our behaviours and underpin the sense of community you will experience at CBN. Equality, diversity and inclusivity are important to us as an organization, and we are committed to fostering and developing a work environment where every employee is treated with dignity and respect.

　　What You Will Do

　　Install and support a variety of database technologies, and m onitor database health and performance.

　　Analyze and promptly resolve system issues and o ptimize performance for enhanced system efficiency.

　　Conduct storage growth projections and capacity planning to accommodate future growth.

　　Develop SQL scripts for database changes associated with new software releases.

　　Collaborate with development teams to develop and deploy new solutions.

　　Manage security ensuring data confidentiality and d esign and manage backup strategies to ensure data integrity in a highly available environment.

　　Pe rform root-cause analysis and f ollow ITIL processes managing incidents, problems, and change requests

　　D evelop, maintain, and test disaster recovery and failure response procedures to ensure data availability and integrity.

　　Write and update a wide variety of technical documentation including implementation plans, architectural diagrams, policies, standards, and operating procedures .

　　Various o ther duties and responsibilities .

　　Qualifications

　　Knowledge and Experience

　　Post secondary education in Computer Science/Engineering or related field

　　Certifications in Microsoft SQL server or Postgre SQL is an asset

　　2+ years experience developing and/or administering MS SQL Server and PostgreSQL database systems in Windows and Linux environments

　　Experience in Lottery & Gaming sector is an asset

　　Scripting experience with Javascript , SQL, and/or Linux/Bash; Powershell is an asset

　　Skills and Abilities

　　Self-directed learner, continuously learning new technology

　　Attention to detail and dedication to providing a quality product

　　Strong verbal and written communication skills

　　Strong analytical and problem-solving skills

　　Ability to multi-task

　　A passion for helping people

　　Demonstrates good judgement

　　Mandatory Requirements

　　Ability to travel and valid passport

　　On-call evenings and weekends (rotation)

　　Ability to obtain and maintain required gaming and security clearances ( e.g. AGCO)

　　About Us

　　CBN designs and develops industry leading solutions for the following domains: Border Security, Civil Identity, Driver Identification and Vehicle Information, Currency and Excise Control, and Lottery and Charitable Gaming. To learn more, visit www.cbnco.com .

　　As an Equal Opportunity Employer, Canadian Bank Note Company, Limited is committed to achieving a skilled workforce that reflects the diversity of the Canadian population. We encourage applications from women, visible minorities, people with disabilities and Aboriginal people. Canadian Bank Note Company Limited is committed to developing inclusive, barrier-free selection processes and work environments. If contacted regarding this competition, please advise the interview coordinator of any accommodation measures you may require.