Amended: Principal System Integration Developer - Department of Technology (1064)
City & County of San Francisco (CA) - San Francisco, CA
posted 3 days ago
About the position
The Department of Technology is looking for a Principal System Integration Developer responsible for performing all aspects of the design, development, integration, installation, maintenance, and support of the applications, processes, computing, integration, and security systems. The Developer will perform these functions for the Justice Tracking Information System (JUSTIS) Data Exchange Hub production, test, and development environments and their related applications and integration components. This position performs work of a complex, technical nature and requires a high level of functional and technical skills. JUSTIS is a program that is chartered to modernize the infrastructure, applications, and systems to integrate with the criminal justice agency partners and to facilitate real-time data exchange and sharing of criminal records. This role is part of a development team and reports to the division's Executive Program Director through the IS Technical Project Director.
Responsibilities
- Create and maintain database tables, views, pl/sql procedures using Oracle 10g, 12C and 19C
- Expertise in system integration using RESTful services and JSON, and working knowledge of SOAP and XML
- Analyze, design and develop business processes and composites using Oracle 12C BPEL Process Manager
- Create and configure database partner links to perform tasks such as data query, execute store procedures and data insert
- Create and configure partner links to invoke other BPEL sub processes
- Use partner links to invoke API services for data exchange with remote data provider using JSON, XML, and document attachments
- Develop business process with JMS partner link to receive messages from remote ActiveMQ message queue
- Create Java, Java script to manipulate JSON objects
- Possess expert level knowledge of configuring, maintaining and troubleshooting Weblogic server
- Design, implement and support functionality using Python, CI/CD, GIT for system integration, and web based applications
- Ability to work with other team members and willingness to assist teammates in performing tasks listed above
Requirements
- 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
- Five (5) years of experience in applications or software programming or development
Nice-to-haves
- Development experience within the Oracle SOA Suite and BPEL in version 10g, 11g, 12C and 19C
- Experience in Oracle database administration and development using PL/SQL, advanced level of SQL skills
- Experience doing software development using Object Oriented programming languages such as Java, C#, C++
- Expert level experience installing, configuring and supporting Windows 2003 - 2016 Servers, Linux Servers
- Experience with modern technology service architectural hosting, security, and risk management concerns
- Experience with python performing ETL, data analysis, system integration and web applications
- Experience in Agile/Scrum, or ITIL principles
Benefits
- Competitive pay, as well as pension and robust retirement options
- Generous paid time off, family leave, and more
- Hybrid Work with a minimum of 20% of time spent in our office in San Francisco, California for all IT related roles
- Diverse work environment in a diverse city
- Career development and growth - move between departments, learn on the job, or take subsidized/reimbursed classes
