Job Description
Operational Ownership (~70%)
- Act as the technical owner for enterprise database platforms (on-premises and cloud), including day-to-day administration, monitoring, and troubleshooting.
- Manage and optimize databases across legacy and modern technologies (e.g., SQL Server, Raven DB, Cosmos, MySQL/PostgreSQL, Azure SQL, AWS RDS, Progress, etc.).
- Ensure high availability, performance, and capacity through proactive monitoring, tuning, and maintenance (indexing, statistics, partitioning, resource governance, etc.).
- Design, implement, and regularly test backup and recovery strategies, including disaster recovery and failover procedures.
- Maintain strong security and compliance posture: user access management, roles and permissions, data encryption, auditing, and alignment with corporate and regulatory requirements.
- Perform and coordinate regular maintenance activities such as patching, upgrades, and vulnerability remediation with minimal impact to business operations.
- Provide tier-3 support for complex incidents and production issues, including participation in an on-call rotation where required.
Project & Engineering Work (~30%)
- Participate in infrastructure and application projects: new system implementations, database refactoring, consolidations, and modernization initiatives.
- Collaborate with solution architects, developers, and business analysts to design scalable and resilient database solutions that meet functional and non-functional requirements.
- Lead or support migration efforts from legacy platforms to modern environments (e.g., on-prem to cloud, version upgrades, re-platforming and re-architecture).
- Contribute to the standardization and automation of database operations (e.g., Infrastructure as Code, CI/CD integration, configuration management, scripting).
- Produce and maintain clear documentation: runbooks, topology diagrams, DR procedures, standards, and operational guidelines.
Qualifications
Required Qualifications & Experience
- 10+ years of progressive experience as a Database Administrator in medium to large enterprise environments.
- Proven experience managing mission-critical, 24/7 environments with strict SLAs.
- Strong knowledge of performance tuning & optimization (execution plans, indexes, waits, locking/blocking).
- Strong knowledge of high availability and disaster recovery (Always On, clustering, log shipping, replication, etc.).
- Strong knowledge of backup, restore, and DR strategy design and execution.
- Experience with security hardening and least privilege access control.
- Experience with cloud database services (Azure, AWS) and hybrid architecture.
- Proficiency in scripting and automation (PowerShell, Bash, Python, T-SQL/PL-SQL, etc.).
- Familiarity with DevOps practices, CI/CD pipelines, and Infrastructure as Code (e.g., ARM/Bicep, Terraform, Ansible) is an asset.
- Post-secondary degree or diploma in Computer Science, Information Technology, or equivalent experience.
Personal Attributes & Soft Skills
- Continuous learner who actively keeps up with new database technologies, patterns, and best practices while respecting the realities of legacy systems.
- Self-starter with strong initiative; able to identify issues, propose solutions, and execute with minimal supervision.
- Demonstrated accountability and ownership – you treat the environment as if it were your own.
- Strong analytical and problem-solving skills, especially under pressure during critical incidents.
- Excellent communication skills, able to translate complex technical topics into clear language for non-technical stakeholders.
- Collaborative mindset; comfortable working with cross-functional teams including infrastructure, security, development, and business units.
- Organized and disciplined with good documentation habits and attention to detail.
Language & Work Environment
- Fully bilingual in English and French (spoken and written).
- Comfortable working in a hybrid model, combining remote work with on-site presence as needed for operational and project activities.
- Willingness to participate in off-hours maintenance windows and an on-call rotation for critical systems support.
Additional Information
Additional Information
- Competitive salary and other benefits;
- Group insurance and RRSP program;
- Company-wide events throughout the year (barbecue, Christmas party, etc.);
- Free on-site gym;
- Two on-site cafeterias (subsidized meal program available);
- Dynamic and rewarding work environment - work on high-impact and meaningful projects while having fun!