IT Database Administrator III

Salary : $90,690.60 - $135,535.81 Annually Location : Riverside Job Type: Regular Job Number: 24-86139-03 Department: Information Technology Division: Database Solutions Opening Date: 10/25/2024 Closing Date: 11/11/2024 11:59 PM Pacific ABOUT THE POSITION The County of Riverside's Information Technology Department is seeking an IT Database Administrator III (DBA III) to support Oracle and SQL Server databases for multiple departments, with a focus on Oracle databases and PeopleSoft applications. The DBA III will manage and optimize databases for the County's enterprise systems, including the PeopleSoft Financial Management System (FMS) and Human Capital Management (HCM). The DBA III will administer and optimize Oracle and SQL Server databases, providing essential support for the County's PeopleSoft Financial Management System (FMS) and Human Capital Management (HCM) systems. This role includes performing database backups, recovery, and disaster recovery management to ensure data integrity and continuity. The DBA III will also monitor and tune databases for optimal performance, resolving any issues to maintain efficient and reliable operations. Additionally, the position involves managing data warehousing and mining systems and keeping up with new database technologies and tools to improve system capabilities. The ideal candidate will have advanced knowledge of Oracle (19c) and MS SQL Server (2019) with hands-on experience in database optimization, backups, and recovery. Experience with cloud platforms, such as Oracle Cloud Infrastructure (OCI), AWS, or Azure, is highly preferred. A background in PeopleSoft systems is beneficial, with knowledge of Oracle Exadata systems seen as a strong advantage. Meet the Team 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. 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 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.) 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 : RDBMS modeling, design, replication, propagation, and tuning; working in a multi-user, multi-platform network environment with understanding of dB/OS interaction; DB2, IMS, Informix, Sybase; one or more of CA-7, COBOL, CLISTS, DBRC, DFDSS, Erwin, ER Studio, FDR, ISPF, MVS, PACE, RMF, SMF, TSO, Turbo Image, or VSAM. Preferred IT-Related Skills : RDBMS in a client server environment (e.g., NT, UNIX); internal consulting to determine user information needs, identify systems of origin and encourage enterprise resource use. Other Requirement : A successful Security Clearance conducted by the Sheriffs' Department is required for positions within the Riverside County Information Technology Department. SUPPLEMENTAL INFORMATION This recruitment is open to all applicants. For questions regarding this recruitment contact Ebelyn Skinner at eskinnerrivco.org. APPLICATION INFORMATION Veteran's Preference The 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 Accommodations The 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 Education If 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 Employer The 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-Employment All 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 Period As 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 Information Current 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 supportgovernmentjobs.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 list MISCELLANEOUS 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 4 10 or more years 160 Hours (20 Days) Maximum Vacation leave accumulation is 480 hours. SICK LEAVE: Four (4) hours Sick Leave accrual per pay period with unlimited accrual. HOLIDAYS: Normally 12 paid holidays per year. BEREAVEMENT LEAVE: Allowed 5 days (3 days are County paid; 2 additional days can be taken from accrued Sick Leave balance). BASIC LIFE INSURANCE: Equal to one times annual base salary not to exceed $50,000 of term life coverage. Premiums are paid by the County. Additional Supplemental Life plan is available for employee purchase. DISABILITY: Short-term Disability benefit pays up to a maximum of $461.54 weekly, payable up to a maximum of 52 weeks. POST RETIREMENT MEDICAL CONTRIBUTION: A monthly contribution is made by the County towards retiree health insurance offered through the County as governed by the applicable SEIU Memorandum of Understanding. OTHER: There may be other benefit provisions as specified in the applicable Memorandum of Understanding. Please contact the recruiter listed on the job posting directly for more information. 01 I understand that I will be required to submit to a security clearance background check conducted by the Riverside County Sheriff's Department as part of the employment requirements of this position. Yes No 02 Have you completed at least 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). Yes No 03 Do you have at least four years of journey level IT database administrator job-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.) Yes No 04 How many years of full-time experience do you have in administering Oracle databases (19c or higher)? No Experience Less than 1 year 1 year or more, but less than 2 2 years or more, but less than 3 3 years or more, but less than 4 4 years or more, but less than 5 5 years or more, but less than 6 6 years or more 05 How many years of full-time experience do you have in managing Microsoft SQL Server databases (2019 or higher)? No Experience Less than 1 year 1 year or more, but less than 2 2 years or more, but less than 3 3 years or more, but less than 4 4 years or more, but less than 5 5 years or more, but less than 6 6 years or more 06 How many years of experience do you have supporting PeopleSoft Financial Management System (FMS) or Human Capital Management (HCM) systems? None Less than 1 year 1 year or more, but less than 2 2 years or more, but less than 3 3 years or more, but less than 4 4 years or more, but less than 5 5 years or more, but less than 6 6 years or more 07 How many years of experience do you have optimizing database performance using tools for Oracle and SQL Server? None Less than 1 year 1 year or more, but less than 2 2 years or more, but less than 3 3 years or more, but less than 4 4 years or more, but less than 5 5 years or more, but less than 6 6 years or more 08 How many years of experience do you have implementing database backup and recovery methods, including off-site disaster recovery solutions? No Experience Less than 1 year 1 year or more, but less than 2 2 years or more, but less than 3 3 years or more, but less than 4 4 years or more, but less than 5 5 years or more, but less than 6 6 years or more Required Question