Senior Innovation & Technology Analyst- Microsoft SQL

City of Riverside•Riverside, CA

1d•Onsite

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

Requirements

Equivalent to a Bachelor's Degree in Computer Science, Information Systems, or closely related field AND Four years of full-time work experience in computer science, information systems, voice/data communications, data center operations, database administration or a related field.
Equivalent to an Associate's Degree in Computer Science, Information Systems, or closely related field AND Six years of full-time work experience in computer science, information systems, voice/data communications, data center operations, database administration or a related field.
High School graduation or satisfactory equivalent (GED) AND 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.

Nice To Haves

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

Responsibilities

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.