Database Team Lead

1 week ago

Ottawa, Ontario, Canada Canadian Bank Note Company, Limited Full time

Internal Job Title:
Database Team Lead

Job Type:
Permanent Full-Time

Location: 18 Auriga Dr, Ottawa ON

Work Model:
Hybrid

Position Summary


As the Database Team Lead in our corporate Information Services department, you will be responsible for leading the daily management of corporate database platforms, including Microsoft SQL Server, MySQL, Azure SQL Database, and Azure SQL Managed Instance.

You'll play a key role in aligning CBN with modern database technologies, contribute to the design and migration to Azure Cloud, and ensure data accessibility, security, and integrity.


What We Can
Offer You
- **Compensation**: 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,
  • Bestinclass 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.
- **Career**: As a knowledge-based organization we will provide you with a wealth of learning opportunities and challenging work that will grow your knowledge, skills and abilities. At CBN, we encourage and empower our employees to chart their own career path, putting you in control of your future.
- **Culture**: Personal character is the foundation of our culture. CBN's 7 Core Principles shape and guide our behaviours and underpin the sense of community you will experience at CBN. Equality, diversity and inclusivity are important to us as an organization, and we are committed to fostering and developing a work environment where every employee is treated with dignity and respect.

What You Will Do

  • Lead the daily management of CBN's Corporate Database Platforms, encompassing Microsoft SQL Server, MySQL, Azure Cloud SQL Databases, and Azure SQL Managed Instance;
  • Translate highlevel business requirements into data models, metadata, test data, and data quality standards;
  • Design the structure and layout of data systems, including databases, warehouses, and lakes;
  • Implement database management systems, defining data schemas, optimizing data storage, and establishing access controls and security measures;
  • Develop and implement the longterm technology strategy and innovation roadmaps for analytics, data engineering, and data platforms;
  • Establish and maintain department standards, guidelines, processes, system documentation, and disaster recovery plans to ensure data quality, integrity, and recoverability;
  • Design and implement ETL processes for various data sources and lead semiannual and annual disaster recovery testing with a crossfunctional team; and
  • Various other duties and responsibilities.

Qualifications

  • Education _and Experience_
  • College of University Degree in Computer Science, Data Science or related field, or equivalent combination of education and years of relevant work experience.
  • At least 5 years of relevant experience administering and supporting multinode clustered Microsoft SQL Server Database platforms.
  • At least 35 years of relevant experience in the design and implementation of data models for enterprise database, data warehouse, data lake initiatives.
  • Direct experience with migrating and/or managing Azure Premised Database platforms (SQL Database PaaS, Azure SQL Managed Instances)
  • Experience leading projects involving data warehousing, data modeling, and data analysis.
  • Strong understanding of database administration best practices (ie. Schema management, index optimization, DBMS hardening, backup/recovery methods, disaster recovery).
  • Understanding of entryrelationship modeling, metadata systems, and data quality tools and techniques.
  • Technical Skills_
  • Troubleshooting and optimizing SQL and database performance and health issues, including using database counters and statistics and other thirdparty monitoring tools.
  • Adept in SQL/T-SQL and able to assist developers with the review and optimization of SQL.
  • Business intelligence tools and technologies such as ETL, PowerBI, etc.
  • Soft _Skills _and Abilities_
  • Excellent organization/timemanagement/prioritization skills
  • Established leadership skills (teams, projects)
  • Attention to detail.

Mandatory Requirements

  • Fluency (verbal and written) in English.
  • Ability to participate in the following oncall rotation: Approx. 1 week on/1 week off

Security Clearance Requirements

  • Ability to obtain and maintain a Government of Canada Secret (Level II) personal security clearance.
