Tuesday, November 25, 2014

Systems Analyst

Recruitment #12-1827-01


 THIS IS A REOPENING OF AN EXISTING EXAMINATION. If you completed an application for this recruitment when it first opened in April 2012, you must contact the HR Technician, Amanda Hui at (510) 272-6741 or via email amanda.hui@acgov.org and request that your application be released back to you. Otherwise, the system will not allow you to submit an application. If you have your application released back to you it is critical that you submit it again prior to the deadline of June 11, 2013, 5:00 p.m. The scores and dispositions of candidates for this examination will be merged with previous exam participants. If you are currently on the eligible list and you choose to reapply you will forfeit your current rank and score. Your new score/disposition will replace your current score and rank. This list may be canceled at any time without notice to candidates. Please contact human resources if you would like additional information. APPLY IMMEDIATELY AS THIS RECRUITMENT MAY CLOSE AT ANY TIME.

A Properly Completed application must be in the possession of the Human Resource Services Department by 5:00 p.m. on the Last Day for Filing (THIS EXAM MAY CLOSE AT ANY TIME).

Postmarks are not accepted.  Failure to apply by the last day for filing and/or failure to submit a supplemental questionnaire by the last day for filing will result in disqualification. Applications will only be accepted on-line.



The Department:
The Information Technology Department provides services to County Departments to aid in the effective delivery of IT services that support the business needs of the county. County Information Technology is a vital part of the organization, providing faster and better ways for our employees to do their jobs and for our residents to access our services. We continue to keep our technology current and to work with members and management of all departments to provide the computing capabilities that are needed. 

-Application Services
-Infrastructure and Technical Services 
-Data Center Services

The Position:
This position is located in the Application Services Division, under general direction, to perform systems analysis, by working extensively with user departments in order to investigate, analyze, evaluate, make recommendations and create documentation concerning a department's needs; to provide program and system design specifications; devise procedures for using the systems; to provide for the implementation of the newly-designed system or system change; to prepare instructional material for staff and the user department; to act as a project manager on small projects and as team member on larger projects; to support database design; and to perform related duties as required.

The Division:
Application services include the assessment, development, implementation and support of technology-based business solutions to support County department goals and objectives. Services in this area include:

Business Analysis: To aid in the determination of how innovative business solutions technologies can improve operations, add business value and present business re-engineering opportunities, staff translate technology-based solutions into detailed designs of the computer system to be developed or purchased. A project team created from business unit staff and technology professionals provide descriptions of the business functions to be supported, diagrams of the proposed system, and flexible application designs for easy modification.

Application Construction: Staff use information obtained in the business analysis phase of a project and perform application construction services (programming) for custom-built applications used to achieve an automated business function.

Web Support: Staff manages the county Internet, Intranet and Extranet sites. The look and functionality of our web site is continuously improving and in 2006 an initiative was undertaken to improve the accessibility of information to our residents through the use of customer-centric categories.

Project Management: Staff provides project management services, creating roadmaps covering all aspects of a project including the necessary resources and timelines to monitor, track and implement projects.

The Ideal Candidate:
In addition to meeting the minimum qualifications the ideal candidate will have the ability to think both creatively and artistically while demonstrating a thorough knowledge of a computing environment/systems similar to those found in Alameda County such as: .Net development; PowerBuilder applications PeopleSoft Applications, Java and related web based development techniques; WebSphere, COBOL, CICS); adhere to established standards, and complete projects within stringent time schedules; handle multiple tasks at once, prioritize, and demonstrate excellent follow-through on each task assigned; perform well under pressure; analyze and diagnose problems quickly to come up with a workable solution within prescribed standards; express oneself clearly and concisely, both orally and in writing; work closely with and explain sophisticated technology, techniques and processes in layman's terms to client/customer community and a thorough knowledge applications, systems, software packages, and hardware found in Alameda County.



NOTE: The following are the duties performed by employees in this classification. However, employees may perform other related duties at an equivalent level. Each individual in the classification does not necessarily perform all duties listed.

1. Defines and documents the scope of system problems and the goals and needs of the automated systems; determines methodology to solve application problems.

2. Analyzes and documents current business practices of a department by conducting organizational analysis, administrative methods analysis and systems survey; develops and documents alternatives to improve system flow and output.

