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

Network Administrator (LAN/WAN)

Montreal
Job Order: MM-6995
 Job Description: Anticipate, mitigate and resolve network issues;  Participate in the planning, design and support of enterprise Core, LAN and WAN infrastructure; Participate in team meetings, project planning and needs analysis; Ensure all communication infrastructure is monitored; Conduct and execute LAN infrastructure assessments and upgrades; Identify opportunities to reduce...
DATE POSTED 2018-11-12

Jr. Developer/Database Administrator

Vaughan, Ontario
Job Order: SK-6996
Job Responsibilities: Participate in planning sessions with division BU leaders and stakeholders to gather technical and process flow requirements. Perform translation into design documentation Technical resource to all team members within I.S. and I.T. Translate functional specifications into detailed design documents and participate in technical solution sessions Identify internal/external...
DATE POSTED 2018-11-12
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.