SQL Database Administrator

Rate TBD

Location Montreal, QC Canada

Type of project

Duration hours

Education required N/A

Years of experience N/A

Type of employment N/A

Area of Specialization N/A

Languages required N/A

Workhoppers Home Montreal QCTELECOMMUTE

Description

Job Description
Job Description

Assignment Duration: 12 months

Work Schedule: 37.5 hours/week

Work Mode: Hybrid (2 days/week in person required)

Language: French

 

As a Database Administrator, your role is to design, configure,
administer and develop SQL Server databases and data structures on
premise and in the cloud. You develop recommendations, solutions and
action plans, according to the organization's orientations and
objectives. You ensure the optimal use, security, integrity and
maintenance of the organization's various databases. The nature of the
files requires extensive and in-depth knowledge in your field.

Responsibilities

* Deploy, configure and support SQL Server database services in IaaS
and PaaS mode for the environments and applications concerned,
ensuring their integrity, security and performance
* Conceptualize, implement and update database structures
* Advise various stakeholders in the management, use and access to
databases
* Participate in the development of automation solutions for the
configuration, installation, maintenance, continuous delivery and
deployment of SQL Server and Azure SQL services
* Write and update documentation related to the various systems and
databases

Requirements and Qualifications Required

Requirements

* Proven experience as a senior DBA
* Significant knowledge of Azure SQL, SQL Server 2012 to 2022,
AlwaysOn, TSQL, Windows Server
* Good knowledge of VMWare and Azure environments
* Experience with backups and data recovery
* Ability to work independently and teamwork
* Excellent written and verbal communication skills in French
* Functional skills in English
* Knowledge of database monitoring tools
* Degree in computer science or related field

Desired skills

* Knowledge of Azure DevOps, GitHub, Ansible, Flyway, CosmosDB
* Knowledge of DevOps and CI/CD practices
* Familiarity with cloud environments (AWS, Azure, GCP)

 

Administrateur base de Données (DBA)

Description du poste

À titre d’Administrateur(-trice) de base de données, votre rôle
consiste à concevoir, à configurer, à administrer et à faire
évoluer des bases de données et structures de données SQL Server on
premise et dans l’infonuagique. Vous élaborez des recommandations,
des solutions et des plans d’action, selon les orientations et
objectifs de l’organisation. Vous assurez l’utilisation optimale,
la sécurité, l’intégrité et l’entretien des diverses bases de
données de l’organisation. La nature des dossiers exige des
connaissances étendues et approfondies dans votre domaine.

 

Responsabilités

* Déployer, configurer et supporter les services de base de données
SQL Server en mode IaaS et PaaS pour les environnements et les
applications concernées en assurant leur intégrité, leur sécurité
et leur performance
* Conceptualiser, implanter et mettre à jour les structures de bases
de données
* Conseiller divers intervenants dans la gestion, l’utilisation et
l’accès aux bases de données
* Participer au développement de solutions d’automatisation pour
la configuration, l’installation, la maintenance, la livraison et le
déploiement continus des services SQL Server et Azure SQL
* Rédiger et mettre à jour la documentation en lien avec les divers
systèmes et bases de données

Exigences et Qualifications Requises

Exigences

* Expérience avérée en tant que DBA senior
* Connaissances significatives de Azure SQL, SQL Server 2012 à 2022,
AlwaysOn, TSQL, Windows Server
* Bonnes connaissances des environnements VMWare et Azure
* Expérience avec les sauvegardes et la récupération de données
* Capacité à travailler de manière autonome et en équipe
* Excellentes compétences en communication écrite et verbale en
français
* Compétences fonctionnelles en anglais
* Connaissance des outils de surveillance des bases de données
* Diplôme en informatique ou dans un domaine connexe

Compétences souhaitées

* Connaissance avec Azure DevOps, GitHub, Ansible, Flyway, CosmosDB
* Connaissance des pratiques DevOps et CI/CD
* Familiarité avec les environnements cloud (AWS, Azure, GCP)

Company Description
Opusing is a 100% Minority-owned and diversity-certified Digital
Transformation and staffing firm that empowers startups, businesses,
and corporations to leverage the power of Technology and Manpower to
trigger unstoppable growth. The success of our clients is the only
goal of our team, which is led by digital native professionals in
creative thinking, programming paradigms, and commercial acumen.

We are a globally growing firm with our headquarters in Boston, USA.
With a focus on addressing clients' unique needs by significantly
enhancing their businesses, we offer unmatched staff augmentation, HR
outsourcing, and IT & non-IT staffing services globally.

We have been a forward-thinking and trustworthy technology & staffing
partner for top-tier brands since 2007. We have worked with fortune
2000 companies in North America -the United States, Canada, India, and
the UK. We have been the primary go-to vendor for all our clients for
Contract and Fulltime Professional services, Offshore Staffing &
SOW-based project work.Company Description
Opusing is a 100% Minority-owned and diversity-certified Digital
Transformation and staffing firm that empowers startups, businesses,
and corporations to leverage the power of Technology and Manpower to
trigger unstoppable growth. The success of our clients is the only
goal of our team, which is led by digital native professionals in
creative thinking, programming paradigms, and commercial
acumen.\r\n\r\nWe are a globally growing firm with our headquarters in
Boston, USA. With a focus on addressing clients' unique needs by
significantly enhancing their businesses, we offer unmatched staff
augmentation, HR outsourcing, and IT & non-IT staffing services
globally.\r\n\r\nWe have been a forward-thinking and trustworthy
technology & staffing partner for top-tier brands since 2007. We have
worked with fortune 2000 companies in North America -the United
States, Canada, India, and the UK. We have been the primary go-to
vendor for all our clients for Contract and Fulltime Professional
services, Offshore Staffing & SOW-based project work.