Administrateur DBA gérant Oracle, SQL Server et MariaDB pour un organisme public québécois. Automatisation, haute disponibilité et infrastructures AWS avec Linux, Terraform et Ansible.
About the role
- Database Administrator focused on SQL Server and DevOps tasks at a sports & entertainment marketing firm. Joining a fixed-term contract team supporting mission-critical database environments.
Responsibilities
- Manage and support mission-critical SQL Server environments across Production, QA, and Development.
- Install, configure, and maintain enterprise-wide SQL Server instances (2016 and higher).
- Perform Windows Server administration (2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSM, RunCommand).
- Configure and manage SQL Server AlwaysOn availability groups and failover clustering.
- Optimize database performance through query optimization, index tuning, and execution plan analysis.
- Manage backup/restore processes and perform point-in-time recovery.
- Administer database security, users, roles, and permissions, including AWS IAM roles and permissions.
- Develop and maintain SSIS packages and SSRS reports.
- Monitor and rightsize infrastructure using tools like CloudWatch and NewRelic.
- Understand and configure ODBC clients and HAProxy as needed.
- Perform capacity planning, forecasting, and proactive performance tuning.
- Conduct root cause analysis for outages and performance issues.
- Automate tasks using T-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
- Troubleshoot connectivity and network issues, including TCP/IP, DNS resolution, and hostname configuration.
- Use Performance Monitor (Perfmon) to monitor OS-level metrics (CPU, memory, disk I/O).
- Basic understanding of Windows Firewall rules, VPN access, and private vs public network configurations.
- Experience with AWS services (RDS, S3, DynamoDB, EC2, IAM); Azure experience is a plus.
Requirements
- Strong expertise in SQL Server administration and performance tuning.
- Hands-on experience with Windows Server environments.
- Knowledge of DevOps practices and cloud platforms, particularly AWS.
- Solid troubleshooting skills across database, network, and server layers.
- Familiarity with monitoring, automation, and reporting tools.
- Excellent communication skills, with the ability to guide less experienced team members.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Administrateur de bases de données Oracle, SQL Server et MySQL chez TEHORA, firme québécoise de services professionnels. Gestion d’environnements haute disponibilité, optimisation, sécurité et automatisation.
Administrateur PostgreSQL assurant performance, fiabilité et sécurité des données d’ACCEO Solutions, éditeur de logiciels comptables. Gestion de l’architecture, réplication, migrations et infrastructure AWS.
Platform database administrator supporting Guidewire’s cloud insurance platform across AWS production environments. Managing Oracle, PostgreSQL, and SQL Server reliability, performance, security, and incident response.
LP
Planview Tool Administrator
LinkedIn Recruiter Post
URGENT!!🚨Looking for a Planview Tool Administrator for a Healthcare client🚨 📍 Hybrid - Mississauga ⏰ 10 Months (high possibility to extend) 💰 $64/hr (INC) - MAX
Administrateur DBA senior optimisant les environnements Microsoft SQL Server pour les clients de TEHORA, firme québécoise de services techniques et de gestion de projets. Diagnostic, gouvernance et amélioration de bases critiques.
LP
SENIOR DATABASE ADMINISTRATOR
LinkedIn Recruiter Post
Senior Database Administrator needed for 1 - year contract in Toronto or Oshawa. Must have SQL Server, Oracle, DB2 experience and strong performance tuning skills.
LP
Database Administrator (DBA) – Operational Support
LinkedIn Recruiter Post
Hiring an experienced Database Administrator for operational support of government/enterprise databases. Must have SQL Server, Oracle, DB2, and REST API experience; located in Canada.
LP
Senior Database Administrator / Systems Specialist – Public Sector
LinkedIn Recruiter Post
Senior DBA/Systems Specialist needed with SQL Server, Azure, Dynamics GP, and Salesforce experience. Onsite in GTA, 5 days/week.
Database Administrator managing SQL Server security, performance, integrations and Azure data services at Toronto law firm Torys. Supporting hybrid infrastructure, modernization, disaster recovery and 24/7 operations.