**About Us

  • Program Lead, Clinical Administrative Databases

    1 week ago

    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    Category Health Information ManagementCity Ottawa, Toronto, Ontario, Canada Program Lead, Clinical Administrative Databases Operations Who we are We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, notforprofit organization and...

  • Database Administrator

    18 hours ago

    Ottawa, Ontario, Canada Telesat Canada Full time

    Telesat (NASDAQ and TSX: TSAT) is a leading global satellite operator, providing reliable and secure satellite-delivered communications solutions worldwide to broadcast, telecommunications, corporate and government customers for over 50 years. Backed by a legacy of engineering excellence, reliability and industry-leading customer service, Telesat has grown...

  • database analyst

    1 week ago

    Ottawa, Ontario, Canada 8084947 CANADA INCORPORATED Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesLead and co-ordinate teams of data administrators in...

  • Team Lead, Software Development

    1 week ago

    Ottawa, Ontario, Canada Lightspeed Commerce Full time

    Growing Opportunity for a Development Team Lead at LightspeedIf you're on the lookout for a fresh career move or simply exploring your options, you're in the right spot. Lightspeed is on a rapid growth trajectory and currently seeks a dedicated Development Team Lead to steer, mentor, and nurture a top-notch software development team. The goal is to foster an...

  • Database Administrator

    1 week ago

    Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time

    Company DescriptionOur culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to...

  • Administrative Team Lead

    1 week ago

    Ottawa, Ontario, Canada dentalcorp Full time

    About us:Conveniently located near Hog's Back Falls, Hog's Back Dental Centre has been providing dental services to the Central Ottawa community for over 40 years. Our dentists, Dr. Levi and Dr. Modi, offers a wide range of dental services for the whole family, including general dentistry, cosmetic, sedation, extractions, and Invisalign.We pride ourselves on...

  • Software Engineer Team Lead

    1 week ago

    Ottawa, Ontario, Canada SpryPoint Services Inc. Full time

    Nova Scotia / Charlottetown, PEI / Halifax / New Brunswick / Newfoundland / Ontario / Ottawa / Prince Edward Island Simply put, SpryPoint provides Smart Solutions for Smart Utilities. Founded in 2011, SpryPoint is a leading provider of cloud-based solutions for the utility sector. Our team of experts has extensive experience serving utilities across North...

  • Team Lead

    2 months ago

    Ottawa, Ontario, Canada Healthy Planet Full time

    Team LeadWe're looking for a dynamic Team Lead Health Consultant who embodies awesomeness and knows how to lead by example. You bring a strong background in retail sales, leadership and a passion for natural wellness to the team.Our dynamic and talented Team Lead Health Consultants leverage their leadership skills, retail sales background and passion for...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada Healthy Planet Full time

    Team LeadWe're looking for a dynamic Team Lead Health Consultant who embodies awesomeness and knows how to lead by example. You bring a strong background in retail sales, leadership and a passion for natural wellness to the team.Our dynamic and talented Team Lead Health Consultants leverage their leadership skills, retail sales background and passion for...

  • Intermediate Database Administrator

    1 week ago

    Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time

    Company DescriptionOur culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead Tanger Outlets - Store 371, 8555 Campeau Dr Unit 850, Ottawa, Ontario, Canada Req #191 Sunday, March 17, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the Team Lead...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead Westboro - Store 183, 348A Richmond Rd, Ottawa, Ontario, Canada Req #179 Sunday, May 19, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the Team Lead provides...

  • Team Lead

    1 month ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead Tanger Outlets - Store 371, 8555 Campeau Dr Unit 850, Ottawa, Ontario, Canada Req #191 Sunday, March 17, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the Team Lead...

  • Team Lead

    1 month ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead St.Laurent Shopping Centre - Store 164, 1200 St. Laurent Blvd., Ottawa, Ontario, Canada Req #175 Sunday, March 17, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead St.Laurent Shopping Centre - Store 164, 1200 St. Laurent Blvd., Ottawa, Ontario, Canada Req #175 Sunday, March 17, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada Roots Full time

    Team Lead Westboro - Store 183, 348A Richmond Rd, Ottawa, Ontario, Canada Req #179 Sunday, May 19, WHAT WE'RE LOOKING FOR? The Team Lead links the leadership team and the sales associates by assisting in the operational functions of the store, and motivating the team to exceed goals. Reporting directly to the Store Manager, the Team Lead provides...

  • Team Lead

    1 week ago

    Ottawa, Ontario, Canada Reitmans Full time

    Company DescriptionWith over 230 stores across the country, Reitmans is leading Canadian women's fashion by championing self-acceptance and inclusivity to a growing and loyal customer base. We know great fashion fits great women, and not the other way around. Our strength lies in our people, so join a creative, welcoming, and socially-minded brand for a job...

  • Team Lead

    1 week ago

    Ottawa, Ontario, Canada Ottawa-Carleton District School Board Full time

    We are seeking a dynamic, committed IT professional to join our team:Team Lead - Security and IdentityBusiness and Learning Technologies Dept.Salary Range: $73,757 to $95,176Reporting to the Team Manager for Security and Identity, the Team Lead is responsible for ensuring the goals and plans of the Security and Identity Division are achieved in such a way...

  • Database Analyst

    1 week ago

    Ottawa, Ontario, Canada The Royal Ottawa Mental Health Centre Full time

    Position InformationPosting Number: ROM23054ETitle: Database Analyst (TFT 1.0 FTE)Position Status: Temporary FulltimeContract End Date: 03/31/2024FTE: 1.0Job Schedule: DaysDepartment: Data & AnalyticsUnion: NonunionSite: Royal Ottawa Mental Health CentreAbout The Royal As one of Canada's foremost mental health care and academic health science centres, The...

  • Team Lead

    4 weeks ago

    Ottawa, Ontario, Canada exp Full time

    Team Lead - Environmental Project Manager Ottawa or Kingston, ON At EXP, we're driven to provide innovative solutions for the world's built and natural environments. As a team of engineers, architects, designers, scientists, creators and a community of professionals, we bring diverse and talented people together to solve the world's most complex challenges....