Database Team Lead

4 weeks ago

Ottawa, 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,
- Best-in-class 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 high-level 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 long-term 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 semi-annual and annual disaster recovery testing with a cross-functional 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 multi-node clustered Microsoft SQL Server Database platforms.
- At least 3-5 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 entry-relationship 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 third-party 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/time-management/prioritization skills
- Established leadership skills (teams, projects)
- Attention to detail.

**Mandatory Requirements**
- Fluency (verbal and written) in English.
- Ability to participate in the following on-call 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

  • Database Team Lead

    1 week ago

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

    Internal Job Title:Database Team LeadJob Type:Permanent Full-TimeLocation: 18 Auriga Dr, Ottawa ONWork Model:HybridPosition SummaryAs 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...

  • Program Lead, Clinical Administrative Databases

    4 weeks ago

    Ottawa, Canada Canadian Institute for Health Information Full time

    **Category** - Health Information Management **City** - 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, not-for-profit...

  • Program Lead, Clinical Administrative Databases

    7 days 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...

  • Merchandiser Retail Team Lead Canada NE PT

    1 week ago

    Ottawa, Canada Team Relax Full time

    Merchandiser Retail Team Lead Canada NE PT Ottawa , Ontario Apply Now SAS Retail Services Canada is currently hiring for a Merchandising Team Lead- Part Time (PT) for grocery relines/resets execution.What We Offer:$18/h pay.Availability: Monday Through Thursday Mornings/Days.Flexible ScheduleWhat You’ll Do:Resets/relines- reading and executing...

  • Membership Services, Team Lead

    4 weeks ago

    Ottawa, Canada Canadian Bar Association Full time

    **Position Summary** Reporting to the Manager, Membership Services, the Membership Services Lead is someone who provides guidance, and leadership to a group of people within the unit. The Team Lead relays clear instructions to a team member and provides ongoing coaching, training, and assistance in support of the membership initiatives. The incumbent is...

  • Membership Services, Team Lead

    2 weeks ago

    Ottawa, Canada Canadian Bar Association Full time

    **Position Summary** Reporting to the Manager, Membership Services, the Membership Services Team Lead is someone who provides guidance, and leadership to a group of people within the unit. The Team Lead relays clear instructions to a team member and provides ongoing coaching, training, and assistance in support of the membership initiatives. The incumbent...

  • Database Administrator

    2 hours ago

    Ottawa, Canada Telesat Full time

    Our Purpose Core Values Life at Telesat Benefits Early Career Menu Jobs List Our Purpose Core Values Life at Telesat Benefits Early Career Return to Jobs List Database Administrator Telesat (NASDAQ and TSX: TSAT) is a leading global satellite operator, providing reliable and secure satellite-delivered communications solutions worldwide...

  • Health Promotion Team Lead

    1 week ago

    Ottawa, Canada Wabano Centre for Aboriginal Health Full time

    Full time, Permanent **Context**: The Wabano Centre for Aboriginal Health is an award-winning Health Access Centre that provides holistic health services to First Nation, Inuit, and Métis people living in Ottawa. We are a fast-paced, client-oriented organization that models the Indigenous values of balance, respect, and community interdependence. We are...

  • database analyst

    1 week ago

    Ottawa, Canada 8084947 CANADA INCORPORATED Full time

    Education: Bachelor's degreeExperience: 2 years to less than 3 yearsTasksDesign 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...

  • database analyst

    7 days 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...

  • database analyst

    1 week ago

    Ottawa, 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 Import Analyst

    4 weeks ago

    Ottawa, Canada Willson International Ltd. Full time

    **Nature & Scope of Position** The Team Lead will be responsible for monitoring the production of their team. They will confirm and release entries and ensure entry quality. They will be the lead for general client and employee matters. The team lead will work closely with the Shift Supervisor and Branch Manager to ensure the success of Canadian Branch...

  • Membership Services, Team Lead Ii

    3 weeks ago

    Ottawa, Canada Canadian Bar Association Full time

    **Position Summary** Reporting to the Manager, Membership Services, the Membership Services Lead is someone who provides guidance, and leadership to a group of people within the unit. The Team Lead relays clear instructions to a team member and provides ongoing coaching, training, and assistance in support of the membership initiatives. The incumbent is...

  • Team Lead, Software Development

    7 days 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...

  • Team Lead, Software Development

    3 weeks ago

    Ottawa, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is growing at a fast pace and we’re looking for a passionate Development Team Lead to help us lead, mentor, and grow a high-performing software development team and cultivate an inclusive...

  • Team Lead, Software Development

    3 weeks ago

    Ottawa, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is growing at a fast pace and we’re looking for a passionate Development Team Lead to help us lead, mentor, and grow a high-performing software development team and cultivate an inclusive...

  • Team Lead, Software Development

    2 months ago

    Ottawa, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is growing at a fast pace and we’re looking for a passionate Development Team Lead to help us lead, mentor, and grow a high-performing software development team and cultivate an inclusive...

  • Team Lead, Software Development

    2 months ago

    Ottawa, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is growing at a fast pace and we’re looking for a passionate Development Team Lead to help us lead, mentor, and grow a high-performing software development team and cultivate an inclusive...

  • Team Lead, Software Development

    2 months ago

    Ottawa, Canada Lightspeed Commerce Full time

    Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is growing at a fast pace and we’re looking for a passionate Development Team Lead to help us lead, mentor, and grow a high-performing software development team and cultivate an inclusive...

  • Database and Stewardship Officer

    3 weeks ago

    Ottawa, Canada Cornerstone Housing for Women Full time

    **MISSION STATEMENT** Cornerstone Housing for Women provides safe supportive housing and emergency shelter to vulnerably housed women and women experiencing homelessness in Ottawa. Cornerstone is committed to providing these services in a way that offers residents dignity and a sense of hope. At Cornerstone Housing for Women, you'll be proud of the work...