SQL Server DBA

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Brampton; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Astra-North Infoteck Inc. in Brampton, ON is seeking a senior SQL Server DBA and Database Developer to administer and optimize Microsoft SQL Server and Azure SQL MI environments.

You will implement HA/DR, performance tuning, backups, and monitoring, develop T-SQL objects, ETL with SSIS and ADF, and collaborate with application teams to ensure robust data solutions and secure databases. Experience with Spring Boot integration and REST APIs is a plus.

Qualifications

• 7+ years of SQL Server DBA and Database Development experience.
• Azure SQL Managed Instance (SQL MI), T-SQL Programming
• Query Optimization & Performance Tuning
• Database Security & Monitoring
• 2+ years of Java and Spring Boot development experience.
• Experience with REST APIs and Microservices.
• Exposure to Azure DevOps, Git, and CI/CD pipelines.
• Strong troubleshooting and problem-solving skills.

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.
• Spring Boot experience is desirable but not the primary focus of this role.

Skills

T-SQL

Azure SQL MI

Performance Tuning

Always On

HA/DR

Backup/Recovery

SSIS

ADF

Tools

Azure DevOps

Git

CI/CD pipelines

Power BI

Databricks

Synapse

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

Required Skills

• 7+ years of SQL Server DBA and Database Development experience.
• Azure SQL Managed Instance (SQL MI), T-SQL Programming
• Query Optimization & Performance Tuning
• Database Security & Monitoring
• 2+ years of Java and Spring Boot development experience.
• Experience with REST APIs and Microservices.
• Exposure to Azure DevOps, Git, and CI/CD pipelines.
• Strong 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.