Banner: Welcome to San Joaquin County, California, USA
Employment Opportunities     HR Home     County Home    
Salary Grade by Classification     Job Descriptions

Information Systems Analyst IV

Recruitment #0513-RI1004-01

Approximate Salary:$6923 - $8417/Monthly
Closing Date:5/17/2013 11:59:00 PM
Employment Type: Full-Time
Analyst: Marie Sneed
Tentative Exam Date:Oral Board Date to be Determined

 Go Back   View Benefits
Printer Friendly Version

INTRODUCTION

This examination is being given to fill one vacancy in the Information Systems Division and to establish an eligible list to fill future vacancies. Resumes will not be accepted in lieu of an application. A completed application must be postmarked or received online by the final filing deadline.

This position will be assigned to Behavioral Health Services.  It is a first line supervisory position that will work with the department's management team to plan, monitor, and support the client information system application software upgrades.  Additionally, this position will be responsible for scheduling and supervising staff on daily tasks including client information system tracking and billing, clinical documentation, patient appointment system, maintenance, backup, upgrades, and operations.

The ideal candidate should have experience with supervising and developing projects with relational databases and Structured Query Language as well as webpage development using dynamic, database driven content.  A working knowledge of MS SQL database, MS Visual Basic, and the .Net development framework with XML experience would be helpful.  Familiarity with VAX VMS and Oracle RDB database as wella s California Mental Health billing is desired but not required. 

NOTE: All correspondences relating to this recruitment will be delivered via e-mail. The e-mail account used will be the one provided on your employment application during time of submittal. Please be sure to check your e-mail often for updates. If you do not have an e-mail account on file, Human Resources will send you correspondences via US Mail.

