Junior Database Administrator Job at OCS
About Us
The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler to authorized private retail stores.
Working at the OCS is a unique opportunity to be part of an agile start-up in a ground-breaking new industry. We’re a diverse team passionate about delivering a great customer experience, working together with mutual respect and building value out of our differences. We’re an inclusive organization that understands that delivering great results comes out of ensuring every voice is heard.
About the Role
We are looking for a Junior Database Administrator to join our team! In this role, you will be responsible for administering the Microsoft Azure database environments including the SQL Server database. You will manage multiple product lifecycle environments, overseeing their status from development to mission-critical production systems.
As Junior Database Administrator, you will configure and maintain database servers and processes including monitoring the health of the system and overall performance. In this role, you will account for any inefficiencies and mitigate issues as needed ensuring that high levels of performance are met as well as security of all systems.
This is a great opportunity to utilize your strong ability to plan and key attention to detail to support mission critical environments on a dynamic IT team.
About Your Day
City: Toronto, ON
Employment Type: Permanent full time
Required Travel: none
We are committed to providing an accessible, equitable and inclusive candidate and employee experience. We provide reasonable accommodation throughout the recruitment process and in employment. If you require an accommodation, please let us know, we will work with you to meet your needs
Please Note :
nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.
The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler to authorized private retail stores.
Working at the OCS is a unique opportunity to be part of an agile start-up in a ground-breaking new industry. We’re a diverse team passionate about delivering a great customer experience, working together with mutual respect and building value out of our differences. We’re an inclusive organization that understands that delivering great results comes out of ensuring every voice is heard.
About the Role
We are looking for a Junior Database Administrator to join our team! In this role, you will be responsible for administering the Microsoft Azure database environments including the SQL Server database. You will manage multiple product lifecycle environments, overseeing their status from development to mission-critical production systems.
As Junior Database Administrator, you will configure and maintain database servers and processes including monitoring the health of the system and overall performance. In this role, you will account for any inefficiencies and mitigate issues as needed ensuring that high levels of performance are met as well as security of all systems.
This is a great opportunity to utilize your strong ability to plan and key attention to detail to support mission critical environments on a dynamic IT team.
About Your Day
- Manage and administer Azure database environments of 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
- Administer Azure SQL DB, Azure SQLDB for MySQL, Azure CosmosDB and any related components
- Manage and maintain Azure Data factory resources
- Routinely refine and automate regular processes, track issues, and document changes
- Manage and ensures compliance with database backup strategies
- Troubleshoot system problems as they arise and ensure system problems are documented
- Analyze and implement optimization enhancements in databases using Log Analytics and Intelligence performance within Azure
- Deployment of projects and solutions into production Azure database resources
- Completed Post-Secondary education in Computer Science, Information Technology or related areas OR equivalent combination of education and experience
- 2+ years of experience of MS SQL Server production support in a mission critical environment, Microsoft Azure SQL DBs
- Experience managing, monitoring and deploying Azure SQLDB
- Experience with analysis and tuning of T-SQL queries to improve performance
- Familiarity with basic server troubleshooting in a Microsoft Azure environment
- Working knowledge of Azure Data Factory, Azure CosmosDB and PowerShell Automation is an asset.
- Ability to plan and problem solve in a fast paced, dynamic environment
- This position offers a Hybrid work schedule. You will be required to be in the office a minimum of 1 day each week, with the ability to work from home for the remaining workdays (subject to specific business needs requiring office attendance).
- When working from home, a reliable internet connection is required. Remote work is supported with cloud-based applications and collaboration tools (i.e., MS Teams)
City: Toronto, ON
Employment Type: Permanent full time
Required Travel: none
We are committed to providing an accessible, equitable and inclusive candidate and employee experience. We provide reasonable accommodation throughout the recruitment process and in employment. If you require an accommodation, please let us know, we will work with you to meet your needs
Please Note :
nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.