Team Lead, Database Administrator
As a Database Team Lead in our Corporate IS group, you will oversee 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.
Responsibilities
- Oversee installation, configuration, maintenance and daily administration of CBN database systems (predominantly Microsoft SQL Server, with instances of MySQL, Azure SQL).
- 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 contribute to performance evaluations.
- Review and approve all database configuration changes, considering risk, scheduling, impact analysis, deployment and rollback strategy.
- Translate high‑level business requirements into data models; design and optimize schemas 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; ensure compliance with data governance, privacy regulations and audit readiness.
- Represent the database team to internal and external auditors during audits; lead semi‑annual and annual disaster recovery testing.
- Lead an initiative to modernize on‑premise Microsoft SQL Server infrastructure to 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 department processes, system configuration, disaster recovery plan and other related materials.
- 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.8+ years of experience administering and supporting multi‑node clustered Microsoft SQL Server platform, including schema management, index optimization, SQL optimization, hardening, clustering, backup, recovery and disaster recovery.3–5 years of experience designing and implementing enterprise data models, data warehouses and data lakes.1–2 years of team‑leadership experience.Direct experience with migrating and / or managing Azure‑PaaS SQL Database platforms (SQL Database PaaS, Azure SQL Managed Instances) is a strong asset.Strong expertise in data modeling, schema design and optimization for databases, warehouses and data lakes.Experience developing ETL processes and data warehouse solutions.Knowledge of DevOps practices and automation tools.Fluency in English (reading, writing, speaking).Ability to work outside standard business hours for maintenance and disaster recovery testing; participate in DBA on‑call rotation.Security clearance : Ability to obtain and maintain Government of Canada Secret (Level II) clearance.Mandatory Requirements
Fluency in English (reading, writing, speaking).Ability to work outside standard business hours as required (typically 4–8 times per year).Ability to participate in DBA team on‑call rotation (approximately 6 after‑hour calls per year).Ability to obtain and maintain Government of Canada Secret (Level II) clearance.Benefits
Industry‑leading defined contribution pension plan with company matching contributions up to 5%.Best‑in‑class health, medical and life insurance benefits.Access to virtual and telehealth services.Progressive fertility, adoption and surrogacy benefits.Equal Opportunity Statement
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. Our commitment extends to all aspects of employment, including recruitment, hiring, promotion, compensation, benefits, training and development. We welcome applicants from all backgrounds and encourage accommodations during the selection process.
#J-18808-Ljbffr