SENIOR INNOVATION & TECHNOLOGY ANALYST- MICROSOFT SQL

City of Riverside, CA

• $107K — $144K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent experience
  • 4-8 years of relevant work experience in IT or related fields
  • Expertise in Windows SQL Database Administration and Management
  • Strong project management skills
  • Ability to provide technical guidance and training to team members

Responsibilities

  • Perform complex system analysis and consultation for information systems
  • Lead projects and provide technical guidance to lower-level analysts
  • Evaluate and implement new systems and upgrades
  • Prepare complex technical reports using database tools
  • Conduct training for users on systems and applications
  • Maintain professional relationships with vendors and technical support
  • Provide on-call support after hours as needed

Benefits

  • Comprehensive health insurance with significant employer contribution
  • Dental and vision insurance coverage
  • Generous retirement plans with no Social Security deduction
  • Life insurance coverage equal to two times annual salary
  • Flexible spending accounts for healthcare and dependent care
  • Long-term disability insurance options
  • Accrued vacation and sick leave benefits
Full Job Description
Salary : $107,880.00 - $144,024.00 Annually
Location : Riverside, CA
Job Type: Full-time
Job Number: 26-9253-01
Department: Innovation and Technology
Division: INNOV AND TECHNOLOGY - OPERS
Opening Date: 10/01/2026
Closing Date: 10/25/2026 11:59 PM Pacific

The Position
The City of Riverside, Innovation and Technology Department (IT) is accepting applications for the position of SENIOR INNOVATION AND TECHNOLOGY ANALYST to fill one (1) vacancy in the Operations Division. The eligibility list established may be used to fill the current and/or upcoming vacancies within this classification for up to six (6) months.
Under general direction, the Senior Innovation and Technology Analyst to perform a variety of complex professional, technical and analytical duties in the areas of programming, testing, troubleshooting, installation, implementation, documentation and maintenance of assigned systems, databases, programs and applications. The Senior Innovation and Technology Analyst is to act in a lead capacity providing technical guidance to the Innovation & Technology Analysts and perform other duties as assigned.

Work Performed
Typical duties may include, but are not limited to, the following:
  • Perform complex system analysis and consultation in the design, development, implementation, and maintenance of information systems, networks, servers, supporting hardware and software applications in a specialized technical area.
  • Act in a lead capacity over lower level Analysts and Technicians on a project basis.
  • Provide advanced technical assistance to system users in accordance with applicable information systems policies, procedures, methods and techniques.
  • Evaluate, plan, implement and integrate new systems and current system upgrades.
  • Prepare and design complex technical reports through database and report writing tools.
  • Perform project management duties on assigned systems projects.
  • Perform research, gather costing information, vendor quotes and recommend hardware and software based on current or new City standards.
  • Develop and produce system documentation, instructional, procedural manuals and systems architectural design.
  • Coordinate and conduct training for client users on assigned systems, applications, or other special projects.
  • Work with administration and propose enhancements to improve services, policies, and procedures.
  • Apply strong written and oral presentation skills when working directly with other Analysts or end users of varying technical ability and/or knowledge.
  • Maintain effective and professional relationships with vendors and their technical support personnel.
  • Provide on-call after hours support 24x7 as assigned.
  • Provide scheduled after hours support for migrations, installations, troubleshooting and upgrades as assigned.

Qualifications

Option I

Education: Equivalent to a Bachelor's Degree in Computer Science, Information Systems, or closely related field.

Experience: Four years of full-time work experience in computer science, information systems, voice/data communications, data center operations, database administration or a related field.

Option II

Education: Equivalent to an Associate's Degree in Computer Science, Information Systems, or closely related field.

Experience: Six years of full-time work experience in computer science, information systems, voice/data communications, data center operations, database administration or a related field.

Option III

Education: High School graduation or satisfactory equivalent (GED).

Experience: Eight year of full-time work experience in computer science, information systems, voice/data communications, data center operations, database administration or a related field.
Necessary Special Requirement:
  • When assigned to the Police Department, must be able to successfully pass an extensive police background.
Highly Desired Qualifications:
Expertise in the following:
  • Windows SQL Database Administration
  • Windows SQL Database Management
  • Windows SQL Database Patching
  • SQL Database Clustering / High Availability
Knowledge/experience in the following:
  • Windows SQL Query Knowledge/Experience
  • SQL Data Warehouse


Selection Process
DOCUMENTS REQUIRED AT THE TIME OF APPLICATION:
1) Completed Employment Application
2) Completed Supplemental Questionnaire
FOR GENERAL INFORMATION ON COMPLETING YOUR ON-LINE APPLICATION, CLICK HERE: (Application Guide).

The selection process will begin with an employment application package screening, with the best qualified candidates being invited to participate further in the assessment process. This process may include any combination of written, performance, and oral assessments to evaluate job-related education, experience, knowledge, skills, and abilities. Those who successfully complete the selection process will be placed on the eligibility list for this classification.

IMPORTANT INFORMATION ON SCHEDULING ASSESSMENTS:

If you are selected to move forward in the assessment process, you may be required to self-schedule your appointment. You will be notified via email of your status and provided with self-scheduling instructions. Please check your email regularly following the closing date of this recruitment.

NOTE: The City reserves the right to modify selection devices and test instruments in accordance with accepted legal, ethical, and professional standards. Candidates may reapply when there is a posting to establish an eligibility list.

EDUCATIONAL REQUIREMENTS:

Proof of education listed in your application will be requested at the time of conditional offer. Acceptable documentation consists of transcripts or degree, if applicable, by the accredited U.S. college or university.

