Database Team Lead & Administrator

Job title:

Database Team Lead & Administrator

Company

Canadian Bank Note Company

Job description

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;
• Collaborate with software development and systems management teams for system design, performance optimization, and troubleshooting related to database applications;
• 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

CBN designs and develops industry leading solutions for the following domains: Border Security, Civil Identity, Driver Identification and Vehicle Information, Currency and Excise Control, and Lottery and Charitable Gaming. To learn more, visit .

As an Equal Opportunity Employer, Canadian Bank Note Company, Limited is committed to achieving a skilled workforce that reflects the diversity of the Canadian population. We encourage applications from women, visible minorities, people with disabilities and Aboriginal people. Canadian Bank Note Company Limited is committed to developing inclusive, barrier-free selection processes and work environments. If contacted regarding this competition, please advise the interview coordinator of any accommodation measures you may require.

Expected salary

Location

Ottawa, ON

Job date

Wed, 10 Jan 2024 04:59:48 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (un-jobs.net) you saw this job posting.