Riverside County, CA
Temporary IT Database Administrator III
Riverside County, CA, Riverside, California, United States, 92504
Salary :
$90,690.60 - $135,535.81 Annually
Location :
Riverside
Job Type:
Temporary
Remote Employment:
Flexible/Hybrid
Job Number:
24-86139-01TBA
Department:
Information Technology
Opening Date:
11/18/2024
Closing Date:
11/28/2024 11:59 PM Pacific
ABOUT THE POSITION
The Riverside County Information Technology (RCIT) department is seeking a Temporary IT Database Administrator (DBA) III to join the Database Solution team.
The Temporary IT Database Administrator III is responsible for defining database information, developing access and file structure requirements through discussions with users and staff members, and designing and implementing database management systems by creating models, building table structures, establishing referential integrity, and preparing documentation. The DBA III will maintain databases by performing database management system backups and recovery, tuning for optimal performance, monitor data integrity and security.
Additionally, the DBA III will ensure acceptable database performance, assess user access and response time, manipulate data through normalization, transfer, and tuning, create and maintain data warehousing and data mining systems, design and maintain database software configuration library, specification, documentation, and operating procedures.
The most competitive candidates will be have experience in using Oracle and PeopleSoft databases.
Meet the Department
The Riverside County Information Technology department provides information technology services to County departments and agencies and is entrusted with managing and safeguarding the County's enterprise and mission-critical solutions and infrastructure. RCIT is committed to cultivating a collaborative and inclusive culture that fosters best of breed solutions with a focus on problem-solving to deliver quality products and services to our customers.
Meet the Team!
TAP Benefits:EXAMPLES OF ESSENTIAL DUTIES• Define database information, access and file structure requirements through discussions with users and colleagues.• May provide technical oversight, mentor, and delegate work to subordinate staff.• Develop methods for storing, analyzing, and organizing data; monitor various third party vendor tools; analyze various vendor products and contribute to request for proposals.• Perform migrations for version upgrades; transfer files.• Develop transaction logs for backups to ensure business continuity; implement disaster recovery plan when needed.• Administer and troubleshoot database issues for users; monitor databases and database interfaces.• Ensure database performance, optimization, and availability.• Maintain security and integrity of databases and servers; develop reports and queries as requested.• Develop procedures and data applications; access user access and response time.• Design and implement database management systems by creating models, building table structure, establishing referential integrity, and preparing documentation; design databases to enhance existing applications; provide database support for application development lifecycle.• Maintain databases by performing database management system backups and recovery including off-site storage for disaster recovery; maintain databases by tuning, monitoring data integrity and security, and resolving problems.• Ensure acceptable database performance through assessing user access and response time, modifying structure, and conferring with others responsible for system resource interface and data users.• Manipulate data through normalization, transfer, tuning, cleansing and scrubbing processes, and database population.• Create and maintain data warehousing and data mining systems; design and maintain database software configuration library, specifications, documentation, and operating procedures.• Research, evaluate and test proposed products, product versions and systems solutions.• Develop quality standards based on industry standards and evaluation of available technology and resources.
MINIMUM QUALIFICATIONS
Education:
Completion of 30 semester or 45 quarter units from an accredited college or university, preferably with coursework in computer science, computer information systems, data processing, information management, or a related field to the assignment. (Additional qualifying IT job-related experience may substitute for the required education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience).
Experience:
Four years of successful journey level IT Database Administrator related experience, one year of which included either lead person duties or technically advanced IT job-related work. (One year as an IT Database Administrator II will satisfy the one year of lead or technically advanced experience requirement.)
Other RequirementsLicense: Possession of a valid California Driver's License may be required.
A successful Security Clearance conducted by the Sheriffs' Department is required for positions within the Riverside County Information Technology Department.
Knowledge of:
The principles, methods, and techniques used in the course of work for the IT Database Administrator series; principles and techniques applied to IT devices, applications, and systems; principles of organization and administration; the principles of documentation and recordkeeping, storage and retrieval.
Ability to:
Gather and analyze data, reason logically, draw valid conclusions, and make appropriate recommendations; resolve technical problems and innovate more efficient use of IT resources; perform systems analysis work and problem solving; interpret and follow written and oral instructions; prepare concise reports and documents; establish and maintain effective working relationships with staff, customers, other employees, and the public; communicate effectively with people at all organizational levels.
Required IT-Related Skills:
Oracle and PeopleSoft database systems
SUPPLEMENTAL INFORMATION
Recruiter Contact Information:
For questions regarding this recruitment contact Brian Arcinas at barcinas@rivco.org.
APPLICATION INFORMATION
Veteran's PreferenceThe County has a Veterans Preference Policy applicable to new hires. To qualify, upload a copy of your (or your spouse's) Member-4 Form DD-214 indicating dates of service, and a copy of your spouse's letter of disability (if applicable) with your application. For privacy reasons, it is recommended that you remove your social security information from the document(s). A Human Resources Representative will review the materials and determine if you qualify for veterans' preference. The Veterans Preference Policy, C-3 is available here:
Reasonable AccommodationsThe County of Riverside is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and Fair Employment and Housing Act (FEHA). Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process should contact the recruiter for the position noted above. For additional information and/or to obtain the appropriate form for requesting a reasonable accommodation, please visit the Disability Access Office web page located at:
Proof of EducationIf using education to qualify or when requested by the recruiter, upload a copy of any license(s), official/unofficial transcript(s), degrees, and/or related employment documents to your NeoGov account at the time of application and before the closing date. Official or unofficial transcripts will be accepted.
If your education was completed outside of the United States, you will need to provide a copy of your Foreign Education Equivalency evaluation from a member of the National Association of Credential Evaluation Services () or Association of International Credential Evaluators, Inc. ().
Equal Opportunity EmployerThe County of Riverside is an Equal Opportunity Employer. It is the policy of the County of Riverside to provide equal employment opportunities for all qualified persons. All applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition (cancer and genetic characteristics), genetic information, or denial of medical and family care leave, or any other non-job-related factors.
Pre-EmploymentAll employment offers are contingent upon successful completion of pre-employment requirements including a criminal background investigation, which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment). A pre-employment physical examination and background check may be required.
Probationary PeriodAs an Approved Local Merit System, all County of Riverside employees, except those serving "At Will," are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding, County Resolution, or Salary Ordinance. Temporary and Per Diem employees serve at the pleasure of the agency/department head.
General InformationCurrent County of Riverside and/or current employees of the hiring department may receive priority consideration. Qualified candidates may be considered for future County vacancies.
Job postings may close without notice based on application volume. Submit your complete application by the recruitment close date; no late applications are accepted. Ensure all relevant experience/education is reflected on your application/resume, as a failure to demonstrate position requirements may disqualify applicants. A description of job duties directly copied from the job classification or job posting will not be considered.
Please read and follow any special application instructions on this posting. Click the ' Apply ' link located on this page to submit your application. For additional instructions on the application process, examinations, Veteran's preference, pre-employment accommodation or other employment questions, please refer to our web site,
If you are experiencing technical problems, you may contact the governmentjobs.com applicant support desk Monday through Friday, 6 am to 5 pm Pacific Time at support@governmentjobs.com or toll-free 1-855-524-5627.
MEDICAL/DENTAL/VISION INSURANCE: A choice of different medical, dental and visions plan are available to elect. The County provides a Flexible Benefit Credit contribution as governed by the applicable SEIU Memorandum of Understanding to contribute towards the cost of these plans.
Note: Employees on assignment through the Temporary Assignment Program (TAP) receive different benefits. See the listMISCELLANEOUS RETIREMENT : County of Riverside has three retirement Tiers through the California Public Employees' Retirement System (CalPERS).Tier I
(Classic Member - Formula 3% @ 60): Applicable to current and former County of Riverside local miscellaneous employees hired prior to 08/24/2012 and did not withdraw CalPERS contributions. The employee contribution is eight (8%) percent.Tier II
(Classic Member - Formula 2% @ 60): Applicable to local miscellaneous employees 1) hired after 08/23/2012 through 12/31/2012; 2) Previously employed with another CalPERS contracting public agency or a reciprocal retirement system, with a break in service of less than six months between the separation date with the previous employer and the appointment date with the County of Riverside. The employee contribution is seven (7%) percent.Tier III
(PEPRA New Member - Formula 2% @ 62): Applicable to CalPERS local miscellaneous new members hired on or after the implementation of the Public Employees' Pension Reform Act of 2013 (PEPRA) which took effect January 1, 2013.
Effective July 1, 2023 employee contributions are 7.25% and will increase to 7.75% effective July 1, 2024.
A new member is defined as any of the following:A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who has no prior membership in any California Public Retirement System.A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who was a member with another California Public Retirement System prior to that date, but who is not subject to reciprocity upon joining CalPERS.A member who first established CalPERS membership prior to January 1, 2013, and who is rehired by a different CalPERS agency after a break in service of greater than six (6) months.
CalPERS refers to all members that do not fit within the definition of a new member as "classic members".
Contribution rates are subject to change based on the County of Riverside annual actuarial valuation.
Note:
This summary is for general information purposes only. Additional questions regarding retirement formulas can be sent to or by calling the Benefits Information Line at (951) 955-4981,Option 2.
If you have prior service credit with another CalPERS agency or within agencies, please contact CalPERS at (888) 225-7377 to determine which retirement tier would be applicable to you. CalPERS is governed by the Public Employees' Retirement Law. The Retirement Law is complex and subject to change. If there's any conflict between this summary and the law, the law will prevail over this summary.DEFERRED COMPENSATION: Voluntary employee contribution with a choice between two 457 deferred compensation plan options.
VACATION ACCRUAL (Bi-Weekly Accrual):
0
YesNo
02
Have you completed 30 semester or 45 quarter units of education or more from an accredited college or university with major coursework in computer science, computer information systems, data processing, information management, or a related field?
YesNo
03
How many years of experience do you have working with Oracle or PeopleSoft database? (include details on application/resume to support your answer)
No experienceLess than 3 years3 years or more, but less than 4 years4 years or more, but less than 5 years5 years or more, but less than 6 years6 years or more, but less than 7 years7 years or more, but less than 8 years8 years or more
04
Do you have at least one year of experience in either a lead role or in performing advanced technical work as an IT database administrator?
YesNo
05
How many years of full-time journey level IT job-related experience do you have?
No ExperienceLess than 1 year1 year or more, but less than 22 years or more, but less than 33 years or more, but less than 44 years or more, but less than 55 years or more, but less than 66 years or more, but less than 77 years or more, but less than 88 years or more
Required Question
$90,690.60 - $135,535.81 Annually
Location :
Riverside
Job Type:
Temporary
Remote Employment:
Flexible/Hybrid
Job Number:
24-86139-01TBA
Department:
Information Technology
Opening Date:
11/18/2024
Closing Date:
11/28/2024 11:59 PM Pacific
ABOUT THE POSITION
The Riverside County Information Technology (RCIT) department is seeking a Temporary IT Database Administrator (DBA) III to join the Database Solution team.
The Temporary IT Database Administrator III is responsible for defining database information, developing access and file structure requirements through discussions with users and staff members, and designing and implementing database management systems by creating models, building table structures, establishing referential integrity, and preparing documentation. The DBA III will maintain databases by performing database management system backups and recovery, tuning for optimal performance, monitor data integrity and security.
Additionally, the DBA III will ensure acceptable database performance, assess user access and response time, manipulate data through normalization, transfer, and tuning, create and maintain data warehousing and data mining systems, design and maintain database software configuration library, specification, documentation, and operating procedures.
The most competitive candidates will be have experience in using Oracle and PeopleSoft databases.
Meet the Department
The Riverside County Information Technology department provides information technology services to County departments and agencies and is entrusted with managing and safeguarding the County's enterprise and mission-critical solutions and infrastructure. RCIT is committed to cultivating a collaborative and inclusive culture that fosters best of breed solutions with a focus on problem-solving to deliver quality products and services to our customers.
Meet the Team!
TAP Benefits:EXAMPLES OF ESSENTIAL DUTIES• Define database information, access and file structure requirements through discussions with users and colleagues.• May provide technical oversight, mentor, and delegate work to subordinate staff.• Develop methods for storing, analyzing, and organizing data; monitor various third party vendor tools; analyze various vendor products and contribute to request for proposals.• Perform migrations for version upgrades; transfer files.• Develop transaction logs for backups to ensure business continuity; implement disaster recovery plan when needed.• Administer and troubleshoot database issues for users; monitor databases and database interfaces.• Ensure database performance, optimization, and availability.• Maintain security and integrity of databases and servers; develop reports and queries as requested.• Develop procedures and data applications; access user access and response time.• Design and implement database management systems by creating models, building table structure, establishing referential integrity, and preparing documentation; design databases to enhance existing applications; provide database support for application development lifecycle.• Maintain databases by performing database management system backups and recovery including off-site storage for disaster recovery; maintain databases by tuning, monitoring data integrity and security, and resolving problems.• Ensure acceptable database performance through assessing user access and response time, modifying structure, and conferring with others responsible for system resource interface and data users.• Manipulate data through normalization, transfer, tuning, cleansing and scrubbing processes, and database population.• Create and maintain data warehousing and data mining systems; design and maintain database software configuration library, specifications, documentation, and operating procedures.• Research, evaluate and test proposed products, product versions and systems solutions.• Develop quality standards based on industry standards and evaluation of available technology and resources.
MINIMUM QUALIFICATIONS
Education:
Completion of 30 semester or 45 quarter units from an accredited college or university, preferably with coursework in computer science, computer information systems, data processing, information management, or a related field to the assignment. (Additional qualifying IT job-related experience may substitute for the required education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience).
Experience:
Four years of successful journey level IT Database Administrator related experience, one year of which included either lead person duties or technically advanced IT job-related work. (One year as an IT Database Administrator II will satisfy the one year of lead or technically advanced experience requirement.)
Other RequirementsLicense: Possession of a valid California Driver's License may be required.
A successful Security Clearance conducted by the Sheriffs' Department is required for positions within the Riverside County Information Technology Department.
Knowledge of:
The principles, methods, and techniques used in the course of work for the IT Database Administrator series; principles and techniques applied to IT devices, applications, and systems; principles of organization and administration; the principles of documentation and recordkeeping, storage and retrieval.
Ability to:
Gather and analyze data, reason logically, draw valid conclusions, and make appropriate recommendations; resolve technical problems and innovate more efficient use of IT resources; perform systems analysis work and problem solving; interpret and follow written and oral instructions; prepare concise reports and documents; establish and maintain effective working relationships with staff, customers, other employees, and the public; communicate effectively with people at all organizational levels.
Required IT-Related Skills:
Oracle and PeopleSoft database systems
SUPPLEMENTAL INFORMATION
Recruiter Contact Information:
For questions regarding this recruitment contact Brian Arcinas at barcinas@rivco.org.
APPLICATION INFORMATION
Veteran's PreferenceThe County has a Veterans Preference Policy applicable to new hires. To qualify, upload a copy of your (or your spouse's) Member-4 Form DD-214 indicating dates of service, and a copy of your spouse's letter of disability (if applicable) with your application. For privacy reasons, it is recommended that you remove your social security information from the document(s). A Human Resources Representative will review the materials and determine if you qualify for veterans' preference. The Veterans Preference Policy, C-3 is available here:
Reasonable AccommodationsThe County of Riverside is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and Fair Employment and Housing Act (FEHA). Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process should contact the recruiter for the position noted above. For additional information and/or to obtain the appropriate form for requesting a reasonable accommodation, please visit the Disability Access Office web page located at:
Proof of EducationIf using education to qualify or when requested by the recruiter, upload a copy of any license(s), official/unofficial transcript(s), degrees, and/or related employment documents to your NeoGov account at the time of application and before the closing date. Official or unofficial transcripts will be accepted.
If your education was completed outside of the United States, you will need to provide a copy of your Foreign Education Equivalency evaluation from a member of the National Association of Credential Evaluation Services () or Association of International Credential Evaluators, Inc. ().
Equal Opportunity EmployerThe County of Riverside is an Equal Opportunity Employer. It is the policy of the County of Riverside to provide equal employment opportunities for all qualified persons. All applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition (cancer and genetic characteristics), genetic information, or denial of medical and family care leave, or any other non-job-related factors.
Pre-EmploymentAll employment offers are contingent upon successful completion of pre-employment requirements including a criminal background investigation, which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment). A pre-employment physical examination and background check may be required.
Probationary PeriodAs an Approved Local Merit System, all County of Riverside employees, except those serving "At Will," are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding, County Resolution, or Salary Ordinance. Temporary and Per Diem employees serve at the pleasure of the agency/department head.
General InformationCurrent County of Riverside and/or current employees of the hiring department may receive priority consideration. Qualified candidates may be considered for future County vacancies.
Job postings may close without notice based on application volume. Submit your complete application by the recruitment close date; no late applications are accepted. Ensure all relevant experience/education is reflected on your application/resume, as a failure to demonstrate position requirements may disqualify applicants. A description of job duties directly copied from the job classification or job posting will not be considered.
Please read and follow any special application instructions on this posting. Click the ' Apply ' link located on this page to submit your application. For additional instructions on the application process, examinations, Veteran's preference, pre-employment accommodation or other employment questions, please refer to our web site,
If you are experiencing technical problems, you may contact the governmentjobs.com applicant support desk Monday through Friday, 6 am to 5 pm Pacific Time at support@governmentjobs.com or toll-free 1-855-524-5627.
MEDICAL/DENTAL/VISION INSURANCE: A choice of different medical, dental and visions plan are available to elect. The County provides a Flexible Benefit Credit contribution as governed by the applicable SEIU Memorandum of Understanding to contribute towards the cost of these plans.
Note: Employees on assignment through the Temporary Assignment Program (TAP) receive different benefits. See the listMISCELLANEOUS RETIREMENT : County of Riverside has three retirement Tiers through the California Public Employees' Retirement System (CalPERS).Tier I
(Classic Member - Formula 3% @ 60): Applicable to current and former County of Riverside local miscellaneous employees hired prior to 08/24/2012 and did not withdraw CalPERS contributions. The employee contribution is eight (8%) percent.Tier II
(Classic Member - Formula 2% @ 60): Applicable to local miscellaneous employees 1) hired after 08/23/2012 through 12/31/2012; 2) Previously employed with another CalPERS contracting public agency or a reciprocal retirement system, with a break in service of less than six months between the separation date with the previous employer and the appointment date with the County of Riverside. The employee contribution is seven (7%) percent.Tier III
(PEPRA New Member - Formula 2% @ 62): Applicable to CalPERS local miscellaneous new members hired on or after the implementation of the Public Employees' Pension Reform Act of 2013 (PEPRA) which took effect January 1, 2013.
Effective July 1, 2023 employee contributions are 7.25% and will increase to 7.75% effective July 1, 2024.
A new member is defined as any of the following:A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who has no prior membership in any California Public Retirement System.A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who was a member with another California Public Retirement System prior to that date, but who is not subject to reciprocity upon joining CalPERS.A member who first established CalPERS membership prior to January 1, 2013, and who is rehired by a different CalPERS agency after a break in service of greater than six (6) months.
CalPERS refers to all members that do not fit within the definition of a new member as "classic members".
Contribution rates are subject to change based on the County of Riverside annual actuarial valuation.
Note:
This summary is for general information purposes only. Additional questions regarding retirement formulas can be sent to or by calling the Benefits Information Line at (951) 955-4981,Option 2.
If you have prior service credit with another CalPERS agency or within agencies, please contact CalPERS at (888) 225-7377 to determine which retirement tier would be applicable to you. CalPERS is governed by the Public Employees' Retirement Law. The Retirement Law is complex and subject to change. If there's any conflict between this summary and the law, the law will prevail over this summary.DEFERRED COMPENSATION: Voluntary employee contribution with a choice between two 457 deferred compensation plan options.
VACATION ACCRUAL (Bi-Weekly Accrual):
0
YesNo
02
Have you completed 30 semester or 45 quarter units of education or more from an accredited college or university with major coursework in computer science, computer information systems, data processing, information management, or a related field?
YesNo
03
How many years of experience do you have working with Oracle or PeopleSoft database? (include details on application/resume to support your answer)
No experienceLess than 3 years3 years or more, but less than 4 years4 years or more, but less than 5 years5 years or more, but less than 6 years6 years or more, but less than 7 years7 years or more, but less than 8 years8 years or more
04
Do you have at least one year of experience in either a lead role or in performing advanced technical work as an IT database administrator?
YesNo
05
How many years of full-time journey level IT job-related experience do you have?
No ExperienceLess than 1 year1 year or more, but less than 22 years or more, but less than 33 years or more, but less than 44 years or more, but less than 55 years or more, but less than 66 years or more, but less than 77 years or more, but less than 88 years or more
Required Question