07 Oct
|
apptoza
|
Brampton
Job Overview
Job Description: 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 Development Design 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).Collaborate with application teams to ensure database design follows best practices.
[Amir Raouf...per Resume | PDF]| [Milind_Soni_Resume | Word]Java / Spring Boot Development Develop| enhance| and support Java-based applications using Spring Boot.
- Build REST APIs and microservices supporting enterprise applications.
- Integrate Spring Boot applications with SQL Server and Azure SQL MI databases.
- Participate in application troubleshooting| performance optimization| and production support.
- Support CI/CD deployments and development best practices.(Spring Boot experience is desirable but not the primary focus of this role.)
Essential Skills: Required Skills
- 7+ years of SQL Server DBA and Database Development experience.
- Strong expertise in:
- oAzure SQL Managed Instance (SQL MI)| T-SQL Programming
- oQuery Optimization & Performance Tuning
- oSSIS| SSRS| Azure Data Factory
- oDatabase Security & Monitoring2+ years of Java and Spring Boot development experience.
- Experience with REST APIs and Microservices.
- Exposure to Azure DevOps| Git| and CI/CD pipelines.
- Solid troubleshooting and problem-solving skills.
Preferred Skills
- Experience with Azure cloud services and database migrations.
- Knowledge of Power BI| Databricks| or Synapse.
- PowerShell scripting and automation experience.
- Azure or Microsoft SQL certifications preferred.
Desirable Skills:
Pay: $60.00-$65.00 per hour
Work Location: Hybrid remote in Brampton, ON
📌 MS SQL Managed Instance DBA (Brampton)
🏢 apptoza
📍 Brampton