Systems DBA Lottery Group

Internal Job Title: Systems DBA
Job Type: Permanent Full-time
Job Location: Ottawa ON
Work Model: Hybrid

Position Summary

As a Systems DBA within our Lottery Development Group you will play a key role in supporting the reliability scalability and performance of PostgreSQL and MariaDB environments across both on-premises and cloud deployments. You will be responsible for implementing high availability (HA) and disaster recovery (DR) strategies automating infrastructure tasks building RPMs managing repositories and contributing to CI/CD pipelines.

Responsibilities

Database Administration and Reliability

• Administer and maintain PostgreSQL and MariaDB systems across on-prem and Azure cloud environments.
• Design and implement HA and DR strategies including replication failover and backup solutions.
• Monitor system and database performance using tools like Prometheus Grafana and pgstatstatements.
• Troubleshoot and resolve performance and reliability issues.
• Ensure system and data security compliance and documentation standards are met.

Infrastructure Automation and Packaging

• Build and manage RPM packages and maintain internal repositories for database components.
• Develop and maintain CI/CD pipelines for database infrastructure and configuration automation.

Collaboration and Agile Delivery

• Collaborate with DevOps and Development teams to ensure seamless integration and deployment.
• Create and maintain documentation for database system configurations processes and procedures.
• Contribute to Agile development cycles through planning reviews and team coordination.

Qualifications :

Education and Knowledge

• Bachelors degree in Computer Science (or related field) or an equivalent combination of relevant education and additional relevant work experience.
• Knowledge of the following:
  • Linux systems PostgreSQL and MariaDB architecture.
  • System and database performance monitoring and optimization tools.
  • RPM packaging and repository management.
  • High and disaster recovery strategies including replication failover and backup solutions.
  • Security and compliance best practices for systems and data.
  • CI/CD practices and infrastructure automation.
  • Cloud infrastructure (Azure)

Experience

• 3 years of experience in systems administration and/or database reliability engineering.
• Experience with PostgreSQL and/or MariaDB in both on-prem and cloud environments.
• Experience with building infrastructure and systems orchestration in a Linux environment.

Competencies and Soft Skills

• Critical thinking skills
  • Analysis problem-solving skills
• Interpersonal skills
  • Communication abilities teamwork and collaboration 
• Organization and time management skills
• Attention to detail
• Self-directed

Technical Environment

• Operating Systems: Linux
• Database Systems: PostgreSQL MariaDB
• Containerization: Docker Kubernetes
• Deployment: Puppet
• Scripting Languages: SQL Python Bash
• Tools: Git GitLab Prometheus Grafana

Mandatory Requirements

• Language: Fluency in English (reading writing speaking)
• Work Hours: Ability to offer support outside of scheduled working hours
• Travel: Ability to travel internationally (passport required) as required

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.

Remote Work :

No

Employment Type :

Full-time