SQL Database Administrator

Place of assignment
Montreal
Date of entry
As soon as possible
Type of contract
Permanent position
Working hours
37.5

A leader in Quebec for nearly 30 years, the NOVIPRO Group is constantly developing its methodologies, solutions and technological service offerings. Seize the opportunity to join a team of experts in the IT field whose excellent reputation is well established. NOVIPRO is currently looking for a Senior SQL Server Database Administrator to join our team in a permanent position. This position is remote.

YOUR ROLE

In your job with us, you will be asked to work on the following:

  • Participate in day-to-day administration activities including installation, configuration and monitoring of databases to ensure that backups, availability and performance are all maintained to the highest standards;
  • Handle incidents, service requests and change requests for databases;
  • Monitor and work the ticket queue for requests for schema changes, security, running scripts on databases, and updating non-production databases;
  • Provide on-call support as needed for production and non-production Microsoft SQL Server databases;
  • On-call tuning, troubleshooting and production support for database environments deployed in Azure cloud environments;
  • Management of cloud services (PaaS and IaaS), storage, web applications, Active Directory, Application Insigh
    Bot application development using Bot Framework and CRM templates.





 

  • Analysis and recommendations for cloud migration projects;
  • Data migration to the cloud;
  • Root cause analysis and provide recommendations; Work with infrastructure team, application team and/or other teams to resolve issues;
  • Utilize monitoring tools and alerts to address any maintenance tasks/problems with databases;
    Perform database capacity analysis;
  • Ensure that documentation of system procedures and configuration is provided and kept up to date;
    Participate in team initiatives.




What we are looking for

  • A degree in computer science or related discipline;
  • Extensive experience with Microsoft SQL Server database technologies is required;
  • Experience with Azure SQL;
  • Knowledge of high availability and disaster recovery options for RDBMS technologies;
  • Knowledge of high availability and disaster recovery options for RDBMS technologies;
  • Experience troubleshooting and resolving database issues;
  • Experience with performance tuning and optimization, using native monitoring and troubleshooting tools;
  • Experience with database backup and restore operations;
  • Knowledge of indexes, index management and statistics;
  • Experience managing users, groups, roles, authentication and authorization for databases;
  • Experience working with Windows Server 2008/2012 and general understanding of Active Directory (SPN, VCO, etc.);
  • Experience working with Linux based systems;
  • Experience creating and implementing operational automation using scripts (PowerShell, Bash);
  • Knowledge of disk subsystem technologies and configurations (SAN, iSCSI, LUN, etc.);
  • Strong analytical and problem solving skills;
  • Excellent communication and documentation skills;
  • Familiar with change management and ITIL processes;
  • Experience as a production DBA and experience as a cloud DBA (Azure or AWS);
  • Asset: Hands-on experience in Azure Cloud Services (PaaS and IaaS), storage, web applications, Active Directory, Application Insights, Logic Apps, Data Factory, Service Bus, Traffic Manager, Azure Monitoring, OMS, Key Vault and SQL Azure.






  • Experience with SSRS administration;
  • Experience with SQL, DTS, MS SQL Server installation, configuration and migrations;
  • Experience with multi-tier Windows application architecture (web, application and database);
  • General knowledge of clustering is an asset;
  • Experience with PostgreSQL and Linux;
  • Experience with additional RDBMS technologies such as Progress/Open Edge, MySQL, IBM DB2 is an asset;
  • Experience with MongoDB is also an asset;
  • Ability to work under pressure;
  • Must be bilingual (written and spoken) in French and English;
  • Senior (8+ years).

At Novipro, the well-being of our employees is important to us. What we offer:

  • Remote working, flexible schedules and work-life balance;
  • Challenging projects;
  • Paid training and certifications;
  • Group insurance with broad coverage;
  • Telemedicine access (24/7) with healthcare professionals via secure chat or video session;
  • Refunded cell phone;
  • Gym discount;
  • Competitive compensation and much more!







Instructions for applying

Nous remercions toutes les personnes qui poseront leur candidature, mais ne communiquerons qu’avec celles retenues pour une entrevue.

Il est essentiel de joindre votre CV au présent formulaire pour que votre candidature soit considérée.

Le genre masculin est utilisé sans discrimination et dans le seul but d’alléger le texte.

Spontaneous application

Vous ne trouvez pas l'emploi correspondant à votre profil parmi nos affichages? Prenez tout de même un moment pour acheminer votre C.V. Il sera automatiquement conservé dans notre base de données de candidat.

Spontaneous application