Principal System Integration Engineer; Enterprise Systems), Oracle BPEL​/SOA Integration

Job Title

Principal System Integration Engineer

Permanent Exempt (PEX), Full‑Time; position excluded by the Charter from the competitive civil service examination process.

• Duration: up to thirty‑six (36) months.
• Salary Range: $ – $ annually.
• Application Opening:
  February 19, 2026.
• Final date to receive applications:
  Apply immediately; recruitment open until filled but no sooner than July 10, 2026.

Department of Technology, 1 South Van Ness Avenue, San Francisco, CA 94103. Employee may be required to work at other City and County sites as needed.

Hybrid work schedule: minimum of two (2) days onsite per week.

Design, operate, and modernize the Justice Tracking Information System (JUSTIS) data exchange platform. This key technical position focuses on building and supporting the integration layer that powers the JUSTIS Data Exchange Hub.

• 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 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.
• 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.
• Support integrations that leverage middleware and messaging technologies (e.g., ActiveMQ, Microsoft message queue) to enable reliable and scalable data movement.
• Troubleshoot and resolve complex production issues related to integrations, database performance, middleware queues, and service reliability.
• Support development, test, and production environments for mission‑critical, 24x7 operations across multiple justice partner agencies.
• Implement and maintain CI/CD pipelines to ensure releases are well‑defined, repeatable, and operationally stable.
• Review, verify, and validate software code to ensure adherence to quality, security, and maintainability standards.
• Develop and maintain unit and integration tests; support test planning and post‑deployment validation.
• Produce and maintain technical documentation (e.g., integration specifications, workflow documentation, runbooks, and operational procedures).
• Work collaboratively with other developers, architects, and stakeholders; assist teammates and contribute to shared delivery goals.
• Communicate technical issues and solution options clearly to technical and non‑technical partners.
• Perform related duties and responsibilities as assigned.

Position may require lifting, pushing, pulling, or carrying computer equipment. May require hand/eye coordination and manual dexterity for data entry. May involve extensive VDT exposure.

• Associate degree in computer science or closely related field, or equivalent (60 semester credits with 20 in CS).
• Five (5) years of experience in applications or software programming or development.
• Experience can be substituted for degree on a year‑for‑year basis (up to two years).

• Extensive experience developing and supporting enterprise‑scale applications or system integrations.
• Advanced expertise in Oracle databases, including complex SQL, performance tuning, schema design, and PL/SQL development (Oracle 12c/19c).
• In‑depth experience with Oracle integration technologies, including Oracle BPEL, SOA Suite, Web Logic, and associated development/support tools.
• Strong experience designing and supporting web services and integration interfaces using REST/JSON; working knowledge…