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.

Java Web Developer

Toronto
Job Order: CP-6825
Responsibilities Deliver exceptional client results and project success. Learn our client's business, their organization, systems, challenges and goals. Work directly with the client to define and clarify requirements. Work with your team to create accurate project and task estimates. Consistently develop and deliver high-quality, low-defect features on schedule....
DATE POSTED 2016-03-30

Backend Team Lead, IT Operations

Montreal
Job Order: MM-6991
Job Description: Provide technical expertise and guidance to his team; Acts as an internal expert resource in the exchange of technical information for project teams, and provides technical insight and recommendations to the business; Grow team expertise to meet demand and to support technology direction; always look for ways to enhance value delivered; Lead, coordinate and participate in key...
DATE POSTED 2018-09-05

Virtualization and Storage Administrator (VMware)

Montreal
Job Order: MM-6992
Job Description: Manage and maintain the company’s VMware environment.  Utilizes VMware best practices along with capacity and problem management to anticipate load changes, with an eye to maximizing hardware utilization in all environments; Monitor and analyze trends in system to identify issues before they create an impact to the production environment; Alert and resolve any...
DATE POSTED 2018-09-05
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.