Company Description
Canadian Bank Note Company (CBN) is a trusted leader in secure technology solutions for governments and businesses worldwide. The company operates across various business domains, including currency production, border security, civil identity, driver identification and vehicle information, excise control, lottery and charitable gaming.
Our 7 Core Principles shape and guide our corporate behaviours and underpin the sense of community you will experience at CBN. We pride ourselves on fostering a supportive and collaborative work environment, where employees are valued for their contributions and encouraged to grow professionally.
At CBN 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.
Job Description
Internal Job Title: Database Support Specialist
Job Type: Permanent, Full-Time
Job Location: Ottawa, ON
Work Model: Hybrid
Position Summary
As a Database Support Specialist in our Lottery Systems R&D group, you will be responsible for the administration, maintenance, and optimization of database systems across development, QA, and production environments. This role ensures the reliability, performance, and security of databases by managing upgrades, backups, monitoring capacity, and supporting business intelligence platforms. The specialist collaborates closely with development, QA, and operations teams to implement database changes, fulfill reporting requests, and support software release cycles.
Responsibilities
Database Administration
Administer and maintain development and QA databases
Maintain backups of production databases
Develop archive procedures and maintain archives of production databases
Monitor database capacity and develop plans to accommodate anticipated future growth
Database Development & Deployment
Test and install database platform upgrades
Develop, maintain, package and install database configuration and database tools RPMs
Develop scripts for database changes associated with new software releases
Business Intelligence (BI) Platform Management
Test, package and install BI platform upgrade, customization, and tools RPMs
Perform BI platform administration tasks (manage users, cubes, subscriptions, etc.)
Performance & Reporting
Conduct database performance tests
Fulfill ad hoc query and report requests
Qualifications
Education and Knowledge
Bachelor's degree in Computer Science (or related field) or an equivalent combination of relevant education and/or additional work experience
Knowledge of the following:
Linux operating system
Database systems (relational databases, database architecture, backup and recovery)
Scripting and automation (scripting languages, SQL)
Performance monitoring and tuning (performance tools, capacity planning)
Software Development Lifecycle (Dev/Ops practices, version control, testing)
Business intelligence tools (asset)
Experience
2+ years of experience in database administration and support
Experience with administering databases in a Linux environment
Competencies and Soft Skills
Critical thinking skills
Analysis, problem solving
Interpersonal skills
Communication, teamwork and collaboration
Organization and time management skills
Self-directed
Growth mindset
Mandatory Requirements
Language: Fluency in English (reading, writing, oral)
Additional Information
Canadian Bank Note Company (CBN) is committed to fostering a diverse and inclusive workplace where all employees are treated with dignity and respect. We are proud to be an equal opportunity employer and do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other legally protected status.
We provide equal employment opportunities to all individuals, including women, Indigenous Peoples, persons with disabilities, visible minorities, and members of the 2SLGBTQ+ community. Our commitment to equity extends to all aspects of employment, including recruitment, hiring, promotion, compensation, benefits, training, and development. As part of our commitment to providing an inclusive, barrier free selection process, we ask that if you are contacted regarding the competition for this position, you advise the interview coordinator or any accommodation measures you may require.
At CBN, we value the unique perspectives and experiences that each employee brings to our organization, and we are committed to maintaining a workplace that reflects the diverse communities we serve. We believe that diversity and inclusion drive innovation and success, and we strive to create an environment where every employee can thrive and contribute to our collective goals.