3. Prepares feasibility studies to improve a departments’ functions and/or procedures; identifies potential solutions and reports on the advisability of each, including feasibility, equipment and infrastructure requirements, personnel requirements, cost/ benefit effectiveness, time requirements, and makes a recommendation on which solution should be used.

4. Develops overall system project plans with Senior Systems Analyst based on the resource requirements approved by management and the user department; assesses equipment; identifies inputs and outputs, major files, data handling techniques; breaks systems into sub-systems; identifies and develops program specifications.

5. Designs detailed systems and programs or delegates this responsibility to a Programmer Analyst.

6. Codes and tests programs in programming languages and tools used by Alameda County ITD.

7. Coordinates and facilitates equipment and system installation.

8. Develops and coordinates new system testing plans to assure that related systems fit user's needs and are fully compatible in terms of program/system implementation and maintenance.

9. Develops procedures for using the system and develops training programs for users and staff.


Either I

The equivalent of one year of experience in the class of Programmer Analyst in Alameda County classified service. (Non-classified includes District Attorney’s Office, Hospital Authority, and the Consolidated Courts.).


The equivalent of four years of full-time, increasingly responsible experience in systems analysis and programming. This experience must include two years in systems analysis and design and two years of programming in at least one of the programming languages and tools used by Alameda County ITD.

NOTE: The Civil Service Commission may modify the above Minimum Qualifications in the announcement of an examination.


NOTE: The level and scope of the following knowledge and abilities are related to duties listed under the “Examples of Duties” section of this specification.

Knowledge of:

• programming languages and tools used by Alameda County ITD.
• Database concepts and SQL language.
• Systems analysis and design principles.
• Applications programming.
• Estimating methods for equipment costs, production costs, programming costs, and system benefits.
• Project Management techniques.

Ability to:

• Analyze processing problems.
• Develop and evaluate alternatives.
• Develop work plans and set target dates.
• Develop reasonable cost and time estimates.
• Communicate technical concepts on problem solutions to user department representatives in an effective manner.
• Analyze data and prepare clear, concise and informative reports.
• Understand and consider impact of organizational, management, administrative and personnel aspects of systems design.
• Resolve related problems and make appropriate recommendations.
• Work effectively with staff and user department representatives.
• Write programming specifications.
• Manage projects and maintenance units.
• Utilize Microsoft Office productivity tools: Excel, Word, Project, Visio, PowerPoint, Outlook, Sharepoint




Alameda County utilizes a Civil Service Selection System founded on merit.  Such a system is competitive and based on broad recruitment efforts and equal opportunity for qualified applicants to test in an examination process designed to determine the qualifications, fitness and ability of competitors to perform duties of the vacant position.  Many of our recruitments are targeted and specific to the needs of a current vacant position, in which case, the eligible list may be exclusively used for that current vacant position.  Other recruitments many be more broadly used for both current and future vacancies, or for other alternate jobs with comparable scopes of work.

To learn more about our recruitment and selection process, please visit the "What You Need To Know" section of our website:  www.acgov.org/hrs.


Selection Plan

Applicants will be informed with reasonable notice in advance of any examination process which will require their attendance.  The following dates are tentative and subject to change based on the needs of the Agency:


Deadline for Filing: continuous-exam may close at anytime-apply immediately
(applications will be accepted on-line only)

1.  Application Review for minimum qualifications and “Ideal Candidates”: Those candidates who possess the 
     minimum requirements for the class will move on to the next step in the examination process, a
     performance examination.

2.  Performance examination: that will be qualifying only (pass/fail).  Those candidates who pass the
     performance examination will move on to the next step in the examination process, an Oral Examination.

3.  Oral Examination - Panel Interviews: tentatively scheduled for, TBD

*Please note that the panel interview will be weighted as 100% of the candidates' final examination score and may contain situational exercises.

Applicants will be notified at least 10 days prior to the examination.

The Human Resource Services Department will make reasonable efforts in the examination process to accommodate qualified individuals with mental and physical disabilities, and/or medical conditions in accordance/compliance with the State Fair Employment Housing Act (FEHA), Federal Americans with Disabilities Act (ADA) of 1990, and Alameda County Resolution No. R-83-773.  To request an accommodation due to a disability during this or other phases of the selection process, please contact the Human Resource Services Department at (510) 272-6472 before the final filing deadline. Alameda County Human Resources Services will require documentation to substantiate a request for reasonable accommodation. In order to qualify for a reasonable accommodation, applicants must have a permanent disability pursuant to the U.S. Equal Employment Opportunity Commission's statute of the Americans with Disability Act of 1990, as amended, and/or the California Department of Fair Employment and Housing (DFEH) Act. 

