DBA - Pipeline

Adastra Group; Markham; Hybrid; CAD 70,000 - 85,000; Full time

Benefits offered by this job

Career progression

Competitive pay

Benefits plan

Referral program

Best Managed Company

Diverse workplace

Job summary

Adastra is seeking a Database Administrator to manage enterprise database environments across development, staging, and production. The role emphasizes performance optimization, backup/recovery, security, and high availability in a hybrid work model with Toronto as the primary location.

Responsibilities include monitoring, upgrades, incident resolution, capacity planning, and collaboration with development teams on schema design and data modeling.

Qualifications

• Proven experience as a Database Administrator supporting enterprise production environments.
• Strong experience administering relational database platforms such as SQL Server, Oracle, PostgreSQL, MySQL, or similar technologies.
• Expertise in database performance tuning, query optimization, indexing strategies, and troubleshooting.
• Hands-on experience with backup, recovery, high availability, and disaster recovery solutions.
• Experience managing database security, access controls, encryption, and compliance requirements.
• Experience planning and executing database upgrades, migrations, and patching activities.
• Strong understanding of database architecture, schema design, and data modeling principles.
• Experience with scripting and automation for database administration functions.
• Knowledge of monitoring, capacity planning, and database health management practices
• Strong analytical, problem-solving, and root cause analysis skills
• Excellent communication and documentation skills
• Ability to work effectively in cross-functional teams and support critical production environments

Responsibilities

• Install, configure, administer, and maintain database environments across development, staging, and production
• Monitor database health and performance, proactively identifying and resolving bottlenecks through optimization of queries, indexes, and configurations
• Design, implement, and regularly test backup, recovery, and disaster recovery strategies
• Manage database security, including user access, permissions, encryption, and compliance with data protection standards
• Plan and execute database upgrades, patching, and migrations while minimizing business disruption
• Implement and maintain high availability and fail‑over solutions, including clustering, replication, mirroring, and log shipping
• Troubleshoot and resolve database incidents, conducting root cause analysis and implementing preventative measures
• Perform capacity planning and forecasting to support future storage, performance, and scalability requirements
• Partner with development teams on schema design, data modeling, and query optimization best practices
• Automate routine database administration tasks, including backups, health monitoring, and maintenance activities
• Maintain database architecture documentation, configurations, and operational procedures
• Provide guidance and knowledge sharing on database administration best practices
• Participate in on‑call support for critical production systems as required

Skills

Database administration

SQL Server

Oracle

PostgreSQL

MySQL

Performance tuning

Backup & DR

Security & compliance

Automation scripting

Job description

Overview

Adastra is seeking a Database Administrator (DBA) to manage, optimize, and support enterprise database environments across development, staging, and production systems. The successful candidate will be responsible for database performance, availability, security, backup and recovery processes, and operational support. This role requires strong troubleshooting abilities, a proactive approach to database management, and experience supporting mission‑critical systems in fast‑paced environments.

Primary Location: Toronto, ON

Work Model: Hybrid 2‑Days Onsite

Employment Type: Full‑Time or Contractor

Vacancy Status: New

Compensation Range: $70,000 - $85,000 CAD

RESPONSIBILITIES

• Install, configure, administer, and maintain database environments across development, staging, and production
• Monitor database health and performance, proactively identifying and resolving bottlenecks through optimization of queries, indexes, and configurations
• Design, implement, and regularly test backup, recovery, and disaster recovery strategies
• Manage database security, including user access, permissions, encryption, and compliance with data protection standards
• Plan and execute database upgrades, patching, and migrations while minimizing business disruption
• Implement and maintain high availability and fail‑over solutions, including clustering, replication, mirroring, and log shipping
• Troubleshoot and resolve database incidents, conducting root cause analysis and implementing preventative measures
• Perform capacity planning and forecasting to support future storage, performance, and scalability requirements
• Partner with development teams on schema design, data modeling, and query optimization best practices
• Automate routine database administration tasks, including backups, health monitoring, and maintenance activities
• Maintain database architecture documentation, configurations, and operational procedures
• Provide guidance and knowledge sharing on database administration best practices
• Participate in on‑call support for critical production systems as required

QUALIFICATIONS, SKILLS & EXPERIENCE

• Proven experience as a Database Administrator supporting enterprise production environments
• Strong experience administering relational database platforms such as SQL Server, Oracle, PostgreSQL, MySQL, or similar technologies
• Expertise in database performance tuning, query optimization, indexing strategies, and troubleshooting
• Hands‑on experience with backup, recovery, high availability, and disaster recovery solutions
• Experience managing database security, access controls, encryption, and compliance requirements
• Experience planning and executing database upgrades, migrations, and patching activities
• Strong understanding of database architecture, schema design, and data modeling principles
• Experience with scripting and automation for database administration functions
• Knowledge of monitoring, capacity planning, and database health management practices
• Strong analytical, problem‑solving, and root cause analysis skills
• Excellent communication and documentation skills
• Ability to work effectively in cross‑functional teams and support critical production environments

NICE TO HAVE

• Experience with cloud database platforms in Azure, AWS, or Google Cloud
• Experience with containerized or cloud‑native database environments
• Knowledge of Infrastructure as Code (IaC) and database automation tools
• Experience supporting large‑scale data warehouse or analytics platforms
• Experience within consulting or professional services environments

ABOUT ADASTRA

Adastra is a global leader in AI and data‑driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.

Trusted by some of the world’s most prominent brands, Adastra delivers end‑to‑end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future‑ready capabilities and delivering measurable, lasting impact.

Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• The opportunity to work with one of Canada’s 50 Best Managed Companies
• Satisfaction of working for a reputable company
• A flexible, dynamic, and diverse workplace

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.