Job Description

Job Description and Duties

State Fund has a position available for an Oracle DBA at our Vacaville Information Technology location. As an Oracle DBA you will be tasked to support the Oracle database(DB), Oracle Application Server and E-business Suite (AS) and their entire life cycle environments.

New to state candidates will be hired into the minimum salary of the classification or minimum of the alternate salary range when applicable. Placement to an alternate salary range may be based on education or experience identified in your state application.

You will find additional information about the job in the .

Working Conditions

Special Requirements

To be considered, you must provide a  fully completed STD 678 application, resume, and statement of qualifications via CalCareers. 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.

Desirable Qualifications

In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

The tasks for the Oracle DBA include, but are not limited to, the following:

• Support of the Oracle database(DB), Oracle Application Server and E-business Suite (AS) and their entire lifecycle environments, including daily operations, backup and  recovery, performance tuning and app code pushes for mission critical applications in the company, encompassing State Fund's Electronic Claims Files (ECF), ECF Payments (E-Business Suite) , ECF related claims databases,  Oracle Application servers and related systems.   

• Production support of State Fund's Oracle database, ECF Payments and related claims databases and Oracle Application Servers issues including after hours on-call support.

• Production support of non-ECF Oracle databases.

• Work with Oracle Support to resolve issues on the DB, AS and E-Business and Oracle tools used by the development teams. 

• Utilize Oracle Designer, Oracle Developer, Oracle APEX and other tools to create, modify and deploy code changes.

• Develop and implement Oracle Stored Procedure verification tools that assist developers in troubleshooting and performance improvement 

• Develop and implement procedures for the synchronization between different environments.

• Develop and implement proactive tools for Oracle environments (such as lock escalation report).

• Provide advice/recommendations on Application architecture, design and implementation.

• Evaluate new products, develop procedures for installation and maintenance of Oracle Databases, Application Server/LDAP, E-Business Suite on Unix servers, and OEM Grid Control on Linux.

• Assist development team in review/troubleshoot SQL and pl/sql

Benefits

State Fund employees are eligible for a number of benefits. Our benefit package includes:

Health Benefits Program (CalPERS)

Retirement (CalPERS)

Employer Health and Consolidated Benefits Contributions

Dental, Vision

401(k) and 457 Deferred Compensation Plans

Employee Assistance Program

Group Legal Services Insurance

Holidays, Vacation/Sick/Other Paid Leave

Flex Elect Reimbursement Program

Wellness and Recognition

Alternate Work Schedules

Transit Pass Program

Tuition Reimbursement

Dependent Scholarship Program

Leadership Training

Mentoring Program

Background Investigation

Prior to employment with State Compensation Insurance Fund, a background investigation (BI) will be initiated.

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

Job Tags

Similar Jobs