For more information regarding our Reasonable Accommodation procedures, please visit our website, www.acgov.org/hrs


WW:lfm Revised 9/16/81
DF:rf 12/24/01
New doc: Jobspecs/1827.doc
CSC Date: 10/13/81
KU:pf Rev. 12/3/02
CSC Date: 2/26/03
SG: cs Revised 4/29/11
CSC Date: 7/27/11



Alameda County, located on the east side of San Francisco Bay, is California's seventh-largest county.  The County employs 9,080 full-time employees and operates on an annual budget of $2.39 billion.  Oakland, the County seat, is California's eighth largest city.  One and a half million people call Alameda County home and live in a variety of incorporated cities, unincorporated communities and rural areas.  As a major urban county, Alameda provides a full range of services to its citizens.  The County is a blend of culturally and ethnically diverse communities, and its mixture of cosmopolitan and suburban areas provides the perfect environment for families and their active lifestyles.  The County offers extensive cultural resources, countless recreational opportunities and an array of fine public and private colleges and universities.



The County offers HMO and PPO medical plans.  The County has two contributions structures, 1) County contributes 100% of the lowest cost HMO; or 2) County contributes 90% of the HMO plans and 90% of the lowest cost HMO towards the PPO. The County contribution can be prorated based on the number of work hours up to 50% of the standard hours in a pay period.  Employees pay any additional premium costs if they chose an alternate HMO or PPO Plan. If an eligible employee waives all medical coverage through the County, a monthly stipend may be provided.


The County offers two Dental Plans: PPO and Dental Maintenance Option (DMO). The County contributes up to 100% of the family coverage for both plans as long as the employee works at least 50% of the standard hours in a pay period. The PPO option plan design is 100% Preventative, 80% Basic Care, 80% Major Care with a $45 per individual deductible and annual maximum up to $1,450 per. The DMO option has an orthodontic benefit for children as well as adults.


The County offers two Voluntary Vision Plans through Vision Service Plan (VSP) for eligible employees.  The two plans consist of a low option and a high option that offer annual eye exams and coverage for various frames and lenses.  The Voluntary Vision Plan is 100% employee paid and available to employees and their dependents.  In addition, an annual eye exam is covered for participants in the HMO Medical Plans with corresponding co-pay. 


The County pays for a Basic Life Insurance policy of $25,000.  Supplemental Life Insurance for an employee can be purchased in $10,000 increments up $1,000,000.  Supplemental Life Insurance can also be purchased for spouse/domestic partner and/or eligible dependent children.


An employee can purchase either a policy for themselves or a family policy in $25,000 increments up to $500,000.


The County provides up to $2900 of flex dollars annually, dependent upon the management employee's represented or unrepresented classification.  These flex dollars can be used to pay for medical, Supplemental Life and/or AD&D premiums.  The unused portion of these flex dollars are deposited into a Health Flexible Spending Account for the management employee, which can be used for unreimbursed medical expenses.


Employees may opt to salary contribute on a pre-tax basis up to $10,000 for eligible out of pocket medical, dental and vision expenses such as: prescription co-pays, office visit co-pays, prescription eye glasses or contact lenses.


For employees who have either children under age 13 or dependents (parent, sibling or in-law incapable of self-care) that are dependent upon the employee for care can contribute salary on a pre-tax basis up to $5,000 annually.  These pre-tax dollars can be used to pay for day care expenses provided by a licensed facility.



For the 2011 Plan Year, an employee can set aside up to $230 a month in pre-tax dollars to pay for qualified work-related parking and commuting to and from work transit fees.


Eleven paid holidays plus two or four floating holidays depending on the union bargaining unit.  Represented management employees are entitled up to three additional days of management paid leave. Unrepresented management employees are entitled up to seven days of management paid leave.


Vacation accrual ranges from two weeks to five weeks depending upon years of service and the union bargaining unit to which the position is assigned.  Sick leave accrues at the approximate rate of one-half day per bi-weekly pay period.  Exact rate is based on the union bargaining unit and is defined in the corresponding Memorandum of Understanding.


The County allows you to purchase one or two additional weeks of vacation through payroll deduction.  Exact benefit is based on the union bargaining unit and is defined in the corresponding Memorandum of Understanding.


