Iowa Department of Administrative Services Information Technology Specialist 5, Senior Database System Administrator Des Moines , Iowa Apply Now Print (https://www.governmentjobs.com/careers/iowa/jobs/newprint/4463524)Apply$75,774.40 - $116,542.40 AnnuallyLocationDes Moines - 50319 - Polk County, IAJob TypeFull-timeJob Number24-03461Agency185 Department of Management - Office of Chief Information OfficerOpening Date04/09/2024Closing Date4/21/2024 11:59 PM CentralLinkedIn Tag#LI-POSTPoint of ContactAbbey Carter (abigail.carter@iowa.gov)DescriptionQuestionsJob DescriptionThe Department of Management (DOM), Division of Information Technology (DoIT) is seeking an Information Technology Specialist 5,Senior Database System Administrator who will provide information technology support across all divisions at the Department of Health and Human Services (HHS). The ideal candidate will be a highly motivated, skilled IT professional to provide advanced technical support in SQL infrastructure and other related services. In this role, you will apply your knowledge to support and aid the SQL solutions utilized by DOM DoIT.Daily responsibilities include, but are not limited to:Working closely with vendors to identify and resolve any issues in functionality and interoperability of applications, cloud-based infrastructure, and other related services and related existing IT systems.Managing and coordinating internal technologies that are not yet updated to a High Availability Deployment or Cloud SaaS/PaaS solutions.Investigating, developing, and executing transition plans for the remaining infrastructure.Helping develop and support an automated CI/CD environment.Ensuring established service level agreements are met or exceeded.Maintaining strong communication, and regularly reporting the status of all initiatives to IT leadership.Ensuring all applicable security, governance, and best practices are followed across all services. This includes maintaining required logs, log reviews, and policy automation.Attending required trainings, meetings, and seminars to provide expertise and recommendations to meet department goals.Maintaining expertise in technologies such as Microsoft SQL Server, Windows Cluster, Azure SQL, and other cloud SQL solutions (AWS, OCI).Participating in on-call rotation.Preference given to those with Microsoft SQL Server Database Administrator CertificationsEmployer Highlights:The Department of Management, Division of Information Technology provides adaptable, secure, and cost-effective technology services and solutions to support the agencies across the State of Iowa, trusted partners, and citizens. We are responsible for managing all IT assets, projects, and resources to deliver top-tier technology support and expertise across the enterprise. Our strength is driven by the skills, talents, and diversity of our people.We have a great total compensation package for all of our full-time employees, including:Flexible Working Environment- Work from Home OpportunitiesHealth, Dental and Vision InsurancePaid HolidaysFlexible Spending AccountsLife InsuranceLong-Term Disability InsuranceAfter a conditional offer of employment has been made, and as the final step in the hiring process, candidates for this position will be subject to a background investigation, which may include but may not be limited to a verification of a candidates education, previous employment/work history, contact of personal references, motor vehicle records, and a criminal history check (including through Federal, State, or Local criminal justice agencies).Information gathered as part of such background investigation will be treated as confidential to the extent permitted by Iowa Code section 22.7, 8B.4A, and other applicable laws, rules, and regulations; provided that, to the extent permitted by applicable law, such information shall be available to candidates upon request.Only applicants who meet the Minimum Qualification Requirements and meet all selective requirements will be placed on the eligible list.Selectives419 PC/LAN Server:6 months experience, 12 semester hours, or a combination of both in the following:Generating, testing and maintaining LAN/server system softwareInstalling and maintaining PC hardware and softwareCreating data sets using a variety of software packagesCombining and converting data sets from different formats and sources to be used in spreadsheets, databases, and graphics software packagesProducing final data summaries and reports using standard statistical proceduresProducing final tables and graphics using various software packagesOR077 NT Administration:6 months experience, 12 semester hours, or a combination of both that demonstrates knowledge and understanding of Windows NT Server Administration.OR413 Network Coordination:6 months experience, 12 semester hours, or a combination of both involving:Installing and configuring network softwareMaintaining securityPerforming technical support for networksApplicants must meet at least one of the following minimum requirements to qualify for positions in this job classification:1) Graduation from an accredited four-year college or university with a degree in any field, and experience equal to three years of full-time work in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing).2) All of the following (a and b):a. Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing); andb. A total of four years of education and/or full-time experience (as described in part a), where thirty semester hours of accredited college or university coursework in any field equals one year of full-time experience.3) All of the following (a and b):a. Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing); andb. Certification by an authorized educational institution/major computer or software producer in an area directly related to one of the computer specialty fields described in part a.4) All of the following (a and b):a. Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing); andb. Eighteen semester hours of accredited post-high-school coursework in one of the specialty fields described in part a.5) Current, continuous experience in the state executive branch that includes six months of fulltime work as an Information Technology Specialist 4.For additional information, please click on thislink to view the job description. (https://das.iowa.gov/sites/default/files/hr/documents/class_and_pay/JobClassDescriptions/InformationTechnologySpecialist5-00122-90122.pdf)Why Choose the State of Iowa?At the heart of our commitment to excellence is a dedication to our most valuable asset our employees. Discover the outstanding benefits that set us apart as an employer of choice.Our Robust Benefits Package Includes:Competitive Compensation:Enjoy a competitive salary that reflects directly on your skills and expertise.Keep in mind, your wage is just one part of your total compensation. Unlock the complete value of your employment with the State of Iowa by using our user-friendlyTotal Compensation Calculator (https://das.iowa.gov/media/3773/download?inline) .Gain insights into your comprehensive annual compensation, including salary and State-provided benefits.Health and Wellness:Prioritize your well-being with our comprehensive health plans, including medical, dental, and vision coverage. Enjoy the peace of mind knowing that the State of Iowa covers 90% of the premiums, providing you and your loved ones with excellent coverage at a remarkably low cost.Retirement Planning:We are proud to offer the Iowa Public Employees Retirement System (IPERS). A defined benefit plan, IPERS benefits are guaranteed for life, meaning once you retire, you will receive the same monthly benefit for the remainder of your life (once vested). We invest in your long-term financial well-being, so you can retire with peace of mind.Click here to learn more about IPERS (https://ipers.org/members) .Paid Time Off:Life is unpredictable, and at the State of Iowa, we understand the importance of work-life balance. Our leave policies, including paid holidays, vacation, and sick leave with unlimited accrual, ensure you have the flexibility you need for personal and family matters.Professional Development:Elevate your career with continuous learning opportunities. We support your growth through training programs, workshops, and tuition reimbursement.Employee Assistance Program (EAP):We care about your well-being beyond the workplace. Access confidential counseling, resources, and support through our Employee Assistance Program.Diversity and Inclusion:Be part of a diverse and inclusive workplace that embraces all backgrounds and perspectives. We believe diversity is a strength that drives innovation.Join Us - Elevate Your Career:Ready to elevate your career with the State of Iowa?Click here (https://iowa.attract.neogov.com/recruitment/p/benefits) to explore more about our unparalleled benefits and discover what makes us unique. Your success is our priority!01Do you understand that the answers to all of the following questions must be truthful, honest, and accurate to the best of your ability? Please read all questions and answers thoroughly and make sure you understand them completely.Ensure the answers to your questions match the information filled out on your application and the attachments you have uploaded. If the answers to your questions are inconsistent with your application information or uploaded attachments, you will be given zero points for the question.Knowingly misrepresenting the facts when submitting any information related to an application, examination, certification, appeal, or any other facet of the selection process will result in your disqualification from this application and future employment with the state of Iowa.Yes - I understand and agree.No02PLEASE READ CAREFULLYHave you filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. 611 et seq?No - I have NOT filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. 611 et seqYes - I HAVE filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. 611 et seq03Have you graduated from a four year college or university? IF YES- How many years of experience do you have operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing)?I have not graduated from a four year college or universityLess than one year of experience in the identified areasOne year to less than two years of experience in the identified areasTwo years to less than three years of experience in the identified areasThree years or more of experience in the identified areas04Do you meet both A and B: (A) Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing) (B) Four years of education and/or ADDITIONAL full-time experience (as described in part a), where thirty semester hours of accredited college or university coursework in any field equals one year of full-time experience.I do not meet A and B05Do you meet A AND B: A Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing); and B Certification by an authorized educational institution/major computer or software producer in an area directly related to one of the computer specialty fields described in part a.I do not meet A AND B06Do you meet A AND B: A. Three years of full-time work experience in: operating a multi-job computer; installing, operating, and coordinating computer-based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks, and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; designing/administering websites; or executing technology projects (e.g., systems analysis, requirements, design, development, and testing); and B. Eighteen semester hours of accredited post-high-school coursework in one of the specialty fields described in part a.No - I do not meet A AND B07If you are a current State of Iowa employee (executive branch) - How many months of full-time work have you had as an Information Technology Specialist 4 for the State of Iowa?I am not a current State of Iowa employee (executive branch)Less than three months of work experience as an Information Technology Specialist 4 for the State of IowaThree months to less than six months of work experience as an Information Technology Specialist 4 for the State of IowaSix months or more of work experience as an Information Technology Specialist 4 for the State of Iowa08Does your application demonstrate that you have 6 months experience, 12 semester hours, or a combination of both involving:Installing and configuring network softwareMaintaining securityPerforming technical support for networks?YesNo09If you answered 'Yes' to the question above - please thoroughly explain exactly HOW you meet it: list exact classes and credit hours, employer, dates and hours per week and exact duties. Please do not paste or state - See application or resume. If you answered no to the question above please type in 'No' in the box below.10Does your application demonstrate that you have 6 months experience, 12 semester hours, or a combination of both in the following:Generating, testing and maintaining LAN/server system softwareInstalling and maintaining PC hardware and softwareCreating data sets using a variety of software packagesCombining and converting data sets from different formats and sources to be used in spreadsheets, databases, and graphics software packagesProducing final data summaries and reports using standard statistical proceduresProducing final tables and graphics using various software packages?YesNo11If you answered 'Yes' to the question above - please thoroughly explain exactly HOW you meet it: list exact classes and credit hours, employer, dates and hours per week and exact duties. Please do not paste or state - See application or resume. If you answered no to the question above please type in 'No' in the box below.12Does your application/resume demonstrate that you have 6 months experience, 12 semester hours, or a combination of both that demonstrates knowledge and understanding of Windows NT Server Administration?YesNo13If you answered 'Yes' to the question above - please thoroughly explain exactly HOW you meet it: list exact classes and credit hours, employer, dates and hours per week and exact duties. Please do not paste or state - See application or resume. If you answered no to the question above please type in 'No' in the box below.Required QuestionAgencyState of IowaAgency185 Department of Management - Office of Chief Information OfficerAddress200 East Grand Ave.WebsiteApplyPlease verify your email addressVerify Email#J-18808-Ljbffr

by Jobble