This assignment is not accepting applications. Click here to find other relevant assignments.
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