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 recognize and reward our employees 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; very progressive fertility, adoption, and surrogacy benefits to support all definitions of family.
Job Description
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. 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
- Oversee installation, configuration, maintenance and daily administration of CBN database systems (predominantly Microsoft SQL Server, with some MySQL and Azure SQL instances).
- Ensure high availability, capacity, performance, scalability and disaster recovery readiness.
- 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 rollback strategy, and communications to stakeholders.
- Translate high‑level business requirements into data models.
- Exercise 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.
- 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 liaison with internal and external auditors during audits.
- Lead and coordinate cross‑functional teams in semi‑annual and annual disaster database and application recovery testing.
- Lead an initiative to modernize our on‑premise Microsoft SQL Server infrastructure to a cloud‑based database.
- Work with software development, infrastructure, data analytics and manufacturing business units to design, optimize and troubleshoot database‑related applications and systems.
- Develop and maintain comprehensive documentation for departmental processes, system configuration, disaster recovery plans and other related team documentation.
- Provide regular reports on database health, capacity planning and risk assessments.
Qualifications
University degree or college diploma in Computer Science, Information Technology, or related field.5+ years of relevant experience administering and supporting multi‑node clustered Microsoft SQL Server databases, 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 and data lake initiatives.1–2 years of experience in a team leadership role.Direct experience with migrating and / or managing Azure PaaS SQL Database platforms (SQL Database PaaS, Azure SQL Managed Instances) is a strong asset.Knowledge of 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 proficiency.DevOps practices and automation tools.Core Competencies
Critical thinking, analysis, problem‑solving.Interpersonal skills : communication, teamwork, collaboration, leadership.Organization and time‑management skills.Attention to detail, adaptability, initiative.Mandatory Requirements
Language : Fluency in English (reading, writing, speaking).Ability to work outside of standard business hours as required (4–8 times per year).Ability to participate in DBA team on‑call rotation.Security clearance : Ability to obtain and maintain Government of Canada Secret (Level II) clearance in a timely manner.Equal Employment Opportunity
Canadian Bank Note Company 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.
#J-18808-Ljbffr