Senior Oracle Developer

Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Position Details

Job Code #:

JC-503566

Position #(s):

402-123-1414-XXX

Working Title:

Senior Oracle Developer

Classification:

INFORMATION TECHNOLOGY SPECIALIST II

$8,625.00 - $11,557.00 A

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

# of Positions:

Multiple

Work Location:

Solano County

Telework:

Hybrid

Job Type:

Permanent, Full Time

Department Information

State Fund is California’s largest provider of workers’ compensation insurance. Established in 1914 by the state legislature, we offer diverse and comprehensive products and services that provide a strong and stable option for employers and injured employees with fast, reliable claims service and medical and indemnity benefits.

Our culture centers on our purpose and values. We exist to provide fairly priced workers' compensation insurance, make workplaces safe, and restore injured workers. To fully represent California, we are committed to our employees by embracing and celebrating our diverse workforce and fostering inclusion to make the workplace a dynamic environment for all. We recognize and reward high performance yet value a healthy work/life balance.

Department Website: http://www.statefundca.com

Job Description And Duties

Are you an IT wizard? Have you been looking for the stability of a state job with incredible benefits such as loan forgiveness, retirement plans, and more? Look no further!

The Information Technology System Engineering Unit Is Seeking a Full-time Permanent Information Technology Specialist II. The Selected Candidate Shall Be Familiar With The Following Duties:

• Provide solutions using Oracle Technologies such as Reports and Designer
• Create Packages, Functions, Procedures using PL/SQL and all necessary database objects for enterprise solutions.
• Provide assistance in Performance Tuning of any SQL queries
• Provide solutions in Oracle Application (AR, AP, GL, Workflow, etc.), Activiti, Jasper and any other technology which SCIF would want to use in the CARE application
• Code the programs as per the technical specifications and in accordance with the State Fund State Fund System Engineering Handbook, as well as conduct unit testing and integration testing. Integration testing often occurs with external vendors.
• Provide Support to State Fund’s claims (CARE) applications
• Work with the users, applications support and interact with other team members in problem resolution
• Training and knowledge transfer to State Fund employees by the consultant resource is considered an integral part of this engagement, and the consultant resource is expected to work in a collaborative fashion with State Fund employees, and provide specific training as directed by State Fund.
• Analyze, code, and unit test the CARE application and backend procedures and packages as per the technical specifications
• Creating Technical Design Documents in accordance with the State Fund System Engineering Handbook.
• Work closely with other development team members to ensure the application performance is within users expectation
• Provide second tier application support and transfer knowledge to Production Support Team, CARE Application team, and SCIF staff.
• Additional responsibilities are: Analyze, Research, and Fix any performance issue in the CARE application.
• Provide day-to-day technical assistance in resolving CARE production problems.
• Transmitting Data externally to vendors and resolving any issues with respect to data transfers and receipt of data.
• Provide more in-depth analysis, diagnose, repair or enhance CARE production application.
• Follow the processes and methodologies contained in State Fund System Engineering Handbook, as well as complete assigned tasks within a reasonable time frame under the supervision of a manager.
• Provide test plans and validate test results.
• Be able to work independently and be a team lead.
• Provide suggestion on performance improvement opportunity on CARE application.
• Resolve performance issues as needed.
• Mentor staff members in programming and problem resolution
  
  

You will find additional information about the job in the Duty Statement .

Special Requirements

Resumes submitted in lieu of the STD 678 may not be accepted. Completed STD 678 must include duties performed, start and end dates, and hours worked per week for each position held.

The successful candidate must reside in California upon appointment.

The person should possess the following technical skills and experience:

• Be proficient in PL/SQL - Back end programming and expertise in the following:
• Packages
• Procedure
• Functions
• Autonomous Procedures
• Handling Arrays
• Make TAPI changes
• Strong knowledge of SQL Tuning -
• How to trace the SQL processing
• How to convert the tracing into readable format ( tkprof )
• How to interpret the trace report
• Understand the causes and fix the problems
• Candidate should know how to generate modules out of Designer
• How to attach libraries in Designer
• How to attach template form in Designer
• Use of Object Library in Designer
• How to do post generation using Forms
• How to access RON in Designer
• How to look for attributes
• How to look for the values of domains
• How to look for the existing indexes attached to the entities
• Some knowledge with J2EE development, Java, JDeveloper and Oracle 10g is preferred.
  

Core Competencies

The consulting resource shall provide the following prerequisite core competencies:

• Acts with integrity;
• Uses sound judgment;
• Commits to quality;
• Demonstrates adaptability;
• Innovates;
• Thinks strategically;
• Ability to communicate effectively and influence others;
• Works well both independently and as part of a team;
• Good communication skills
  
  

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

Final Filing Date: 1/16/2026

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply

Complete Application Packages (including Your Examination/Employment Application (STD 678) And Applicable Or Required Documents) Must Be Submitted To Apply For This Job Posting. Application Packages May Be Submitted Electronically Through Your CalCareer Account At Www.CalCareers.ca.gov. When Submitting Your Application In Hard Copy, a Completed Copy Of The Application Package Listing Must Be Included. If You Choose To Not Apply Electronically, a Hard Copy Application Package May Be Submitted Through An Alternative Method Listed Below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

State Compensation Insurance Fund

Talent Acquisition/Staffing

Attn: JC-503566 TS

2275 Gateway Oaks Drive

Sacramento , CA 95833

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

State Compensation Insurance Fund

Talent Acquisition/Staffing

JC-503566 TS

2275 Gateway Oaks Drive

Sacramento , CA 95833

08:00 AM - 05:00 PM

Required Application Package Documents

The Following Items Are Required To Be Submitted With Your Application. Applicants Who Do Not Submit The Required Items Timely May Not Be Considered For This Job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
  
  

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.