Senior Innovation & Technology Analyst- Microsoft Sql

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.

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.

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.

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.

• When assigned to the Police Department, must be able to successfully pass an extensive police background.

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

• 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.

If you are selected to move forward in the assessment process, you may be required to…