SQL Server DBA - Lorven Technologies Inc.

Skills

PowerShell SQL Monitoring Operating Systems Windows Database Management SQL Server Azure

Job Specifications

Our client is looking SQL Server DBA for Long Term project in Montreal, QC (Onsite) Below is the detail requirement.
Job Title: SQL Server DBA
Location: Montreal, QC (Onsite) Face to Face Interview Required
The Database Administrator will:
Be a hands-on Database Administrator responsible for the design, maintenance, integration and operational support for the MSSQL environment SQL Server 2016/2019/2022
SQL Server DBA with strong azure cloud knowledge
Continuously monitor performance of SQL server, application and scheduled job performance and work to improve performance as well as establish performance baselines.
Provide high-level database support and guidance to both the Development and Infrastructure teams.
Troubleshoot and provide advice on SQL Server performance issues and be able to work with application developers and provide recommendations.
Ability to work in shifts to provide operations support.
Maintains quality of service by establishing and enforcing organization standards.
Own, resolve, and track all database incidents and requests across production, UAT, and development environments.
Be responsible for ensuring data consistency and integrity across all database systems.
Work closely with other IT resources (e.g. Windows Engineering team, Network Administrators) to create and implement new applications and technologies
Implement and support production changes adherent to the change management/ release process
Manage, design and implement backup, recovery, and high-availability processes for all database systems
The ideal candidate will have:
8 - 10 years of Database Administration experience, preferably in financial services
A demonstrated proficiency in supporting the database platform of a large organization.
Flexibility to support the operations of our businesses 24/7
A bachelor's degree in computer science / Information Technology or equivalent experience
Experience in SQL 2016/2019/2022 database management and related products from Microsoft including PowerShell, Windows 2016/2019/2022 Server and
desktop operating systems.
Prior experience with SQL Clustering, Strong Transact-SQL & SQL Server Reporting Services (SSRS) and SQL Server Integration Services
(SSIS) knowledge, Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Database capacity planning, and Users
and Role creation and monitoring.
Ability to quickly troubleshoot and resolve complex problems in a live environment.
Excellent interpersonal skills and ability to articulate complex ideas and solutions to users.
Expert knowledge and in-depth experience with the Microsoft platform and the following technologies:
Self-motivation with the ability to work independently and as a strong team player.

About the Company

Lorven Technologies, Inc. is a highly recognized provider of professional technology consultancy in the US. We provide high quality and cost effective strategic solutions to our clients supported by superior staffing and training services. We offer a wide range of services in the areas of analysis, design, development and maintenance of various information systems. Lorven excels in providing talented, dedicated, and knowledgeable professionals with proven industry experience to our clients. We are committed to building lo... Know more

Related Jobs

Company Name: Quantum World Technologies Inc.
Job Title: Site Reliability Engineer

Company Name: Quantum World Technologies Inc.
Job Title: DB SRE – MSSQL & Azure (Techno-Managerial)

Company Name: Tanisha Systems, Inc
Job Title: Very Urgent Openings- DB SRE – MSSQL & Azure (Techno-Managerial at Toronto / Greater Ontario Area (Hybrid)

Company Name: VLink Inc
Job Title: SQL Database Developer