Database Admin Senior Specialist

Position

Database Admin Senior Specialist

Tiverton, Ontario, Canada

A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.

10 years of progressive database administration experience, including production support, performance tuning, backup and recovery, disaster recovery planning, and database maintenance activities.

• Manage and administer production, QA, and development database environments ensuring high availability and optimal performance.
• Perform database performance tuning, query optimization, indexing, and capacity planning to improve system efficiency.
• Perform Oracle RMAN and SQL Server backup/recovery operations and regularly validate restoration procedures.
• Manage Oracle and SQL Server security, user access, roles, and database permissions.
• Implement and maintain backup, recovery, and disaster recovery (DR) strategies to ensure business continuity.
• Monitor database health, storage utilization, replication, and system performance using enterprise monitoring tools.
• Plan and execute database upgrades, migrations, patching, and maintenance activities with minimal downtime.
• Troubleshoot and resolve database incidents, performance bottlenecks, and data integrity issues within defined SLAs.
• Collaborate with application, infrastructure, and security teams to support releases and system enhancements.
• Develop and maintain database standards, documentation, SOPs, and operational runbooks.
• Support compliance, audit, security, and access management requirements across database platforms.
• Participate in on-call support and provide proactive recommendations for continuous service improvement.

• 10+ years of hands‑on experience as a Database Administrator supporting enterprise‑scale production environments.
• Strong hands‑on experience administrating Oracle Database and Microsoft SQL Server environments, including installation, configuration, performance tuning, backup/recovery, patching and upgrades.
• 10+ years of experience with database backup/recovery, replication, clustering, and high‑availability solutions.
• Proven expertise in SQL query tuning, performance troubleshooting, and database optimization.
• 10+ years of experience supporting mission‑critical applications in 24x7 production environments.
• Knowledge of cloud database technologies (Azure SQL, AWS RDS, Oracle Cloud, etc.) is an asset.
• 10+ years of experience with database monitoring and administration tools.
• Familiarity with ITIL processes, incident management, change management, and release management.
• Excellent stakeholder communication and documentation skills.
• Preferred to have Level1 Security Clearance.
• Spécialiste en administration de bases de données (DBA)

Un administrateur de bases de données (DBA) professionnel assurera le bon fonctionnement continu de la base de données 24h/24 et 7j/7. L'objectif est de fournir un flux d'informations fluide dans toute l'entreprise, en tenant compte à la fois de la structure des données dorsales (backend) et de l'accessibilité frontale (frontend) pour les utilisateurs finaux.

Minimum de 10 ans d'expérience progressive en administration de bases de données, incluant le support de production, l'optimisation des performances, la sauvegarde et la restauration, la planification de la reprise after sinistre et les activités de maintenance des bases de données.

• Gérer et administrer les environnements de bases de données de production, d'assurance qualité (QA) et de développement en garantissant une haute disponibilité et des performances optimales.
• Optimiser les performances des bases de données, des requêtes, l'indexation et planifier la capacité pour améliorer l'efficacité du système.
• Exécuter les opérations de sauvegarde/restauration Oracle RMAN et SQL Server, et valider régulièrement les procédures de restauration.
• Gérer la sécurité, les Clientès utilisateurs, les…