Database Administrator

Job Description

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 an 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, Best-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: As 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 monitor database health and performance. Analyze and promptly resolve system issues and optimize 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 design and manage backup strategies to ensure data integrity in a highly available environment. Perform root-cause analysis and follow ITIL processes managing incidents, problems, and change requests Develop, 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 other duties and responsibilities. Qualifications Knowledge and Experience Post secondary education in Computer Science/Engineering or related field Certifications in Microsoft SQL server or PostgreSQL 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.