The County has an EAP available for employees, spouses/domestic partners and eligible dependents.  This program provides services such as: counseling, financial consulting, child and elder care consulting and some legal counseling.


Two voluntary plans are offered: Short-term Disability and Long-term Disability can be purchased through a payroll deduction or with accrued vacation hours depending upon the union bargaining unit.


This voluntary benefit extends care for yourself and/or your spouse and/or your parents who experience a serious accident, chronic illness or frailties of old age.  Places where care can be provided are: in one's home, at a nursing home, at an assisted living facility or adult day care center.


The County retirement program is a Defined Benefit plan and is governed under the provisions of the 1937 Act.  The County's retirement is based on one's age upon entrance, compensation, years of service and specific percentage of employee/employer contributions with the County's portion vesting after five years of employment. (With regard to Project positions - Regularly appointed incumbents in full-time, non-project positions in the Alameda County classified service who are current members of the retirement system and who are appointed, without a break in service or status to a project position can elect to remain in the retirement system.  Individuals hired into a project position and subsequently appointed to full-time, non-project positions become members of the retirement system at the time of the regular appointment.  Computations and determinations of eligibility for retirement shall be based on the date of the regular appointment, with entitlements being prospective from that date.)


The County offers a Deferred Compensation program where an eligible employee can voluntarily contribute on a pre-tax and/or after-tax basis, a minimum of $20 per pay period up to the total annual contribution limit.


Those claiming additional preference points as a VETERAN must submit a copy of the DD214 form on the day of the oral examination. Those claiming additional preference points as a DISABLED VETERAN must submit a copy of the DD214 form and a letter from the Department of Veteran Affairs confirming eligibility for additional points on the day of the oral examination.

The Human Resource Services Department will make reasonable efforts in the examination process to accommodate qualified individuals with mental and physical disabilities, and/or medical conditions in accordance/compliance with the State Fair Employment Housing Act (FEHA), Federal Americans with Disability Act (ADA) of 1990, and Alameda County Resolution No. R-83-773.  To request reasonable accommodation, you must notify the Human Resource Representative listed on this bulletin as soon as possible and before the last day to file, in order to make the necessary arrangements during each step of the examination process.                                                               (510) 272-3703 (TDD)

All government employees are disaster service workers as defined by California Government Code Section 3100.  In addition to everyday duties, employees have the added responsibility of helping throughout any disaster. 

An applicant's previous employment may be investigated.  Results of this investigation may be cause for disqualification.  Also, all convictions will be reviewed and may result in a request for additional information or termination of employment.  A conviction record will not necessarily disqualify an applicant from employment.  Each case will be given individual consideration, based on job-relatedness.

All prospective county employees must pass a medical examination before beginning employment.  For positions which require a commercial driver's license and the performance of functions defined as "safety sensitive," Federal law and County policy requires that the examination include a drug screening process.  Offers of employment are conditional upon successful completion of this examination.

Alameda County is an Equal Opportunity/Affirmative Action employer.  Women, ethnic and racial minorities and persons with disabilities are encouraged to apply.  Applicants will be considered without regard to their race, color, religion, sex national origin, age, disability, sexual orientation, or any other non-job-related factor.


All notices related to County recruitments for which you have applied will be sent/delivered via email. Please add @acgov.org and alamedacountyHR@acgov.org as accepted addresses to any email blocking or spam filtering program you may use. If you do not do this, your email blocking or spam filtering program may block receipt of the notices regarding your application for recruitments. You are also strongly advised to regularly log into your County of Alameda online application account to check for notices that may have been sent to you. All email notices that will be sent to you will also be kept in your personal online application account. You will be able to view all of your notices in your online application account by clicking on the "My applications" button on the Current Job Openings page.

Please take the steps recommended above to insure you do not miss any notices about a recruitment for which you have applied. The County of Alameda is not responsible for notices that are not read, received or accessed by any applicant for a County recruitment.

NOTE: All notices are generated through an automated email notification system. Replies to the email box alamedacountyHR@acgov.org are routed to an unmonitored mailbox. If you have questions please go to our website at www.acgov.org/hrs. You may also contact the Human Resources Analyst listed on the bulletin for the recruitment for which you have applied.

Debra Robinson Harris, Human Resources Analyst III
Human Resource Services Division, County of Alameda