Skip to main content

DBA-Microsoft SQL Server and Azure SQL Managed Instance

Technology
Brampton, CanadaCAD 60 - CAD 61 /hora2 months ago
Service contract

Job description

MS SQL Managed Instance DBA - (Azure SQL MI, SQL Server DBA, Database Developer, T-SQL, SSIS, SSRS, Azure Data Factory, Always On, Performance Tuning, Azure SQL Managed Instance, Java, Spring Boot, REST API, Microservices, Azure DevOps, Database Migration)

Brampton, ON - Hybrid (2-3 Days WFO)

6-12 months

Skills: SQL Server Database Administration

Experience Required: 8-10

Role Descriptions

Key Responsibilities

Database Administration- 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 DevelopmentDesign 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).

Essential Skills

Required Skills

7 years of SQL Server DBA and Database Development experience.

Strong expertise in: oAzure SQL Managed Instance (SQL MI)| T-SQL Programming oQuery Optimization & Performance TuningoSSIS| SSRS| Azure Data Factory oDatabase 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 SkillsExperience 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.

Keywords
monthsOfExperience: 84Spring FrameworkMicrosoft SQL ServerCloud computingDevOpsPowershellSqlApache SynapseJavaCI / CDReplicationGitCI/CD

Interested in this role?