1063 Sr. IS Programmer Analyst- CC&B Programmer/Analyst
|Department||Public Utilities Commission|
|Date Opened||3/23/2017 1:00:00 PM|
|Filing Deadline||4/21/2017 5:00:00 PM|
|Salary||$85,618.00 - $107,822.00/year|
|Job Type||Permanent PBT|
About the San Francisco Public Utilities Commission (SFPUC)
Our mission is to provide customers with high quality, efficient and reliable water, power, and sewer services in a manner that is inclusive of environmental and community interests, and sustains the resources entrusted in our care. We are comprised of three essential 24/7 service utilities: Water, Wastewater, and Power. We provide retail drinking water and wastewater services to San Francisco, wholesale water to three Bay Area counties, and green hydroelectric and solar power to San Francisco’s City facilities and properties. Headquartered in San Francisco, we have about 2,300 employees working in seven counties with a combined annual operating budget of over $900 million.
Under general direction, the Customer Care & Billing System Progammer-Analyst will be responsible for providing support and enhancements to the Customer Information System (CIS), a water billing system for the San Francisco Public Utilities Commission (SFPUC). This billing system is a package from Oracle, called Customer Care and Billing System (CC&B).
Provide analysis and technical support for highly complex systems; troubleshooting system problems and designing solutions; analyze and evaluate system metrics for cost effective and efficient performance; recommend modifications; liaise with end-users and support staff on various work-related issues; ensures interfaces are stable, operational and functioning efficiently. Prepare and update technical documentation, provide maintenance and support of CIS and other related systems; develop, test & de-bug code in Java. Design, develop and configure enhancements to the CC&B system. Develop regression-test environments to thoroughly test enhancements and fixes; define system requirements; design, code, test and debug systems; writes detailed design specifications; write complex SQL and PL/SQL queries; build and maintain automated test scripts; package building & deployment; create Cognos business intelligence reports; perform other related duties as assigned.
1. An associate degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].
2. Three (3) years of experience in application or software development or programing
3. Three (3) years of experience in Oracle Database and Application Development and Maintenance
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two years). One year is equivalent to 30 semester units/45 quarter units with a minimum of 10 semester/15 quarter units in computer scirence or a closely related field.
Please note, apical condition is associated with this particular position and therefore differs from the standard minimum qualifications associated with this classification.
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
Experience with Oracle’s web-based Customer Care and Billing System. Testing tools. Version Control tools (GIT, BitBucket, SVN etc), Unix, software package upgrades, user and technical documentation, and business systems analysis methodologies and techniques. Experience with supporting a large complex Billing, Payroll, Financial or Utilility system.
How To Apply
Applications for City and County of San Francisco jobs are only 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
- 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
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, @sfpl.org, @dcyf.org, @first5sf.org).
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, Michelle Chee, by telephone at 415-554-1682, or by email at email@example.com.
Oral/Performance Examination: (Weight: 100%) Candidates who meet the minimum qualifications of the position will be invited to participate in an oral/performance examination designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: knowledge of Java Programming language and its structures and methodologies, knowledge of Oracle's Customer Care & Billing product knowledge of Oracle database and table structures, trouble-shooting skills; ability to analyze and resolve system and technical issues, ability to work in a fast-paced ever-changing productions environment inter-personnel skills, and communication skills.
Certification: The certification rule for the eligible list resulting from this examination will be Rule of 3 Scores. The hiring department may conduct additional selection processes 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 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.
As a finalist for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a finalist. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:
- Candidates applying for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
- Candidates applying for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.
Having a conviction history does not automatically preclude you from a job with the City.
If you are selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
Terms of Announcement:
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 the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.
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.
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://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.
Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.
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.
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:
Seniority Credit in Promotional Exams:
Information regarding seniority credit can be found at:
Exam Type: CPE
Issued: March 23, 2017
Human Resources Director
Department of Human Resources
Recruitment ID Number: 075265
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, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.