Database Team Lead

5 months 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 Administrator

    3 months ago

    Ottawa, Canada Versaterm Full time

    **THE COMPANY** Versaterm is a Public Safety software company that has been in business for over 45 years. We provide industry-leading products in mission-critical areas for all areas of public safety including Police, Fire and EMS agencies across North America. Versaterm's FivePoint Solutions focuses on delivering solutions to state and local agencies,...

  • Program Lead, Clinical Administrative Databases

    5 months 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...

  • Database Architect

    3 weeks ago

    Ottawa, Ontario, Canada Canadian Bank Note Full time

    Database Developer Job DescriptionAbout the RoleWe are seeking a highly skilled Database Developer to join our team at Canadian Bank Note Company Limited. As a key member of our Lottery Systems R&D team, you will design, build, and maintain data pipelines, manage database systems, and preprocess data for analysis.Key ResponsibilitiesDesign and develop data...

  • Database System Specialist

    3 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    We are seeking a skilled Database System Specialist to join our team at SEAMS DATA. The ideal candidate will have experience in designing, developing, and maintaining databases to support our business operations.ResponsibilitiesDesign and develop databases to meet business needsOperate database management systems to analyze dataDevelop and implement data...

  • Database Architect

    4 weeks ago

    Ottawa, Ontario, Canada NAV Canada Full time

    Job Summary: As a highly skilled Database Administrator at NAV CANADA, you will play a critical role in designing and implementing national system changes and enhancements. With a strong background in database administration and a passion for innovation, you will be responsible for providing technical expertise and direction in one or more areas of...

  • Database Administrator

    5 months ago

    Ottawa, Canada Telesat 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

    6 months 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 Administrator

    1 month ago

    Ottawa, Canada NAV CANADA Full time

    Description What NAV CANADA offers you:   Challenging, team-oriented work environment  Competitive compensation and flexible benefits  Defined benefit pension plan  Opportunities for growth and development  Flexible work arrangements  Diverse and inclusive workforce  Key Accountabilities:    Provide technical / operational expertise...

  • database analyst

    6 months 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...

  • Database Administrator

    5 months 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...

  • Database Engineer

    1 month ago

    Ottawa, Ontario, Canada Telesat Full time

    Database Engineer Job DescriptionAt Telesat, we are seeking a skilled Database Engineer to join our Platform Engineering team. In this role, you will be responsible for providing supporting capabilities for the design and deployment of various Cloud-based and on-premise databases.Main ResponsibilitiesDevelop and implement data administration policies,...

  • Database Developer

    3 months ago

    Ottawa, Canada Canadian Bank Note Full time

    Description Internal Job Title: Database Developer Job Type: Permanent, Full-Time Location:18 Auriga Dr., Ottawa ON Work Model: Hybrid Position Summary As a Database Developer in our Lottery Systems R&D team, you will design, build, and maintain data pipelines, manage database systems, and preprocess data for analysis. You will also monitor and...

  • Database Systems Engineer

    2 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionWe are seeking a highly skilled Database Systems Engineer to join our team at SEAMS DATA.ResponsibilitiesDesign and develop database systems to meet the needs of our organization.Operate and manage database management systems to analyze complex data sets.Develop and implement data administration policies, standards, and models to ensure data...

  • Database Developer

    3 months ago

    Ottawa, Canada Canadian Bank Note Company, Limited Full time

    Internal Job Title: Database DeveloperJob Type: Permanent, Full-TimeLocation: 18 Auriga Dr., Ottawa ONWork Model: HybridPosition SummaryAs a Database Developer in our Lottery Systems R&D team, you will design, build, and maintain data pipelines, manage database systems, and preprocess data for analysis. You will also monitor and resolve performance issues...

  • Database Analysts and Data Administrators

    5 months ago

    Ottawa, Canada Studyincanada Full time

    Database Analysts and Data AdministratorsDatabase analysts design, develop, and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards, and models.Duties May IncludeCollect and document user requirementsDesign and develop database architecture for information...

  • Database and Stewardship Officer

    6 months 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...

  • AWS Database Engineer

    3 months ago

    Ottawa, Canada Canadian Bank Note Company, Limited Full time

    p>Internal Job Title: Database DeveloperJob Type: Permanent, Full-TimeLocation: 18 Auriga Dr., Ottawa ONWork Model: HybridPosition SummaryAs a Database Developer in our Lottery Systems R&D team, you will design, build, and maintain data pipelines, manage database systems, and preprocess data for analysis. You will also monitor and resolve performance issues...

  • Database Systems Engineer

    2 weeks ago

    Ottawa, Ontario, Canada Telesat Full time

    At Telesat, we are a leading global satellite operator providing reliable and secure satellite-delivered communications solutions worldwide to broadcast, telecommunications, corporate and government customers.We take pride in being an equal opportunity employer that values equality in the workplace. We offer competitive salaries, with this role having an...

  • Database Developer: Designing Data Pipelines and Database Systems

    3 weeks ago

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

    We are seeking a skilled Database Developer to join our Lottery Systems R&D team in Ottawa, ON.This role involves designing, building, and maintaining data pipelines using ETL, ELT, and streaming methodologies from various sources.The ideal candidate will have 3+ years of experience working in SQL, Bash or Python, and a strong understanding of database...

  • Database Systems Engineer

    6 days ago

    Ottawa, Ontario, Canada Canadian Bank Note Full time

    **About Us**Canadian Bank Note designs and develops industry-leading solutions for various domains, including lottery systems.We are seeking a highly skilled Database Systems Engineer to join our team.**Your Role**In this role, you will be responsible for designing, building, and maintaining data pipelines using ETL, ELT, and streaming methodologies from...