SENIOR INNOVATION & TECHNOLOGY ANALYST- MICROSOFT SQL

City of Riverside; Riverside (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

The City of Riverside, Innovation and Technology Department, is seeking a Senior Innovation and Technology Analyst to lead complex information systems projects and provide technical guidance to staff. The role emphasizes system analysis, database administration, and cross-functional collaboration within the IT team.

Responsibilities include design, implementation, and maintenance of systems, training client users, and coordinating with vendors.

Qualifications

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

Responsibilities

• Perform complex system analysis and design, development, implementation, and maintenance of information systems, networks, servers, and software applications.
• Act in a lead capacity over Analysts and Technicians on a project basis.
• Provide advanced technical assistance to system users in accordance with information systems policies and procedures.
• Prepare and design complex technical reports through database and report writing tools.
• Coordinate and conduct training for client users on assigned systems and applications.

Skills

Project management

Technical leadership

System analysis

Vendor coordination

Training coordination

Education

Bachelor's degree in Computer Science/Information Systems

Associate's degree in Computer Science/Information Systems

High School diploma or GED

Tools

Windows SQL Server

SQL Database Administration

SQL Database Management

SQL Database Patching

SQL Database Clustering/HA

SQL Data Warehouse

Job description

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.

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.

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

DOCUMENTS REQUIRED AT THE TIME OF APPLICATION

• 1) Completed Employment Application
• 2) Completed Supplemental Questionnaire

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.

Positions that require, or may require, a California Commercial Driver’s License are considered Safety Sensitive and are monitored by the U.S. Department of Transportation. Any candidate being considered for a Safety Sensitive position must submit authorization forms to the City immediately upon request to begin the pre-employment process.

It is the responsibility of candidates with a disability requiring accommodation in the assessment process to contact the Human Resources Department in writing to request such accommodation prior to the closing date of this recruitment.

Appointment may be subject to the successful completion of a pre-employment background investigation, drug screen, and/or medical/physical examination.

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.