Principal System Integration Engineer (Enterprise Systems), Oracle BPEL / SOA Integration (1064) - D

Job Description

Job Description:\n\nCompany Description\n\nSpecific information regarding this recruitment process is listed below: \nAppointment Type: Permanent Exempt (PEX), Full-Time position 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 up to thirty-six (36) months.\n\n Application Opening: February 19, 2026\n Application Deadline: Apply Immediately. This recruitment is considered open until filled and will close no sooner than July 10, 2026.\n Salary Range: $148,460.00 - $186,732.00 annually (click here to learn more).\n\nThis job posting has been amended as follows:\n\n 6/26/2026: Updated to correct clerical errors to the company description and desirable qualifications.\n 6/23/2026: Updated to reorder sections for clarity and to include the scheduled wage increase effective July 1, 2026.\n 4/15/2026: Updated to reflect extended application period and additional information in the concluding section.\n 2/27/2026: Updated the Job Title, Desirable Qualifications, and Salary Range details to reflect the complexity and advanced responsibilities of this role.\n 2/23/2026: Updated the Nature of Work to include additional telecommute policy information.\n\nWork 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.\nThis 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.\nAbout the Department of Technology\n Are you ready to make an impact in one of the most innovative cities? The San Francisco Department of Technology (DT) is looking for passionate IT professionals to help shape the future of technology in San Francisco! As 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 is leading the charge in digital transformation. DT provides services through our core areas of IT Excellence:\n\n IT Project Management Office\n Enterprise Application Services\n Cloud Center of Excellence\n IT Operations and Support including the Service Desk and NOC\n City Infrastructure including the Network, Telcom and Data Centers\n Office of Cybersecurity including Cyber Defense, Identity Management and Disaster Recovery\n Public Safety Systems and Municipal Broadband Fiber\n SFGovTV Broadcasting Services\n IT Finance and Administration Services\n Emerging Technologies\n\nWhy 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.\nBenefits of Working for CCSF: In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.\n\n Competitive pay, benefits, and retirement options\n\n Career growth opportunities through training, internal mobility, and subsidized education\n\n Diverse work environment in a diverse city\n\nJoin 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!Job Description\n\nThe 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.\nThis Principal System Integration Engineer 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 especially well-suited for a developer who brings deep experience in Oracle-based integration technologies—such as BPEL, SOA Suite, WebLogic, and advanced SQL/PL/SQL—combined with API and web service development skills.\nWorking 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.\nAs a member of the JUSTIS development team, the Principal System Integration Engineer 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.\nThis 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.\nEssential duties include, but are not limited to, the following:\nOracle Integration & Database Development\n\n Design, develop, and maintain Oracle database objects including tables, views, complex SQL, and PL/SQL procedures/packages (Oracle 12c/19c).\n Develop, enhance, and support integration workflows using Oracle BPEL and related SOA Suite components to implement business processes and data exchange patterns.\n Create and maintain database schemas that represent and support business processes, with strong attention to performance, data integrity, and maintainability.\n Support and troubleshoot integration solutions built on Oracle WebLogic and SOA Suite, including diagnosing failures across multi-system workflows.\n\nWeb Services, APIs & Integration Interfaces\n\n Design, develop, and maintain web services and integration interfaces that support secure, reliable data exchange across justice partner systems.\n Implement and support service-based integrations using RESTful services and JSON; maintain working knowledge of SOAP and XML where required.\n Develop reusable, testable server-side components and integration services, leveraging Python and Java as needed for service development and operational tooling.\n\nMiddleware, Messaging & Operational Support\n\n Support integrations that leverage middleware and messaging technologies (e.g., ActiveMQ and Microsoft message queue) to enable reliable and scalable data movement.\n Troubleshoot and resolve complex production issues related to integrations, database performance, middleware queues, and service reliability.\n Support development, test, and production environments for mission-critical, 24x7 operations across multiple justice partner agencies.\n\nDevOps, Quality & Release Management\n\n Implement and maintain CI/CD pipelines to ensure releases are well-defined, repeatable, and operationally stable.\n Review, verify, and validate software code to ensure adherence to quality, security, and maintainability standards.\n Develop and maintain unit and integration tests; support test planning and post-deployment validation.\n\nDocumentation & Team Collaboration\n\n Produce and maintain technical documentation (e.g., integration specifications, workflow documentation, runbooks, and operational procedures).\n Work collaboratively with other developers, architects, and stakeholders; assist teammates and contribute to shared delivery goals.\n Communicate technical issues and solution options clearly to technical and non-technical partners.\n\nPerforms related duties and responsibilities, as assigned.\nNature of Work: 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.Qualifications\n\nMinimum Qualifications\nEducation:\n An associate degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].\nExperience:\n Five (5) years of experience in applications or software programming or development.\nSubstitution:\n Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.\nNote(s): \n\n One-year full-time employment is considered equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40 hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment. \n\n Applicants must meet minimum qualification requirements by the final filing date unless otherwise noted. \n\nDesirable Qualifications\n\n Extensive experience developing and supporting enterprise-scale applications or system integrations.\n Advanced expertise in Oracle databases, including complex SQL, performance tuning, schema design, and PL/SQL development (Oracle 12c/19c).\n In-depth experience with Oracle integration technologies, including Oracle BPEL, SOA Suite, WebLogic, and associated development/support tools (e.g., JDeveloper, SQL Developer).\n Strong experience designing and supporting web services and integration interfaces using REST/JSON; working knowledge of SOAP/XML.\n Experience with middleware, messaging, and integration patterns (e.g., ActiveMQ, Microsoft message queue, event-driven approaches).\n Proficiency with CI/CD pipelines, version control systems (Git), and modern DevOps practices.\n Strong unit testing, debugging, troubleshooting, and production support skills.\n Experience working in highly regulated environments involving sensitive or protected data; familiarity with CJIS requirements is highly desirable.\n Experience working in Agile/Scrum or ITIL-informed environments.\n Experience with scripting/automation (e.g., shell scripting) and strong technical documentation practices.\n Experience leveraging AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, Microsoft Copilot) to improve productivity, code quality, and documentation.\n Proven ability to perform effectively in demanding, high-availability operational environments, with strong attention to accuracy and output.\n Demonstrated hands-on experience applying foundational concepts associated with computer science, information systems, engineering, or a closely related fields.\n\nVerificationPlease make sure it is clear in your application exactly how you meet the minimum qualifications. Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education for considerations taken when reviewing applications.\nNote: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.\nApplicants must meet the minimum qualifications requirement by the final application deadline unless otherwise noted.\n\nAdditional Information\n\nSelection Procedures\n The selection process will include evaluation of applications in relation to minimum requirements and assessment of candidates’ job-related knowledge, skills and abilities. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to evaluate candidate qualifications. This typically includes an oral interview and/or a written or performance exercise.\nIf this becomes necessary, only those applicants whose qualifications most closely meet the Department needs will be invited to continue in the selection process. Applicants meeting the minimum requirements are not guaranteed advancement in the selection process. \nAdditional Information Regarding Employment with the City and County of San Francisco: \n\n Information About the Hiring Process\n Conviction History\n Employee Benefits Overview \n Equal Employment Opportunity\n Disaster Service Worker\n ADA Accommodation\n Right to Work\n Copies of Application Documents\n Diversity Statement\n\nHow to Apply:\n Applicants are encouraged to apply immediately as this recruitment may close at any time, but not before July 10, 2026.\n\n Your application MUST include a resume.  To upload, please attach using the "additional attachments" function. \n You may contact Sean Sexton via email at View email address on us.fitly.work with questions regarding this opportunity. \n Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted. Resumes will not be accepted in lieu of a completed City and County of San Francisco application.\n\nFor best practices on the application process, please visit Apply for Jobs in the City and County of San Francisco Best Practices Guide. Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses @sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com). \nApplicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.\nThe Office of the City Administrator is committed to ensuring that the City's services are inclusive, efficient, equitable, and culturally competent for San Franciscans of a