This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

English jobs board for the people in Laval, Québec

To post a job, login or create an account |  Post a Job

   Jobs Laval   

Find new job offers in English every day in Laval

previous arrow
next arrow
Slider

Database Administrator (DBA)/ Big Data

Gebo Cermex

This is a Full-time position in Laval, QC posted November 15, 2018.

We are looking for a skilled Database Administrator (DBA) with Big Data knowledge and experience to join ourEIT Software Development team. The ideal candidate will work closely with our software developers, testers,analysts and project/product managers in order to collect, store, process and analyze huge sets of data. Youwill be responsible for choosing an optimal solution to implement, test, maintain, monitor and document yourwork. You will also be responsible for their integration within the product architecture and across thecompany’s infrastructure.

Responsibilities

  • Work closely with the development team to develop, test, maintain and optimize the company’s datamodeling and architecture, as defined in the roadmap.
  • Participate with your teammates to elaborate and define user stories, give feedback andrecommendations, provide time estimates and identify areas of risk.
  • Design and build the infrastructure for data extraction, preparation and loading from a variety of sourcesusing technologies such as SQL Server, BigQuery, Firebase and Google Cloud Platform (GCP).
  • Be an advocate for quality throughout the development process.
  • Provide quality and acceptance validation of your new features and functionalities by using acombination of scripted and manual testing techniques.
  • Contribute to the ongoing efforts to refine and improve the internal software development processes,test methodologies, and internal testing tools.
  • Create new and maintain existing documentation (ie: requirements, designs, architectures, releasenotes, user manuals, etc).

Competencies:

  • Graduate degree in Computer Science, or equivalent experience.
  • At least 8 years of experience as a database administrator (DBA).
  • At least 4 years of experience with Big Data and/or the Google Cloud Platform.
  • Advanced knowledge and experience with MS SQL Server (2008R2 to 2017).
  • Advanced knowledge and experience with SQL query authoring (Transact-SQL) and relational databases.
  • Experience with capacity planning, installation, configuration, database design, migration, replication,high availability (HA), security, troubleshooting, as well as backup (full, differential, transactional) and data recovery.
  • Experience with performance analysis and monitoring (query plan, wait statistics and I/O, locks anddeadlocks, profiler / extended events / query store).
  • Experience with Microsoft SQL Server Agent

    Should Have

  • General understanding of distributed computing architectures.
  • General understanding of operating systems (ie: Windows or Linux).
  • General understanding of storage technologies and networking.
  • Experience with schema-less databases.
  • Experience with the publish-subscribe (pub/sub) pattern.

    Nice to Have

  • Experience with a variety of databases (MySQL, Oracle, Postgres, NoSQL, NewSQL)
  • Experience with .Net C# development
  • Experience with Microsoft PowerShell
  • Experience with Microsoft Team Foundation Server (TFS)
  • Experience with Google Cloud Platform (GCP) or GCloud SDK and console.
  • Experience with Google’s Firebase
    Experience with BigQuery (dataset and table creation, nested and repeated fields, partitioning).

Skills Required

  • Education level: College
  • Work experience (years): 6-9 years

Package

Salary: N/D