Find jobs in your neighborhood today! Jobs in English!

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

Database Administrator (DBA)/ Big Data

Gebo Cermex

This is a Full-time position in Laval, QC posted September 26, 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).

Must Have
● 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

How to Apply