Work in Iowa Jobs

Information Technology Specialist 4, Systems and Database Administrator

Print (https://www.governmentjobs.com/careers/iowa/jobs/newprint/4546008)

Apply



Information Technology Specialist 4, Systems and Database Administrator

Salary

$65,395.20 - $101,150.40 Annually

Location

Waterloo - 50703 - Black Hawk County, IA

Job Type

Full-time

Job Number

24-04286

Agency

185 Department of Management - Office of Chief Information Officer

Opening Date

06/14/2024

Closing Date

6/24/2024 11:59 PM Central

LinkedIn Tag

#LI-POST

Point of Contact

Abbey Carter (abigail.carter@iowa.gov)

• Description

• Benefits

• Questions

Job Description

The Department of Management, Division of Information Technology (DoIT) is seeking an Information Technology Specialist 4, Systems and Database Administrator to join our team! In this position you will support staff, systems, and infrastructure along with MS SQL Server database support and report writing for the Department of Corrections, 1st District.

Key Responsibilities:

• 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.

• Serves as systems manager for one or more system management processes/systems, including coordinating the availability and allocation of system storage space, administering system resources such as network, data, programs, and objects, system access, etc., within organizational standards to ensure integrity and security.

• 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. Provides Tier-1 and above support to local staff.

• 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.

• Prepares program specifications, develops data bases or files for testing and tests system using sample data; prepares system documentation and develops program code.

• Translates and write T-SQL queries to extract data from an SQL Server database; compiles, organizes and aggregates data to meet business information requests. Works with different groups of consumers with various levels of technical knowledge to help them define analytical, management, statistical, and tracking report needs.

• Translates customer requests into technical design documentation. Plans and participates in the development of complex programming code utilizing a variety of programming tools. Evaluates alternative methods of program development.

• Analyzes more complex agency operations/procedures and studies components to determine feasibility of adapting to automation; evaluates potential changes in operations/procedures and prepares cost estimates/time lines for completion.

• Evaluates potential changes in operations and procedures, prepares cost estimates and time lines for completion of details identified during analysis.

• Analyzes system management processes/systems (availability, change, configuration, problem, project, network and storage management, capacity planning, system performance, data modeling, charge back, information services, disaster recovery, systems security and skills planning). Manages one or more system management process including availability/allocation of system storage space, system resources (e.g., network, data, programs and objects) and system access.

• Develops/delivers formal and informal training (e.g., products and software) to individuals or groups. Participates as a team member, by providing input and sharing responsibility in order to ensure continuing improvements on District projects, program and services.

• Consults with customers concerning systems management. Prepares detailed specifications/proposals. Evaluates proposals. Makes recommendations and coordinates the procurement process in order to secure the required hardware, software, or service.

Work Location Information:

• The successful candidate will select one of the District's area offices as their official domicile forprimarily in-office work:

• 314 E 6th St, Waterloo, IA 50703

• 745 Main Street, Dubuque, IA 52001

Please note, candidates for this positionmustreside in the state of Iowa at the time of starting the role.

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 Opportunities

• Health, Dental and Vision Insurance

• Vacation Leave

• Sick Leave

• Paid Holidays

• Flexible Spending Accounts

• Life Insurance

• Long-Term Disability Insurance

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 candidate’s 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 Requirements

Graduation 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;

OR

an 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;

OR

an equivalent combination of education and experience substituting one year of the required experience for thirty semester hours of the required education;

OR

employees 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!

01

Do 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.

• No

  02

  PLEASE READ CAREFULLY

Have 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 seq

• Yes - I HAVE filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq

  03

  Have 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 university

• No experience to less than one year

• One year to less than two years of the identified experience

• Two years or more of the identified experience

  04

  How 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 experience

• Less than two years of the combined identified education or experience

• Two years to less than four years of the combined identified education or experience

• Four years to less than six years of the combined identified education or experience

• Six years or more of the combined identified education or experience

  05

  Have 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 currriculum

• Less than one year of experience in the identified areas

• One year to less than two years of experience in the identified areas

• Two years or more of experience in the identified areas

  06

  If 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 Iowa

• Three months to less than six months of experience as an Information Technology Specialist 3 for the State of Iowa

• Six months or more of experience as an Information Technology Specialist 3 for the State of Iowa

  Required Question

Agency

State of Iowa

Agency

185 Department of Management - Office of Chief Information Officer

Address

200 East Grand Ave.

Des Moines, Iowa, 50309

Website

https://ocio.iowa.gov/

Apply

Please verify your email addressVerify Email