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 failover 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