SQL BI Developer

Description

This is a MS SQL Server Developer role largely responsible for providing database development, deployment, and code review services to the organization. We are looking to fill a need to have a highly competent and highly motivated individual in this role.
In this role, your primary responsibilities will be to work with the various BI and .Net development teams within the company to put code into TFS, developing automated deployment processes, creating database projects, and help troubleshoot performance issues throughout the organization. You will also be able to review current development and deployment strategies to ensure they are correct, and where not, make changes.
Other responsibilities include operational work, including participating in the weekly oncall rotation, incident management and prevention to ensure that service related issues are resolved quickly and efficiently, responding to database alerts, and general ticket requests. We expect a 70/30 ratio of development to operation work.
This role does require a service oriented mentality, high sense of ownership of the problems/work assigned with a focus on solving issues for the long term, and excellent communication skills as you will be interacting with various teams across the organization.
Role Requirements
We are looking for a person that has Strong understanding and experience in the use Visual Studio Database Projects, including creating, managing, and deployment of new code.
Strong understanding and experience in the use TFS Source Control and workflows, including process creation and automation of deployments.
Strong understanding of source control, branching strategies, GIT, etc. and how to apply to various projects within an organization.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Strong understanding of good database development practices and TSQL
Experience in implementing operational automation using scripts.
Experience with Azure SQL, Azure DW, and OLTP environments.
Knowledge of backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Knowledge of indexes, index management, and statistics.
Good communication and documentation skills.
Additional Items of Separation
Experience optimizing code for tables with over 1 billion records.
Experience in indexing strategies for 100+ million table environments in an AlwaysOn Replica setup.
Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
Certification is a plus; MCTS, MCITP, MVP
Experience with DB2, Oracle, and/or SAP environments
General understanding of Linux CLI commands