System Integration Developer
The Department of Technology (DT) is looking for a System Integration Developer responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of the 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 developer will work with system architects and developers to maintain, upgrade, and enhance the applications and systems to continue to meet operational needs and satisfy local, state, and federal laws that govern user access, data protection, and network security for the platform. The develop must perform work of a complex, technical nature and requires a high level of functional and technical skills.
The Justice Tracking Information System (JUSTIS) is a program that is chartered to modernize the infrastructure, applications, and systems between 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.
The System Integration Developer will join an existing development division within the Department of Technology that designs, enhances, and supports the data exchange hub that serves the 24x7x365 operations of 8 critical San Francisco agencies.
Under 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-premise architecture integrated with the local case management systems of the partner agencies.
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:
a) Create and configure database partner links to perform tasks such as data query, execute store procedures and data insert.
b) Create and configure partner links to invoke other BPEL sub processes.
c) Use partner links to invoke API services for data exchange with remote data provider using JSON, XML, and document attachments.
d) Develop business process with JMS partner link to receive messages from remote ActiveMQ message queue.
e) Create Java script to manipulate JSON objects.
- Possess working knowledge of configuring, maintaining, and troubleshooting Weblogic server.
- Ability to work with other team members and willingness to assist teammates in performing tasks listed above.
Requirements
This role is not fully remote, but the incumbent may adopt a hybrid schedule with supervisor approval.
If hired, the incumbent must be a resident of California or relocate within 4 weeks.
IMPORTANT: Your application MUST include responses to the supplemental questionnaire found here: https://forms.gle/T8Lk6eQz2CUgZCFY6
Applicants must complete the supplemental questionnaire prior to starting the online application process. The application will not be reviewed without a completed supplemental questionnaire.
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.
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.
About SAN FRANCISCO DEPARTMENT OF TECHNOLOGY
Why Work for the Department of Technology (DT)? DT is the centralized technology services provider in the City and County of San Francisco (CCSF). We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that range from Public Safety radio and wiring and Network services to Enterprise Support and the Cloud.
Benefits of Working for CCSF: In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.
- Job security, pension, and robust retirement options
- Competitive pay with consistent bi-yearly or yearly increases
- Hybrid Work with a minimum of 20% of time spent in our office in San Francisco, California for all IT related roles
- Generous paid time off, family leave, and more!
- Diverse work environment in a diverse city
- Union protections and representation
- Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!
PEOPLE-CENTERED SOLUTIONS — have a powerful, meaningful effect on the community each day with people at the heart of every solution!
CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!
SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!
DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!
