SQL Server DBA
2 hours ago
Winnipeg, Manitoba, Canada
Astra-North Infoteck Inc.
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Key Skills: T-SQL +Azure SQL MI, Performance Tuning + Always On + HA/DR + Backup/Recovery + SSIS +ADF
Brampton, ON - Hybrid(3 Days WFO)
Role Descriptions: Key Responsibilities
Administer 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 Development
Design 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 Skills
7+ years of SQLServer DBA and Database Development experience.
Query Optimization& Performance Tuning
2+ 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 Skills
Experience withAzure cloud services and database migrations.
Knowledge of PowerBI, Databricks, or Synapse.
PowerShellscripting and automation experience.
Azure or MicrosoftSQL certifications preferred.
Brampton, ON - Hybrid(3 Days WFO)
Role Descriptions: Key Responsibilities
Administer 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 Development
Design 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 Skills
7+ years of SQLServer DBA and Database Development experience.
Query Optimization& Performance Tuning
2+ 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 Skills
Experience withAzure cloud services and database migrations.
Knowledge of PowerBI, Databricks, or Synapse.
PowerShellscripting and automation experience.
Azure or MicrosoftSQL certifications preferred.