Job Description

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.

Internal Job Title:

Team Lead, Database Administrator

Job Type:

Permanent, Full-Time

Job Location:

18 Auriga Drive, Ottawa, ON

Work Model:

Hybrid

Position Summary

As a Database Team Lead in our Corporate IS group, you will be responsible for overseeing the design, implementation, and maintenance of enterprise database platforms, ensuring optimal performance, security, and data integrity. This leadership role combines technical expertise with team management, guiding database administrators in supporting mission-critical systems across on-premises and cloud environments. In this position you will collaborate with cross-functional teams to align database strategies with organizational goals, drive modernization initiatives such as cloud migration, and establish best practices for disaster recovery and compliance.

Responsibilities

Database Administration

Oversee installation, configuration, maintenance and daily administration of CBN database systems (predominantly on Microsoft SQL Server, with a few instances of MySQL, Azure SQL). Ensure high availability, capacity, performance, scalability, and disaster recovery readiness.

Leadership & Team Management

Lead and supervise the database team fostering collaboration, coaching and continuous improvement. Assign tasks, monitor progress, and provide input to staff performance evaluations. Review and approve all Database configuration changes with consideration for risk, scheduling, impact analysis, deployment and roll back strategy and communications to stakeholders.

Database Design & Performance Optimization

Translate high-level business requirements into data models. Strong expertise in data modeling, schema design and optimization for databases, warehouses and data lakes. Monitor database performance and implement tuning strategies. Develop and enforce standards for query optimization and indexing. Design and implement ETL processes from various sources into the organization's data systems.

Security & Compliance

Continuously review, implement and improve security, availability, capacity planning, and disaster recovery measures and processes. Ensure compliance with data governance, privacy regulations, and audit readiness. Represent the database team in liaising with internal and external auditors during the course of various and frequent audits. Lead and coordinate a cross function team in the semi-annual and annual disaster database and application recovery testing.

Project & Stakeholder Collaboration

Lead an initiative to modernize our on-premise Microsoft SQL Server infrastructure to cloud based database. Work with software development teams, infrastructure teams, data analytics teams and manufacturing business units to design, optimize and troubleshoot database related applications and systems.

Documentation & Reporting

Develop and maintain comprehensive documentation for dept processes, system configuration documentation, disaster recovery plan and other related team documentation material. Provide regular reports on database health, capacity planning, and risk assessments.

Qualifications

Education and Knowledge

University degree or College diploma in Computer Science, Information Technology, or related field. Knowledge of the following: + Clustered SQL Server platform administration (schema management, troubleshooting, performance tuning, hardening, clustering, backup/recovery, disaster recovery)
+ Enterprise data model design and implementation (data warehousing, data lakes)
+ SQL and T-SQL
+ DevOps practices and automation tools

Experience

5+ years of relevant experience administering and supporting multi-node clustered Microsoft SQL Server Database platform including schema management, index optimization, SQL optimization, DBMS hardening, clustering, backup/recovery methods and disaster recovery. 3-5 years of relevant experience in design and implementation of data models for enterprise database, data warehouse, data lake initiatives. 1-2 years experience in a team leadership role. Direct experience with migrating and/or managing Azure Premised SQL Database platforms (SQL Database PaaS, Azure SQL Managed Instances) would be a strong asset.

Core Competencies

Critical thinking skills + Analysis, problem solving
Interpersonal skills + Communication, teamwork and collaboration, leadership
Organization and time management skills Attention to detail Adaptable Initiative

Mandatory Requirements

Language

: Fluency in English (reading, writing, speaking)

Work Hours:

+ Ability to work outside of standard business hours as required (e.g. DB system maintenance and/or disaster recovery testing activities) - typically 4-8 times/year;
+ Ability to participate in DBA team on-call rotation - DBA team typically receives <6 after-hour calls/year

Security Clearance

: Ability to obtain (in a timely manner) and maintain Government of Canada Secret (Level II) clearance

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.