Updated: 2023-09-12

Senior SQL Database Administrator

Chicago

  • Published 3 years ago
  • English
  • Expected start date: ASAP

Assignment Details

We are working with our nonprofit client to find a Sr. SQL DBA. The SQL DBA work under the Director of Information Services. The SQL DBA will be responsible for both production support and database development. Main responsibilities are for backups/recovery, Database Monitoring and Performance Tuning with secondary responsibilities in SQL Development, stored procedures, ETL processes (SSIS), advanced querying coding.
 

Technical Knowledge:

  • Expert level knowledge of Backups/Recovery Operation, Database Shrink Operations, Database Monitoring/Performance Tuning, DBCC commands, Clustering, Database Mirroring and Replication in Microsoft SQL Server.
  •  Expert level skill developing new and enhance Database objects and packages to meet business needs.
  •  Expert level skill monitoring SQL jobs and transfer queues to ensure they are functioning as expected
  • Skilled with Microsoft SQL Server Integration Services (SSIS) to build Extract, Transformation, Load (ETL) processes.
  • Skilled with Star Schemas and Dimensional Modeling
  • Strong SQL development skills in a data warehouse environment.
  • Knowledge of Visual Studio IDE and Azure DevOps Git repository.
  • Familiar with cloud-based database services preferre
  •  Familiar with .Net technologies preferred.

Experience:

  • 5+ years of DBA experience
  • 5+ years of experience utilizing SSIS to build ETL process.
  •  2+ years of managing technical staff.
  • At least 5 years of SQL Server experience
  • Experience designing and implementing data warehouse.
  • Experience maintaining data warehouse and reporting technology infrastructure.
  • Experience in a non-profit setting, directly with marketing and production departments.
  •  Experience with Azure platforms preferred.

Overview

Location Chicago
Workload 40 Hours/Week , 100% Onsite
Expected start date ASAP
Expected end date Open
Necessary languages English
Necessary skills Azure, DATABASE, DBA, ETL, SQL

Assignment closed

This assignment is closed as of 2020-04-15 and is no longer accepting applicants. Create an account to be the first to know when a similar or other relevant assignments are posted on Onsiter.

Create account