Logo for Centrilogic

Senior SQL Server Database Administrator – Advisory Services

Role overview

Summary

The role is for a Senior SQL Server Database Administrator within the Advisory Services organization, responsible for the implementation and maintenance of SQL Server systems. You will work with multiple clients to ensure operational readiness and performance of their databases, both on-premise and in cloud environments.

Qualifications

  • Minimum 6 years MSSQL Database Administration (DBA)
  • Hands-on experience supporting large databases
  • Proven experience with database replication techniques and high-availability strategies
  • Professional Azure and AWS database administration
  • Preferred: Experience with SSRS and SSIS

Responsibilities

  • Engage continuously with assigned clients
  • Install and maintain database performance
  • Develop processes for optimizing databases
  • Create and manage database reports and visualizations

Key facts

Hard skills

Key skills for this role

Other skills

  • Communication
  • Collaboration
  • Problem Solving

About the company

Centrilogic logo

Centrilogic

  • IT Services & Consulting
  • 51–200
Centrilogic is a global provider of IT transformation solutions that empower organizations to realize their digital potential. Armed with capabilities that span the stack – from multicloud management to next-gen applications and strategic services – Centrilogic delivers resilient end-to-end digital solutions that help companies reshape the role of their technology platforms as business-driving assets. With regional headquarters in Canada, USA, and the United Kingdom, Centrilogic delivers solutions to innovative companies worldwide.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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

Related jobs

See all Database Administrator jobs

Other jobs at Centrilogic