On-Prem SQL DBA

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.