City and County of San Francisco
Principal System Integration Developer Department of Technology 1064
City and County of San Francisco, San Francisco, California, United States, 94199
Job Description
The Department of Technology is looking for a Principal System Integration Developer responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of applications, processes, computing, integration, and security systems. The Developer will perform these functions for the JUSTIS Data Exchange Hub production, test, and development environments and their related applications and integration components. The position will work with system architects and developers to maintain, upgrade, and enhance the applications and systems to continue to meet the operational needs and satisfy local, state, and federal laws that govern user access, data protection, and network security for the platform. This position performs work of a complex, technical nature and requires a high level of functional and technical skills.
JUSTIS is a program that is chartered to modernize the infrastructure, applications, and systems to integrate with the criminal justice agency partners and to facilitate real-time data exchange and sharing of criminal records. This role is part of a development team and reports to the division's Executive Program Director through the IS Technical Project Director.
Principal System Integration Developer will join an existing development division within the Department of Technology that designs, enhances, and supports a data exchange hub that serves the 24x7x365 operations of 8 critical San Francisco agencies.
Under the general direction of the IS Technical Project Director, this position will be responsible for creating, designing, and maintaining the JUSTIS HUB. The JUSTIS HUB is an on-premises architecture integrated with the local case management systems of the partner agencies. This role requires expert level knowledge and understanding of system integration using Oracle Fusion Middleware with SOAP, REST, XML, JSON, Java, etc. This System Integration Developer will also possess in-depth knowledge of criminal record processes, business terms and operations, as well as industry standards and government requirements such as CLETS, CJIS, NIST.
Position Responsibilities
Create and maintain database tables, views, pl/sql procedures using Oracle 10g, 12C and 19C
Expertise in system integration using RESTful services and JSON, and working knowledge of SOAP and XML
ANALYZE, DESIGN and DEVELOP business processes and composites using Oracle 12C BPEL Process Manager. Tasks include:
• Create and configure database partner links to perform tasks such as data query, execute store procedures and data insert.
• Create and configure partner links to invoke other BPEL sub processes.
• Use partner links to invoke API services for data exchange with remote data provider using JSON, XML, and document attachments.
• Develop business process with JMS partner link to receive messages from remote ActiveMQ message queue.
• Create Java, Java script to manipulate JSON objects.
Possess expert level knowledge of configuring, maintaining and troubleshooting Weblogic server
Design, implement and support functionality using Python, CI/CD, GIT for system integration, and web based applications
Ability to work with other team members and willingness to assist teammates in performing tasks listed above
Job Type:
This Permanent Exempt - Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The anticipated duration of this project position is thirty-six (36) months and will not result in an eligible list or permanent civil service hiring.
Nature of Work:
Incumbent must be willing to work
a 40-hour week
as determined by the department. Travel within San Francisco may be required.
The incumbent must be a resident of the State of California or be willing to relocate within 4 weeks of beginning employment with the City and County of San Francisco.
The City and County of San Francisco does not sponsor visas. If you have an F1 student visa, the City will not sponsor the “optional practical training” requirement. All applicants must be able to demonstrate that they are legally able to work in the United States without visa sponsorship by the employer.
Work Location:
Incumbent will conduct the majority of work at the Department of Technology,
1 south Van Ness in San Francisco . However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary.
This position does not support fully remote work. Employees may be permitted to work a hybrid schedule with supervisor approval, after which they must work at least two days in the office every two weeks.
Qualifications:
Education:
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].
Experience:
Five (5) years of experience in applications or software programming or development.
License and Certification:
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 or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.
Desired Qualifications:
Must have development experience within the Oracle SOA Suite and BPEL in version 10g, 11g, 12C and 19C, building interfaces using web services, data conversions and application extensions.
Must have experience in Oracle database administration and development using PL/SQL, advanced level of SQL skills, table structure and RESTful APIs.
Must have experience doing software development experience using Object Oriented programming languages such as Java, C#, C++
Must have expert level experience installing, configuring and supporting Window 2003 – 2016 Servers, Linux Servers with strong understanding of networking concepts.
Proven record of working in a demanding environment and high stress situation with high level of accuracy and output. Ability to work with other team members and willing to assist teammates.
Experience with modern technology service architectural hosting, security, and risk management concerns (e.g. Data Warehouse, Data Engineering Pipeline, Data Preparation and Modeling, Advanced - Analytics, Data Services, and Consumption).
Experience with python performing ETL, data analysis, system integration and web applications.
Experience in Agile/Scrum, or ITIL principals with experience implementing one of these practices preferred.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
Note:
Security Clearances & Background Investigations : Criminal Justice Information Services (CJIS) Security Clearance may be required. Positions in this classification may require that successful candidates who become eligible for appointment may be required to go through a background investigation to determine the candidate's suitability for employment in this classification.
Verification:
Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement.
How to Apply:
Application deadline: September 27, 2024 at 11:59pm
Your application MUST include a resume. To upload, please attach using the "additional attachments" function.
In addition to submitting your application, you MUST submit this supplemental questionnaire.
You may contact Carol Wong via email at
carol.x.wong@sfgov.org
with questions regarding this opportunity.
Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.
#J-18808-Ljbffr
The Department of Technology is looking for a Principal System Integration Developer responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of applications, processes, computing, integration, and security systems. The Developer will perform these functions for the JUSTIS Data Exchange Hub production, test, and development environments and their related applications and integration components. The position will work with system architects and developers to maintain, upgrade, and enhance the applications and systems to continue to meet the operational needs and satisfy local, state, and federal laws that govern user access, data protection, and network security for the platform. This position performs work of a complex, technical nature and requires a high level of functional and technical skills.
JUSTIS is a program that is chartered to modernize the infrastructure, applications, and systems to integrate with the criminal justice agency partners and to facilitate real-time data exchange and sharing of criminal records. This role is part of a development team and reports to the division's Executive Program Director through the IS Technical Project Director.
Principal System Integration Developer will join an existing development division within the Department of Technology that designs, enhances, and supports a data exchange hub that serves the 24x7x365 operations of 8 critical San Francisco agencies.
Under the general direction of the IS Technical Project Director, this position will be responsible for creating, designing, and maintaining the JUSTIS HUB. The JUSTIS HUB is an on-premises architecture integrated with the local case management systems of the partner agencies. This role requires expert level knowledge and understanding of system integration using Oracle Fusion Middleware with SOAP, REST, XML, JSON, Java, etc. This System Integration Developer will also possess in-depth knowledge of criminal record processes, business terms and operations, as well as industry standards and government requirements such as CLETS, CJIS, NIST.
Position Responsibilities
Create and maintain database tables, views, pl/sql procedures using Oracle 10g, 12C and 19C
Expertise in system integration using RESTful services and JSON, and working knowledge of SOAP and XML
ANALYZE, DESIGN and DEVELOP business processes and composites using Oracle 12C BPEL Process Manager. Tasks include:
• Create and configure database partner links to perform tasks such as data query, execute store procedures and data insert.
• Create and configure partner links to invoke other BPEL sub processes.
• Use partner links to invoke API services for data exchange with remote data provider using JSON, XML, and document attachments.
• Develop business process with JMS partner link to receive messages from remote ActiveMQ message queue.
• Create Java, Java script to manipulate JSON objects.
Possess expert level knowledge of configuring, maintaining and troubleshooting Weblogic server
Design, implement and support functionality using Python, CI/CD, GIT for system integration, and web based applications
Ability to work with other team members and willingness to assist teammates in performing tasks listed above
Job Type:
This Permanent Exempt - Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The anticipated duration of this project position is thirty-six (36) months and will not result in an eligible list or permanent civil service hiring.
Nature of Work:
Incumbent must be willing to work
a 40-hour week
as determined by the department. Travel within San Francisco may be required.
The incumbent must be a resident of the State of California or be willing to relocate within 4 weeks of beginning employment with the City and County of San Francisco.
The City and County of San Francisco does not sponsor visas. If you have an F1 student visa, the City will not sponsor the “optional practical training” requirement. All applicants must be able to demonstrate that they are legally able to work in the United States without visa sponsorship by the employer.
Work Location:
Incumbent will conduct the majority of work at the Department of Technology,
1 south Van Ness in San Francisco . However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary.
This position does not support fully remote work. Employees may be permitted to work a hybrid schedule with supervisor approval, after which they must work at least two days in the office every two weeks.
Qualifications:
Education:
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].
Experience:
Five (5) years of experience in applications or software programming or development.
License and Certification:
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 or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.
Desired Qualifications:
Must have development experience within the Oracle SOA Suite and BPEL in version 10g, 11g, 12C and 19C, building interfaces using web services, data conversions and application extensions.
Must have experience in Oracle database administration and development using PL/SQL, advanced level of SQL skills, table structure and RESTful APIs.
Must have experience doing software development experience using Object Oriented programming languages such as Java, C#, C++
Must have expert level experience installing, configuring and supporting Window 2003 – 2016 Servers, Linux Servers with strong understanding of networking concepts.
Proven record of working in a demanding environment and high stress situation with high level of accuracy and output. Ability to work with other team members and willing to assist teammates.
Experience with modern technology service architectural hosting, security, and risk management concerns (e.g. Data Warehouse, Data Engineering Pipeline, Data Preparation and Modeling, Advanced - Analytics, Data Services, and Consumption).
Experience with python performing ETL, data analysis, system integration and web applications.
Experience in Agile/Scrum, or ITIL principals with experience implementing one of these practices preferred.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
Note:
Security Clearances & Background Investigations : Criminal Justice Information Services (CJIS) Security Clearance may be required. Positions in this classification may require that successful candidates who become eligible for appointment may be required to go through a background investigation to determine the candidate's suitability for employment in this classification.
Verification:
Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement.
How to Apply:
Application deadline: September 27, 2024 at 11:59pm
Your application MUST include a resume. To upload, please attach using the "additional attachments" function.
In addition to submitting your application, you MUST submit this supplemental questionnaire.
You may contact Carol Wong via email at
carol.x.wong@sfgov.org
with questions regarding this opportunity.
Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.
#J-18808-Ljbffr