Powered by JobAps

1064 IS Programmer Analyst-Principal

Recruitment #PBT-1064-059458


1064 Programmer Analyst-Principal



This is a Position-Based Test conducted in accordance with the Civil Service Rule 111A.


General Description:

Under general supervision of the BHIS IS Business Analyst-Principal this position uses tools such as SQL Server, Crystal Reports, ASP.NET and RAD modeling tools to develop and modify systems changes to meet departmental needs. 


Essential functions include: managing system maintenance activities, preparing and present training materials; coordinating the creation of system end-user reports; performing programming and administration of MS SQL Server databases; performing IIS web server administration and IS Web server application development and administration; developing and supporting data warehouses; developing reports and providing user support for the State DMH Data Collection and Reporting (DCR) system, SQL Server TSQL Programming (complex queries), SQL Server SSIS and SQL Server database administration which includes managing security, installing, configuring, maintaining, troubleshooting and disaster recovery; developing technical system documentation; providing technical support to application users and desktop support units; installing applications and/or enabling connectivity as needed; developing consumer resource materials and training plans; installing, testing, and debugging system updates; deploying tested systems to the production environment; identifying opportunities for improving business processes through automation; evaluating and recommending internal departmental procedures to ensure efficient utilization of systems, applications and IT resources; supervising, training and providing guidance to subordinate staff; performing .NET programming (C#, and/or VB.NET) and other duties as assigned.

Minimum Qualifications

1. Possession of a Bachelor's degree from an accredited college or university, preferably in management information system, information technology, computer science, business administration, or a closely related field; AND


2. Four (4) years of verifiable experience managing cross-functional and complex web-based applications. This experience must include having responsibility for designing the applications, integrating the applications with legacy systems, testing the applications, training users on the applications and working under aggressive deadlines.  Additionally, the four (4) years of experience must include one (1) year of experience in SQL, Java and Web development.



  • Knowledge of rules and regulations governing healthcare information security and confidentiality including HIPPA, California Medical Privacy Act, Code of Federal Regulations Title 42, California Welfare and Institutions codes and California Administrative Codes related to medical records maintenance.
  • Knowledge of database design, relational and non-relational database design, development and maintenance including SQL, MS Access database coding and development
  • Three years of experience in Crystal reports, and SQL server administration and support.

The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.

How To Apply

Applications for City and County of San Francisco jobs are being accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement (PBT-1064-059458)
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Interested applicants are encouraged to FILE IMMEDIATELY.  Receipt of applications will be cut off, suspended or closed when there are a sufficient number of qualified applicants. 


If you are a current CCSF employee with permanent status in the 1064 IS Programmer Analyst – Principal and wish to be considered for transfer or reinstatement to a position in the same classification within the department/agency for which this announcement has been issued, you must submit an Employee Request for Transfer form

(see http://www.sfdhr.org/Modules/ShowDocument.aspx?documentid=11618) or an Employee Request for Reinstatement form

(see http://sfdhr.org/Modules/ShowDocument.aspx?documentid=11617), along with a copy of your resume, to the Exam Analyst during the recruitment period indicated above.

Reassignment language for DPH Employees.

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Elaine Lee, by telephone at 415-206-5033, or by email at Elaine.Lee@sfdph.org.

Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process. 

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Selection Procedures

Training and Experience Evaluation:                                            Weight:  100%

The information provided by candidates on the job application, requested verification, if required, and a Supplemental Questionnaire will be evaluated in relations to the knowledge, skills and abilities required for this position in class 1064 IS Programmer Analyst – Principal.


Candidates will be placed on the eligible list in rank order according to their final score.

The department may utilize additional selection procedures to make a final hiring decision.


Certification Rule: The certification rule for the ranked eligible list resulting from this examination will be Rule of Three Scores. The hiring department may administer additional position-specific selection procedures to make final hiring decisions. 

Eligible List:
The eligible list resulting from this examination is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.

The duration of the eligible list resulting from this examination process will be of six (6) months, and may be extended with the approval of the Human Resources Director.

Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification.  To find other Departments which use this classification, please see http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=13693. Search that document by title or job code to see which departments use the classification.


Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.



Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:

Information regarding requests for Veterans Preference can be found at:


General Information concerning City and County of San Francisco Employment Policies and Procedures:

Important Employment Information for the City and County of San Francisco can be obtained at http://www.sfdhr.org/index.aspx?page=1709 or hard copy at 1 South Van Ness Avenue, 4th floor.


Terms of Announcement: http://www.sfdhr.org/index.aspx?page=20#announcementsdefinitions


Applicants must be guided solely by the provisions of this announcement including, requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by posting the correction on the Department of Human Resources website at: www.jobaps.com/sf.


Position Based Tests are administered in accordance with Civil Service Rule 111A. General information concerning City and County of San Francisco employment policies and procedures may be found in the pamphlet entitled “Important Employment Information for Position Based Testing”. This information is part of the terms of this announcement. The pamphlet is available at the Department of Human Resources Information Center, One, South Van Ness Ave. 4th Floor, San Francisco, CA 94103 or online at http://www.sfdhr.org/index.aspx?page=20#positionbasedtesting

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

All other provisions of this announcement except for the Certification Rule are appealable to the Human Resources Director. Appeals of these provisions must be filed with the examination analyst listed on this announcement.


Copies of Application Documents: http://www.sfdhr.org/index.aspx?page=20#copies


Applicants are encouraged to keep copies of all documents submitted. Submitted documents become a permanent part of the exam records and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.


Right to Work:



All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.


Medical Examination:

Prior to appointment, at the Department’s expense, applicants may be required to take a TB screening test, and a medical examination.




Combined Entrance and Promotive

Micki Callahan

Human Resources Director

Department of Human Resources

Announcement #: PBT-1064-059458

Issued: November 16, 2012

Team DPH/EL (415) 206-5033


Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, typically a 7.5% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.