Oracle Database Administrator

Salary : $90,012.08 - $124,948.31 Annually
Location : Ventura and may require travel throughout Ventura County, CA
Job Type: Full-Time Regular
Job Number: 1868ITS-23AA (CZ)
Department: Information Technology Services Department
Division: ITSD Technical Services
Opening Date: 12/08/2023
Closing Date: Continuous
Description
What We Offer
The County of Ventura offers an attractive compensation and benefits package. Aside from our base salary range, an employee with this position will also be eligible for the following:

• A general salary increase (GSI) of 4.0% effective December 23, 2023 and 3.5% effective December 22, 2024.
• New Hire/Retention/Referral Incentive - New hires may be eligible for a one-time New Hire Incentive up to 10% of the current annual base wage. (Subject to the applicable section of the SEIU 721 MOA 2022-2025, Article 38 (Secs. 3801 - 3803))
• Educational Incentive - An educational incentive of 2.5% for completion of an associate degree, 3.5% for completion of a bachelor's degree, OR 5% for completion of a graduate degree.
• Flexible Workweek - A compressed work schedule (e.g., 9/80 workweek) may be available for some positions.
• Vacation Accrual - New regular, full-time employees shall accrue approximately 14 days of vacation a year for the first 10,400 hours or 5 years of service; vacation accruals increase at 5, 11, 12, 13, 14, 15 and 20 years of service topping out at 26 days a year and 400 hours of vacation hours banked.
• Vacation Leave Redemption - After 14,560 hours of continuous County service an employee may elect to "cash in" or redeem up to 80 hours of vacation accrued in the same year after using 80 hours of vacation in the preceding 12 months.
• Sick Leave - Full time regular employees accrue 3.08 hours of sick leave per pay period with an advance at hire of 40.04 hours which will be balanced at the completion of 13 bi-weekly pay periods.
• Health Plans - You are afforded an annual flexible credit allowance for purchasing medical, dental, and/or vision insurance from a group of authorized plans.
• Flexible Spending Accounts - Pre-tax benefit towards eligible medical, dental and vision care expenses.
• Pension Plan - Participation in County's defined pension plan, which has reciprocity with CalPERS.
• Holidays - 12 paid days per year which includes a scheduled floating holiday.
• Additional Benefits - Tuition Reimbursement, Disability Plans, Employee Assistance Program, Life Insurance, Wellness Program.

The Department
The Information Technology Services Department (ITSD) works with every Ventura County department/agency to provide the necessary technology infrastructure and consulting/contracting services to meet ongoing and emerging business needs, including project management, business process improvement, applications support, voice/data infrastructure, data security, threat and vulnerability/risk management, and extended staffing.
The Position
Under general supervision, develops relational and client/server applications; including participation in the analysis, architecture, design, and documentation required to produce a database capable of supporting large and complex applications. May supervise a small technical team as part of a larger project.
The Ideal Candidate
The successful candidate will have extensive Oracle database administration experience with at least 5 years supporting large critical production environments running on Linux. The candidate will also have experience or the knowledge to support SQL server databases.
Payroll Title: Data Systems Architect
The Oracle Database Administrator (Data Systems Architect) position is represented by the Service Employees International Union (SEIU), Local 721 and is eligible for overtime compensation.
The eligible list established from this recruitment may be used to fill current and future Regular (including temporary and Fixed Term), Intermittent, and Extra-Help vacancies within the Information Technology Services Department. There is currently one (1) Regular, Full-time vacancy.
TENTATIVE SCHEDULE
OPENING DATE: Friday, December 8, 2023
CLOSING DATE: Continuous and may close at any time; therefore, the schedule for the remainder of the process will depend upon when we receive a sufficient number of qualified applications to meet business needs.
Examples Of Duties
Duties may include but are not limited to the following:

• Installs and creates Oracle Databases;
• Uses utilities and tools to support large Oracle Databases;
• Upgrades and patches Oracle Databases
• Manages storage within the Oracle Databases and Oracle Database Appliances;
• Performs Oracle Database backups and recovery;
• Manages users and security within Oracle Databases;
• Monitors and conducts performance tuning;
• Checks Error Log and Corrective Action;
• Supports SQL Server Databases in a backup role; and
• Performs other related duties as required.

Typical Qualifications
These are entrance requirements to the examination process and assure neither continuance in the process nor placement on an eligible list.
EDUCATION, TRAINING and EXPERIENCE
Highly experienced in supporting Oracle databases running on Linux (RHEL) operating systems, be proficient in a relational database environment such as Oracle and SQL Server.
NECESSARY SPECIAL REQUIREMENTS:

• Possess and maintain a California driver's license;
• Ability to travel within Ventura County to conduct studies or troubleshoot;
• Ability to work long hours to resolve production problems or meet project deadlines;
• Ability to work nights, weekends, and holidays on an on-call basis;
• Excellent written communication skills must be demonstrated in the completion of the employment application and supplemental questionnaire.

DESIRED:

• Advanced formal training from software/database vendors.

KNOWLEDGE SKILLS AND ABILITIES:
Thorough knowledge of:

• Linux (RHEL) operating systems;
• Oracle Database Appliances highly desirable;
• The concepts and techniques of analyzing data and developing or refining physical databases;
• Formal training on 11g-19c Oracle Database;

Thoroughly skilled in:

• SQL Data Management/Manipulation language;

Comprehensive ability to:

• Provide lead technical direction to staff;
• Analyze complex procedures and develop logical conclusions;
• Prepare and present comprehensive reports and recommendations in written and oral form;
• Gain knowledge of client's database and its current and potential uses;
• Communicate effectively orally and in writing;
• Maintain positive working relationships with customer departments and internal staff members;

Recruitment Process
FINAL FILING DATE: Continuous and may close at any time; therefore, apply as soon as possible if you are interested in it. Your application must be received by the County of Ventura Human Resources in Ventura, California, no later than 5:00 p.m. on the closing date.
To apply on-line, please refer to our web site at If you prefer to fill out a paper application form, please call (805) 654-5129 for application materials and submit them to County of Ventura Human Resources, 800 South Victoria Avenue, L-1970, Ventura, CA 93009.
Note to Applicants: Sufficient information must be provided under the Education/Work experience portion of the application and supplemental questionnaire to thoroughly and accurately demonstrate your qualifications in order to determine eligibility. A resume may be attached to supplement your responses in the above-referenced sections; however, it may not be submitted in lieu of the application.
INFORMATION FOR TRANSFER CANDIDATES: If presently permanently employed in another "merit" or "civil service" public agency/entity in the same or substantively similar position as is advertised, and if appointed to that position by successful performance in a "merit" or "civil service" style examination, then appointment by "Lateral Transfer" may be possible. If interested, please click for additional information.
SUPPLEMENTAL QUESTIONNAIRE - qualifying
All applicants are required to complete and submit the questionnaire for this examination at the time of filing. The supplemental questionnaire may be used throughout the examination process to assist in determining each applicant's qualifications and acceptability for the position. Failure to complete and submit the questionnaire may result in the application being removed from consideration.
APPLICATION EVALUATION - qualifying
All applications will be reviewed to determine whether or not the stated requirements are met. Those individuals meeting the stated requirements will be invited to continue to the next step in the examination process.
TRAINING & EXPERIENCE EVALUATION:
A Training and Experience Evaluation (T&E) is a structured evaluation of the job application materials submitted by a candidate, including the written responses to the supplemental questionnaire. The T&E is NOT a determination of whether the candidate meets the stated requirements; rather, the T&E is one method for determining who are the better qualified among those who have shown that they meet the stated requirements. In a T&E, applications are either scored or rank ordered according to criteria that most closely meet the business needs of the department. Candidates are typically scored/ranked in relation to one another; consequently, when the pool of candidates is exceptionally strong, many qualified candidates may receive a score or rank which is moderate or even low resulting in them not being advanced in the process.
NOTE: The selection process will likely consist of an Oral Exam, which may be preceded or replaced with the score from a Training and Experience Evaluation (T&E), contingent upon the size and quality of the candidate pool. In a typical T&E, your training and experience are evaluated in relation to the background, experience and factors identified for successful job performance during a job analysis. For this reason, it is recommended that your application materials clearly show your relevant background and specialized knowledge, skills, and abilities. It is also highly recommended that the supplemental questions within the application are completed with care and diligence. Responses such as "See Resume" or "Refer to Resume" are not acceptable and may disqualify an applicant from further evaluation.
ORAL EXAMINATION - 100%:
A job-related oral examination will be conducted to evaluate and compare participating candidates' knowledge, skills, and abilities in relation to those factors which job analysis has determined to be essential for successful performance of the job. Candidates must earn a score of seventy percent (70%) or higher to qualify for placement on the eligible list.
NOTE: If there are three (3) or fewer qualified applicants, an examination will not be conducted. Instead, a score of 70% will be assigned to each application, and each applicant will be placed on the eligible list.
Candidates successfully completing the examination process may be placed on an eligible list for a period of one (1) year.
BACKGROUND INVESTIGATION: A thorough post offer, pre-employment background investigation which may include inquiry into past employment, education, criminal background information, and driving record may be required for this position.
EQUAL EMPLOYMENT OPPORTUNITY
The County of Ventura 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.
For further information regarding this recruitment, please contact Crystal Zendejas by email at Crystal.Zendejas@ventura.org or by telephone at (805) 654-7608.
YOUR BENEFITS AS A COUNTY OF VENTURA EMPLOYEE
Service Employees International Union (LOCAL 721)
(SEIU)
To learn more about Benefits, Retirement, and the Memorandum of Agreement (MOA), see links below.

• or you may call (805) 654-2570.

Union Codes: UPA, UPC, UPE, UPH, UPI, UPJ, UPT, UWS
01
Describe your experience using Oracle Databases. In your answer, please include the following:
A) The employer on this application where you obtained the experience
B) Duties performed
C) Number of years of experience
If you do not have this experience, please type "No experience."
02
Describe your experience supporting databases running on Linux (RHEL) operating systems. In your answer, please include the following:
A) The employer on this application where you obtained the experience
B) Duties performed
C) Number of years of experience
If you do not have this experience, please type "No experience."
03
Describe your knowledge of or experience working with SQL server databases. In your answer, please include the following:
A) The employer on this application where you obtained the experience
B) Duties performed
C) Number of years of experience
If you do not have this experience, please type "No experience."
04
Do you possess, or can you obtain and maintain, a valid California driver's license prior to date of hire?

• Yes
• No

05
Are you willing and able to ...