SQL Server DBA

Role: SQL Server DBA

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.

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:

Azure SQL Managed Instance (SQL MI) T-SQL Programming

Query Optimization & Performance Tuning

SSIS SSRS Azure Data Factory

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.