TYPICAL DUTIES

  • Provides highly advanced professional level support to one or more departments with highly complex systems and programs; areas of responsibility include the analysis, evaluation, design, development and testing of these strategic systems, networks, programs and applications across multiple platforms and technologies; serves as database administrator on assigned systems.
  • Designs and develops current or new systems for large and complex systems; analyzes user operations and business requirements to design and develop technology solution; reviews, evaluates and recommends current and third party systems and applications; creates or oversees the development of data flow diagrams and other systems documentation to develop program specifications; designs optimum system configurations; develops and implements testing plan; ensures system quality assurance; determines whether new program meets the client's business and technology requirements and adjusts as required.
  • Provides highly complex support in planning, developing, integrating, testing and evaluating the County's local and wide area networks; determines network system requirements; studies the integrity and security of data to establish system configuration; monitors systems to control and support network traffic; devises and implements strategies for connection of other systems through the use of routers, bridges and gateways.
  • Participates in the evaluation of network protocols, hardware and software to determine their applicability to County network needs; evaluates new applications to determine integration with current systems and applications.
  • Investigates, analyzes and resolves network-related problems; resolve compatibility problems across systems and networks; troubleshoots complex network failures, router problems and telecommunications problems; recommends and implements changes and improvements.
  • Analyzes network security and performance issues; identifies potential security and utilization or performance issues; designs strategies and recommendations to improve security and network performance.
  • Performs database analysis, administration and maintenance duties; provides support to information technology staff in planning, designing and implementing databases; designs and modifies database structure, tables, files, views, and indexes; manages and maintains database and file space allocation; develops methodologies to export data from mainframe environment to other platforms; plans future storage requirements.
  • Ensures database availability to system users; provides and controls user access; maintains database security to ensure data integrity; monitors users to ensure compliance with operational and security procedures; monitors database performance; makes database tuning changes as required; makes recommendations on enhancements to optimize resources; conducts and maintains database systems back ups to ensure timely recovery of data; develops alternative strategies for data recovery.
  • As assigned, serves as project leader on components of information systems projects; analyzes client information system needs; recommends solutions and appropriate technology to meet client needs; designs project and resource plans and schedules; develops proposals using cost/benefit analyses; coordinates the installation and evaluation of proposed hardware and software to ensure compatibility with existing systems; coordinates programming activities; controls, monitors and reports budget expenditures; directs members of the project team; provides written reports and presentations on project status.
  • Performs technical writing duties in the development and production of complex system documentation, instructional and procedural manuals; identifies training issues and coordinates training sessions for client users on assigned systems or applications; develops training schedule; designs training manuals; conducts training sessions; trains assigned project staff in their areas of work including structured programming and development methods, procedures and techniques.
  • Attends and participates in professional group meetings; stay abreast of new trends and innovations in the field of information technology.
  • MINIMUM QUALIFICATIONS

    Note: Supplemental application must be submitted with employment application.

    Either I

    Experience:  One year as an Information Systems Analyst III in San Joaquin County.

     

    Note:  This requirement shall be waived for individuals employed within the Information Systems Division in the San Joaquin County classes of Systems and Programming Analyst IV, Systems and Procedures Analyst II, and Systems and Programming Coordinator on September 13, 2000. Individuals employed within the Information Systems Division in the San Joaquin County classes of Systems and Programming Analyst III and Senior Office Systems Analyst on September 13, 2000 shall receive credit for their experience in those classes on a year-for-year basis. 

    Or II

    Education:  Graduation from an accredited four-year college or university with a major in computer science, information systems, mathematics, business administration or a related field

    Experience:  Three years of increasingly responsible professional, analytical computer and related systems work in an information systems environment.

     

    Substitution #1:  Possession of an approved information systems technology certificate, or completion of an approved information systems training course may substitute for all or part of the above required education.  A list of approved certificates and/or courses shall be maintained within the Human Resources Department.

     

    Substitution #2:  Additional qualifying experience may substitute for the above required education on a year-for-year basis to a maximum of two years. 

    And

    KNOWLEDGE

    Operations, services and activities of a comprehensive information systems program across multiple operating platforms; advanced principles and practices of system design, development, analysis, testing and security administration; methods and techniques of evaluating complex systems and business requirements and developing information systems solutions; advanced programming languages, methods and techniques including integrated database management applications; operations, services and activities of local and wide area network design, development and administration; local and wide area network protocols; methods and techniques of resolving complex network system compatibility and integration issues; principles, practices, methods and techniques of supporting a comprehensive database design, management and administration program; operational characteristics of a variety of database systems, tools and utilities; principles and practices of quality assurance, data security, integrity, backup and recovery processes in assigned systems area; principles of lead supervision and training; principles and practices of project leadership; pertinent Federal, State and local codes, laws and regulations.

    ABILITY

    Analyze department operations, procedures and data to recommend, design and develop logical solutions to complex systems problems; perform highly complex systems and applications programming and analysis duties; recommend and implement quality assurance and security procedures for assigned systems; provide advanced level technical systems support by identifying and resolving problems for highly complex systems and applications; provide complex support in the design, configuration, implementation and testing of wide area network operating systems, hardware and software; analyze and troubleshoot complex local and wide area network operating, hardware and software system problems; perform database administration and maintenance functions; evaluate and make recommendations to accommodate future data storage needs; develop and modify database models based on County information technology needs; prepare clear and concise technical reports and documentation; as assigned, lead, direct and review the work of project staff; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work

    PHYSICAL/MENTAL REQUIREMENTS

    Mobility-Frequent use of keyboards; frequent sitting, standing or walking for long periods; occasional pushing/pulling, bending, squatting and crawling; driving; Lifting-Frequently 5-30 pounds; occasionally 70 pounds or less; Vision-Constant use of good overall vision; frequent reading/close-up work; occasional color, depth and peripheral vision; Dexterity-Frequent repetitive motion; frequent writing; frequent grasping, holding, reaching; Hearing/Talking-Frequent talking/hearing in person and on the telephone; Emotional/Psychological-Frequent decision making and concentration; frequent public contact; occasional working alone, working nights and traveling; Environmental-Frequent exposure to noise.

    BENEFITS

    Health Insurance:  San Joaquin County provides employees with a choice of three health plans:  a Kaiser Plan, a Select Plan, and a Premier Plan.  Employees pay a portion of the cost of the premium. Dependent coverage is also available. 

    Dental Insurance:  The County provides employees with a choice of two dental plans:  Delta Dental and Pacific Union Dental.  There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense.

    Vision Insurance:  The County provides vision coverage through Vision Service Plan (VSP).  There is no cost for employee only coverage; dependent coverage is available at the employee’s expense.

    For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Benefits. 

    Life Insurance:  The County provides eligible employees with life insurance coverage as follows: 

     1 but less than 3 years of continuous service:                   $1,000
     3 but less than 5 years of continuous service:                   $3,000
     5 but less than 10 years of continuous service:                 $5,000
    10 years of continuous service or more:                           $10,000
     

    Employee may purchase additional term life insurance at the group rate.

    125 Flexible Benefits Plan:  This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan (Health Flexible Spending Account $2080 annual limit); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit).

    Retirement Plan:  Employees of the County are covered by the County Retirement Law of 1937.  Please visit the San Joaquin County Employees’ Retirement Association (SJCERA) at www.sjcera.org for more information.  NOTE:  If you are receiving a retirement allowance from another California county covered by the County Employees’ Retirement Act of 1937 or from any governmental agency covered by the California Public Employees’ Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance.

    Deferred Compensation:  The county maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $17,500 or 100% of your includible compensation, whichever is less. Individuals age 50 or older may contribute to their plan, up to $23,000.

    Vacation:  Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years.

    Holiday:  For current Civil Service employees:  14 paid holidays per year.  For new employees:  10 paid holidays per year.

    Sick Leave:  12 working days of sick leave annually with unlimited accumulation.  Sick leave incentive:  An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one- half of the cumulative amount that the employee is eligible to accrue.  The employee must also be on payroll during the entire calendar year.

    Bereavement Leave3 days of paid leave for the death of an immediate family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child.

    Merit Salary Increase:  New employees will receive the starting salary, which is the first step of the salary range.  After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step.

    Job Sharing:  Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources.

    Educational Reimbursement Program:  Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year.  Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year.

    Parking Supplemental Downtown Stockton:  The County contributes up to $17 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area.

    School Activities:  Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities.

    SELECTION PROCEDURES

    Applicants who meet the minimum qualifications will go through the following examination process:

    • Written Exam: The civil service written exam is a multiple choice format.  If the written exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list.
       
    • Oral Exam:   The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise.   The oral exam selection process is not a hiring interview.   A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list.  Top candidates from the eligible list are referred for hiring interviews.  If the oral exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. 
       
    • Written & Oral Exam:  If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement.  Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list.
       
    • Rate-out:  A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. 

     Note:  The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points.

    Testing Accommodation:  Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date.   

    Veteran’s Points:  Eligible veterans, unmarried widows and widowers of veterans of the United States Armed Forces who have been honorably discharged and who have served during wartime shall be given veteran’s points in initial appointment to County service.  Eligible veterans receive 5 points and eligible disabled veterans receive 10 points. Disabled veterans must submit a recent award letter stating a 10% service connected disability issued by the United States Veterans Administration.  Note:  A copy of your DD214 showing the discharge type must be received in the Human Resources by the date of the examination.

    Acceptable wartime service dates:

    • September 16, 1940 to December 31, 1946

    • June 27, 1950 to January 31, 1955

    • August 5, 1964 to May 7, 1975

    • Persian Gulf War, August 2, 1990, through a date to be set by law or Presidential Proclamation.

    Eligible Lists:   Candidates who pass the examination will be placed on an eligible list for that classification.  Eligible lists are effective for one year, but may be extended up to two additional years by the Civil Service Commission.

    Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods.

    • Rule of the Rank: The top three ranks will be referred for hiring interviews.  If there are less than 5 names in the top three ranks the next rank is referred.  This applies only to open competitive recruitments.
    • Rule of the List: The entire list will be referred to the department for further selection.
    • Rule of Five:  The top five names will be referred for hiring interviews.  This applies only to department or countywide promotional examination.

    Physical Exam:  Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities.

    Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when;

    • They are related to the Appointing Authority or

    • The employment would result in one of them supervising the work of the other.

    Department Head may establish additional limitations on the hiring of relatives by departmental rule.

    Proof of Eligibility:  If you are offered a job you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S.

    HOW TO APPLY

    Apply Online:       

    www.sjgov.org/hr

    By mail or in person:  

    San Joaquin County Human Resources

    44 N. San Joaquin Street Suite 330

    Stockton, Ca 95202                                  

     

    Office hours:               
    Monday – Friday 8:00 am to 5:00 pm; excluding holidays.

    Phone:  (209) 468-3370 

     

    Job Line:

    For current employment opportunities please call our 24-hour job line at (209) 468-3377. 

    When a final filing date is indicated, applications must be filed with the Human Resources Division before 5:00 p.m. or postmarked by the final filing date. Resumes will not be accepted in lieu of an application. Applications sent through county inter-office mail, which are not received by the final filing date, will not be accepted. (The County assumes no responsibility for mailed applications which are not received by the Human Resources Division).  

    San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees.

    Equal Opportunity Employer:  San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation.  For more information go to
    www.sjgov.org/eeo.


    For more info contact us via e-mail at humanresources@sjgov.org or call (209) 468-3370.