Information Technology Specialist 4, Developer/Database Administrator

Information Technology Specialist 4, Developer/Database AdministratorPrint (https://www.governmentjobs.com/careers/iowa/jobs/newprint/4445630)Apply?Information Technology Specialist 4, Developer/Database AdministratorSalary$65,395.20 - $101,150.40 AnnuallyLocationWaterloo - 50703 - Black Hawk County, IAJob TypeFull-timeJob Number24-03264Agency185 Department of Management - Office of Chief Information OfficerOpening Date03/26/2024Closing Date5/20/2024 11:59 PM CentralLinkedIn Tag#LI-POSTPoint of ContactAbbey Carter (abigail.carter@iowa.gov)DescriptionBenefitsQuestionsJob DescriptionThe Department of Management (DOM), Division of Information Technology (DoIT) is seeking an Information Technology Specialist 4, Database Administratorto join our team!This position will be responsible for supporting, maintaining, and creating reports and products for Iowa Department of Corrections (DOC). In this position you will work with MSSQL server databases and administrator positions leading the company database environment.Duties include but not limited to:Administer, design, write, support, and maintain applications for the DOC using ColdFusion / HTML / CSS / SQL / AJAX / JavaScript / PHP with the ability to work in other programming languages as needed.Create reports from various sources.SQL/Database administration, design, configuration, and development (both development and production environments); SQL server maintenance, including but not limited to maintenance plans, backup and optimization of databases.Design and configure databases to be used for DOC applications.Serves as a primary contact for 1st District user community regarding hardware and software issues.Assists in resolving operational issues through technical competencies involving written and verbal communications by utilization of Core Correctional Practices (CCP) and technical abilities while adhering to DOM DoIT and DOC/1st District policies and procedures.Performs setup of new user computer access, which includes necessary security levels for areas of work and user help-desk services; provides documentation and trains end-users on how to use and access reports and forms. Assists staff in resolving problems relating to automated information systems; provides technical assistance and support when needed.Installs/upgrades system components (e.g., hardware and software) and develops installation plans, configuring, tuning, placing, testing and training users. Coordinates implementation of the systems; develops, coordinates and administers customer training; provides system enhancements and maintenance as required.Assists with the administration of VDI and Citrix, computer hardware/software installations, network coordination, managing over 200 computer devices, and the local area network throughout eleven counties in Northeast Iowa.Keep current with technology to meet 1st District operational needs. Knowledge base includes, but not limited to servers, databases, programs, disaster recovery, infrastructure, programming principles, and user applications necessary for operational success.Order equipment and supplies as needed; manage inventory of equipment and supplies per Iowa Code, policies, and procedures.Employer 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:Iowa Public Employees' Retirement System (IPERS)Retirement Investors Club (RIC)Flexible Working Environment- Work from Home OpportunitiesHealth, Dental and Vision InsuranceVacation LeaveSick LeavePaid HolidaysFlexible Spending AccountsLife InsuranceLong-Term Disability InsuranceThe successful candidate will select one of the District's area offices (Waterloo, Independence, Oelwein, Manchester or Dubuque) as their official domicile.SHIFT: Variable schedule, however generally Monday - Friday 8:00 A.M. - 4:30 P.M. with flexibility to accommodate assigned duties such as travel, training and technical support of 24/7 residential correctional facilitiesThis position will be primarily in-office.Background check requirements:After 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.Minimum Qualification RequirementsGraduation from an accredited four-year college or university and experience equal to two years of full-time work: 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; or designing/administering Internet sites;ORan equivalent combination of education and experience substituting the completion of an approved curriculum/specialized training program developed and implemented by or in cooperation with state government; or eighteen semester hours of accredited post high school course work in one of the specialty areas listed above; or certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed above, for the required education;ORan equivalent combination of education and experience substituting one year of the required experience for thirty semester hours of the required education;ORemployees with current continuous experience in the state executive branch that includes experience equal to six months of full-time work as an Information Technology Specialist 3.For additional information, please click on this link to view the job description (https://das.iowa.gov/sites/default/files/hr/documents/class_and_pay/JobClassDescriptions/InformationTechnologySpecialist4-00121-90121.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 full time 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; or designing/administering Internet sites?I have not graduated from a four-year college or universityNo experience to less than one yearOne year to less than two years of the identified experienceTwo years or more of the identified experience04How many years do you have of combined post high school education in any field and 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; or designing/administering Internet sites?I do not have any of the identified education or experienceLess than two years of the combined identified education or experienceTwo years to less than four years of the combined identified education or experienceFour years to less than six years of the combined identified education or experienceSix years or more of the combined identified education or experience05Have you completed an approved curriculum/specialized training program developed and implemented by or in cooperation with State Government; or eighteen semester hours of accredited college or university course work in one of the specialty areas listed above (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; or designing/administering Internet sites); or certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed above? 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; or designing/administering Internet sites?NA - I have not completed the identified currriculumLess than one year of experience in the identified areasOne year to less than two years of experience in the identified areasTwo years or more of experience in the identified areas06If 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 3 for the State of Iowa?I am not a current State of Iowa employee (executive branch)Less than three months of experience as an Information Technology Specialist 3 for the State of IowaThree months to less than six months of experience as an Information Technology Specialist 3 for the State of IowaSix months or more of experience as an Information Technology Specialist 3 for the State of IowaRequired QuestionAgencyState of IowaAgency185 Department of Management - Office of Chief Information OfficerAddress200 East Grand Ave.Des Moines, Iowa, 50309Websitehttps://ocio.iowa.gov/ApplyPlease verify your email addressVerify Email