It Database Administrator Ll

Salary : $79,606.80 - $109,303.45 Annually Location : Riverside Job Type: Regular Job Number: 24-86138-01 Department: Information Technology Division: Database Solutions Opening Date: 10/23/2024 Closing Date: 11/7/2024 11:59 PM Pacific ABOUT THE POSITION The Riverside County Information Technology (RCIT) Department is seeking a skilled IT Database Administrator II (IT DBA II) to join the Database Solutions Division located in Riverside, CA.
This role will focus on the installation, implementation, and management of Microsoft SQL Server and Oracle database solutions to support various in-house and third-party applications and data repositories.
The ideal candidate will have hands-on experience with SQL Server 2019 or higher, Oracle databases, and the ability to handle database creation, table and view design, stored procedures, and functions development.
Additionally, you will manage and monitor database maintenance plans, SSIS (SQL Server Integration Services), agent jobs, and perform import/ETL processes from external sources.
Key Responsibilities: Install and implement Microsoft SQL Server and Oracle database solutions.
Create and manage SQL Server and Oracle databases, tables, views, stored procedures, and functions to support applications and data repositories.
Implement, manage, and monitor SQL and Oracle database maintenance plans, SSIS packages, and agent jobs.
Perform data imports and ETL processes from external sources.
Collaborate with internal and external teams to support in-house and third-party applications.
Desired Qualifications: Proficiency with Microsoft SQL Server 2019 or higher.
Experience with Oracle Databases (version 19g or higher).
Working knowledge or experience with: SolarWinds monitoring and management tools.
Veeam backup solutions.
Microsoft Power BI.
Tyler EnerGov Permitting & Land Management software and databases.
Required Qualifications: Extensive knowledge of Oracle Databases.
Experience in Microsoft SQL Server database administration and management.
Strong understanding of database maintenance plans, agent jobs, and SSIS.
Preferred Experience: Experience with Tyler EnerGov software and database.
Working knowledge of SolarWinds and Veeam tools.
Meet the Team 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.
EXAMPLES OF ESSENTIAL DUTIES Define database information, access and file structure requirements through discussions with users and colleagues.
Administer and troubleshoot database issues for users; monitor databases.
Maintain security and integrity of databases and servers; develop reports as requested.
Develop procedures and data applications; access user access and response time.
Design architecture of server applications; Design and implement by writing, testing, and debugging complex programs.
Design and implement database management system by creating models, building table structure, establishing referential integrity, and preparing documentation.
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 : Two years of IT database administrator job-related experience, preferably with the County of Riverside.
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 specific questions regarding this position, contact Ebelyn Skinner at eskinner 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 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 02 How many years of IT database administrator related work experience do you have with the County of Riverside, a public agency or large organization?
No Experience Less than 1 year 1 year or more, but less than 2 years 2 years or more, but less than 3 years 3 years or more, but less than 4 years 4 years or more, but less than 5 years 5 years or more, but less than 6 6 years or more 03 How many years of experience do you have in managing and administering Microsoft SQL Server databases (version 2019 or higher)?
(Please note that your answers will be verified against the information provided on your application) 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 04 How many years of experience do you have working with Oracle databases (version 19g or higher), including installation, configuration, and performance tuning?
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 experience do you have with ETL (Extract, Transform, Load) processes and data imports from external sources?
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 Describe your experience with developing and managing SQL Server Integration Services (SSIS) packages.
How frequently have you worked with SSIS in your database administration roles?
No Experience Limited experience (have used occasionally) Moderate experience (used regularly) Extensive experience (expert user) 07 How experience do you have with a complex database project you worked on where you had to manage both SQL Server and Oracle databases?
No Experience Limited Experience (have used occasionally) Moderate Experience (used regularly) Extensive Experience (expert user) Required Question