Department Systems Specialist I

  • City of Sacramento, CA
  • Sacramento, California
  • Jul 24, 2022
Full Time Information Technology and Communication Services
  • Salary: $66,902.18 - $94,138.09 Annually USD

Job Description

The City of Sacramento requires all newly appointed employees to be fully vaccinated against COVID-19 as a condition of employment. Candidates seeking an accommodation from this requirement will be considered on a case-by-case basis.


With supervisor approval, incumbents may be eligible for intermittent remote work; however, they must physically reside within the State of California with the ability to report to Sacramento-based physical worksites daily if required.

This position is part of the Enterprise Applications Division responsible for configuring, supporting, and maintaining the cloud case management system. The primary responsibilities for this position include the day-to-day support and configuration of the system. Additional responsibilities include report development, scripting, requirement gathering, and administration.

This is a technical position that provides a wide range of development-related duties and end-user training. In addition, this position will monitor system security and performance. The ideal candidate should also be able to work independently with minimal supervision on providing necessary support and enhancements in a timely manner.

The ideal candidate will have two or more years of hands-on experience with the following:
  • Application configuration, scripting, and support
  • Strong verbal and written communication skills
  • Fluency with a programming language
  • Proficient with requirements gathering and report development
Additional experience will the following is preferred, but not required:
  • Citizenserve code enforcement software
  • Relational Database, SQL query and Power BI reporting
To provide analytical support to an assigned business unit by applying business and information technology solutions to a broad range of business unit processes and applications; to serve as the primary contact and technical resource within a department; to serve as primary liaison with information technology professional and technical staff; to perform a variety of technical support and training duties involving the use of hardware, application software, and networks. The scope of help desk assistance may include mainframe, mid-range, client/server, desktop computer, and networks.


The primary focus of these classes is to support business unit systems, application, and activities where depth of knowledge of business unit functions and processes are critical to job success. The more technical functions of programming, applications development, and systems administration are performed by other classes. Assignments are predominantly involved in direct user support on single server systems and/or assisting in the resolution of problems relating to desktop equipment, proprietary software, and the less complex matters.

Some positions in the Department Systems Specialist class series are flexibly staffed at the I and II levels. Appointment to the higher class requires that the employee be performing substantially the full range of duties for the class and meet the qualification standards for the class.

Department Systems Specialist I is the journey-level in this class series. Assignments are generally limited in scope and performed within the procedural framework established by higher level staff.


Department Systems Specialist I is directed by higher level staff.

- Prove information and consulting assistance to operating department staff on planning, exploring, and evaluating business process improvements and information technology opportunities
- Assist operating department staff in defining their business information needs and prioritize their requests to ensure that the information technology organization provides service based on their business strategic direction.
- Assist operating department staff and information technology technical staff in the development of business processes improvement proposals including statement of need, proposed solution, costs, benefits, and return on investment.
- Act as liaison between users and systems analysts, programmers, and/or vendors
- Assist in the development of feasibility reports and analysis
- Determine processing characteristics and program specifications for assigned applications
- Assist in the negotiation of service level agreements with service providers
- Monitor and gather customer service satisfaction information and share such information with information technology professional and technical staff
- Assist in research, evaluation and selection of information technology products and services
- Coordinate or prepare implementation plans, status reports, and post-implementation evaluation reports
- Coordinate product implementation and conversion and assist in solving problems that may arise from the project
- Coordinate and perform system acceptance tests with vendors and/or information technology technical staff
- Participate in the analysis, diagnosis and correction of problems with existing computer applications with vendors and/or information technology technical staff
- Manage departmental database applications, following procedures developed by/with vendor or information technology technical staff
- Produce reports from system as needed; develop ad-hoc reports or define new reports for development by vendor or information technology technical staff
- Advise management and users of new products and current trends that apply to assigned applications
- May install and upgrade desktop hardware, software and peripheral equipment and configure system for optimum operations
- Coordinate the resolution of network hardware, software, and applications problems between technical, support and customer personnel
- Report hardware failures to appropriate vendors via telephone or on-line systems
- Evaluate user hardware and software needs and assist in acquisition of approved equipment and software
- Assist in preparation of user's procedures and documentation
- May train users in operating systems, computer language, applications programs, utilities and hardware operation; assist users in applying computer training to work environment; create technical documents and computer training for end-users
- Analyze problems and design technical solutions to specific departmental needs including spreadsheets, word processors, database, presentation graphics, client/server applications, emulators, communications protocols, and intranet/internet
- Other related duties may also be performed; not all duties are necessarily performed by each individual holding this classification.
Knowledge of:

- Basic operations, procedures and regulations applicable to assigned department
- Principles of and current trends in information technology including systems software and hardware technologies for mainframe, server, personal computer, and client server environment
- Information technology security methods
- City rules for information technology projects and business objectives, processes and environment
- Currently available commercial off-the-shelf software
- Principles and techniques of training including training needs assessment techniques
- Disaster planning and recovery methods
- General computer architecture including application life cycle
- Various hardware platforms and multiple desktop software
including electronic mail systems, spreadsheets, word processors, database, presentation graphics, client/server applications, emulators, communications protocols, and intranet/internet
- Personal computer and local-area-network troubleshooting techniques
- Personal computer and local-area-network configurations, specifications and requirements

Ability to:

- Communicate effectively orally and in written format in a variety of situations and formats and make group presentations
- Exercise analytical skills in providing fact-based details to support ideas, recommendations, and analysis
- Reason logically, use a variety of techniques to resolve problems, manage time and resources, concurrently handle multiple assignments, and work under strict deadlines
- Coordinate and facilitate work with others and train and guide others
- Lift and move equipment weighing up to 50 pounds
- Analyze, diagnose and resolve customer problems relating to the application of information technology in the solution of business operation problems
- Apply technical knowledge to solve problems with systems of assigned operations department
- Understand and apply technical documentation
- Perform first level systems administration and database administration
- Configure desktop computers and related peripherals
- Prepare and present technical oral and written reports


Any combination of education and experience that would provide the required knowledge and skills is qualifying. A typical way to obtain the knowledge and skills would be:


An Associate's Degree or equivalent from an accredited college or university with a major in business administration, public administration, information technology, or a closely related field.


One year of experience as a City of Sacramento Information Technology Trainee.


Two years of experience with specific business systems related to department operations including extensive involvement in the analysis, design, development and implementation of information technology solutions to business problems.


Should education be used to qualify for this position, then proof of education such as, but not limited to, university/college transcripts and degrees should be submitted with your application and will be required at the time of appointment. Unofficial documents and/or copies are acceptable.

An applicant with a college degree obtained outside the United States must have education records evaluated by a credentials evaluation service. Evaluation of education records will be due at time of appointment.


Employees must complete twelve (12) months of probation at a satisfactory performance level prior to gaining permanent status.

Please note, the City of Sacramento's preferred method of communication with applicants is via e-mail. As such, please ensure you verify the e-mail address on your application, and check your e-mail frequently, including your spam and junk folders. All e-mail notifications can also be accessed through the applicant inbox.

1. Application: (Pass/Fail) - All applicants must complete and submit online a City of Sacramento employment application for further consideration.
  • Employment applications must be submitted online; paper applications will not be accepted.
  • Employment applications will be considered incomplete and will be disqualified:
  • If applicants do not list current and/or past job-related experience in the duties area of the "Work Experience" section. Note: Qualifying experience is based on full-time experience (40 hours per week). Qualifying experience is calculated to the full-time equivalent (pro-rated if less than 40 hours/week).
  • If "see resume" is noted in the "Work Experience" section; a resume will not substitute for the information required in the "Work Experience" section.
  • Proof of education such as, but not limited to, university/college transcripts and degrees should be submitted online with your application. Proof of education will be required at time of appointment.
  • Position/job titles will not be considered in determining eligibility for meeting the minimum qualifications for this position.

  • If you're requesting Veteran's credit, a copy of your DD214 must be submitted online with your application. Information regarding the use of Veteran's credit can be found in the Civil Service Board rules under rule 4.9C.

  • Applicants are responsible for attaching a copy of their DD214 to each position for which they apply.
2. Training and Experience Exam: (Weighted 100%) - The questions located at the end of the application are the Training and Experience (T&E) Exam. Responses to the T&E questions will be rated and scored. This exam will evaluate the relevance, level, and progression of a candidate's education, training and experience. The exam score will determine your ranking on the eligible list for this job. When completing the T&E questions, please note:
  • Responses to the T&E questions must be submitted online; paper questionnaires will not be accepted.
  • A resume will not substitute for the information required in the T&E questions.
3. Eligibility: Candidates who pass the Training and Experience Test will be placed on the eligible list. The hiring department may contact candidates for interview at any time during the life of the one-year list. Candidate's eligibility expires one year from the date of notification of a passing score for the Department Systems Specialist I examination.

4. Screening Committee: (Pass/Fail)- All candidates that pass the examination and are in one of the top three ranks will have their application forwarded to the hiring department for review. The hiring department will select the most competitive applications for further consideration. Human Resources will only evaluate employment applications for the minimum qualifications, as stated on the job announcement, for applications selected by the hiring department.

5. Conditional Hire: Upon receipt of a conditional offer, the selected candidate must complete and pass LiveScan/fingerprinting; and provide proof of receiving a complete COVID-19 vaccination. If applicable, candidates may also need to pass a pre-employment medical exam, controlled substance and/or alcohol test, and possess any required licensure or certification prior to receiving a start date from the Department. Failure to meet these prerequisites will be grounds for withdrawal of your conditional offer of employment.

For questions concerning this job announcement and the application process:

Special Instructions


Additional Information

Closing Date/Time: Continuous

Job Address

Sacramento, California 95814 United States View Map