Job Description

We are looking for an experienced developer to help us connect processes and data to improve City services using Oracle Cloud Services.

Working with a team of analysts, you will build the services that connect the wide range of applications used by City agencies and their partners. The SF311 integration HUB distributes and tracks work based on rules and process that are constantly changing to improve performance and interoperability. You will focus on cloud architecture, application integration, and cloud application development using Oracle's Cloud Integration Platform (OIC), Oracle PaaS technologies, Oracle application, Oracle databases, On-premises Apps, CRM applications and 3rd party systems. You'll create and manage workflow that augments service request data to increase efficiency.

ESSENTIAL DUTIES INCLUDE, BUT ARE NOT LIMITED TO:

• Design, develop, test, and maintain applications on Oracle Integration Cloud (OIC)
• Oversee all phases of the software development lifecycle (SDLC)
• Work closely with other team members to support processes and translate requirements to technical design.
• Develop and expose SOAP and RESTful based web services
• Perform technical design, development, and testing of resources created.
• Debug and maintain existing projects.
• Develop and deploy application customization and changes.
• Parse unstructured XML for access to and incorporation of XML instance data
• Create and configure data sources for integration data exchange
• Create and update tables in databases; create SQL for queries and updates
• Ensure correct balance of new development and support for existing systems
• Monitor systems for errors, provide technical and operational support by working with technical teams in maintaining system operations.

Nature of Work: Full-time, usually Monday through Friday, 9:00 am – 6:00 pm. This position will require applicant to be available to work occasional weekends and holidays whenever necessary to meet operational commitments. We are currently remote due to Covid-19; however, in the event in person work in San Francisco is allowed, this position may require continued remote work based on operational needs.

Qualifications

Education: An associate degree in computer science or a 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.

Experience: Three (3) years recent and verifiable experience in development of software applications or system integrations. Experience must be WITHIN THE LAST SIX YEARS.

Substitution: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

NOTES:

1. One (1) year full-time employment is equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.
2. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

DESIRABLE QUALIFICATIONS 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 Integration Cloud (OIC)
• Experience with Oracle SOA Suite (BPEL, XML, WSDL/XSD, Adapters)
• Experience with Oracle Service Bus (OSB) implementation
• Knowledge working with Integration frameworks (REST, SOAP, FTP and Messaging)
• Experience programming in Java
• Experience in writing database queries and procedures for applications integration
• Collaboration, teamwork, and relationship-building skills.

VERIFICATION OF EDUCATION AND EXPERIENCE: Applicants may be required to submit verification of the qualifying experience and education, at any point in the application, examination or departmental selection process.  Resumes will NOT be accepted in lieu of verification of qualifying experience and education. More information can be found at: http://sfdhr.org/information-about-hiring-process#verification 

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.

Additional Information

SELECTION PROCEDURE: MINIMUM QUALIFICATION SUPPLEMENTAL QUESTIONNAIRE (MQSQ): Candidates will be required to submit an MQSQ at any point in the application, examination or departmental selection process. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. APPLICANTS MUST ALSO COMPLETE THE PRELIMINARY QUESTIONS. It is essential that applicants provide complete information in identifying their education, experience and training. The Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.

ORAL/PERFORMANCE EXAMINATION (WEIGHT: 100%): Candidates deemed qualified will be invited to participate in an Oral/Performance examination designed to measure their relative knowledge, skill and ability levels in job-related areas which may include, but is not limited to the following: ability to develop complex integration services, understand business requirements and determine the best option for integration, write database queries and procedures for applications integration; knowledge of Integration frameworks, Java/JEE and web applications architecture, development, and debugging and tuning; human relations ability; oral communication ability.

CERTIFICATION RULE: The certification rule for the ranked eligible lists resulting from this examination will be RULE OF THREE SCORES. The department may administer additional position-specific selection procedures to make final hiring decisions.

ELIGIBLE LIST/SCORE REPORT: A confidential eligible list of applicant names that have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process 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.  

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

TERMS OF ANNOUNCEMENT: This is a Position Based Test conducted in accordance with Civil Service Rule 111A. 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 and, if so, an amended note will be posted on this official job announcement. 

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.

SPECIFIC INFORMATION REGARDING THIS EXAMINATION PROCESS ARE LISTED BELOW.

• APPLICATION OPENING - Wednesday September 29, 2021
• APPLICATION DEADLINE - Amended to Continuous application until we have sufficient qualified application; may close at anytime.  Applicants are encouraged to FILE IMMEDIATELY. (10/18/21)
• Compensation Range for 1063 Integrations Developer (IS Programmer Analyst-Senior)
• EXAMINATION PLAN for this recruitment consists of an Oral/Performance weighted at 100% of the candidates exam score.  Candidates must pass all phases of exams to be ranked on the eligible list (PBT-1063-114859).
• ELIGIBLE LIST DURATION resulting from this examination process will be six (6) months.
• CERTIFICATION RULE for the eligible list resulting from this examination will be Rule of Three Scores.
• EXAM TYPE: Combined Entrance and Promotive

QUALIFIED CANDIDATES WILL BE NOTIFIED OF THE DATE, TIME, LOCATION AND TYPE OF EXAM FORMAT IN THEIR EXAM APPOINTMENT NOTIFICATION.

ADDITIONAL INFORMATION REGARDING EMPLOYMENT WITH THE CITY AND COUNTY OF SAN FRANCISCO:

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Seniority Credit in Promotional Exams
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

EXAM ANALYST INFORMATION: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Angie Ignao at ANGIE.IGNAO@SFDPW.ORG.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be vaccinated against COVID-19 as a condition of employment.  For details on how it is applicable to your employment, please click here.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.