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
Il y a plus de 30 jours
Type de contrat
  • Temps plein
  • Permanent
Description de poste

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

    Créer une alerte emploi pour cette recherche

    Team Lead • Ottawa, Ontario, Canada

    Offres similaires
    Oracle Cloud Senior Technical Lead

    Oracle Cloud Senior Technical Lead

    ArcLight Consulting • gatineau, qc, ca
    Temps plein
    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 ...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Contract Senior Tech Architect - Private Cloud Lead

    Contract Senior Tech Architect - Private Cloud Lead

    Dls Technology Corporation • Ottawa
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 18 jours • Offre sponsorisée
    System Administrator Technical Lead

    System Administrator Technical Lead

    Rebel • Ottawa, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Lead Clinical Data Manager

    Senior Lead Clinical Data Manager

    Warman O'Brien • ottawa, on, ca
    Permanent
    Senior Lead Clinical Data Manager – Top CRO – Fully Remote – Permanent.My client is a global CRO who have revolutionized the field of data science and are rapidly expanding their data management te...Voir plus
    Dernière mise à jour : il y a 6 heures • Offre sponsorisée • Nouvelle offre
    Oracle OCM Senior Consulting Manager - Codex

    Oracle OCM Senior Consulting Manager - Codex

    Codex • ottawa, on, ca
    Temps plein
    Oracle OCM Senior Consulting Manager.Join a global consulting team that helps organizations reimagine the way they work, innovate, and grow. As a Senior Manager of Organizational Change & Transforma...Voir plus
    Dernière mise à jour : il y a 6 heures • Offre sponsorisée • Nouvelle offre
    Lean Six Sigma Black Belt — Drive Operational Excellence

    Lean Six Sigma Black Belt — Drive Operational Excellence

    Avanti Software Inc. • Ottawa
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a 18 jours • Offre sponsorisée
    Senior Oracle Fusion Maintenance Lead

    Senior Oracle Fusion Maintenance Lead

    EY • Ottawa
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 18 jours • Offre sponsorisée
    Data Security Compliance Lead : PKI & Audits

    Data Security Compliance Lead : PKI & Audits

    Entrust Datacard • Ottawa
    Temps plein
    A leading security solutions provider in Canada is seeking an experienced individual to join their Data Security Services compliance team. You will oversee compliance processes, facilitate audits, a...Voir plus
    Dernière mise à jour : il y a 18 jours • Offre sponsorisée
    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    Oracle Cloud Senior Technical Lead - ArcLight Consulting

    ArcLight Consulting • gatineau, qc, ca
    Temps plein
    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 ...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Systems DBA - Lottery Group

    Systems DBA - Lottery Group

    Canadian Bank Note Company • Nepean, ON, Canada
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    BPA Team Lead - Hybrid Ottawa : Automation & Impact

    BPA Team Lead - Hybrid Ottawa : Automation & Impact

    Thales • Ottawa
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 4 jours • Offre sponsorisée
    Oracle Cloud Senior Technical Lead - ottawa

    Oracle Cloud Senior Technical Lead - ottawa

    ArcLight Consulting • ottawa, on, ca
    Temps plein
    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 ...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Administrateur de base de données (DBA)

    Administrateur de base de données (DBA)

    Exposant 3 • Gatineau, Quebec, .CA
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours
    Retail Technology Transformation Lead

    Retail Technology Transformation Lead

    EY • Ottawa
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 4 jours • Offre sponsorisée
    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....Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior BA for COTS Implementations (Hybrid Ottawa)

    Senior BA for COTS Implementations (Hybrid Ottawa)

    Altis Technology • Ottawa
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 8 jours • Offre sponsorisée
    Business Process Automation Team Lead

    Business Process Automation Team Lead

    Thales Group • Ottawa
    Temps plein
    Business Process Automation Team Lead page is loaded## Business Process Automation Team Leadremote type : Hybridlocations : Ottawatime type : Full timeposted on : Posted Todayjob requisition id...Voir plus
    Dernière mise à jour : il y a 18 jours • Offre sponsorisée