SQL DBA (with Azure) for Full-time & Direct-hire in Mississauga, ON, Canada (Hybrid)

Overview

Hybrid
$120,000 - $130,000
Full Time
Accepts corp to corp applications

Skills

MS SQL Server DBA
Azure
Windows Server
DevOps
SQL query language

Job Details

Skill : MS SQL Server DBA (with Azure)

Location : Mississauga, ON, Canada (Hybrid, 3 days in office)

Duration : Full-time/ Direct-Hire

Should be located in Canada only

 

Position Overview:

The position is responsible for managing, maintaining, and optimizing Microsoft SQL Server and Azure SQL databases within an organization. They play a critical role in ensuring the performance, availability, security, reliability and automation of the database systems. Their duties include database design, installation, configuration, troubleshooting, backup and recovery, performance tuning, security management, and ensuring data integrity.

 

Required Qualifications & Skills:

  • 9-10+ years of experience in IT.
  • 7+ years of experience in design, implementation and support of Microsoft SQL Server in Windows Server environments.
  • Strong experience in design, implementation and support of Azure SQL and proficiency in Azure services. Intermediate to advanced level knowledge of Microsoft Azure.
  • Strong understanding of relational database concepts and SQL query language.
  • Azure DevOps experience.
  • Experience with performance tuning, indexing, and query optimization.
  • Familiarity with backup and recovery procedures, disaster recovery planning, and high availability solutions (e.g., clustering, replication, AlwaysOn).
  • Experience supporting production and pre-production environments across multiple locations and the technologies to support them.
  • Ability to troubleshoot database-related issues and perform root cause analysis.
  • Advanced knowledge of PowerShell working with database environments
  • Excellent communication and collaboration skills for working with cross-functional teams.
  • Understanding of ITIL and SDLC.
  • Bachelor s degree in Computer Science, IT, or a related field; a combination of training and experience may be considered in lieu of degree.
  • Should be located in Canada only.

 

Preferred Skills:

  • Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics (SQL Server).
  • Azure Data Factory (ADF) and Azure Synapse
  • PostgreSQL, and MySQL are a plus.

 

Essential Responsibilities:

  • Collaborate with application developers and system architects to design and implement efficient and scalable database structures.
  • Create and maintain database schemas, tables, indexes, views, and stored procedures.
  • Deploy, manage, automate and secure Azure SQL databases
  • Install, configure, and upgrade on prem Microsoft SQL Server instances, including applying patches and service packs.
  • Configure database settings and options to optimize performance and ensure security.
  • Monitor database performance using built-in tools and third-party monitoring solutions.
  • Identify and resolve performance bottlenecks through query optimization, indexing strategies, and server configuration adjustments.
  • Participate in rotating On-Call coverage or emergency response, as needed.
  • Develop and implement backup and recovery strategies to safeguard critical data.
  • Perform regular backups, test restores, and maintain backup integrity.
  • Develop disaster recovery plans and participate in recovery drills.
  • Implement and enforce security policies and access controls to protect sensitive data.
  • Manage user permissions, roles, and privileges.
  • Monitor for security vulnerabilities and apply security patches and updates.
  • Diagnose and resolve database-related issues, including connectivity problems, performance degradation, and data corruption.
  • Conduct root cause analysis and implement preventive measures to mitigate future incidents.
  • Estimate future database growth and plan for scalability requirements.
  • Optimize resource utilization to accommodate increasing workloads.
  • Maintain accurate documentation of database configurations, procedures, and processes.
  • Generate reports on database performance, availability, and security compliance.

 

Our Company:

We are the preferred Oracle partner in North America with the experience and capabilities to comprehensively support Oracle products from implementation to support. We complement our Oracle expertise with additional competencies to support infrastructure, custom development, integrations, reporting, automation, and much more.

At Vigilant, our mission is to deliver impactful and successful outcomes to companies we serve. Our goal is to develop deep and lasting relationships with the clients we partner with by exceeding expectations, in our innovative solutions, the quality of our services, and the value we deliver.
Please visit our website URL: for more details pertaining to our company.

 

Please share your resume and contact details, if interested.

 

 

Thanks,

P Kumar

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.