Apply now »

Specialist, Database Administrator

 

  • Req ID: 97412
  • Department: Information Services
  • Job Type: Full-Time
  • Position Type: Non-Union
  • Location: Calgary, Alberta
  • Country: Canada
  • % of Travel:
  • # of Positions: 1
  • Job Grade: 4
  • Job Available to: Internal & External
  • Deadline to apply: 09/30/2022

 

Canadian Pacific is a transcontinental railway in Canada and the United States with direct links to major ports on the west and east coasts, providing North American customers a competitive rail service with access to key markets in every corner of the globe. CP is growing with its customers, offering a suite of freight transportation services, logistics solutions and supply chain expertise. Visit cpr.ca to see the rail advantages of CP.

 

PURPOSE OF THE POSITION

  • The Database Administrator is responsible for providing operational database services to CP;
  • Some of the primary responsibilities of this role include setup and install, configure, monitor, patch, optimize, protect, improve, and ownership of database systems;
  • Also included is the tracking and resolving of database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g. database backups, maintenance and monitoring) to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with other teams to come up with strategic solutions to recurring problems;
  • This role also provides a focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with internal projects and application sustainment teams to keep them updated with status of their requests, initiates and performs changes on production systems and proactively escalates any issues that cannot be resolved within the established timeframes.

 

POSITION ACCOUNTABILITIES

  • Review service related reports (e.g. database backups, maintenance, monitoring) to ensure service related issues are identified and resolved within established SLAs;
  • Respond to database related alerts and escalations and work with database vendors to come up with strategic solutions to recurring problems;
  • Provide operational support for our Database Management Systems;
  • Develop database management tools and utilities and monitor DBMS infrastructure to ensure continued operation against availability and performance service targets;
  • Analyze and sustain capacity and performance requirements;
  • Execute demand and capacity management processes to ensure that the infrastructure can meet upcoming project and organic growth demand;
  • Assist project teams in the proper design and implementation of the database solutions;
  • Develop or participate in database upgrades and patching;
  • Participate in Business Continuity services for Disaster Recovery;
  • Participate in providing 7x24 database supports;

 

POSITION REQUIREMENTS

  • University degree or equivalent in Engineering, or Computer Science is required;
  • 9+ years of Oracle and 3+ years of DataGuard setup and maintenance working experience;
  • Some hands on experience with SQL Server database administration work
  • Working experience with DB2LUW, Sybase or Informix would be an asset;
  • Ability to analyze and troubleshoot performance issues;
  • Good hands on skills on OEM;
  • Good organizational and planning skills, results oriented;
  • Ability to communicate effectively;
  • Must be a good team player;
  • Good shell scripting skills;
  • Good drill down ability;
  • Willing to learn/take up new database technologies;

 

WHAT CP HAS TO OFFER: 

  • Flexible and competitive benefits package
  • Competitive company pension plan
  • Employee Share Purchase Plan
  • Performance Incentive Program 
  • Annual Fitness Subsidy

 

ADDITIONAL INFORMATION: 

As an employer with national presence, the possibility does exist that the location of your position may be changed based on organizational requirements.

 

Background Investigation:

The successful candidate will need to successfully complete the following clearances:    

  • Criminal history check
  • Reference check

 

Management Conductor Program:

Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CP. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.

 

CP is an equal opportunity employer committed to the principles of employment equity and inclusion. We welcome applications from all qualified individuals. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act ("PIPEDA").

Apply now »