Senior SQL Server Database Administrator – Advisory Services at Centrilogic

C
Senior SQL Server Database Administrator – Advisory Services
Centrilogic

Job details

CANTodayRemotevia Himalayas

Use AI to assess how you fit

About this role

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 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 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