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

About the role

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.

Responsibilities

• 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 WebLogic 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 and 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.

Requirements

• Five (5) years of experience in applications or software programming or development.
• Extensive experience developing and supporting enterprise-scale applications or system integrations.
• In-depth experience with Oracle databases, including complex SQL, performance tuning, schema design, and PL/SQL development (Oracle 12c/19c).
• Advanced expertise in Oracle integration technologies, including Oracle BPEL, SOA Suite, WebLogic, and associated development/support tools (e.g., JDeveloper, SQL Developer).
• Strong experience designing and supporting web services and integration interfaces using REST/JSON; working knowledge of SOAP/XML.
• Experience with middleware, messaging, and integration patterns (e.g., ActiveMQ, Microsoft message queue, event-driven approaches).
• Proficiency with CI/CD pipelines, version control systems (Git), and modern DevOps practices.
• Strong unit testing, debugging, troubleshooting, and production support skills.
• Experience working in highly regulated environments involving sensitive or protected data; familiarity with CJIS requirements is highly desirable.
• Experience working in Agile/Scrum or ITIL-informed environments.
• Experience with scripting/automation (e.g., shell scripting) and strong technical documentation practices.
• Experience leveraging AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, Microsoft Copilot) to improve productivity, code quality, and documentation.
• Proven ability to perform effectively in demanding, high-availability operational environments, with strong attention to accuracy and output.
• Demonstrated hands-on experience applying foundational concepts associated with computer science, information systems, engineering, or a closely related fields.

Skills

• Strong technical depth in enterprise integration and Oracle technologies.
• Operational awareness and the ability to collaborate effectively across teams and partner agencies.

Benefits

Competitive pay, benefits, and retirement options; career growth opportunities through training, internal mobility, and subsidized education; diverse work environment in a diverse city.

Pay

$148,460.00 - $186,732.00 annually (click here to learn more).

Schedule

Full-time position excluding the competitive civil service examination process and serving at the discretion of the appointing officer. The anticipated duration of this project position is up to thirty-six (36) months.