On-Prem SQL DBA

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 18 Month(s)

Skills

On prem SQL databases
PowerShell or T-SQL
Performance troubleshooting
backups
configuration
Give script
run script
Performance Analysis

Job Details

Position: On-Prem SQL DBA

Location: Charlotte, NC or Maryland Heights, MO

  • 4x/week onsite and 1 remote of their choice

Contract Length: Through End of Year with likelihood to extend

  • Usually up to 18 months

Top Requirements:

  1. On prem SQL databases
  2. Migrations or upgrades of on-prem SQL databases
  3. Performance troubleshooting, backups, configuration
    1. All issues might not be SQL issues, since we are still on prem, there could be issues with the network
  4. PowerShell or T-SQL
    1. Give script, run script - make tweaks and be able to run the scripts

Day to Day Responsibilities/project specifics: This person would be responsible for on-prem to on-prem SQL upgrades - the team upgrades about 3,000 DBs per year to ensure EOL versions stay functioning. Additionally, the team builds out new SQL environments. The team does have a deadline to decommission a large environment by the end of November and thus part of the role will also include decommissioning the legacy environment until that November goal is met.

The role would include gathering requirements, submitting a build request for another team to build and then ensuring what was delivered was what was requested. Once complete, this person will create a run plan with the application team to outline what needs to be migrated (it s not always the entire environment).

Once agreed upon, this person would be responsible for installing/configuring SQL. This environment is entirely on-prem and thus patching, back ups, performance analysis as well as troubleshooting capabilities are extremely important. Additionally, a strong awareness of operating environments is required there may be hard drive rewrite latencies impacting environments, networks impacting performance, etc. and thus a strong ability to write SQL queries is required.

The team is seeking someone that can work on multiple projects at once as this is a fast paced environment.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.