Job Seekers, Please send resumes to resumes@hireitpeople.com 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.

SkillRequired / DesiredAmountof ExperienceExpert understanding of Database best practicesRequired8YearsDemonstrated ability to lead a team of at least 5 staff membersRequired3YearsStrong technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and leaRequired6YearsStrong written and verbal communication skillsRequired6YearsData Warehousing conceptsRequired3YearsSQL Server DBA experience with 2012 or newerRequired8YearsSQL Server Database DesignRequired8YearsSQL Server Database Performance monitoringRequired8YearsSQL Server database troubleshooting and query optimizationRequired8YearsSQL Server Stored Procedure Design and implementationRequired8YearsSQL Server Analysis Services (SSAS)Required8YearsSQL Server Integration Services (SSIS)Required8YearsSQL Server Reporting Services (SSRS)Required8YearsExperience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred).Required2YearsFamiliarity with Agile (Scrum and/or Kanban) methodologyRequired2YearsExperience migrating databases to the Cloud using AWSHighly desired  Architecture Planning experienceHighly desired