SQL Server DBA/Team Lead

Short Description: Senior SQL Server DBA/Team Lead Complete Description: The State of Iowa is looking for someone who has a strong understanding of SQL Server database administration, with experience developing in SSIS and XML. This TS3 position will be joining our database support team and assume workload coordination of 6 SQL Server DBAs. This person will help shape the department’s future SQL Server Vision from database standards and policies to automation efforts for deployment.

The ideal candidate will have experience implementing databases in the cloud, and will have experience with continuous integration and automation concepts. Responsibilities: ? Manage day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). ? Effectively prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.

? Drive results and leverage past experiences to improve the environment and related processes. ? Foster a spirit of teamwork, coach and mentor staff and empower employees to take responsibility. ? Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps. ? Coordinate with other agency departments to update and integrate processes as necessary.

Skill Required / Desired Amount of Experience Expert understanding of Database best practices Required 8 Years Demonstrated ability to lead a team of at least 5 staff members Required 3 Years Strong technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and lea Required 6 Years Strong written and verbal communication skills Required 6 Years Data Warehousing concepts Required 3 Years SQL Server DBA experience with 2012 or newer Required 8 Years SQL Server Database Design Required 8 Years SQL Server Database Performance monitoring Required 8 Years SQL Server database troubleshooting and query optimization Required 8 Years SQL Server Stored Procedure Design and implementation Required 8 Years SQL Server Analysis Services (SSAS) Required 8 Years SQL Server Integration Services (SSIS) Required 8 Years SQL Server Reporting Services (SSRS) Required 8 Years Experience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred).

Required 2 Years Familiarity with Agile (Scrum and/or Kanban) methodology Required 2 Years Experience migrating databases to the Cloud using AWS Highly desired Architecture Planning experience Highly desired