Login


New to IMS? Register Now

Forgot Your Password?

Database Administrator (MS-SQL)

Montreal
Job Order: MM-6983

Job Description:

  • Provide Level 3 support on MS-SQL;
  • Detect and troubleshoot SQL Servers related CPU, memory, I/O, disk space and other resource contention;
  • Manage backups, restores, recovery models, database shrink operations, DBCC commands, database mirroring, replication;
  • Work efficiently on indexes, integrity checks, configuration, patching;
  • Work efficiently with SQL Server tools ( Profiler, DTA, SSMS, SSRS, SSIS, SSCM, PerfMon, DMVs);
  • Create, maintain and refresh instances/databases for development and production environments;
  • Act as liaison between application programmers to assist with resolving problems;
  • Follow standards, write, maintain and document monitoring scripts needed in support of databases;
  • Communicate and collaborate effectively with staff of varying technical expertise;
  • Perform On-call hours.

 

Job Requirements:

  • Completed Bachelor degree in computer sciences plus 3 years relevant experience/or combination of college degree with stronger background;
  • Minimum 3 years of experience on MS-SQL Server (2005 and higher) as a database administrator;
  • Minimum 3 years of experience with Windows Server in VM environments;
  • Strong experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues;
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools;
  • Experience supporting 24x7 environments. Provide after hours on-call support for critical database issues.
  • Experience with Oracle and DB2 databases;
  • Knowledge of 3rd party DBA tools and applications ( e.g Redgate, Idera, SCOM );
  • Knowledge in a scripting language like Powershell;
  • Experience/Knowledge of AIX operating system.
  • Effective oral and written communication skills in both official languages;
  • Highly self-motivated, self-directed, and attentive to detail;
  • Proven analytical & problem-solving abilities;
  • Able to prioritize & execute tasks in a high-pressure environment
DATE POSTED 2018-03-20

Shown below are the latest jobs from this category.

System - Network Administrator (JD Edwards Environment)

Burlington
Job Order: MM-7015
Job Descriptions: Responsible for the successful operation, maintenance, configuration and support of the company JD Edward’s environment. Use your analytical skills when recommending upgrade, process improvements and feature deployment as it relates to JD Edwards. The responsibilities include but are not limited to the following:  Operations and Support Maintain the company JD...
DATE POSTED 2019-11-28

Systems - Cloud Engineer

Ottawa
Job Order: MM-7016
Job Descriptions: Lead enterprise end user technology transformation initiatives with Windows 10, Active Directory, Office 365, SharePoint, Exchange, Skype, OneNote, Teams, Azure, MFA, Microsoft Certificate Services, Active Directory, Mobile and end user device management technologies. Deliver advanced troubleshooting and problem-solving solutions to the business, including incident and...
DATE POSTED 2019-12-04

US Payroll Specialist

Montreal
Job Order: MM-7017
Job Descriptions: Collaborate with SAP functional analysts, related systems analysts, corporate IT architects, users and business partners. Work in cooperation with the manager and the company main stakeholders to shape the organization’s BI strategy;   Identify, contribute to and implement improvements to the department’s internal processes so as to improve efficiency[M1] ...
DATE POSTED 2020-01-09

SAP BI Developer

Montreal
Job Order: MM-7018
Job Descriptions: Work in cooperation with the manager and with company main stakeholders to shape the organization’s BI strategy;   Identify, contribute to and implement improvements to the department’s internal processes so as to improve efficiency[M1]  and quality;  Design solutions by considering the business processes of different departments; Take part in the...
DATE POSTED 2020-01-23
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.