Senior SQL Server DBASSIS Developer is needed to support the Iowa Department of Revenue systems Modernization Project 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 position will be an addition to our database support team of three 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 Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes. 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. Coordinate with other agency departments to update and integrate processes as necessary. Demonstrate leadership skills (foster a spirit of teamwork, mentor peers, and take ownership of assigned project work). Install and configure SQL Server, applying service packs and feature packs. Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs. Assist developers with complex query tuning and schema refinement. Stay current on technology and industry standards work with leadership to develop strategic plans and roadmaps. REQUIRED SKILLS SQL Server DBA experience with 2012 or newer 8 years REQUIRED SQL Server Integration Services (SSIS) 8 years REQUIRED SQL Server Reporting Services (SSRS) 8 years REQUIRED SQL Server Stored Procedure Design and implementation 8 years REQUIRED SQL Server database troubleshooting and query optimization 8 years REQUIRED SQL Server Database Performance monitoring 8 years REQUIRED SQL Server Database Design 8 years REQUIRED Expert understanding of Database best practices 8 years REQUIRED Experience upgrading databases from lower to latest versions 8 years REQUIRED Data Warehousing concepts 3 years REQUIRED Operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred) 2 years REQUIRED Databases migration using Azure or AWS HIGHLY DESIRED Experience in performing DR techniques – Always On, Clustering, Replication, Database mirroring, etc. HIGHLY DESIRED RequiredDesired Skills Skill Required Desired Amount of Experience SQL Server DBA experience with 2012 or newer Required 8 Years SQL Server Integration Services (SSIS) Required 8 Years SQL Server Reporting Services (SSRS) Required 8 Years SQL Server Stored Procedure Design and implementation Required 8 Years SQL Server database troubleshooting and query optimization Required 8 Years SQL Server Database Performance monitoring Required 8 Years SQL Server Database Design Required 8 Years Expert understanding of Database best practices Required 8 Years Experience upgrading databases from lower to latest versions Required 6 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 le Required 6 Years Strong written and verbal communication skills Required 6 Years Data Warehousing concepts Required 3 Years Operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). Required 2 Years Familiarity with Agile (Scrum andor Kanban) methodology Required 2 Years Databases migration using Azure or AWS Highly desired 0 Years Experience in performing DR techniques – Always On, Clustering, Replication, Database mirroring, etc. Highly desired 0 Questions No. Question Question1 The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement? Question2 Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement? Question3 This requirement falls under the e-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement? Question4 Please list candidate’s email address HERE that will be used when submitting E-RTR. Question5 INTERVIEW DATES Interviews will be conducted on September 9th, 10th, and 11th. Only to submit candidates who are available to interviews on the date(s) provided. Question6 PROVIDE candidates CURRENT PHYSICAL LOCATION HERE, Question7 REMOTE WORK PERMITTED Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the chosen candidate must be available to report in person as directed by the client to pick up equipment on the first day. This position REQUIRES the selected candidate to work ONSITE for the duration of the assignment once clear to return to the building. Do you accept this requirement? Question8 IS YOUR CANDIDATE AWARE that heshe would need to RELOCATE to Des Moines for this position? Question9 IF OFFERED THE POSITION How much notice does your candidate require before heshe is able to start working? Question10 Provide three (3) professional (REQUIRED) references on the candidate resume with Contact Name, Title, Contact, and Relation to the candidate. NOTE Candidates without professional references WILL NOT BE CONSIDERED Question11 SUMMARY of QUALIFICATIONS field under the DETAILS tab of the candidate profile A) DO NOT COPYPASTE from Candidates CVResume. B) ONLY PROVIDE STAFFING AGENCY RECRUITING NOTES as it pertains to their qualification of the candidate and reason for submission to this specific position . Question12 OCIO contractor personnel are now required to undergo additional background check investigations (run by OCIO) before starting, requiring completion of several waiver forms fingerprint processes. The selected candidate will be responsible for completing all the necessary waiver forms (CAI provide), scheduling and completing the fingerprinting process, and returning all completed items to OCIO for processing. Please confirm you have discussed this with your candidate, and heshe will comply if selected.