State of Iowa - Executive Branch · 1 month ago
Information Technology Specialist 4 - Database Administrator
Des Moines, IA
Full-time
Hybrid
Entry, Mid Level
2+ years expThe State of Iowa - Executive Branch is seeking an Information Technology Specialist 4 - Database Administrator to join their team. The role involves the installation, maintenance, and administration of application servers and databases to support critical state law enforcement operations, ensuring the seamless operation and security of various applications.
AssociationConsultingNon Profit
No H1B
Responsibilities
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 KeyStore (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
Qualification
Required
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
6 months experience, 12 semester hours, or a combination of both that demonstrates knowledge and understanding of Linux Server Administration
6 months experience, 12 semester hours, or a combination of both involving Oracle System Administration including Oracle Database and Oracle Forms and Reports
6 months experience, 12 semester hours, or a combination of both in developing, installing and maintaining database management systems
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
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
An equivalent combination of education and experience substituting one year of the required experience for thirty semester hours of the required education
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
Must possess and maintain a valid Driver's License with the ability to travel statewide as necessary
Attain IOWA System/NCIC Certification within 30 days of employment and maintain certification continuously while employed in this position
Benefits
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
Company
State of Iowa - Executive Branch
If you’re looking for a work life of accomplishment, reward, and opportunity, you’ll discover Iowa State Government is just the place where there’s a rich and diverse population; where community, culture and differences matter; where exceptional work ethic, values and peace of mind all come together! The more you know about the State of Iowa, the more you’ll know it’s the right fit for you! There are 16 agencies in state government providing services to Iowans requiring specialized talent in agriculture, corrections, economic development, education, human services, natural resources, public health, public safety, revenue, transportation, veterans’ services and more.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Jacob Nicholson
Chief Operating Officer
Darwin Ten Haken
Enterprise Architect, Office of the CIO
Recent News
Company data provided by crunchbase