Job Description

Job Description and Duties

The Information Technology Specialist II (ITS II), serving as a Database Administrator in the Database Platform Services Section, independently handles complex tasks related to FI$Cal databases, associated tools, applications, and their interactions. The ITS II is responsible for developing, planning, and implementing all activities within the FI$Cal Database Platform Services Section. The incumbent designs, installs, configures, patches, upgrades, monitors, optimizes, backs up, recovers, maintains, and operates all FI$Cal system database services. Additionally, they oversee system monitoring to ensure optimal performance and reliability and conduct technical testing, including performance testing, disaster recovery testing, and accessibility testing, to support FI$Cal system integrity. 

Please note that to be list appointed for placement in the Information Technology Specialist II classification, you must take and pass the examination .

This position is being re-advertised. If you have previously applied, your application is on file for consideration and you do not need to reapply.

You will find additional information about the job in the .

Working Conditions

At FI$Cal, we currently offer a remote-centered position with the flexibility of telework up to three days per week. In-office attendance is mandatory on designated days and is subject to change. Our office is located at 2000 Evergreen Street, Sacramento, CA. Candidates residing outside of California are welcome to interview, but proof of California residency is required before appointment. Please note, relocation and commute expenses are the responsibility of the employee.

This position requires prolonged sitting in an office-setting environment with the use of a personal computer. Employees must demonstrate a commitment to maintain a working environment free from discrimination and sexual harassment. All staff must maintain regular, consistent, predictable attendance, maintain good working habits and adhere to all policies and procedures.

Visa Sponsorship
This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment with Department of FISCal.

Special Requirements

• The position(s) require(s) a Background Investigation be cleared prior to being hired.

• The incumbent will use tact and interpersonal skills to develop constructive and cooperative working relationships with others, e.g., stakeholders, customers, management, peers, etc., to facilitate communication to improve the work environment and increase productivity.
• This position requires the ability to work under pressure to meet deadlines and may require excess hours to be worked.   
• The incumbent is expected to perform functions and duties under the guidance of the Department of FISCal’s core values.
• The incumbent provides back-up, as necessary, to ensure continuity of departmental activities.

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:

• Experience installing and configuring Oracle database software and tools.
• Experience designing and implementing high availability and disaster recovery using Oracle RAC, Data Guard, ASM, and RMAN.
• Experience monitoring database performance and implementing performance tuning.
• Experience developing, testing, and implementing database backup and recovery procedures.
• Knowledge of implementing TDE Encryption.
• Experience in database patching and upgrades.
• Experience with SQL, PL/SQL scripting.
• Experience working in the Linux operating system.
• Experience in Exadata.
• Experience in Oracle Cloud Infrastructure (OCI).

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

Our office has free, gated parking, and convenient electric vehicle charging stations available.

Statement of Qualifications

Statement of Qualifications (SOQ)

A Statement of Qualifications (SOQ) is required and must be submitted with your application. The SOQ serves as a documentation of each candidate’s ability to present information clearly and concisely in writing.

When completing the SOQ, you must title the page “Statement of Qualifications”, number and list the question, providing your answer below. When completing the SOQ please explain your answers thoroughly, including all relevant experience, education and training. The SOQ must be typed in 12-point Arial font and be no more than 3 pages in length with correct grammar use, punctuation and spelling. Your SOQ must address the following:

1. Please provide a specific example of a challenging performance issue you resolved in an Oracle database, include the steps you took to identify and resolve the performance issue and the tools you used to resolve it.

2. Describe your experience implementing Oracle Data Guard for high availability and disaster recovery. How did you configure it, and how do you ensure it operates effectively in production environments?

3. List the most common issues you’ve faced in an Oracle RAC environment. From that list provide an example of a specific issue and the steps you took to diagnose and resolve the issue.

Please attach your SOQ to your application. Applications received without the SOQ or that do not follow these instructions will not be considered.

Note: Resumes, letters, and other materials will not be evaluated or considered as responses to the Statement of Qualifications.

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 optional. It may be included, but is not required.
• Statement of Qualifications -

  A Statement of Qualifications (SOQ) is required and must be submitted with your application. Please see instructions below.

Job Tags

Permanent employment, Full time, Work at office, Remote work, Relocation, 3 days per week,

Similar Jobs