Applications Developer

Salary : $86,098.88 - $121,149.76 Annually Location : Sacramento, CA Job Type: Full-Time Career Job Number: 010703-24-IT-2 Department: Information Technology Opening Date: 11/06/2024 Closing Date: 11/27/2024 11:59 PM Pacific THE POSITION Please Note: A candidate may be required to successfully pass a thorough background investigation, including a criminal history check for job-related convictions, fingerprinting, polygraph test, and a drug use history to be considered for this position With supervisor approval, incumbents may be eligible for intermittent remote work; however, they must physically reside within the Sacramento region or have the ability to regularly report to a City of Sacramento physical worksite with little notice. The Applications Developer position is in the Information Technology Department within the Public Safety Information Technology group. This position is part of a team responsible for developing, implementing and maintaining solutions that support public safety priorities and initiatives. This position provides a wide range of application development duties, technical support, and system enhancements/upgrades. IDEAL CANDIDATE STATEMENT The ideal candidate will be proficient in object-oriented programming and have hands-on experience with modern frameworks and tools. The ideal candidate will have a solid understanding of database management, API integration, and the best practices in software development. Additionally, the below expereince and knowledge is desired in the ideal candidate: - Enterprise Records Management, Computer Aided Dispatch, and Employee Scheduling systems - Programming experience using Microsoft Visual Studio, SQL Server, .NET Framework or Core - Developing applications utilizing programming languages including C#, Javascript, PowerShell and Perl - Working knowledge of structured query language, database design and implementation with enterprise relational database management systems such as Microsoft SQL Server, PostgreSQL and Oracle - Working with end users to gather requirements - Performing business analysis and applications testing - Providing documentation on code development and customizations - Implementing good coding standards by developing sustainable and stable coding - Developing reports and queries to business users Under general supervision, the Applications Developer performs a variety of professional, technical, and analytical duties involving the design, development, testing, implementation, administration and support of new and existing small and medium sized systems and databases in a multi-platform environment that includes mainframe, client server, distributed and web based systems. DISTINGUISHING CHARACTERISTICS This is a journey-level-professional classification populated with multiple incumbents. The Application Developer's responsibilities involve concepts of systems analysis and design, programming, testing, implementation, and maintenance of new and existing systems. The Application Developer classification is distinguished from a Programmer in that the former performs an increased degree of difficulty of work that requires a greater level of technical knowledge to perform assigned tasks. This classification is distinguished from the Senior Application Developer in that the latter serves as team or project leader and possesses a higher level of technical knowledge and skill. SUPERVISION RECEIVED AND EXERCISED Supervision is provided by an Information Technology Supervisor or higher-level manager. The Application Developer does not supervise. ESSENTIAL DUTIES AND RESPONSIBILITIES Assists in planning information technology related projects involving applications, systems, and processes. Assists in designing and/or creating database structures. Participates in developing data migration/conversion techniques for system(s) conversions or upgrades. Participates in the support of existing systems, applications, and databases by responding to user requests for service, enhancement, modification or information and training. Identifies functional requirements for enhancement of existing systems. Assists in monitoring databases and systems for potential problems; documents problems and solutions to assure more efficient database operations. Maintains various tables to ensure that software functionality meets organizational and legislated policies and procedures. Creates and maintains the documentation of the City's business applications. Provides end users with training and continuing support for applications, systems, and databases. Codes and/or tests programs and resolves related problems in small and medium-sized systems. Other related duties may also be performed; not all duties listed may necessarily be performed by each individual holding this classification. QUALIFICATIONS Knowledge of: Fundamentals of business process and software design; relational and distributed database technology; networks and communications; and project management. Software development methodologies and life cycles. Current trends in information technology software, business systems, hardware, networks, and communications. Commonly used programming languages, databases, and operating systems on multiple hardware platforms. Application development and structured analysis methods; data modeling theory and methods; disaster planning and recovery techniques; debugging and error detection. Software applications such as finance human resources, utility billing, geographical information systems, and permitting. Skill in: The use of design and testing tools and methodologies The use of various desktop tools A variety of programming languages, databases and operating systems on multiple hardware platforms The use of relational and distributed database technology Maintaining good working relationships with a variety of city staff at all levels Ability to: Communicate effectively orally and in written format in a variety of situations and formats; make group presentations Analyze and develop logical solutions and alternatives to problems Train others; coordinate and facilitate work with others Carry out multiple tasks simultaneously EXPERIENCE AND EDUCATION Any combination of education and experience that would provide the required knowledge and abilities is qualifying. A typical way to obtain knowledge and abilities would be: Experience: Two years applications development and/or database management experience in a multi-platform environment. Education: A Bachelor's degree from an accredited college or university in Information Technology or a related degree. Substitution: Additional years of experience may substitute for education on a year-for-year basis. PROOF OF EDUCATION Should education be used to qualify for this position, then proof of education such as, but not limited to, university/college transcripts and degrees should be submitted with your application and will be required at the time of appointment. Unofficial documents and/or copies are acceptable. An applicant with a college degree obtained outside the United States must have education records evaluated by a credentials evaluation service. Evaluation of education records will be due at time of appointment. SPECIAL QUALIFICATIONS Driver's License: Possession of a valid California Class C Driver's License at the time of appointment. Individuals who do not meet this requirement due to physical disability will be reviewed on a case-by-case basis. PROBATIONARY PERIOD: Employees must complete twelve (12) months of probation at a satisfactory performance level prior to gaining permanent status. THE SELECTION PROCEDURE Please note, the City of Sacramento's preferred method of communication with applicants is via e-mail. As such, please ensure you verify the e-mail address on your application, and check your e-mail frequently, including your spam and junk folders. All e-mail notifications can also be accessed through the governmentjobs.com applicant inbox. 1. Application: (Pass/Fail) - All applicants must complete and submit online a City of Sacramento employment application by the final filing deadline; Employment applications must be submitted online; paper applications will not be accepted. Employment applications will be considered incomplete and will be disqualified: If applicants do not list current and/or past job-related experience in the duties area of the "Work Experience" section. Note: Qualifying experience is based on full-time experience (40 hours per week). Qualifying experience is calculated to the full-time equivalent (pro-rated if less than 40 hours/week). If "see resume" is noted in the "Work Experience" section; a resume will not substitute for the information required in the "Work Experience" section. Proof of education such as, but not limited to, university/college transcripts and degrees should be submitted online with your application. Proof of education will be required at time of appointment. Position/job titles will not be considered in determining eligibility for meeting the minimum qualifications for this position. If you're requesting Veteran's credit, a copy of your DD214 must be submitted online with your application or emailed to the Employment Office by the final filing deadline. Information regarding the use of Veteran's credit can be found in the Civil Service Board rules under rule 4.9C. Applicants are responsible for attaching a copy of their DD214 to each position for which they apply. 2. Training and Experience Exam: (Weighted 100%) - The questions located at the end of the application are the Training and Experience (T&E) Exam. Responses to the T&E questions will be rated and scored. This exam will evaluate the relevance, level, and progression of a candidate's education, training and experience. The exam score will determine your ranking on the eligible list for this job. When completing the T&E questions, please note: Responses to the T&E questions must be submitted online; paper questionnaires will not be accepted. A resume will not substitute for the information required in the T&E questions. 3. Eligibility: Candidates who pass the Training and Experience Test will be placed on the eligible list. The hiring department may contact candidates for interview at any time during the life of the one-year list. Candidate's eligibility expires one year from the date of notification of a passing score for the Applications Developer examination. 4. Screening Committee: (Pass/Fail)- All candidates that pass the examination and are in one of the top three ranks will have their application forwarded to the hiring department for review. The hiring department will select the most competitive applications for further consideration. Human Resources will only evaluate employment applications for the minimum qualifications, as stated on the job announcement, for applications selected by the hiring department. 5. Background Process: If considered for appointment, candidates may be required to pass a background investigation, which includes a criminal history check, fingerprinting, polygraph test, and drug use history. QUESTIONS: For questions concerning this job announcement and the application process: Please visit https://www.governmentjobs.com/Home/ApplicationGuide for a comprehensive, step-by-step guide to the application process. For technical support between 6 AM - 5 PM PT, contact Live Applicant Support at (855) 524-5627. Visit the City of Sacramento Human Resources Department website at https://www.cityofsacramento.gov/HR/employment; Send an email to employmentcityofsacramento.org; or Call the Human Resources Department at (916) 808-5726 Bilingual Pay Did you know that the City offers bilingual pay? That's right, most labor agreements offer the option of providing employees with bilingual pay if the department deems it to be operationally necessary. Pension Reform Act The City of Sacramento is covered by the California Public Employees' Retirement System, and as such, must adhere to the California Public Employee's Pension Reform Act (PEPRA) of 2013. Please note that the provisions within this act may affect or impact an applicant's eligibility and/or selection for open vacancies at the City of Sacramento. Equal Opportunity Employer The City of Sacramento is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation. Additional Information Civil Service Rules: Union Contracts: Salary Schedule: 01 APPLICATION : I understand my application must meet the minimum qualifications for consideration of employment with the City of Sacramento. The experience I list in the duties area of the "Work Experience" section of the employment application will be used to determine if I meet the minimum qualifications as stated on the job announcement. A resume, responses to the supplemental questions requiring a narrative response, employment history listed elsewhere in the application or attachments will not substitute for the information required in the "Work Experience" section of the employment application. Position/job titles will not be considered in determining eligibility for meeting the minimum qualifications for this position. Note: Qualifying experience is based on full-time experience (40 hours per week). Qualifying experience is calculated to the full-time equivalent (pro-rated if less than 40 hours/week).Please refer to the City of Sacramento's Applicant Resources Page for Screening Instructions: https://www.cityofsacramento.gov/HR/employment Yes 02 PROOF OF EDUCATION: To qualify for this classification you may use any combination of education and/or experience as listed to provide required knowledge, skills, and abilities.I understand proof of education such as, but not limited to, university/college transcripts and degrees should be submitted with my application and will be required at the time of appointment if I am using education to qualify for this position.Please refer to the City of Sacramento's Proof of Education Requirements (https://www.cityofsacramento.gov/HR/employment) for information on accepted documentation. Yes 03 EDUCATION CONFIRMATION: If I am using education to qualify for this position, I attest I possess or will possess the following level of education in Information Technology by time of appointment if I am selected for this position No units from an accredited college or university Less than 30 semester or 45 quarter units from an accredited college or university 30 semester or 45 quarter units from an accredited college or university 60 semester or 90 quarter units from an accredited college or university Associates Degree 90 semester or 135 quarter units from an accredited college or university Bachelors Degree Masters Degree Doctorate 04 I understand I may be required to pass a thorough background investigation, including a criminal history check for job-related convictions, fingerprinting, polygraph test, and a drug use history to be considered for this position Yes 05 SUPPLEMENTAL QUESTIONNAIRE : The answers to the questions below will be reviewed by the hiring department along with the information provided in your employment application. Therefore, your answers must be consistent with your employment application information (especially in the "Education" and "Work Experience" sections), must be unambiguous, and must contain sufficient but concise detail and organization. A resume will not be accepted in lieu of completing this Supplemental Questionnaire. Lack of clarity, incomplete or inconsistent information, and/or disorganized presentation may negatively affect the hiring department's review of your Supplemental Questionnaire. I understand and agree to the above instructions. Yes 06 Summarize your experience with applications development and include the programming languages, databases, framework and tools used. 07 Tell us about a project assigned to you as an applications developer and how you worked through the software development lifecycle. 08 Please describe a time when you encountered a major technical issue during a project and outline the steps you took to troubleshoot and resolve it. 09 TRAINING AND EXPERIENCE EXAMINATION : The following questions are the Training and Experience (T&E) Examination. In addition to the City of Sacramento employment application, applicants must complete and submit online responses to the T&E questions. This exam will evaluate the relevance, level, and progression of a candidate's education, training and experience. Therefore, your responses to the T&E Exam questions should be thorough and complete because the exam score will determine your ranking on the eligible list for this job. In accordance with the City of Sacramento's Racial and Gender Equity Action Plan (RGEAP), this examination contains non-binary names and pronouns. For additional information regarding the City's RGEAP, please copy and paste the following link into a web browser: http://www.cityofsacramento.org/-/media/Corporate/Files/CMO/City-of-Sacramento-RGEAP-v810012020.pdf?laen I understand and agree to the above instructions. Yes 10 Select the one option that best describes your experience with languages, platforms, and tools as it relates to applications development. Four years or more At least three years, but less than four years At least two years, but less than three years At least one year, but less than two years Less than one year 11 Select the one option that best describes your experience providing production application support. Four years or more At least three years, but less than four years At least two years, but less than three years At least one year, but less than two years Less than one year 12 Select the one option that best describes your experience working with relational databases. Four years or more At least three years, but less than four years At least two years, but less than three years At least one year, but less than two years Less than one year 13 Select the one option that best describes your experience resolving complex technical issues as it relates to applications development or database management. Four years or more At least three years, but less than four years At least two years, but less than three years At least one year, but less than two years Less than one year 14 Select the one option that best describes your experience establishing and maintaining effective working relationships with leadership, colleagues, and stakeholders to move new procedures or objectives forward. Four years or more At least three years, but less than four years At least two years, but less than three years At least one year, but less than two years Less than one year Required Question