Database Administrator (ITD245)

September 12 2019
Industries Energy
Categories Information Technology, Database Dev. & Admin.
Longueuil, QC

Role and Responsibilities

Reporting to the Manager – Information Technologies, the Database Administrator will have the following main responsibilities:

  • Install, configure, and monitor the performance and backup of databases and servers to ensure optimal performance and availability of databases;
  • Design and develop database for computer system projects;
  • Build operational and technical documentation;
  • Plan maintenance, changes, growth plan (planning capacity), improve settings and performance;
  • Optimized and develop the requests;
  • Implement and maintain database security (create and maintain users and roles, assign privileges);
  • Report on operations and system improvements through the proactive monitoring and troubleshooting of corporate applications;
  • Participate in design discussions for new systems or for updating current systems;
  • Work with business intelligence teams in the production of operational and financial reports;
  • Establish installation, maintenance and enhancement standards (for databases);
  • Collaborate in the development, testing and revision of the recovery plan.

Profile

  • Ability to delve into details when required or summarize effectively to facilitate decision-making;
  • Current with the latest trends in your field;
  • Strong organizational skills and a great ability to manage time effectively;
  • Excellent problem-solving skills;
  • Work ethic, concern for quality and high sense of responsibility.

Professional Requirements

 

  • Bachelor's degree in Computer Science or equivalent;
  • 5 to 7 years of experience as a DBA (ideally MS SQL Server 2012 and 2016);
  • Experience in ETL, data warehouse and database development;
  • Experience in performance analysis and SQL query optimization and data structure design;
  • Excellent knowledge of SSAS, SSIS, and SSRS;
  • In-depth understanding of system design and analysis, acceptance testing, user training and performance improvement;
  • Experience in planning capacity and changes;
  • Experience in troubleshooting and resolving database issues such as performance, blocking, deadlocking, log shipping, connectivity and security;
  • Experience in reporting on system operations and enhancements through proactive monitoring and troubleshooting of enterprise applications;
  • Proficiency in French and English, both spoken and written; Spanish an asset.

Company Profile

Innergex Renewable Energy Inc. is a global player with an extensive and growing portfolio of assets in Canada, the United States, France and Chile. The Corporation develops, acquires, owns and operates hydroelectric facilities, wind farms and solar parks exclusively producing renewable energy.

Sustainable development producing positive social, environmental and economic results guides our actions. We are not only proud of the work we do, but also of the way we do it. Our many accomplishments and continued successes are made possible by our outstanding team of employees.

Innergex, a publicly traded corporation, has offices in Longueuil, Vancouver, Lyon and San Diego.

The position could be based at the company's head office located in Longueuil, steps away from the Longueuil - Université de Sherbrooke metro station.

Apply now!

Jobs.ca network

#