Menu Close Menu
Français
Shaw Communications
Printer friendly interface

Senior Database Analyst

Department name: Information Technology
Business unit: TOPS
Position ID: J0421-0272

A little about us

What we do at Shaw matters - in a world where being connected has never been more critical, we bring the best wireline and wireless technology and solutions together to create exceptional customer experiences. Every day we help millions of Canadians live their best-connected lives through the strength, capacity and combined power of our Fast LTE and Fibre+ networks.

At Shaw we say we’re brighter together, and we believe it’s the diverse mix of brilliant people here that really makes us shine. When you join our team, you’ll see we are so much more than just a company. Shaw connects you with limitless opportunity, an incredible culture, career development and a great benefits package. We are a friendly, collaborative group, and we have a lot of fun finding new ways to delight our customers.

Come dream bigger and brighter with Shaw.

The role

As a Senior Database Analyst, you will join the Enterprise Services, Technology & Network - Database Technologies Team at Shaw. The Senior DBA position will be responsible for maintaining the company’s database systems such as MS SQL Server and Oracle. In this role, the successful candidate will be responsible for maintaining the integrity and the performance of the company databases and guarantee the data is stored securely and efficiently. This role requires ability to work in various projects with team members from multiple disciplines as well to be involved in the planning and development of the database systems in a complex environment.

A typical day

• Manage Oracle/SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability (Windows Failover Cluster, Always-On, Oracle RAC), and security.
• Ability to automate repetitive tasks by using PowerShell, PHP and other scripting tools.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Ensures strategic design, implementation, and documentation of current and future projects within Database environments.
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• All other duties as required.

Your skills/experience

• 5+years MS SQL Server, 2+ years Oracle Database administration experience required.
• Good knowledge & experience on Cloud Computing like Azure/Oracle Cloud Infrastructure/WS.
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience with backups, restores and recovery models.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) for SQL Server and Oracle.
• Experience working with Windows/Linux servers, including PL/SQL/T-SQL and PowerShell/Shell.
• Knowledge and adherence to ITIL best practices for execution of Incident/Request/Change Management.
• Excellent written and verbal communication.
• Team player, great interpersonal and communication skills
• Ability to organize and plan work independently.
• Ability to work in a rapidly changing environment.
• Ability to multi-task and context-switch effectively between different activities and teams.
• MCTS, MCITP, OCP certifications would be considered an asset.

Other details

• This position requires the successful completion of a criminal (and credit) background check.
• This role is not location-specific.
• Applicants will be hired in any Shaw or Freedom Mobile location and will not be required to relocate for this role.

Posting closing date: May 17, 2021

Shaw Communications, through its third-party vendor, collects and stores information applicable to the candidate profile you create when you submit the information asked for below. The use and disclosure of the collected information is for the sole purpose of job search and placement activities for Shaw Communications. The information is subject to Personal Information Protection and Electronic Documents Act. The information will be retained and when disposed of, it is done so in a secure manner. Your profile will become inactive and moved to the archive if you do not access your profile for a period of 1 year.

We thank all applicants for their interest; however, only selected candidates will be contacted. No telephone calls or agencies, please.