Information Technology Specialist - Database Administrator

Join to apply for the Information Technology Specialist 4 - Database Administrator role at State of Iowa - Executive Branch

Job Description

Only applicants who meet the Minimum Qualification Requirements and meet all selective requirements (listed below) will be placed on the eligible list. The Department of Management (DOM), Division of Information Technology (DoIT) is seeking an Information Technology Specialist 4 - Database Administrator to join our team!

The successful candidate will be responsible for the installation, maintenance, and administration of application servers and web services supporting critical state law enforcement operations. This position requires expertise in managing complex systems, databases, and application servers, with a focus on ensuring the seamless operation and security of various state and law enforcement applications.

• Application Server Management:
  Administer and maintain associated components on Linux and Oracle Database Appliance servers.
• Administer and maintain associated components on Windows or Linux Servers providing Microsoft SQL Databases.
• Oversee migration, installation, and deployment of applications and web services.
• Configure clusters, managed servers, data sources, and targets for web services deployments.
• Monitor deployed web services to ensure availability and troubleshoot issues by analyzing logs and collaborating with developers and end-users.
• Business Application Support:
  Maintain and enhance Java-based applications.
• Configure and administer database ETL jobs and integrations.
• Write SQL queries, stored procedures, and create ad-hoc reports for management analysis and troubleshooting.
• Database Administration and Troubleshooting:
  Manage multiple databases ensuring data integrity, performance, and security.
• Support database connectivity issues, including resolving problems with native and ODBC drivers.
• Install and upgrade Java Development Kits (JDK) on Linux servers to maintain application compatibility.
• System Administration:
  Support the reverse proxy servers for secure access to applications.
• Manage security certificates, including SSL and Java Key Store (JKS) configurations.
• Plan and execute backup of database and applications.
• Support the maintenance of Oracle cloud agents and monitor server environments using Oracle Enterprise Manager.
• On-Call Support and Miscellaneous Duties:
  Serve on an after-hours call-back list for on-call support, resolving issues related to databases, Linux systems, and application servers as needed.
• Manage server and data migrations, along with system upgrades.

• Proven experience administering application servers and databases in Linux and Windows environments.
• Strong skills in Java application support, SQL development, and ETL processes.
• Familiarity supporting Oracle APEX Applications and related services.
• Ability to troubleshoot complex issues across applications, databases, and integrations.
• Experience supporting mission‑critical systems, ideally in public safety or government environments.
• Excellent communication and collaboration skills, with a proactive approach to problem-solving and continuous improvement.
• Note:
  
  to ensure your application passes initial candidate screening, your application materials should clearly reflect how you meet the listed Minimum Qualifications.

• Flexible work environment
• Iowa Public Employees' Retirement System (IPERS)
• Health, dental and vision insurance
• Generous vacation, sick leave, and paid holidays
• Life and disability insurance
• Retirement savings options (RIC)
• Flexible Spending Accounts

At the Iowa Department of Management (DOM), we help government agencies across the state perform at their best by managing financial resources, technology, and information. Our mission is rooted in service – we provide efficient, innovative and strategic solutions that empower agencies to fulfill their goals.

• Integrity – We act with honesty and accountability.
• Teamwork – We collaborate to achieve shared success.
• Service – We are committed to excellence in public service.
• Partnership – We build strong relationships to drive results.

Thi…