Systems DBA - Lottery Group chez Canadian Bank Note Company

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.

Internal Job Title: Systems DBA

Job Type: Permanent, Full-time

Job Location: Ottawa, ON

Work Model: Hybrid

Position Summary

As a Systems DBA within our Lottery Development Group, you will play a key role in supporting the reliability, scalability, and performance of PostgreSQL and MariaDB environments across both on-premises and cloud deployments. You will be responsible for implementing high availability (HA) and disaster recovery (DR) strategies, automating infrastructure tasks, building RPMs, managing repositories, and contributing to CI/CD pipelines.

Responsibilities

Database Administration and Reliability

• Administer and maintain PostgreSQL and MariaDB systems across on-prem and Azure cloud environments.
• Design and implement HA and DR strategies, including replication, failover, and backup solutions.
• Monitor system and database performance using tools like Prometheus, Grafana, and pg_stat_statements.
• Troubleshoot and resolve performance and reliability issues.
• Ensure system and data security, compliance, and documentation standards are met.

Infrastructure Automation and Packaging

• Build and manage RPM packages and maintain internal repositories for database components.
• Develop and maintain CI/CD pipelines for database infrastructure and configuration automation.

Collaboration and Agile Delivery

• Collaborate with DevOps and Development teams to ensure seamless integration and deployment.
• Create and maintain documentation for database system configurations, processes, and procedures.
• Contribute to Agile development cycles through planning, reviews, and team coordination.

Education and Knowledge

• Bachelor’s degree in Computer Science (or related field) or an equivalent combination of relevant education and additional relevant work experience.
• Knowledge of the following:
  • Linux systems, PostgreSQL and MariaDB architecture.
  • System and database performance monitoring and optimization tools.
  • RPM packaging and repository management.
  • High and disaster recovery strategies, including replication, failover, and backup solutions.
  • Security and compliance best practices for systems and data.
  • CI/CD practices and infrastructure automation.
  • Cloud infrastructure (Azure)

Experience

• 3+ years of experience in systems administration and/or database reliability engineering.
• Experience with PostgreSQL and/or MariaDB in both on-prem and cloud environments.
• Experience with building infrastructure and systems orchestration in a Linux environment.

Competencies and Soft Skills

• Critical thinking skills
  • Analysis, problem-solving skills
• Interpersonal skills
  • Communication abilities, teamwork and collaboration 
• Organization and time management skills
• Attention to detail
• Self-directed

Technical Environment

• Operating Systems: Linux
• Database Systems: PostgreSQL, MariaDB
• Containerization: Docker, Kubernetes
• Deployment: Puppet
• Scripting Languages: SQL, Python, Bash
• Tools: Git, GitLab, Prometheus, Grafana

Mandatory Requirements

• Language: Fluency in English (reading, writing, speaking)
• Work Hours: Ability to offer support outside of scheduled working hours
• Travel: Ability to travel internationally (passport required) as required

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.