65 Dba jobs in Canada
Systems DBA - Lottery Group
Posted today
Job Viewed
Job Description
Job Description
Company 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.
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 pg_stat_statements.
- 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.
Education and Knowledge
- Bachelor’s 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.
DBA - Oracle sql, AWS
Posted 11 days ago
Job Viewed
Job Description
Exp Required: 6 Database Administrator Skills Required: Digital: Amazon Web Service(AWS) Cloud Computing Digital : Ansible ORACLE SQL~IT IS_AMS_Database_MS SQL Server Job Description: • Automation Design, engineer, and deploy on MS SQL Server. Nice to have experi-ences on Oracle or AWS RDS, Redshift DBMS technologies. • Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions Build and leverage au-tomation and DB Develops pipelines to provision, upgrade, patch and maintain DB systems Sup-port DB change request and problem investigation and resolution of both production and non-production environments. • Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. • 5 years of hands-on DBA experience and strong skills on MS SQL server Nice to have sound knowledge of Oracle or AWS RDS, Redshift, preferable with 1 year hands-on experiences Solid un-derstanding of the Software Development Life Cycle (SDLC) Sound knowledge and 1year experi-ence with Database automation and DB Develops (e.g. Ansible, AWS CDK, GitHub Action, Liqui-base, shell scripting, python, SQL)
Database Administrator
Posted today
Job Viewed
Job Description
Job Description
About Us:
At Beanfield, we’re not just building networks, we’re building communities. We’re dedicated to investing in our 100% Canadian-based employees, 100% Canadian-driven investments, and our 100% Canadian operations. We’ve spent over 35 years growing a fibre-optic network that connects people and businesses across Toronto, Montreal, and Vancouver. Beanfield has always challenged the status quo, believing that everyone deserves fast and reliable fibre internet.
We are Challengers , leading the way, disrupting the industry with a startup mentality and a focus on building our own infrastructure.
We are United , operating as one team, where everyone's ideas are valued.
We Care , prioritizing the well-being of our employees, partners, customers, and communities. We foster trust, communicate openly, and focus on our brand and customers.
Come join our team as we continue to connect communities and foster choice, by providing fast and reliable fibre Internet to Canadians.
Position Summary
We are seeking a Database Administrator (DBA) to join our dedicated team. In this role, you will be responsible for the full lifecycle of our databases, including design, installation, monitoring, maintenance, and performance tuning. Your primary goal will be to ensure high levels of data and system availability while maintaining the integrity of our database infrastructure.
You will independently manage and deliver end-to-end projects, taking full ownership from concept to completion. You will mentor and provide technical guidance to junior team members. You will also develop, implement, and oversee policies and procedures that govern our databases and their associated software.
This is a critical position that requires a commitment to excellence and reliability. Please note that this role includes special working conditions, such as the need to work after-hours or on weekends as required by project and business needs.
Roles & Responsibilities
Installation & Configuration: Install, configure, and upgrade PostgreSQL databases and associated tools.
Performance Tuning: Monitor database performance, identify and resolve bottlenecks, and optimize SQL queries to ensure maximum efficiency.
Backup & Recovery: Develop and implement comprehensive backup and recovery strategies, including disaster recovery plans, to guarantee data integrity and availability.
Security Management: Implement and enforce security policies, manage user permissions, and ensure data encryption and compliance.
High Availability & Disaster Recovery (HA/DR): Design and deploy HA/DR solutions, such as streaming replication, Patroni, or pgpool-II, to minimize downtime.
Development Support: Collaborate with development teams to support database design, create schemas, and optimize application-to-database interactions.
Troubleshooting & Support: Diagnose and resolve database issues promptly, including providing rotational on-call support for critical systems.
Automation & Scripting: Automate routine database tasks like maintenance and monitoring using scripting languages such as Bash or Python.
Documentation: Maintain thorough and current documentation for all database configurations, procedures, and standards.
Capacity Planning: Analyze database storage and performance metrics to forecast and plan for future capacity needs.
Skills & Qualifications
5+ years of professional experience as a Database Administrator.
3+ years of hands-on experience with PostgreSQL and MySQL. (NoSQL is a plus.)
3+ years of experience in SQL coding and scripting.
2+ years of experience with cloud platforms, preferably Google Cloud Platform (GCP).
Proven expertise in designing, deploying, and administering highly available database systems.
Experience with on-premise, cloud, and hybrid database environments in a 24/7 production setting.
Demonstrated experience in migrating SQL databases from on-premise to cloud platforms.
Expertise in designing, building, installing, configuring, and providing support for database servers.
Strong ability in performance tuning and capacity planning.
Proven ability to effectively prioritize and execute tasks independently in a 24/7 production environment.
Excellent problem-solving skills and the ability to conduct research on database issues, standards, and products as needed.
Nice to have: PostgreSQL Professional and/or Google Cloud Platform (GCP) certifications.
University/College Degree Required
Degree in Computer Science, Information Systems, or a related area.
What's in it for you?
- Competitive base salary plus annual bonus based on company and individual performance.
- Permanent, full-time position.
- A comprehensive group insurance plan - medical, dental, vision care with health and lifestyle spending accounts.
- A fantastic parental leave top-up program.
At Beanfield, we are proud to be an equal-opportunity employer.
We are committed to fostering a diverse and inclusive workplace where all qualified applicants are considered for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or any other protected status.
Beanfield is dedicated to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in all aspects of employment, as well as in our services, programs, and activities. If you require accommodation during the application or interview process, please contact us at
Please note that candidates must be legally eligible to work in Canada at this time. We regret that Beanfield is unable to sponsor employment Visas.
Please note that all communication regarding recruitment and hiring at Beanfield will come exclusively from email addresses ending in @beanfield.com . We urge candidates to be cautious of any unsolicited messages or offers and to remain vigilant against phishing attempts.
Database Administrator
Posted today
Job Viewed
Job Description
Job Description
We are looking for an experienced Senior Database Administrator for our client. This is a permanent position that is remote to start with later relocation to Calgary or Winnipeg . Our client is a global enterprise company with a product that you've likely used.
This position requires the ability to code as well as perform the duties of a database administrator. Previous experience as a Software Engineer/Developer will be regarded highly.
You Have:
- 5+ years’ experience working with databases, with strong foundational skills in database theory (MySQL , SQL Server , DynamoDb , Relational Databases or other NoSQL
- Experience coding in Java8 OR C# and Python .
- Experience working with AWS
- Great communication skills and the ability to communicate technical concepts with ease
Perks:
- Competitive Salary
- Individual performance bonus
- Health and dental benefits
- 3 weeks’ vacation
- Relocation Package
If this opportunity sounds like something that fits your career path, please apply to this posting; we'd love to talk to you!
Be The First To Know
About the latest Dba Jobs in Canada !