Senior Oracle Developer

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment.

This position serves as a Senior Oracle Developer performing complex professional and advisory functions in Application Services, supporting the Illinois State Police (DoIT/ISP).

In this role, you will perform advisory tasks for the large and complex Criminal History Record Information (CHRI) System.

In addition, you will conduct and coordinate design and development of viable solutions for the resolution of complex issues or improving the efficiency of the system and resolve technical issues through efficient and targeted debugging, substantial technical research, and investigation.

If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position with DoIT!

As a State of Illinois employee, you receive a comprehensive benefits package including:

• Competitive Group Insurance benefits including health, life, dental and vision plans
• Flexible work schedules (when available and dependent upon position)
• 10 -25 days of paid vacation time annually (10 days for first year of state employment)
• 12 days of paid sick time annually which carry over year to year
• 3 paid personal business days per year
• 13-14 paid holidays per year dependent on election years
• 12 weeks of paid parental leave
• Pension plan through the State Employees Retirement System
• Deferred Compensation Program – voluntary supplemental retirement plan
• Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

Why Work for Illinois?

Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.

No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.

Essential Functions

• Under administrative direction, serves as a Senior Oracle Developer performing complex professional and advisory functions in Application Services for the Department of Innovation & Technology (DoIT)/Illinois State Police (ISP) in Law Enforcement Unit A conducting and coordinating in-depth feasibility studies and technical research to identify and meet user needs and requirements as well as for complex system conversions and enhancements.
• Conducts and coordinates system design and development of viable solutions for the resolution of complex issues or improving the efficiency of the system.
• Provides technical guidance to system developers for completing assignments in the most efficient and timely manner.
• Keeps abreast of new developments in the information technology field by continuing education through online training platforms, meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
• Performs other duties as required or assigned which are reasonably within the scope of duties enumerated above.

Minimum Qualifications

• Requires knowledge, skill, and mental development equivalent to completion of four (4) years of college with course work in computer science or directly related fields.
• Requires three (3) years of professional experience in Application Development Services or a related Information Technology field.

Preferred Qualifications (In Order Of Significance)

• Three (3) years of professional experience as a full stack oracle developer, demonstrating expertise in Oracle 19c/23ai database engineering, PL/SQL (triggers, packages, and performance tuning), and Java 8/11 backend development, using MVC/MVVM patterns and tools including Oracle Enterprise Manager, SQL Navigator/Developer, SQL Plus to deliver complex system solutions.
• Two (2) years of professional experience designing and implementing enterprise middleware and web integrations using Java Spring Boot, Oracle Application Development framework, Oracle Apex, and message-oriented middleware technologies including MQSeries, Message Broker, WebSphere, WebLogic, and Oracle REST Data Services.
• Three (3) years of professional experience conducting detailed business analysis for Criminal Justice or other large-scale government systems including gathering complex user and statutory requirements and translating them into clear technical specifications for system design and enhancement.
• Three (3) years of professional experience implementing cloud-native solutions using Azure or Oracle Cloud, including resource management, identity and access control, cloud architecture principles, , and Data Services (SQL/NoSQL/JSON Database, Storage). Including applying DevOps practices including CI/CD pipelines, automated build and deployment strategies, and environment management.
• Three (3) years of professional experience in Oracle database design and administration, and optimization including integrating database solutions with legacy and web applications to improve performance, stability, and scalability for systems.
• Three (3) years of professional experience providing technical guidance to system developers, ensuring alignment with architectural standards, efficient coding practices, and adherence to project timelines.
• Ability to analyze data logically, apply sound technical judgement, and evaluate operational or procedural problems to determine effective, efficient solutions.
• Ability to establish and maintain cooperative and productive working relationships with agency leadership, technical teams, external partners, and end-users.
• Written and verbal communication skills with the ability to present technical information clearly and effectively to both technical and non-technical audiences.
• Demonstrated organizational and time‑management skills with the ability to handle multiple projects, competing priorities, and deadlines in a fast‑paced environment.

Conditions of Employment

Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

• Requires the ability to verify identity.
• Requires employment authorization to accept permanent full-time position with State of Illinois.
• Requires the ability to pass a position-specific, agency required background check.
• Requires self-disclosure of criminal history.
• Requires the ability to travel in performance of duties.
• Requires the ability to work outside of normal hours to meet deadlines.
• Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
• Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies, or other industry related topics relevant to job duties.
• Requires the ability to lift and carry objects or equipment weighing up to 20 pounds. This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.
• The conditions of employment listed are incorporated and/or related to any duties included in the position description.

Work Hours: Monday - Friday 8:30am - 5:00pm (Work hours may vary)

Headquarter Location: 801 S 7th St, Springfield, Illinois, 62703