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.

Server Administrator

Montreal
Job Order: MM-6997
Job Description: Provide technical expertise and works autonomously; Establish and implement policies, procedures, and technologies to ensure server security; Serve as the cornerstone for escalating server issues; provide timely response to customer escalations; Plan and implement server upgrades, maintenance fixes, and vendor-supplied patches; Monitor and test system performance and provide...
DATE POSTED 2019-04-09

Software Developer

Toronto
Job Order: SE-7003
Job Descriptions:   Designs and develops new software and modifies and enhances existing software for clients’ systems, and for the company base software. Communicates directly with the clients to ensure that requirements and specifications are understood fully. Reviews completed software designs or prototypes with clients. Tests software and ensures that completed work correctly...
DATE POSTED 2019-03-06

Sr. IT Administrator

Markham
Job Order: GD-7007
Job Description: Manage daily IT operations at company headquarters and branch offices including general technical support (Helpdesk support, tele/video conferences, WebEx meetings, photocopier and fax machines, unified communications systems, etc.), data backup/recovery, vendor management, system monitoring and access control. Participate in the development, maintenance, and monitoring of...
DATE POSTED 2019-03-28

EndPoint Infrastructure Administrator

Montreal
Job Order: MM-7008
Job Description: •    Plan and implement end point & server upgrades (SCCM), maintenance fixes, and vendor-supplied patches; •    Establish and implement policies, procedures, and technologies to ensure end point security; •    Monitor and test system performance and provide performance statistics and reports; •  ...
DATE POSTED 2019-04-09
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.