MS SQL Managed Instance DBA - (Azure SQL MI, SQL Server DBA, Database Developer, T-SQL, SSIS, SSRS, Azure Data Factory, Always On, Performance Tuning, Azure SQL Managed Instance, Java, Spring Boot, REST API, Microservices, Azure DevOps, Database Migration)
Brampton, ON - Hybrid (2-3 Days WFO)
6-12 months
Skills: SQL Server Database Administration
Experience Required: 8-10
Role Descriptions
Key Responsibilities
Database Administration- Administer and support Microsoft SQL Server and Azure SQL Managed Instance environments.
Monitor database performance| availability| security| and capacity.
Implement and manage HA/DR solutions including Always On Availability Groups| replication| backup| and recovery.
Perform database patching| upgrades| migrations| and maintenance activities.
Troubleshoot production issues related to performance| locking| blocking| and connectivity.
Database DevelopmentDesign and develop T-SQL objects including Stored Procedures| Functions| Views| and Triggers.Optimize SQL queries| indexing strategies| and execution plans.Develop and support ETL processes using SSIS and Azure Data Factory (ADF).
Essential Skills
Required Skills
7+ years of SQL Server DBA and Database Development experience.