Database Administrator - N.A. Service Delivery Group

Canadian Bank Note Company View all jobs

Ottawa, ON
Permanent
Full-time

20 days ago

Company Description) is a trusted leader in secure technology solutions for governments and businesses worldwide. We develop and deploy secure document and enterprise-level system solutions across the following domains: border security, civil identity, driver licence/identification and vehicle information, excise control, currency, lotteries and charitable gaming.and 7 Core Principles shape and guide our corporate behaviours and underpin the sense of community you will experience at CBN. At CBN, we seek long-term relationships with our employees (current average tenure is ~10 years) and offer a competitive compensation package that includes health, medical and life insurance benefits and a defined contribution pension plan with company matching.Job DescriptionInternal Job Title: Database Administrator
Job Type: Permanent, Full-Time
Job Location: Ottawa, ON
Work Model: HybridJob Status: Existing VacancyPosition SummaryAs 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.

QualificationsMinimum 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.
4+ years of experience in database administration
Experience with the following technologies:

Operating Systems: Linux, Windows Server
Database Management Systems: Oracle, PostgreSQL
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 InformationEqual Opportunity StatementOur organization is committed to employment equity and diversity in the workplace. We actively encourage applications from women, Indigenous Peoples, persons with disabilities, members of visible minorities, and LGBTQ2+ individuals.We are dedicated to removing barriers and fostering a workplace that reflects the communities we serve and we are committed to providing an accessible and inclusive recruitment process in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation at any stage of the hiring process, please contact us at so that appropriate arrangements can be made.

Canadian Bank Note Company

Apply Now