19 Nov
|
Astra North Infoteck
|
Brampton
19 Nov
Astra North Infoteck
Brampton
Key Skills: T-SQL +Azure SQL MI, Performance Tuning + Always On + HA/DR + Backup/Recovery + SSIS +ADFBrampton, ON - Hybrid(3 Days WFO)Role Descriptions:Key ResponsibilitiesAdminister andsupport Microsoft SQL Server and Azure SQL Managed Instance environments.Monitor databaseperformance, availability, security, and capacity.Implement andmanage HA/DR solutions including Always On Availability Groups, replication,backup, and recovery.Perform databasepatching, upgrades, migrations, and maintenance activities.Troubleshootproduction issues related to performance, locking, blocking, and connectivity.Database DevelopmentDesign and developT-SQL objects including Stored Procedures, Functions, Views, and Triggers.Optimize SQLqueries, indexing strategies, and execution plans.Develop and supportETL processes using SSIS and Azure Data Factory (ADF).Collaborate withapplication teams to ensure database design follows best practices.Develop,
enhance,and support Java-based applications using Spring Boot.Build REST APIs andmicroservices supporting enterprise applications.Integrate SpringBoot applications with SQL Server and Azure SQL MI databases.Participate inapplication troubleshooting, performance optimization, and production support.Support CI/CDdeployments and development best practices.Spring Bootexperience is desirable but not the primary focus of this role.Required Skills7+ years of SQLServer DBA and Database Development experience.Query Optimization& Performance Tuning2+ years of Javaand Spring Boot development experience.Experience withREST APIs and Microservices.Exposure to AzureDevOps, Git, and CI/CD pipelines.Strongtroubleshooting and problem-solving skills.Preferred SkillsExperience withAzure cloud services and database migrations.Knowledge of PowerBI, Databricks, or Synapse.PowerShellscripting and automation experience.Azure or MicrosoftSQL certifications preferred.
📌 Sql Server Dba (Brampton)
🏢 Astra North Infoteck
📍 Brampton