City of Santa Rosa, CA
Technology Application Specialist
City of Santa Rosa, CA, Santa Rosa, California, us, 95402
Salary :
$7,779.92 - $9,452.75 Monthly
Location :
Various locations in the City of Santa Rosa, CA
Job Type:
Full-Time
Job Number:
24/25-14DAG-O
Department:
Water
Opening Date:
09/23/2024
Closing Date:
10/14/2024 11:59 PM Pacific
FLSA:
Non-Exempt
Bargaining Unit:
07
The Position
The City of Santa Rosa
is currently seeking a qualified applicant for the position of Technology Application Specialist. We invite you to join the team at the City where you can be part of a dynamic, customer-centric, collaborative, diverse, inclusive and knowledgeable organization committed to facilitating a thriving community by providing excellent customer service.
The City of Santa Rosa is committed to building a workforce reflective of our community and establishing a lasting culture of equity and belonging within our organization. Our collective talents and expertise contribute to high-quality public services that support a vibrant, resilient, inclusive City for our community and visitors. We celebrate a diverse workforce and welcome all qualified candidates to apply.
THE BENEFITS OF CITY EMPLOYMENT:
12 paid holidays annually, plus 1 to 3 'floating holidays' per year, depending on start date and years of service$500 annually for wellnessFlexible schedule 9/80 available with management approvalMay be eligible for a hybrid remote schedule after successful completion of probationIn addition to offering a challenging, rewarding work environment and excellent salary, the City of Santa Rosa provides a generous suite of benefits, including retirement through CalPERS, a competitive leave accrual package, your choice of health plan, a flexible spending program, employer contributions to a Retiree Health Savings plan, flexible work schedule options, and top of the line employer paid (free to you) vision and dental coverage. More information regarding benefits associated with this position can be found on our .
ABOUT THE POSITION:The primary purpose of this job classification is to handle software and enterprise-level application tasks of moderate to complex difficulty, supporting various operations across multiple divisions within the Water department. This role is based in the Asset Management Division and assists City departments with the daily management of essential software applications. Responsibilities include software configuration, program modifications, user support, training, process improvements, report development, and other related duties as needed.THE IDEAL CANDIDATE The ideal candidate has experience supporting enterprise level software applications and Microsoft SQL databases, including writing complex T-SQL queries, developing stored procedures, using Microsoft SQL Server Management Studio, developing reports using Microsoft SQL Server Reporting Services (SSRS), and troubleshooting software problems. In addition, the ideal candidate has excellent interpersonal skills which enable him or her to work extensively with both technical and non-technical staff at all levels City- wide. The candidate must be able to logically create detailed documents and emails, as well as track, coordinate and facilitate communication on multiple projects simultaneously. Experience with water utility processes and asset data is a plus. Previous asset management experience is highly desirable.
THE SUCCESSFUL CANDIDATE:The successful candidate:
Has significant experience with software troubleshooting or installations dutiesIs detail oriented and has experience analyzing business processes and recommending modifications.Understands and can implement the modern principles and practices of computer systems management and maintenance.For more information about the City of Santa Rosa Water Department and its efforts to providing safe and reliable water supply to our local community, please visit Water's website at:
HOW TO APPLY:Please complete a thoughtful, thorough Supplemental Questionnaire submission. As part of the selection process, your responses to these questions will be scored using criteria specific to this position. Incomplete responses, or responses such as "See Resume" can result in disqualification from the selection process.
ADDITIONAL REQUIREMENTS:Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter.
THE SELECTION PROCESS:The selection process will include a minimum qualifications assessment; and may also include an application and supplemental questionnaire review, followed by department selection interviews.
THE CURRENT VACANCIES:The City of Santa Rosa Water Department is looking to fill one, full-time Technology Application Specialist (TAS) with duties in Asset Management focused heavily on fulfilling the City's asset information needs.*The resulting eligible list of this recruitment may be used to fill future vacancies City-wide.*
For more information about this exciting opportunity, please contact Debbie Gutman at
Examples of Duties and Responsibilities
Analyzes, documents and recommends changes to business processes;Advises and consults with users to develop required application services for departmental business processes;Plans, coordinates, and schedules future needs keeping all parties informed of plans, progress, and issues;Develops and recommends application and resource priorities;Evaluates existing program performance and recommends modifications;Administers changes and adjustments to systems as needed.Assists in the day-to-day operations of the department's applications technology needs;Replaces, repairs, upgrades, and maintains system software and hardware;Monitors and recommends improvement to operational performance and security;Troubleshoots system problems;Isolates the cause of system failures;Implements system upgrades;Installs new and additional hardware and software as required.Develops and implements automated records, workflows, stored procedures and specialized mid-level reports in response to user needs.Conducts formal and informal training programs on the use and operation of various application systems software. Maintains and compiles documentation of user procedures manuals, technical references, training manuals, handbooks and guides;Identifies opportunities for improving service delivery methods and procedures;Reviews with appropriate management staff and implements improvements.Maintains tables, data structures, diagrams and testing data;Develops and administers methods to ensure data integrity.Determines when to escalate problems to vendors or programmers to identify and correct causes of hardware and software malfunctions and to perform enhancements.Responds to and resolves user inquiries and complaints.Attends and participates in professional group meetings;Stays abreast of new trends, innovations, equipment, and languages used in computer systems and information technology in the area of assignment, as well as standard word processing, spread-sheet, database, reporting tools, graphics, and desktop publishing software.Provides emergency response to reduce down time, correct errors, monitor vendor activity, facilitate off hours scheduled maintenance, and repair system failures on an as needed basis.Performs other duties as assigned.
Required Qualifications
Knowledge of:
Modern principles and practices of computer systems management, analysis, design, database structures & relationships, script writing, documentation, and maintenance; various software packages including word processing, spreadsheet, and database management, reporting tools, graphics and desktop publishing applications and programs; principles, techniques, and tools of computer hardware and software installation, troubleshooting and maintenance; operating principles, methods, practices, options, and limitations of a wide range of hardware related to computers; data management theory, principles, techniques, and practices and their application to a wide variety of services and programs; applicable technical terminology, applications, features, and services; operating systems such as Windows, LAN/WAN principles, PC, Web and server applications and telephone systems; modern office practices, methods, and equipment; principles and procedures of record keeping and reporting; research techniques, methods, and procedures; occupational hazards and standard safety practices necessary in the area of computer operations; correct usage of the English language, including correct grammar, spelling, vocabulary, and punctuation; techniques for dealing effectively with, and providing a high level of customer service to, the public, vendors, contractors and City staff, both in person and over the telephone.
Ability to :
Analyze problems, identify alternative solutions, project consequences of proposed actions, and implement recommendations in support of goals; accurately evaluate and prioritize hardware and software requests; operate and troubleshoot modern office equipment including computer equipment and software programs; learn the operations and functions of assigned City work groups in order to provide appropriate support; research, develop, recommend and implement cost-effective technical system improvements; prepare and maintain accurate and complete records; respond to requests and inquiries from end-users; exercise good judgment, flexibility, creativity, and sensitivity in response to changing situations and needs; understand and carry out oral and written instructions; use English effectively to communicate in person, over the telephone, in a classroom and in writing; use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines; establish and maintain effective working relationships with those contacted in the course of the work.
Education and Experience:
Any combination of training and experience that would provide the required knowledge, skills and abilities is qualifying. A typical way to obtain the required qualifications would be:
Experience - Sufficient years of increasingly responsible experience providing administration and technical support to users of a specialized computer application to demonstrate possession of the knowledge and abilities listed above.
Education - Equivalent to completion of high school supplemented by college or university coursework in computer science, information technology, business administration, or a related field.
Selection Process:All applications and supplemental questionnaires will be carefully reviewed. The applicants possessing the MOST DESIRABLE qualifications will be invited to the next steps of the selection process, which will include an interview and may include an application appraisal and written exam. An eligible list will be established as a result of this selection process and may be used to fill future vacancies.
Additional Information
Working Conditions
Ability to sit for extended periods of time with some ability to move about at will. Ability to operate standard office equipment, computers and a variety of office software requiring continuous or repetitive arm-hand movements. Ability to learn Job-related material through oral and/or written instruction in an on-the-job setting, structured classroom training, and by reading and comprehending written material and graphic instructions and making inferences from the contents. Ability to communicate verbally face to face, on the telephone, and in group meetings. Able to perform a visual scan of on-screen information when monitoring operation of applications. Ability to occasionally lift and move monitors, printers, and other equipment weighing up to 50 pounds for short distances.
SANTA ROSA - A WONDERFUL CITY TO CALL HOME:The City of Santa Rosa is nestled in the center of famous Sonoma Wine Country, located just 55 miles north of San Francisco and 30 miles east of the Pacific Ocean with a population of approximately 180,000. Santa Rosa serves as the County seat and the center of trade, government, commerce, and medical facilities for the North Bay. The surrounding area is home to over a hundred wineries and vineyards and many beautiful parks and recreational facilities, including golf courses. Santa Rosa is in the center of a nationally recognized cycling area. We boast many attractions associated with large cities, including a symphony, performing arts center, theater productions and internationally recognized restaurants, yet still retain the warmth and small town feel of decades past. Santa Rosa has been named one of the 50 greenest cities in the United States with one of the top five mid-sized downtowns in California.
The City of Santa Rosa is proud to be an equal opportunity workplace.
The City does not discriminate on the basis of disability in employment. Requests for reasonable accommodations needed to participate in the recruitment process may be made by submitting a
Request for Reasonable Accommodation Form
within five (5) business days of being noticed that an event requiring accommodation is occurring. You may also contact the Human Resources Department at (707) 543-3060 or jobs@srcity.org.
In addition to offering a challenging, rewarding work environment and excellent salary, the City of Santa Rosa provides a generous suite of benefits.
This job classification is in Miscellaneous Unit 7, Technical. Please click to be redirected to the City's benefits information page.
01
Describe your level of experience with Microsoft SQL Server Management Studio, including writing complex stored procedures and queries using T-SQL. What versions of SSMS have you used?
02
Describe the extent of your experience developing complex reports for end-users using Microsoft SQL Server Reporting Services (SSRS), dashboard tools such as Microsoft PowerBI, or other report development tools.
03
Describe your overall database and scripting experience. What scripting languages and/or ETL tools have you used? What was your involvement in development and maintenance?
04
Describe your experience providing information, software configuration, and support to end-users on enterprise-level software applications. In your response, include your experience providing needs analysis, software configuration, testing, ad-hoc queries, training, creating process documentation, and report writing. Please also describe any specific experience you have with enterprise asset management and/or permitting and inspection systems.
05
Please provide an example of a time when you provided excellent customer service. Include the type of issue, the challenges you faced, and the results.
Required Question
$7,779.92 - $9,452.75 Monthly
Location :
Various locations in the City of Santa Rosa, CA
Job Type:
Full-Time
Job Number:
24/25-14DAG-O
Department:
Water
Opening Date:
09/23/2024
Closing Date:
10/14/2024 11:59 PM Pacific
FLSA:
Non-Exempt
Bargaining Unit:
07
The Position
The City of Santa Rosa
is currently seeking a qualified applicant for the position of Technology Application Specialist. We invite you to join the team at the City where you can be part of a dynamic, customer-centric, collaborative, diverse, inclusive and knowledgeable organization committed to facilitating a thriving community by providing excellent customer service.
The City of Santa Rosa is committed to building a workforce reflective of our community and establishing a lasting culture of equity and belonging within our organization. Our collective talents and expertise contribute to high-quality public services that support a vibrant, resilient, inclusive City for our community and visitors. We celebrate a diverse workforce and welcome all qualified candidates to apply.
THE BENEFITS OF CITY EMPLOYMENT:
12 paid holidays annually, plus 1 to 3 'floating holidays' per year, depending on start date and years of service$500 annually for wellnessFlexible schedule 9/80 available with management approvalMay be eligible for a hybrid remote schedule after successful completion of probationIn addition to offering a challenging, rewarding work environment and excellent salary, the City of Santa Rosa provides a generous suite of benefits, including retirement through CalPERS, a competitive leave accrual package, your choice of health plan, a flexible spending program, employer contributions to a Retiree Health Savings plan, flexible work schedule options, and top of the line employer paid (free to you) vision and dental coverage. More information regarding benefits associated with this position can be found on our .
ABOUT THE POSITION:The primary purpose of this job classification is to handle software and enterprise-level application tasks of moderate to complex difficulty, supporting various operations across multiple divisions within the Water department. This role is based in the Asset Management Division and assists City departments with the daily management of essential software applications. Responsibilities include software configuration, program modifications, user support, training, process improvements, report development, and other related duties as needed.THE IDEAL CANDIDATE The ideal candidate has experience supporting enterprise level software applications and Microsoft SQL databases, including writing complex T-SQL queries, developing stored procedures, using Microsoft SQL Server Management Studio, developing reports using Microsoft SQL Server Reporting Services (SSRS), and troubleshooting software problems. In addition, the ideal candidate has excellent interpersonal skills which enable him or her to work extensively with both technical and non-technical staff at all levels City- wide. The candidate must be able to logically create detailed documents and emails, as well as track, coordinate and facilitate communication on multiple projects simultaneously. Experience with water utility processes and asset data is a plus. Previous asset management experience is highly desirable.
THE SUCCESSFUL CANDIDATE:The successful candidate:
Has significant experience with software troubleshooting or installations dutiesIs detail oriented and has experience analyzing business processes and recommending modifications.Understands and can implement the modern principles and practices of computer systems management and maintenance.For more information about the City of Santa Rosa Water Department and its efforts to providing safe and reliable water supply to our local community, please visit Water's website at:
HOW TO APPLY:Please complete a thoughtful, thorough Supplemental Questionnaire submission. As part of the selection process, your responses to these questions will be scored using criteria specific to this position. Incomplete responses, or responses such as "See Resume" can result in disqualification from the selection process.
ADDITIONAL REQUIREMENTS:Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter.
THE SELECTION PROCESS:The selection process will include a minimum qualifications assessment; and may also include an application and supplemental questionnaire review, followed by department selection interviews.
THE CURRENT VACANCIES:The City of Santa Rosa Water Department is looking to fill one, full-time Technology Application Specialist (TAS) with duties in Asset Management focused heavily on fulfilling the City's asset information needs.*The resulting eligible list of this recruitment may be used to fill future vacancies City-wide.*
For more information about this exciting opportunity, please contact Debbie Gutman at
Examples of Duties and Responsibilities
Analyzes, documents and recommends changes to business processes;Advises and consults with users to develop required application services for departmental business processes;Plans, coordinates, and schedules future needs keeping all parties informed of plans, progress, and issues;Develops and recommends application and resource priorities;Evaluates existing program performance and recommends modifications;Administers changes and adjustments to systems as needed.Assists in the day-to-day operations of the department's applications technology needs;Replaces, repairs, upgrades, and maintains system software and hardware;Monitors and recommends improvement to operational performance and security;Troubleshoots system problems;Isolates the cause of system failures;Implements system upgrades;Installs new and additional hardware and software as required.Develops and implements automated records, workflows, stored procedures and specialized mid-level reports in response to user needs.Conducts formal and informal training programs on the use and operation of various application systems software. Maintains and compiles documentation of user procedures manuals, technical references, training manuals, handbooks and guides;Identifies opportunities for improving service delivery methods and procedures;Reviews with appropriate management staff and implements improvements.Maintains tables, data structures, diagrams and testing data;Develops and administers methods to ensure data integrity.Determines when to escalate problems to vendors or programmers to identify and correct causes of hardware and software malfunctions and to perform enhancements.Responds to and resolves user inquiries and complaints.Attends and participates in professional group meetings;Stays abreast of new trends, innovations, equipment, and languages used in computer systems and information technology in the area of assignment, as well as standard word processing, spread-sheet, database, reporting tools, graphics, and desktop publishing software.Provides emergency response to reduce down time, correct errors, monitor vendor activity, facilitate off hours scheduled maintenance, and repair system failures on an as needed basis.Performs other duties as assigned.
Required Qualifications
Knowledge of:
Modern principles and practices of computer systems management, analysis, design, database structures & relationships, script writing, documentation, and maintenance; various software packages including word processing, spreadsheet, and database management, reporting tools, graphics and desktop publishing applications and programs; principles, techniques, and tools of computer hardware and software installation, troubleshooting and maintenance; operating principles, methods, practices, options, and limitations of a wide range of hardware related to computers; data management theory, principles, techniques, and practices and their application to a wide variety of services and programs; applicable technical terminology, applications, features, and services; operating systems such as Windows, LAN/WAN principles, PC, Web and server applications and telephone systems; modern office practices, methods, and equipment; principles and procedures of record keeping and reporting; research techniques, methods, and procedures; occupational hazards and standard safety practices necessary in the area of computer operations; correct usage of the English language, including correct grammar, spelling, vocabulary, and punctuation; techniques for dealing effectively with, and providing a high level of customer service to, the public, vendors, contractors and City staff, both in person and over the telephone.
Ability to :
Analyze problems, identify alternative solutions, project consequences of proposed actions, and implement recommendations in support of goals; accurately evaluate and prioritize hardware and software requests; operate and troubleshoot modern office equipment including computer equipment and software programs; learn the operations and functions of assigned City work groups in order to provide appropriate support; research, develop, recommend and implement cost-effective technical system improvements; prepare and maintain accurate and complete records; respond to requests and inquiries from end-users; exercise good judgment, flexibility, creativity, and sensitivity in response to changing situations and needs; understand and carry out oral and written instructions; use English effectively to communicate in person, over the telephone, in a classroom and in writing; use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines; establish and maintain effective working relationships with those contacted in the course of the work.
Education and Experience:
Any combination of training and experience that would provide the required knowledge, skills and abilities is qualifying. A typical way to obtain the required qualifications would be:
Experience - Sufficient years of increasingly responsible experience providing administration and technical support to users of a specialized computer application to demonstrate possession of the knowledge and abilities listed above.
Education - Equivalent to completion of high school supplemented by college or university coursework in computer science, information technology, business administration, or a related field.
Selection Process:All applications and supplemental questionnaires will be carefully reviewed. The applicants possessing the MOST DESIRABLE qualifications will be invited to the next steps of the selection process, which will include an interview and may include an application appraisal and written exam. An eligible list will be established as a result of this selection process and may be used to fill future vacancies.
Additional Information
Working Conditions
Ability to sit for extended periods of time with some ability to move about at will. Ability to operate standard office equipment, computers and a variety of office software requiring continuous or repetitive arm-hand movements. Ability to learn Job-related material through oral and/or written instruction in an on-the-job setting, structured classroom training, and by reading and comprehending written material and graphic instructions and making inferences from the contents. Ability to communicate verbally face to face, on the telephone, and in group meetings. Able to perform a visual scan of on-screen information when monitoring operation of applications. Ability to occasionally lift and move monitors, printers, and other equipment weighing up to 50 pounds for short distances.
SANTA ROSA - A WONDERFUL CITY TO CALL HOME:The City of Santa Rosa is nestled in the center of famous Sonoma Wine Country, located just 55 miles north of San Francisco and 30 miles east of the Pacific Ocean with a population of approximately 180,000. Santa Rosa serves as the County seat and the center of trade, government, commerce, and medical facilities for the North Bay. The surrounding area is home to over a hundred wineries and vineyards and many beautiful parks and recreational facilities, including golf courses. Santa Rosa is in the center of a nationally recognized cycling area. We boast many attractions associated with large cities, including a symphony, performing arts center, theater productions and internationally recognized restaurants, yet still retain the warmth and small town feel of decades past. Santa Rosa has been named one of the 50 greenest cities in the United States with one of the top five mid-sized downtowns in California.
The City of Santa Rosa is proud to be an equal opportunity workplace.
The City does not discriminate on the basis of disability in employment. Requests for reasonable accommodations needed to participate in the recruitment process may be made by submitting a
Request for Reasonable Accommodation Form
within five (5) business days of being noticed that an event requiring accommodation is occurring. You may also contact the Human Resources Department at (707) 543-3060 or jobs@srcity.org.
In addition to offering a challenging, rewarding work environment and excellent salary, the City of Santa Rosa provides a generous suite of benefits.
This job classification is in Miscellaneous Unit 7, Technical. Please click to be redirected to the City's benefits information page.
01
Describe your level of experience with Microsoft SQL Server Management Studio, including writing complex stored procedures and queries using T-SQL. What versions of SSMS have you used?
02
Describe the extent of your experience developing complex reports for end-users using Microsoft SQL Server Reporting Services (SSRS), dashboard tools such as Microsoft PowerBI, or other report development tools.
03
Describe your overall database and scripting experience. What scripting languages and/or ETL tools have you used? What was your involvement in development and maintenance?
04
Describe your experience providing information, software configuration, and support to end-users on enterprise-level software applications. In your response, include your experience providing needs analysis, software configuration, testing, ad-hoc queries, training, creating process documentation, and report writing. Please also describe any specific experience you have with enterprise asset management and/or permitting and inspection systems.
05
Please provide an example of a time when you provided excellent customer service. Include the type of issue, the challenges you faced, and the results.
Required Question