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
- Oracle-based integration technologies—such as BPEL, SOA Suite, WebLogic, and advanced SQL/PL/SQL
- API and web service development skills
- Oracle Integration & Database Development
- Web Services, APIs & Integration Interfaces
- Middleware, Messaging & Operational Support
- DevOps, Quality & Release Management
- Documentation & Team Collaboration
Work Arrangement
Hybrid
Team
Structure: JUSTIS development team
Additional Information
- Appointment Type: Permanent Exempt (PEX), Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer. The anticipated duration of this project position is thirty-six (36) months.
- Work Location: Incumbent will conduct most of the work at the Department of Technology, 1 South Van Ness Avenue, San Francisco, CA 94103. However, there may be situations where the incumbent will be required to work at other sites throughout the City and County of San Francisco as necessary.
- Nature of Work: This is a full-time position. The department supports a hybrid work schedule in compliance with City & County of San Francisco policies on remote work, which currently requires onsite work of a minimum of two (2) days per week. Position may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination and manual dexterity for data entry. May involve extensive VDT exposure.
