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 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 organizations 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-SQLDevOps practices and automation toolsExperience
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 skillsAnalysis problem solving
Interpersonal skillsCommunication teamwork and collaboration leadership
Organization and time management skillsAttention to detailAdaptableInitiativeMandatory 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 receivesSecurity Clearance : Ability to obtain (in a timely manner) and maintain Government of Canada Secret (Level II) clearanceAdditional 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.
Remote Work : No
Employment Type : Full-time
Key Skills
Law Enforcement,ABB,Marine Biology,Filing,Automobile,AV
Experience : years
Vacancy : 1