Job Information
Rogers Database Administrator in Toronto, Ontario
Database Administrator
Our Technology team wakes up every day with one goal in mind - connecting Canadians to the people and things that matter most. Together, we are proud to support 30 million Canadians each month through managing a robust portfolio that champions leading-edge technology. We drive large-scale, complex, and high-visibility technology projects and programs that shape the future of technology in Canada and expand connectivity from coast to coast. If you are interested in being a part of this, consider applying for the following opportunity:
Reporting to the IT Manager, the Database Administrator shall be responsible for build and administration activities within a fast moving, complex environment. The role oversees solutions and delivery of SQL Server, MariaDB, PostGreSQL, and emerging database technologies. In this position you will require strong technical skills coupled with the ability to work in a fast-paced environment managing diverse activities in our North York Head Office.
What you will be doing:
Provide enterprise design, and administration of our SQL Server platforms encompassing various versions from MS SQL 2000 through 2019, as well as open-source platforms such as MariaDB.
Collaborate with various departments to develop new and optimize existing SQL code to ensure optimal application performance and a positive-end user experience.
Adhere to best practices for database design, performance, and security, including user management and database access
Optimize and improve data and system security through encryption and other emerging technologies
Troubleshoot complex issues, promote efficiency, and identify opportunities for process automation
Monitor Comwave’s database and related systems infrastructure using native and third-party tools such as Idera.
Build and maintain database disaster recovery plan and related documentation
Provide Incident, Problem management support and implement infrastructure/database changes.
Provide 24/7 emergency support for the SQL platforms
Staying abreast with new database technologies and analyzing such technologies to bring into scope of existing infrastructure.
Other duties as assigned
What you bring to the team:
10 years’ experience working in SQL Server versions 2000-2019
Experience in setting up and maintaining SQL Server replication, clustering and other high availability solutions
Advanced Experience working with Complex T-SQL queries and triggers
In depth knowledge of SQL backup and disaster recovery solutions
Advanced experience in SQL Server monitoring with knowledge of third-party database monitoring tools such as Idera Diagnostic Manager
Database performance tuning experience including troubleshooting complex SQL procedures and query optimization
Scripting experience in PERL, Python, or Shell Scripting experience in PERL, GoLang Python, or Shell
PostGreSQL and MariaDB administration experience
Advanced knowledge of permissions with a focus on security
Excellent verbal and written communication skills
Excellent documentation skills
The ability to work evenings and weekends as required
Nice to have:
Experience as a developer
Exposure to SAP Data warehousing
Database Administration Certification
*Please note that the selected candidate is required to successfully complete a background check.
Schedule: Full time
Shift: Day
Length of Contract: Not Applicable (Regular Position)
Work Location: 61 Wildcat Road (7883), Toronto, ON
Travel Requirements: None
Posting Category/Function: Technology & Database Development
Requisition ID: 311497
At Rogers, we believe the key to a strong business, is a diverse workforce where equity and inclusion are core to making everyone feel like they belong. We do this by embracing our diversity, celebrating our different perspectives, and working towards creating environments that empower our people to bring their whole selves to work. Everyone who applies for a job will be considered. We recognize the business value in creating a workplace where each team member has the tools to reach their full potential by removing any barriers for equal participation. We work with our candidates who are experiencing a disability throughout the recruitment process to ensure that they have what they need to be at their best. Please reach out to our recruiters and hiring managers to begin a conversation about how we can ensure that you deliver your best work. You matter to us! For any questions, please visit the Recruitment Process FAQ (https://performancemanager4.successfactors.com/doc/custom/RCI/Recruitment_Process-FAQ-EN.pdf) .
Successful candidates will be required to complete a background check as part of the hiring process.
Posting Notes: Technology
Location:
Toronto, ON, CA
Being a Rogers team member comes with some great perks & benefits including:
· Health & well-being benefits
· Donation matching
· Paid time off for volunteering
· Wealth Accumulation including: Pension plan & Employee stock options
· Generous employee discounts
· Leadership development, Mentorship, and Coaching programs
*available for full-time and part-time permanent employees, some restrictions apply
Looking for career guidance and inspiration?
Catch up on the latest episodes of For the Love of Work (https://fortheloveofwork.ca/) podcast with Dr. Sonia Kang.