Programmer Analyst-Principal

Principal System Integration Engineer (Enterprise Systems), Oracle BPEL / SOA Integration (1064) – Department of Technology

Apply using Smart Recruiters, the City and County of San Francisco's application portal.

• Final date to receive applications: Apply Immediately. This recruitment is considered open until filled and will close no sooner than April 8, 2026.
• Salary Range: $ - $ annually

Note: This posting has been amended with updates to the Job Title, Desirable Qualifications, Salary Range, and telecommute policy information.

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 and supports public safety, municipal broadband, cybersecurity, cloud solutions, and more. DT operates through core areas including IT Excellence, IT Project Management Office, Cloud Center of Excellence, IT Operations and Support, City Infrastructure, Office of Cybersecurity, Public Safety Systems and Municipal Broadband Fiber, SFGovTV Broadcasting Services, IT Finance and Administration Services, and Emerging Technologies.

Why Join Us? Innovative and impactful work at DT powers a city. Your expertise will directly impact San Francisco residents, 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 the San Francisco office.

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

The Justice Tracking Information System (JUSTIS) team designs, operates, and modernizes 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 24/7.

This Principal System Integration Engineer role is a key technical position on the JUSTIS development team, focusing on building and supporting the integration layer of the JUSTIS Data Exchange Hub. The role emphasizes Oracle-based integration technologies (BPEL, SOA Suite, Web Logic, advanced SQL/PL/SQL) along with API and web service development.

Working with system architects, technical leadership, project management, and partner agencies, this role performs complex hands-on development and operational support across development, test, and production environments. The role ensures justice data exchanges are reliable, secure, auditable, and compliant with applicable laws and data protection requirements.

As a member of the JUSTIS development team, the Principal System Integration Engineer designs, develops, enhances, and provides operational support for the JUSTIS Data Exchange Hub and its integration services. This includes building and maintaining integrations that enable system-to-system data exchange while ensuring high availability and data integrity.

This position requires strong depth in enterprise integration and Oracle technologies, along with operational awareness and collaboration across teams and partner agencies.

Essential duties include, but are not limited to:

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 to performance, data integrity, and maintainability.
• Support and troubleshoot integration solutions built on Oracle Web Logic and SOA Suite, including diagnosing failures across multi-system workflows.

Web Services, APIs & Integration Interfaces

• Design, develop, and maintain web services and integration interfaces that support secure, reliable data exchange across justice partner systems.
• Implement and support service-based integrations using RESTful services and JSON; maintain working knowledge of SOAP and XML where required.
• Develop reusable, testable server-side components and integration services, leveraging Python and Java as needed for service development and operational tooling.

Middleware, Messaging & Operational Support

• Support integrations that leverage middleware and messaging technologies (e.g., Active
  
  MQ and Microsoft message queue) to enable reliable and scalable data movement.
• Troubleshoot and resolve complex production issues related to integrations, database…