Database Administrator – N.A. Service Delivery

Job title:

Database Administrator – N.A. Service Delivery

Company

Canadian Bank Note Company

Job description

Company DescriptionCanadian 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 DescriptionInternal Job Title: Database Administrator
Job Type: Permanent, Full-Time
Job Location: Ottawa, ON
Work Model: HybridPosition 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 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.

QualificationsKnowledge, 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

• Operating Systems: Linux, Windows Server
• Database Management Systems: Oracle, PostgreSQL, Mongo DB, NoSQL (Elasticsearch)
• Virtualization: VMware, HyperV, XCP-ng
• Containerization/Orchestration: Docker, Kubernetes
• Deployment/Configuration: Puppet, Terraform, Ansible, Bicep, Helmchart
• SQL and Scripting: SQL, Python, PowerShell, Bash, Ruby
• Security: Active Directory, Kerberos, LDAP, TLS, Bitlocker, LUKS
• Cloud Platforms: AWS RDS, Azure SQL Database
• Tools: Git, tcpdump, Wireshark, PowerCLI, Sysinternals Suite, BIRT

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 InformationCanadian 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.

Expected salary

Location

Ottawa, ON

Job date

Tue, 01 Apr 2025 22:44:25 GMT

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