Develop and maintain Oracle APEX applications tailored to public safety workflows and data requirements.
Build and optimize Python scripts for automation, data processing, and system integration.
Business Requirements Analysis: Translate business needs into efficient, high-quality technical solutions and collaborate with stakeholders to understand and define project requirements.
Database Integration: Design and manage database objects, write SQL and PL/SQL code to support application functionality, and ensure data integrity.
User Interface (UI) Design: Develop intuitive, visually appealing, and responsive user interfaces that provide a positive user experience.
Performance Optimization & Maintenance: Ensure the stability and optimal performance of applications, troubleshoot bugs, and resolve ad-hoc requests.
AI Integration: Implement and utilize AI features, including Generative AI, to accelerate development and enhance application functionality.
Security Implementation: Implement robust authentication and authorization mechanisms to safeguard application integrity and data security.
Oracle Cloud Infrastructure (OCI)
Collaborate with stakeholders across public safety units to gather requirements and translate them into technical solutions.
Assist in designing and implementing RESTful APIs and secure system integrations.
Support database development using SQL and PL/SQL, ensuring data integrity and performance.
Participate in code reviews, testing, and documentation efforts.
Troubleshoot and resolve application issues, with attention to uptime and reliability in emergency response contexts.
Ensure compliance with data security, privacy, and regulatory standards relevant to public safety.
Requirements
Experience : One (1) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.
Substitution:
Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.
Special Conditions :
One year of experience in Oracle database and application development and maintenance
One year of experience in developing web apps with various scripting languages.
Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
3-5 years of experience with Oracle APEX development.
2-4 years of experience with Python programming.
Experience working within or supporting a public safety organization (e.g., fire, police, emergency services, or related government agencies).
Solid understanding of relational databases, especially Oracle.
Familiarity with HTML, CSS, JavaScript, and web development fundamentals.
Experience using Git or other version control systems.
Ability to work independently and collaboratively in high-stakes environments. Exposure to Flask or Django frameworks.
Experience with RESTful API development and integration.
Familiarity with Agile development practices.
Basic understanding of cloud platforms (e.g., Oracle Cloud, AWS).
Experience with data visualization or reporting tools.
Knowledge of CJIS, HIPAA, or other relevant compliance frameworks.
All your information will be kept confidential according to EEO guidelines.
Information About The Hiring Process
Conviction History
Employee Benefits Overview
Equal Employment Opportunity
Disaster Service Worker
ADA Accommodation
Veterans Preference
Right to Work
Copies of Application Documents
Diversity Statement
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyO
Additional Information
The San Francisco Fire Department is hiring a Journey Level Oracle APEX and Python Developer to join its Team. Reporting to the Principal Developer, the Oracle APEX and Python Developer with experience supporting technology solutions within a public safety organization shall develop and maintain web-based applications and backend services that support mission-critical operations. The ideal candidate will have a solid foundation in Oracle APEX and Python, and a strong understanding of the operational needs and data sensitivity within public safety environments.