Java and Oracle Programmer

San Francisco Public Utilities Commission | San Francisco

Salary Range: $88,192.00 - $111,046.00/year
Open Date: 03/30/2018
Close Date: 04/27/2018

Position Description

The SFPUC is looking for a dynamic, smart and skilled Java and Oracle developer who can learn new systems quickly and is excited about enhancing, developing and integrating new innovative business solutions for both the desktop and mobile platforms. Under the general direction of an IT Principal Engineer, the Senior Programmer Analyst develops and maintains applications related to asset management for the SFPUC, primarily for the IBM Maximo asset management system and its integration with both SFPUC and other City departments’ enterprise systems, e.g GIS, CRM, CMMS, and data warehouse, financial and timekeeping systems.

Both individually and as a member of the SFPUC Maximo support team, scope of duties include:

• Design, develop, document and implement Java extensions and code for Maximo
• Interact with the users to define system requirements; test and debug systems; train the trainer on new applications
• Develop system interfaces using Oracle PL/SQL or XML data or web services
• Develop mobile solutions using web services, Java/Javascript/Jython and HTML5
• Design reports and write intermediate to advanced level database PL/SQL queries and programs
• Troubleshooting and resolving production application, integration and systemwide problems.
• Testing and applying software upgrades.
• Provide direct user support and system administrative support as needed.
• Writing ad-hoc SQL queries
• Creating and consuming web services and web service clients
• Ensuring the applications are available and doing any maintenance if necessary
• Use Java and/or Jython to implement GIS-related features in Maximo
• Develop Maximo app customizations using Java class extensions or Jython scripts
• Maintaining the data and operational integrity and security of systems
• Doing feasibility analysis, technology and software assessment, and maintaining detailed project plans and schedules
• Perform other related duties as assigned

This individual must have at least two years combined experience in these broad areas:

Java – developing applications using Java, JavaBeans, J2EE application model including EJBs, JDBC, JSP and servlets, scripting with JavaScript or Jython
• Oracle – designing and developing databases, writing intermediate to advanced level PL/SQL queries and programs, troubleshooting code, integrating databases, creating views, stored procedures and triggers, doing backups, and making software upgrades.
• XML and web services – working knowledge of XML, HTML, and web services.

Desired experience includes:

• Knowledge of tools for IBM Maximo asset management system or comparable systems is highly desirable.
• Experience with reporting tools like Cognos or BIRT is preferred.
• Knowledge of Websphere application server configuration and usage is preferred

Position Qualifications

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].

Three (3) years of experience in application or software development or programming.Two of the three years must include combined experience in Java, Oracle, XML and web services

How to Apply

Contact Email: