SQL Server DBA

Astra-North Infoteck Inc.

Brampton

Hybrid

CAD 90,000 - 120,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Astra-North Infoteck Inc. is looking for an experienced SQL Server DBA and Database Developer in Brampton, ON, with hybrid work arrangement (3 days in-office). You will administer SQL Server and Azure SQL MI, implement HA/DR, monitor performance, and support ETL processes with SSIS and ADF.

Java/Spring Boot development exposure is a plus. Ideal candidates have 7+ years of DBA experience, strong query optimization skills, and experience with REST APIs and microservices.

Qualifications

  • 7+ years of SQL Server DBA and Database Development experience.
  • Query Optimization & Performance Tuning.
  • 2+ years of Java and Spring Boot development experience.
  • Experience with REST APIs and Microservices.

Responsibilities

  • 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.
  • 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.
  • 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.

Skills

T-SQL
Azure SQL MI
Performance Tuning
Always On
HA/DR
Backup/Recovery
SSIS
ADF
Java
Spring Boot

Tools

Azure DevOps
Git
CI/CD pipelines

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Database Administrator
SQL Database Administrator

CloudVital • Vancouver

Hybrid
CAD 90,000 - 130,000
Technical Lead - SQL DBA, SQL Server & Database Administration
Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc. • Vancouver

On-site
CAD 120,000 - 180,000
Database Administrator (MS SQL/Azure)
Database Administrator (MS SQL/Azure)

HRBrain Inc. • Toronto

On-site
CAD 96,000 - 107,000
L3 MSSQL and Azure DBA(Need local candidate to Montreal, QC)
L3 MSSQL and Azure DBA(Need local candidate to Montreal, QC)

Q1 Technologies, Inc. • Montreal

On-site
CAD 120,000 - 150,000
SQL DBA
SQL DBA

Info-Ways • Brampton

On-site
CAD 80,000 - 100,000
MS SQL Server Developer
MS SQL Server Developer

Astra-North Infoteck Inc. • Toronto

On-site
CAD 110,000 - 150,000
SQL Database Administrator
SQL Database Administrator

HCL Technologies Limited • Calgary

On-site
CAD 100,000 - 130,000
Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 95,000 - 130,000
Senior Azure SQL & MSSQL DBA - Performance, HA & Automation
Senior Azure SQL & MSSQL DBA - Performance, HA & Automation

Q1 Technologies, Inc. • Montreal

On-site
CAD 120,000 - 150,000
Database Administrator
Database Administrator

JPS Tech Solutions • New Brunswick

On-site
CAD 90,000 - 120,000