DataSF
1063-IS Programmer Analyst-Senior
DataSF, San Francisco, California, United States, 94199
The San Francisco Police Department (SFPD) is seeking a proficient Senior IS Programmer Analyst to analyze and design, conduct feasibility analysis, and provide technology solutions for the following tasks relating to development and support of San Francisco Police Department software applications:Collaborate with colleagues and users to determine program and system requirements, document those requirements, and analyze data processing needs.Develop and provide technical and user documentation, user training, post Go-Live stabilization, and troubleshoot application issues.Troubleshoot, maintain, and support new and current Technology interfaces, including development and support.Customize PeopleSoft HRMS BI Publisher, scheduling, and payroll interface.Design, develop, tune, and test applications.Configure the Records Management System (RMS) and build forms, which includes the MS SQL Server Reporting Services (SSRS) and RMS Output Designer .Develop data structures for reports and statistical analysis. Implement reports using various standard reporting tools.Develop and maintain operational and system level documentation.Develop procedures and jobs that run on Microsoft, Oracle, Linux, or Android platforms.Develops no code/low code solutions using, but not limited to, MS Power Apps or MS SharePoint after gathering requirements, documenting, and prototyping solutions to stakeholders.Design and create relational databases using data modeling techniques, including maintenance and modifications.Create scripts to create tables, views, sequences, and triggers and as well as create reports using PL/SQLCoordinate with colleagues, other city agencies, vendors, and contractors to complete projects and service requests.Stay current with technology changes and law enforcement operations that influence technology solutions.Advise and implement new technologies and maintain expertise to apply it successfully in the workplace.Prepare supporting presentation content to lead a demo and discussion on a program solution to stakeholders.Serve as a technical resource and backup for other members of the development and maintenance teams.Perform related duties and responsibilities, as assigned.How to qualify
1.
Education
:
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].AND2.
Experience
:
Three (3) years of full-time professional experience in application or software development or programmingSubstitution
:
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.Desirable Qualification: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.Demonstrated experience working with PeopleSoft HRMS up through version 9.2 and PeopleCode up through version 8.56.Experience in Oracle, PL/SQL and Web applications development.Experience with law enforcement Record Management Systems and Public Safety systems.Verification of Education and Experience: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirementsNote: 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.All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.Resumes
will not
be accepted in lieu of a completed City and County of San Francisco application.Applications completed improperly may be cause for ineligibility ordisqualification.Background Investigation: Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment. The investigation may include, but not be limited to: criminal history records, driving records, drug/alcohol screening, and other related employment and personal history records. Reasons for rejection may include use of controlled substances and alcohol, felony conviction, repeated or serious violations of the law, inability to work with co-workers,inability to accept supervision, inability to follow rules and regulations or other relevant factors. Candidates may be required to undergo drug/alcohol screening, and must clear Department of Justice and Federal Bureau of Investigation fingerprinting. Criminal records will be carefully reviewed; candidates who do not report their complete criminal records on their applications will be disqualified. Applicants will be fingerprinted.What else should I know?
Recruiter Information : If you have any questions regarding this recruitment or application process, please contact the Staff Services analyst, Danny Wan atdanny.wan@sfgov.org .Additional Information Regarding Employment with the City and County of San Francisco:Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.Select the “I’m Interested” button and follow instructions on the screenThe City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.
#J-18808-Ljbffr
1.
Education
:
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].AND2.
Experience
:
Three (3) years of full-time professional experience in application or software development or programmingSubstitution
:
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.Desirable Qualification: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.Demonstrated experience working with PeopleSoft HRMS up through version 9.2 and PeopleCode up through version 8.56.Experience in Oracle, PL/SQL and Web applications development.Experience with law enforcement Record Management Systems and Public Safety systems.Verification of Education and Experience: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirementsNote: 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.All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.Resumes
will not
be accepted in lieu of a completed City and County of San Francisco application.Applications completed improperly may be cause for ineligibility ordisqualification.Background Investigation: Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment. The investigation may include, but not be limited to: criminal history records, driving records, drug/alcohol screening, and other related employment and personal history records. Reasons for rejection may include use of controlled substances and alcohol, felony conviction, repeated or serious violations of the law, inability to work with co-workers,inability to accept supervision, inability to follow rules and regulations or other relevant factors. Candidates may be required to undergo drug/alcohol screening, and must clear Department of Justice and Federal Bureau of Investigation fingerprinting. Criminal records will be carefully reviewed; candidates who do not report their complete criminal records on their applications will be disqualified. Applicants will be fingerprinted.What else should I know?
Recruiter Information : If you have any questions regarding this recruitment or application process, please contact the Staff Services analyst, Danny Wan atdanny.wan@sfgov.org .Additional Information Regarding Employment with the City and County of San Francisco:Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.Select the “I’m Interested” button and follow instructions on the screenThe City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.
#J-18808-Ljbffr