Enterprise DBA - Performance, Security & HA

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

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.