MS SQL Database Administrator - Remote / Telecommute

MS SQL Database Administrator - Remote / Telecommute

Cynet Systems
  • Nashville, TN, United States

Description

Job Description:
• Scope of work that they will be supporting.
• Maintaining SQL server 2016 and 2019 Always on Cluster and standalone servers.
• Monitoring Replication performance and maintaining replication on Production servers and lower environments.
• Creating task scheduler jobs and monitoring logs of production jobs.
• Working on performing Database Integrity Checks, Database Maintenance plans, updating Database Statistics and performing Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Monitoring Redgate alerts and resolving if there are any blockings, server waits or long running queries.
• Monitor windows cluster logs and identify if there are any issues.
• Working on ServiceNow tickets to resolve user access issues or data copy requests from one environment to another through Red Gate Schema compare and Data compare tools.
• Maintaining Security on database servers through SECURE.
• Production deployments support after business hours.
• Resolve any performance slowness issues in production and stage environments.
• Create and maintain reports on performance and growth of databases in production.
• Set up alerts and notifications if there are any login failures and if there are any replication job failures.
• Maintain indexes and resolve slowness issues. Experience:
• 8+ years. Skills:
• Core skill sets Hiring Manager is looking for:
• Microsoft certified SQL Server consultant with experience in MS SQL Server 2019/2017/2014/2012.
• Technologies:
• Extensive experience in managing both standalone and Replication, clustered and Always on Environment.
• Experience in upgrading SQL Server databases SQL 2012, 2014, 2016 to 2019 and setting up failover cluster.
• Expertise in core DBA (Database Administrator) tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing.
• Installing and Configuring SSRS (SQL Server Reporting Services) in SQL Server 2016 and 2019.
• Expert level experience on Data Center Migrations and Server Consolidation.
• Proven experience in maintenance of SQL Server in a VLDB environment (Databases size1.5 to 2TB) & experience in troubleshooting and resolving problems.
• Extensive experience in managing MS SQL Server on Windows and 2008, 2016 Servers.
• Must have experience in using DMVs, DMFs monitoring, and troubleshooting performance issues.
• Working experience with tools like SQL Profiler, Windows Permanence and Redagate for Monitoring and Tuning MS SQL Server Performance.
• Experience in performing Database Integrity Checks, Database Maintenance plans, updating Database Statistics and performing Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Extensive Experience in RED Gate Installation and configuration on Prod servers.

Responsibilities

  • Scope of work that they will be supporting
  • Maintaining SQL server 2016 and 2019 Always on Cluster and standalone servers
  • Monitoring Replication performance and maintaining replication on Production servers and lower environments
  • Creating task scheduler jobs and monitoring logs of production jobs
  • Working on performing Database Integrity Checks, Database Maintenance plans, updating Database Statistics and performing Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance
  • Monitoring Redgate alerts and resolving if there are any blockings, server waits or long running queries
  • Monitor windows cluster logs and identify if there are any issues
  • Working on ServiceNow tickets to resolve user access issues or data copy requests from one environment to another through Red Gate Schema compare and Data compare tools
  • Maintaining Security on database servers through SECURE
  • Production deployments support after business hours
  • Resolve any performance slowness issues in production and stage environments
  • Create and maintain reports on performance and growth of databases in production
  • Set up alerts and notifications if there are any login failures and if there are any replication job failures
  • Maintain indexes and resolve slowness issues

Qualifications

  • 8+ years
  • Core skill sets Hiring Manager is looking for:
  • Microsoft certified SQL Server consultant with experience in MS SQL Server 2019/2017/2014/2012
  • Extensive experience in managing both standalone and Replication, clustered and Always on Environment
  • Experience in upgrading SQL Server databases SQL 2012, 2014, 2016 to 2019 and setting up failover cluster
  • Expertise in core DBA (Database Administrator) tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing
  • Installing and Configuring SSRS (SQL Server Reporting Services) in SQL Server 2016 and 2019
  • Expert level experience on Data Center Migrations and Server Consolidation
  • Proven experience in maintenance of SQL Server in a VLDB environment (Databases size1.5 to 2TB) & experience in troubleshooting and resolving problems
  • Extensive experience in managing MS SQL Server on Windows and 2008, 2016 Servers
  • Must have experience in using DMVs, DMFs monitoring, and troubleshooting performance issues
  • Working experience with tools like SQL Profiler, Windows Permanence and Redagate for Monitoring and Tuning MS SQL Server Performance
  • Experience in performing Database Integrity Checks, Database Maintenance plans, updating Database Statistics and performing Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance
  • Extensive Experience in RED Gate Installation and configuration on Prod servers

Summary

Job Type : FULLTIME
Category : Database Administrator
Posted : November 16, 2023
Salary : N/A

Share With