Education obtained outside the United States (US) require one of the following options:
  1. An equivalency statement from an evaluation company certified by the National Association of Credential Evaluation Services (NACES) at Members - NACES or the Association of International Credential Evaluators Inc. (AICE) at http://aice-eval.org/members/.
  2. An advanced-level degree from an accredited US college or university.

All applicants will be notified via e-mail or telephone of their application status and the assessment dates/times/locations after the closing date of this announcement.
THE PROVISIONS OF THIS JOB ANNOUNCEMENT DO NOT CONSTITUTE AN EXPRESSED OR IMPLIED CONTRACT.
Benefit Level II includes Senior Management, Management and Professional classifications (Exempt)

The City offers an attractive benefits package, the central provisions of which are as follows:
  • Retirement for Classic Members - For employees hired after 1/1/2013 who are CLASSIC MEMBERS of California Public Employees' Retirement System (CalPERS) or a reciprocal agency as of 12/31/12 and have not been separated from service from such agency for six months or more, the retirement benefit shall be 2.7 % @ age 55; 3-year final compensation. The required employee contribution is 8%. The City does not participate in Social Security; thus, employees do not bear this additional 6.2% expense.
  • Retirement for New Members - For employees hired 1/1/2013 or later and who ARE NOT a member of the California Public Employees' Retirement System (CalPERS) or a reciprocal agency as of 12/31/12, or those who have been separated from a public agency which contracts with CalPERS or a reciprocal agency for six months or more, the retirement benefit shall be 2% at age 62; 3 year final compensation. The required employee contribution is 50% of the normal cost. And is subject to change per CalPERS every fiscal year. The City does not participate in Social Security; thus, employees do not bear this additional 6.2% expense.
  • Health Insurance - The City offers six health insurance plans and contributes up to $1,734 per month for HMO plans (family coverage).
  • Dental Insurance - The City provides three dental insurance plans and contributes up to $85 per month.
  • Vision Insurance - The City provides vision coverage through Vision Service Plan (VSP) for employees and their dependents that are enrolled in medical coverage.
  • Life Insurance - The City provides and pays for term life insurance with accidental death and dismemberment equal to two times the annual salary rounded to the next highest $1,000 (up to $700k) plus AD&D. Additional Life Insurance is available and voluntary for employee and eligible dependents (up to $300k).
  • Deferred Compensation - The City will contribute the following amounts per month, with a minimum employee contribution of $12.50 per check:
    • Management and Professional Units: $150/month
    • Senior Management Unit: $175/month
  • Leave Benefits - Includes vacation leave, sick leave, bereavement leave, and holiday benefits. Please refer to the Fringe Benefits and Salary Plan for specific details.
  • Flexible Spending Account - The City offers a Health Care and Dependent Care Flexible Spending Plan for optional participation.
  • Long Term Disability - The City offers optional enrollment in the Long-Term Disability Plan.
  • LegalEase Plan - Optional legal services plan for employees and eligible dependents.
  • Critical Illness Plan - Optional critical illness insurance plan for employees and eligible dependents.
  • Vacation Accrual - 0-9 yrs. = 144 hrs., 10+ yrs. = 184 hrs.
  • Administrative Leave -
    • Management and Professional Units: 64 hrs. per fiscal year.
    • Senior Management Unit: 80 hrs. per fiscal year.

For additional benefits information, please visit the following website:

For part-time, benefitted positions the insurance and other benefits (leave accruals, holidays, etc.) are pro-rated based on ½ or ¾ time status.
01

Instructions: The information on the application and your responses to the following supplemental questions will be used to determine whether you meet the minimum and/or highly desirable qualifications for the position in which you are applying. Detailed responses must be provided for each question in order to ensure qualifications are properly considered.
(Do not refer to a resume in lieu of completing the supplemental questions).
Employers listed on this questionnaire must also be listed and fully detailed in the work experience section of your application.
  • I understand.

02

Please indicate the highest level of education you have completed.
  • Less than High School Diploma or GED
  • High School Diploma or GED
  • Some college coursework completed
  • Associate's Degree
  • Bachelor's Degree
  • Master's Degree
  • PhD

03

Please indicate the amount of full-time work experience you possess in computer science, information systems, voice/data communications, data center operations, database administration or a related field.
  • Less than 4 years
  • More than 4 years, less than 6 years
  • More than 6 years, less than 8 years
  • 8 years, or more

04

Indicate your level of experience with Windows SQL Database Administration.
  • Beginner
  • Proficient
  • Expert

05

Indicate your level of experience with Windows SQL Database Management.
  • Beginner
  • Proficient
  • Expert

06

Indicate your level of experience with Windows SQL Database Patching.
  • Beginner
  • Proficient
  • Expert

07

Indicate your level of experience with SQL Database Clustering / High Availability.
  • Beginner
  • Proficient
  • Expert

08

Indicate your level of experience with SQL Data Warehouse.
  • Beginner
  • Proficient
  • Expert

09

Do you possess SQL Query knowledge?
  • Yes
  • No

10

Do you possess SQL Query experience?
  • Yes
  • No

11

I understand this position may perform work that supports the Police Department and therefore will require an extensive Police Department background check.
  • I understand

12

Certification: I understand that I cannot update my application once it has been submitted. Therefore, I have fully completed ALL sections, provided full descriptions of my duties and responsibilities for each employer, and have fully answered ALL questions on the Supplemental Questionnaire. Do not refer to a resume or other documentation, as it will not be reviewed in lieu of completing the Supplemental Questionnaire. Note: Employers and/or experience noted on the Supplemental Questionnaire must also be included and fully detailed on the Application.
  • I understand.

Required Question

Similar Jobs

More Jobs at City of Riverside, CA

More Information Technology Jobs

Find similar SENIOR INNOVATION & TECHNOLOGY ANALYST- MICROSOFT SQL jobs: