
SQL/Azure Database Administrator – Apps DBA
TD
full-time
Posted on:
Location Type: Hybrid
Location: Mississauga • Canada
Visit company websiteExplore more
Salary
💰 CA$81,600 - CA$115,200 per year
About the role
- Monitor system lifecycles, ensuring specifications and functionality support business objectives and architecture decisions, undertaking re-development, as required
- Provide Disaster Recovery support by assisting in defining / reviewing disaster recovery plans and by participating in testing
- Assess and analyze optimization opportunities to the operational environment to improve performance and/or resource utilization
- Ensure effective change management discipline is used
- Assist in the maintenance of secure computing facilities and technical infrastructure/architecture to support clients and applications as appropriate
- Adhere to existing processes/standards, business technology architecture, risk and production capacity guidelines; plan, monitor and escalate issues as required
- Follow standards, policies and procedures to ensure compliance with the Disaster Recovery Plan (DRP) and applicable Business Recovery Plans (BRP)
Requirements
- Undergraduate degree or Technical Certificate
- 5-7 years relevant experience
- 5 years Database Administration experience
- Microsoft SQL server experience and skills with T-SQL and SQL scripting
- Strong Azure SQL/Cosmos DB Experience
- Expert performance and tuning skills with Microsoft SQL Server
- Scripting and automation experience with Powershell, Python, Javascript, Unix Shell, Mongo Shell, Ansible
- Experience with Windows Server and Windows Clustering
- Solid understanding of database backup and recovery with Mongo and Microsoft SQL Server
- Experience with Mongo Operations Manager
- Understanding of relational database design concepts and best practices
- Experience installing, configuring, supporting or managing database infrastructure
Benefits
- Health and well-being benefits
- Savings and retirement programs
- Paid time off
- Career development
- Reward and recognition programs
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Database AdministrationMicrosoft SQL ServerT-SQLSQL scriptingAzure SQLCosmos DBPerformance tuningPowershellPythonAnsible
Soft Skills
Change managementAnalytical skillsProblem-solvingCommunicationCollaboration
Certifications
Undergraduate degreeTechnical Certificate