Responsibilities

• Optimize system designs through review and analysis of 8 JUSTIS agency user needs; customize systems through design and administration in coordination with the team and agencies to ensure customizations and optimizations do not break or negatively impact the JUSTIS systems or agency systems and historical data.
• Identify opportunities for improvements in business processes through automation; make recommendations for new procedures and applications. Continual improvements to enhance, automate, and error-proof the functionality of applications and systems.
• Analyze the feasibility of ‘and develop requirements for new systems and enhancements to existing systems; may require preparation of cost estimates and schedules for modifications; set scope, boundaries and objectives for system’ functions and interfaces based on departmental needs. Systems and enhancements to existing systems; prepare cost estimates and schedules for modifications; set scope, boundaries and objectives for system’ functions and interfaces based on departmental needs. Work closely with JUSTIS agencies to capture requirements, set scope, estimate delivery, demonstrate new functions, allow user testing and feedback, and modify the function to meet user needs and expectations. Communicate with user when an issue is not technical and is a business process, operations, or training issue.
• Design, develop and implement new systems to support departmental activities. As laws change and agency case management systems change, upgraded or replaced, design, develop, test, and implement new or updated systems to enable the continued and uninterrupted exchange of criminal data. Be responsible for the applications you build. Create APEX workspaces for specific Criminal Justice Agencies. Work in an agile development environment.
• Define system requirements; design, code, test and debug systems; train users on new applications.
• Develop or modify system design: write detailed design specifications. Maintain and update system documentation.
• Provide advice on the functionality of new programs and compatibility of modifications to ensure user needs are met. Work with users to ensure they understand the downstream and upstream impacts related to the changes being requested. Coordinate communications and meetings to ensure all agencies are informed of changes.
• Evaluate software and hardware products on multiple platforms; make recommendations for compatibility, based on user requirements and systems analysis.
• Provide analysis and technical support for highly complex systems; troubleshoot systems problems; implement solutions. Conduct investigation into errors, unexpected outcomes, and incidents to understand the root cause of an issue and proposed solution or workaround with an understanding of the historical data and logic that was in the legacy CMS system and how the system handled the data and/or transaction.
• Support and maintain highly technical systems or networks; analyze and evaluate systems for cost effective and efficient performance; recommend modifications. As work is performed to modernize the JUSTIS environment, platform, tables and databases continue to support and maintain production systems and recommend modifications to improve performance, efficiency and accuracy. Requires rich experience in writing SQL queries, views, materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, system reference cursor, Dynamic SQL. Requires knowlege of using PL/SQL wrappers to protect the PL/SQL procedures and packages ensuring developed applications comply to JUSTIS security model.
• Coordinate the efforts of analysts, engineers and operators in the implementation of projects spanning multiple systems and sites; multiple platforms. Lead and work with contract developers to ensure tasks are performed in alignment with expected outcomes and deliverables. Interface with senior engineers who have built the current Criminal Justice System.
• Manage and monitor the progress of contractors and vendors; resolve problems.

Requirements

This role is not fully remote, but the incumbent may adopt a hybrid schedule with supervisor approval.

If hired, the incumbent must be a resident of California or relocate within 4 weeks.

Education: An associate degree in computer science or a 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].

Experience: Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

Substitution: 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 / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

SUPPLEMENTAL INFORMATION:  Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination for semi-skilled movements, such as taking apart casings. installing parts and reconnecting computers and for per-forming data entry. May involve extensive VDT exposure.

SPECIAL CONDITION: 36 months experience in the following: 

• Criminal Justice Systems Business Analyst experience
• Criminal Justice Technical Application Development experience

SPECIAL CONDITION: Background Clearence Required.

About SAN FRANCISCO DEPARTMENT OF TECHNOLOGY

Why Work for the Department of Technology (DT)? DT is the centralized technology services provider in the City and County of San Francisco (CCSF). We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that range from Public Safety radio and wiring and Network services to Enterprise Support and the Cloud.

Benefits of Working for CCSF:  In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.

• Job security, pension, and robust retirement options
• Competitive pay with consistent bi-yearly or yearly increases
• Generous paid time off, family leave, and more!
• Hybrid Work with minimum of 20% of time spent in our Office in San Francisco, California for all IT related roles. (Must be a California resident)
• Diverse work environment in a diverse city
• Union protections and representation
• Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!

PEOPLE-CENTERED SOLUTIONS — have a powerful, meaningful effect on the community each day with people at the heart of every solution!

CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!

SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!

DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!