Talent.com
Team Lead, Database Administration Corporate IS Group
Team Lead, Database Administration Corporate IS GroupCanadian Bank Note Company • Ottawa, Ontario, Canada
Team Lead, Database Administration Corporate IS Group

Team Lead, Database Administration Corporate IS Group

Canadian Bank Note Company • Ottawa, Ontario, Canada
30+ days ago
Job type
  • Full-time
  • Permanent
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 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-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
  • 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.

    Remote Work : No

    Employment Type : Full-time

    Key Skills

    Law Enforcement,ABB,Marine Biology,Filing,Automobile,AV

    Experience : years

    Vacancy : 1

    Create a job alert for this search

    Team Lead • Ottawa, Ontario, Canada

    Similar jobs
    Senior Data Engineer

    Senior Data Engineer

    Systematix • Greater Ottawa Metropolitan Area, Canada
    Full-time
    We are Systematix and we are looking for a.The ideal candidate must already possess a security clearance at the Reliability level (Level I) or higher. The expected start date for this 1-year contrac...Show more
    Last updated: 18 days ago • Promoted
    Oracle Cloud Senior Technical Lead

    Oracle Cloud Senior Technical Lead

    ArcLight Consulting • gatineau, qc, ca
    Full-time
    ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment. For over 15 years, ArcLight experts have provided guidance ...Show more
    Last updated: 30+ days ago • Promoted
    Senior BI Analyst

    Senior BI Analyst

    Targeted Talent • Ottawa, ON, Canada
    Permanent
    We are looking for an experienced.Our client is a global enterprise company with a product that you've likely used.This is a really exciting opportunity to work for a company whose product is u...Show more
    Last updated: 30+ days ago • Promoted
    Contract Senior Tech Architect - Private Cloud Lead

    Contract Senior Tech Architect - Private Cloud Lead

    Dls Technology Corporation • Ottawa
    Full-time
    DLS Technology Corporation seeks a Senior Technology Architect to lead the design and integration of a secure private cloud infrastructure in Ottawa, Canada. This role demands a high-level expertise...Show more
    Last updated: 15 days ago • Promoted
    System Administrator Technical Lead

    System Administrator Technical Lead

    Rebel • Ottawa, ON, Canada
    Full-time
    Reports to : Director of Technology.We are seeking an accomplished system administrator leader with strong technical capabilities and a desire to make a difference to join our dynamic and agile tech...Show more
    Last updated: 30+ days ago • Promoted
    SAP Payroll (ECC) Lead

    SAP Payroll (ECC) Lead

    freelance.ca • Ottawa, Canada
    Full-time
    Key information / Informations clés.Work mode : Hybrid (local presence required) .The SAP Payroll (ECC) Lead is responsible for leading payroll consultants and providing quality assurance oversight ...Show more
    Last updated: 1 day ago • Promoted
    Lean Six Sigma Black Belt — Drive Operational Excellence

    Lean Six Sigma Black Belt — Drive Operational Excellence

    Avanti Software Inc. • Ottawa
    Full-time +1
    A leading medical supply company in Ottawa seeks a Lean Six Sigma Black Belt to drive process improvements and operational excellence. The successful candidate will lead projects, mentor team member...Show more
    Last updated: 15 days ago • Promoted
    Senior Oracle Fusion Maintenance Lead

    Senior Oracle Fusion Maintenance Lead

    EY • Ottawa
    Full-time
    A global professional services firm seeks a Senior Consultant or Manager in Ottawa for Oracle Fusion Supply Chain.Ideal candidates have 8-10 years' experience, with project management skills and Or...Show more
    Last updated: 15 days ago • Promoted
    Administrateur de base de données (DBA)

    Administrateur de base de données (DBA)

    freelance.ca • Gatineau, Canada
    Full-time
    Nous croyons fermement en une gestion saine et humaine, où la confiance, la compétence, et le plaisir de réussir ensemble sont au centre de nos valeurs. Nous vous offrons bien plus qu’un simple empl...Show more
    Last updated: 30+ days ago • Promoted
    Systems DBA - Lottery Group

    Systems DBA - Lottery Group

    Canadian Bank Note Company • Nepean, ON, Canada
    Full-time +1
    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...Show more
    Last updated: 30+ days ago • Promoted
    BPA Team Lead - Hybrid Ottawa : Automation & Impact

    BPA Team Lead - Hybrid Ottawa : Automation & Impact

    Thales • Ottawa
    Full-time
    A leading technology company in Ottawa is seeking a Business Process Automation Team Lead to oversee a team and drive the implementation of innovative automated solutions.The ideal candidate will h...Show more
    Last updated: 1 day ago • Promoted
    Oracle Cloud Senior Technical Lead - ottawa

    Oracle Cloud Senior Technical Lead - ottawa

    ArcLight Consulting • ottawa, on, ca
    Full-time
    ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment. For over 15 years, ArcLight experts have provided guidance ...Show more
    Last updated: 30+ days ago • Promoted
    Administrateur de base de données (DBA)

    Administrateur de base de données (DBA)

    Exposant 3 • Gatineau, Quebec, .CA
    Full-time
    Quick Apply
    Rejoignez Exposant 3 (E3) : La puissance de l’humain au cœur de la technologie !.Exposant 3 est une firme de services-conseils en gestion des affaires et technologies de l'information, dédiée à acc...Show more
    Last updated: 30+ days ago
    Retail Technology Transformation Lead

    Retail Technology Transformation Lead

    EY • Ottawa
    Full-time
    A global professional services firm in Canada is seeking a Retail Manager for their Technology Strategy Transformation team. In this full-time role, you will engage with leading retailers to address...Show more
    Last updated: 1 day ago • Promoted
    Database Administrator

    Database Administrator

    Targeted Talent • Ottawa, ON, Canada
    Permanent
    We are looking for an experienced.This is a permanent position that is remote to start with later relocation to.Our client is a global enterprise company with a product that you've likely used....Show more
    Last updated: 30+ days ago • Promoted
    Senior BA for COTS Implementations (Hybrid Ottawa)

    Senior BA for COTS Implementations (Hybrid Ottawa)

    Altis Technology • Ottawa
    Full-time
    A leading tech firm in Ottawa seeks a Business Analyst for a COTS Implementation Contract.You will optimize processes, align workflows with a COTS platform, and ensure business requirements are met...Show more
    Last updated: 6 days ago • Promoted
    Business Process Automation Team Lead

    Business Process Automation Team Lead

    Thales Group • Ottawa
    Full-time
    Business Process Automation Team Lead page is loaded## Business Process Automation Team Leadremote type : Hybridlocations : Ottawatime type : Full timeposted on : Posted Todayjob requisition id...Show more
    Last updated: 15 days ago • Promoted
    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    ArcLight Consulting • ottawa, on, ca
    Full-time
    ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment. For over 15 years, ArcLight experts have provided guidance ...Show more
    Last updated: 30+ days ago • Promoted