Canadian Bank Note Company

Database Administrator - N.A. Service Delivery Group

Canadian Bank Note Company • $80K — $100K *
Ottawa, ON K1G 3J6In-Person
Education, Government & Non-Profit
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Legally eligible to work in Canada
  • Fluent in English (speak, read, write)
  • Able to obtain and maintain Government of Canada Secret level security clearance
  • Able to travel approximately 2 weeks/year
  • Bachelor's degree in computer science or equivalent experience
  • 10 years of database administration experience
  • Knowledge of database management principles, tuning, security, and backup practices.

Responsibilities

  • Design, implement, and maintain database systems to meet requirements
  • Install and configure production systems prior to shipment
  • Define migration strategies and develop migration procedures
  • Monitor and optimize database performance
  • Ensure database security through access controls and encryption
  • Develop backup and recovery plans to protect data integrity
  • Provide troubleshooting support for database-related issues.

Benefits

  • Hybrid work model
  • Support for ongoing training and development
  • Opportunity to work with national and international government customers
  • Access to advanced technologies and tools
  • Collaborative work environment with System Architects.
Full Job Description
Internal Job Title: Database Administrator
Job Type: Permanent, Full-Time
Job Location: Ottawa, ON
Work Model: Hybrid

Job Status: Existing Vacancy

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 national and international government customers. In this position, you will design, develop and provide ongoing support and tune and optimize their performance to ensure they remain highly available, reliable, and secure.

Core Responsibilities
  • Design, implement, and maintain database systems to meet organizational requirements. Collaborate with System Architects to plan DBMS capacity and hardware requirements.
  • Install and configure the production system locally in advance of shipment to customer site. Train and support Developers and Local Service Providers (LSPs).
  • Define database migration strategy and design replication topology and methodology. Develop migration procedures/scripts and perform the migration.
  • Monitor database performance, identify issues, and optimize database performance.
  • Ensure database security by implementing access controls, encryption, and other security measures.
  • Develop and implement backup and recovery plans to protect data integrity.
  • Provide support for database-related issues, including troubleshooting and resolving problems.
  • Create and maintain documentation for database configurations, schemas, changes, processes, and procedures.


Qualifications

Minimum Qualifications
  • Legally eligible to work in Canada
  • Fluent in English (speak, read, write)
  • Able to obtain (in a timely manner) and maintain Government of Canada Secret level security clearance
  • Able to travel approx. 2 weeks/year on average
  • Bachelor's degree in computer science (or related program) or equivalent years of additional relevant professional experience
  • Knowledge of the following:
    • Database management principles
    • Data modeling
    • Database tuning, performance and optimization
    • Database security practices
    • Database backup and recovery
    • Basic networking concepts including TCP/IP, DNS, DHCP, network security practices.
  • 10 years of experience in database administration
  • Experience with the following technologies:
    • Operating Systems: Linux, Windows Server
    • Database Management Systems: SQL, Oracle PL/SQL, PostgreSQL PL/pgSQL and Bash
    • Virtualization: VMware
    • Containerization/Orchestration: Docker
    • Deployment/Configuration: Puppet
    • SQL and Scripting: SQL, Bash
    • Security: Active Directory, Kerberos, LDAP, TLS
    • Tools: Git

Preferred Qualifications
  • Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or similar certifications are assets.
  • Experience with the following technologies:
    • Database Management Systems: Mongo DB, NoSQL (Elasticsearch)
    • Virtualization: HyperV, XCP-ng
    • Containerization/Orchestration: Kubernetes
    • Deployment/Configuration: Terraform, Ansible, Bicep, Helmchart
    • SQL and Scripting: Python, PowerShell
    • Security: Bitlocker, LUKS
    • Cloud Platforms: AWS RDS, Azure SQL Database
    • Tools: tcpdump, Wireshark, PowerCLI, Sysinternals Suite, BIRT


Additional Information

About Canadian Bank Note Company

The Canadian Bank Note Company is a security printing company that produces banknotes, passports, and other secure documents for governments and central banks around the world. The company was founded in 1897 and is headquartered in Ottawa, Canada. Canadian Bank Note Company has a global presence with operations in North America, Europe, Africa, and Asia. The company's products include banknotes, passports, driver's licenses, and other secure documents. Canadian Bank Note Company is known for its high-quality printing and security features, which help prevent counterfeiting and fraud. The company is also involved in the production of lottery tickets and other gaming products.
Learn more about Canadian Bank Note Company
Size
1,500 employees
Industry
Business Services
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Canadian Bank Note Company

More Education, Government & Non-Profit Jobs

Find similar Database Administrator - N.A. Service Delivery Group jobs:

NationwideOttawa, ON