System Integration Developer, Oracle BPEL​/SOA Integration Department of Technology

Overview

Company Description

The Department of Technology (DT) is the centralized technology services provider for the City and County of San Francisco (CCSF). DT delivers critical infrastructure and services to over 33,000 employees, supporting public safety, municipal broadband, cybersecurity, cloud solutions, and more, with a $140M+ annual budget and a team of 300+ experts. DT provides services through a core set of areas including:

• IT Project Management Office
• Enterprise Application Services
• Cloud Center of Excellence
• IT Operations and Support including the Service Desk and NOC
• City Infrastructure including the Network, Telcom and Data Centers
• Office of Cybersecurity including Cyber Defense, Identity Management and Disaster Recovery
• Public Safety Systems and Municipal Broadband Fiber
• SFGovTV Broadcasting Services
• IT Finance and Administration Services
• Emerging Technologies

Why Join Us? Innovative & Impactful Work. At DT, you won’t just work on IT—you’ll power a city. Your expertise will directly impact the residents of San Francisco, from closing the digital divide to ensuring secure, efficient city operations.

Benefits of Working for CCSF
:
In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.

• Competitive pay, benefits, and retirement options
• Career growth opportunities through training, internal mobility, and subsidized education
• Diverse work environment in a diverse city
• We offer employees the ability to work from home one day a week while spending the other four days in our San Francisco office, promoting both collaboration and work-life balance

Join the team that’s shaping the future of technology in San Francisco. Apply today and be part of a dynamic, innovative, and mission-driven IT team!

The Department of Technology’s Justice Tracking Information System (JUSTIS) team is responsible for designing, operating, and modernizing the City and County of San Francisco’s criminal justice data exchange platform. JUSTIS enables secure, real-time information sharing among multiple criminal justice partner agencies, supporting mission-critical operations that run 24 hours a day, 7 days a week.

This System Integration Developer role is a key technical position on the JUSTIS development team, with a primary focus on building and supporting the integration layer that powers the JUSTIS Data Exchange Hub. The position is well-suited for a developer with deep experience in Oracle-based integration technologies (such as BPEL, SOA Suite, Web Logic, and advanced SQL/PL/SQL) combined with API and web service development skills.

Working closely with system architects, technical leadership, project management, and partner agencies, the developer performs complex, hands-on development and operational support across development, test, and production environments. This role helps ensure that justice data exchanges are reliable, secure, auditable, and compliant with laws and requirements governing access controls, data protection, and criminal justice information security.

As a member of the JUSTIS development team, the System Integration Developer is responsible for the design, development, enhancement, and operational support of the JUSTIS Data Exchange Hub and its associated integration services and components. This includes building and maintaining integrations that enable partner agencies to implement system-to-system data exchange, while ensuring high availability and strong data integrity.

This position requires strong technical depth in enterprise integration and Oracle technologies, along with operational awareness and the ability to collaborate effectively across teams and partner agencies.

Oracle Integration & Database Development

• Design, develop, and maintain Oracle database objects including tables, views, complex SQL, and PL/SQL procedures/packages (Oracle 12c/19c).
• Develop, enhance, and support integration workflows using Oracle BPEL and related SOA Suite components to implement business processes and data exchange patterns.
• Create and maintain database schemas that represent and support business processes, with strong attention…