Work in Iowa Jobs

Information Technology Specialist 4, Developer/Database Administrator

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

Apply



Information Technology Specialist 4, Developer/Database Administrator

Salary

$65,395.20 - $101,150.40 Annually

Location

Waterloo - 50703 - Black Hawk County, IA

Job Type

Full-time

Job Number

24-03264

Agency

185 Department of Management - Office of Chief Information Officer

Opening Date

03/26/2024

Closing Date

5/20/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 (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 Opportunities

• Health, Dental and Vision Insurance

• Vacation Leave

• Sick Leave

• Paid Holidays

• Flexible Spending Accounts

• Life Insurance

• Long-Term Disability Insurance

The 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 facilities

This 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 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