On-Prem SQL DBA

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.

Required Skills : Top Requirements: 1. On prem SQL databases 2. Migrations or upgrades of SQL databases 3. Performance troubleshooting, backups, configuration a. All issues might not be SQL issues, since we are still on prem, there could be issues with the network so they need to be naturally thinking of these things 4. PowerShell or T-SQL a. Give script, run script - make tweaks and be able to run the scripts in Powershell, bulk of work is in TSQL versus Powershell

Basic Qualification :

Additional Skills :


Background Check : Yes


Drug Screen : No


Notes :
Selling points for candidate :
Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Blanket Approval Received Client Letter: Will Provide
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :
Master Job Title :
Branch Code :