Database Administrator

Canadian Bank Note Company; Ottawa; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company specializing in secure technology solutions is seeking a Database Administrator. This full-time position involves designing and deploying database solutions for government clients, ensuring database performance, security, and reliability. The ideal candidate will hold a Bachelor's degree in Computer Science and possess relevant certifications.

Benefits

Industry-leading defined contribution pension plan

Best-in-class health and life insurance benefits

Access to virtual and telehealth services

Progressive fertility and adoption benefits

Qualifications

• 4-7 years of experience in database administration.
• Oracle Certified Professional (OCP) is a plus.
• Strong analytical and problem-solving skills, excellent communication abilities.

Responsibilities

• Design, implement, and maintain database systems to meet organizational requirements.
• Monitor database performance, identify issues, and optimize performance.
• Develop and implement backup and recovery plans to protect data integrity.

Skills

Database management principles

Data modeling

SQL

Database security practices

Database tuning and optimization

Backup and recovery

Basic networking concepts

Education

Bachelor's degree in Computer Science

Tools

Oracle

PostgreSQL

Mongo DB

NoSQL (Elasticsearch)

SQL

Python

PowerShell

Bash

Ruby

Job description

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 production, border security, civil identity, driver identification and vehicle information, excise control, lottery and charitable gaming.

Our 7 Core Principles shape and guide our corporate behaviours and underpin the sense of community you will experience at CBN. We pride ourselves on fostering a supportive and collaborative work environment, where employees are valued for their contributions and encouraged to grow professionally.

At CBN 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.

Job Description

Internal Job Title : Database Administrator

Job Type : Permanent, Full-Time

Job Location : Ottawa, ON

Position Summary

As a Database Administrator (DBA) in our North American Service Delivery group, you will be responsible for designing, developing and deploying highly secure database solutions for our Canadian federal and provincial government customers. In this position, you will provide ongoing support and tune and optimize their performance to ensure they remain highly available, reliable, and secure.

Responsibilities

• Database Design and Implementation :

Design, implement, and maintain database systems to meet organizational requirements. Collaborate with System Architects to plan DBMS capacity and hardware requirements.

• Database Deployment :

Install and configure the production system locally in advance of shipment to customer site. Train and support Developers and Local Service Providers (LSPs).

• Database Migration :

Define database migration strategy and design replication topology and methodology. Develop migration procedures / scripts and perform the migration.

• Performance Monitoring and Tuning :

Monitor database performance, identify issues, and optimize database performance.

• Security Management :

Ensure database security by implementing access controls, encryption, and other security measures.

• Backup and Recovery :

Develop and implement backup and recovery plans to protect data integrity.

• Troubleshooting and Support :

Provide support for database-related issues, including troubleshooting and resolving problems.

• Documentation :

Create and maintain documentation for database configurations, schemas, changes, processes, and procedures.

Qualifications

Knowledge, Experience and Skills

• Education : Bachelor's degree in Computer Science, Information Technology (or a related field) or an equivalent combination of relevant education and work experience.
• Certifications : Oracle Certified Professional (OCP), Microsoft Certified : Azure Database Administrator Associate, or similar certifications are assets.
• Knowledge : Database management principles, data modeling, SQL, database security practices, database tuning and optimization, database backup and recovery, basic networking concepts including TCP / IP, DNS, DHCP, and network security practices.
• Experience : 4-7 years of experience in database administration.
• Soft Skills : Strong analytical and problem-solving skills, excellent communication abilities, attention to detail, and the ability to work independently and as part of a team.
• Competencies : Organizational skills, adaptability, a proactive approach to identifying and solving issues, and a strong sense of responsibility and accomplishment in completing tasks and achieving goals.

Technical Environment

• Database Management Systems : Oracle, PostgreSQL, Mongo DB, NoSQL (Elasticsearch)
• SQL and Scripting : SQL, Python, PowerShell, Bash, Ruby
• Security : Active Directory, Kerberos, LDAP, TLS, Bitlocker, LUKS

Mandatory Requirements

• Language(s) : Fluency in English (reading, writing, speaking)
• Work Hours : Ability to work on-call rotation (1 week on, 3 weeks off)
• Travel : Ability to travel domestically / internationally (passport required) approx. 2 weeks / year
• Security Clearance : Ability to obtain (in a timely manner) 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.

Create a job alert for this search