Senior SQL Server Database Administrator – Advisory Services

Centrilogic · via Himalayas ·

TypeFull-time job
LocationCanada
Posted1 hour ago
Senior SQL Server Database Administrator – Advisory Services
Purpose
As part of the Advisory Services organization, the role of the Senior SQL Server Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance to our clients. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and sustainment of multiple clients on various SQL Server versions ensuring operational readiness (security, health, and performance) on clients with SQL Server on premise and/or within Azure or AWS. Must be capable of working independently and collaboratively.
Primary Duties and Responsibilities
Continuous engagement with the assigned client

Ensure continuous communications in a consultative approach

Install and maintain the performance of database

Develop processes for optimizing database

Set and maintain database

Manage database

Performance tuning of database

Install, upgrade, and manage database

Diagnose and troubleshoot database

Recommend and implement emerging database

Create and manage database reports, visualizations, and

Create automation for repeating database

Be available for on-call

Consult on additional

Review operational

Advise sales resources on current and future opportunity possibilities within their assigned client base.

Build a knowledge base, document, and develop standard operation procedures

for each customer’s SQL Server Architecture.

Uphold company policies and

Perform additional related responsibilities as

Required Experience & Skills
Minimum 6 years MSSQL Database Administration (DBA)

Hands-on experience supporting large database

Proven experience with database replication techniques, complexities, automation, monitoring, and high-availability strategies--use of 3rd party solutions in these techniques is encouraged.

Previous experience working with Systems Admins in the areas of storage, backups, and database operations processes preferred.

Excels in a collaborative environment and is willing to own all database related

Experience with SSRS, SSIS, and

Professional Azure and AWS database administration:

Migrate SQL Server databases to SQL

Provision SQL Server

Backup and restore SQL

Implement high availability and disaster

Monitor and optimize the performance of cloud

Essential Functions

Design, document, and monitor the database

Develop standards and procedures for maintenance and modification of database

Provide systems architecture guidance in creating high availability

Provide direction in capacity planning, performance improvement, and storage management in partnership with other client and internal resources.

Plan and support the implementation of major architectural

Develop back-up and recovery procedures, including testing back-ups and data

Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of issues.

Assist Business functions on delivery of timely business metrics

Assist the company in developing a data driven business

Originally posted on Himalayas
database-administrator sql-server-database-administrator database-engineer
Apply on Himalayas →

Job sourced from Himalayas. Applications happen directly on the original platform — we never collect your data.