Team Lead, Database Administration

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: 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