Senior Programmer Analyst - Promotional

Full Job Description

This recruitment is promotional only. You must presently be a full or part-time regular or probationary County of Sonoma, Community Development Commission, Sonoma County Fairgrounds, or Sonoma County Water Agency employee in order to apply for this position.

The Sheriff's Office has requested a department promotional certification to fill a Senior Programmer Analyst position.

Only qualified permanent and/or probationary Sheriff's Office employees on the eligible list may be eligible for referral to the department for the advertised position.

This employment list may also be used to fill future full-time or part-time positions as they occur during the active status of the list.

The Senior Programmer Analyst reports to and receives project and task assignments from the Sheriff’s Office Senior Department Information Systems Manager.

Working under general direction, the position works independently in managing complex systems and programs.

As a Senior Programmer Analyst, you will be responsible for the design, development, and maintenance of applications, websites, databases, and reporting solutions for both agency employees and the public.

You will also consult and communicate with stakeholders throughout the development lifecycle, while having flexibility and autonomy to make technical and design decisions as appropriate.

Additional responsibilities include:

• Serving as the primary analyst for major technology initiatives and software development projects
• Acting as the lead architect and developer across all phases of the system development lifecycle, including design, coding, modification, testing, and implementation of software solutions
• Serving as the primary architect for all database designs and data relationships, including table structures, queries, stored procedures, integration with external data sources, and data optimization
• Collaborating with stakeholders—including administration, department managers, vendors, and end users—to identify business needs, analyze and define requirements, and design and implement effective solutions
• Developing project timelines, identifying resource needs, making feasibility/risks assessments, identifying hardware/software costs, and making vendor assessments
• Serving as a team leader, coordinating all efforts on the solution development, testing, implementation, documentation, maintenance, management, monitoring, and support of systems
• Developing training plans and conducting training for technical staff and end users

The ideal candidate will have strong written and verbal communication skills, including the ability to present and recommend technical solutions.

They will have knowledge of business process analysis and functional specification development. They will also bring experience working with and/or possess knowledge of many of the following:

• Programming in C#, Visual Basic, and JavaScript (additional languages a plus)
• Analyzing complex problems and designing effective technical solutions
• Knowledge of relational database design, normalization, and SQL-based data workflows
• Experience with Microsoft Visual Studio and Visual Studio Data Tools
• Experience designing, building, and maintaining applications, databases, and websites, and using many of the following:
  • Development using the Microsoft .NET Framework and APIs
  • Web development using Razor, Blazor, and/or MVC (ASP.NET/WebForms a plus)
  • Microsoft SQL Server and T-SQL (SSIS/SSRS a plus)
  • HTML, CSS, JavaScript, and modern web frameworks
  • RESTful APIs and web services
  • Code Versions, such as GitHub

Azure Fundamentals (AZ-900), Azure Developer Associate (AZ-204), Azure Solutions Architect Expert (AZ-305), or legacy Microsoft certifications desired (not required).

Requirements

Experience: Any combination of training and experience which would provide an opportunity to acquire the knowledge and abilities listed. Normally, two years of technical professional experience involving systems analysis and programming in a multi-platform information systems environment would provide this opportunity. Additional highly relevant professional level experience may be substituted for the required education.

Education: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college with major coursework in computer science, information systems, or a closely related field would provide this opportunity.

License: Possession of a valid driver's license at the appropriate level including necessary special endorsements, as required by the State of California to perform the essential job functions of the position.

The position advertised on this announcement does not require possession of a valid California Driver’s License.

Qualifications

Considerable knowledge and understanding of: structured coding and analysis; application development products; specific programming techniques and languages such as COBOL, C/C++, SQL, and Visual Basic; principles, methods, and techniques of systems analysis; data representation, data types, data structures, and algorithms; methods to analyze and recommend business solutions to meet customer needs and requirements; operation and application of relational database and file management systems.

Working knowledge and understanding of: the inter-relationship of mainframe, PC, LAN, Network and telecommunications systems including hardware components, software applications, operating systems, and documentation; database design; computer operations, including operating systems and software products; principles of data security; methods and techniques of providing support to users; methods and techniques of troubleshooting software and inter-connectivity problems; principles of project management; principles of governmental accounting and fiscal systems.

Ability to: analyze and design computer applications; create systems and programming specifications; provide technical support and leadership in area of expertise; write and modify applications, instructions, procedures, manuals, documentation; analyze customer's problems, develop effective business solutions, and prepare cost estimates; work cooperatively and effectively with staff, customers, vendors, and the public; perform a variety of tasks in a consistent and accurate manner; analyze and evaluate information, problems, and situations and develop an effective course of action; prepare clear, concise and accurate oral and written reports.

Additional Information

• Your application information and your responses to the supplemental questions are evaluated and taken into consideration throughout the entire selection process.
• You should list all employers and positions held within the last ten years in the work history section of your application. Be as thorough as possible when responding to the supplemental questions.
• You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, list out each position separately.
• Failure to follow these instructions may impact your competitiveness in this process or may result in disqualification.

Please visit Getting a Job with the County of Sonoma to review more detailed information about the hiring process, including the application process, examination steps, and department selection process.

Application submissions require the Supplemental Questionnaire be completed.

Responses to supplemental questions may be scored using position-specific criteria.

Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications.

Responses that state, "See Resume" or "See Application" may be considered insufficient and therefore may not be scored.

The selection procedure will consist of the following examination:

An Application and Supplemental Questionnaire Appraisal Examination (weight 100%) will be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position.

Personally identifiable information (PII) is removed from the standard application fields and applicable attachments.

This PII blind screening practice redacts a candidate’s personal information that could potentially influence or bias the scoring process.

Personal information includes the applicant’s name, former last name, address, phone number, email, driver's license number, school name, education start and end dates, age, date of birth, gender, and race.

This PII blind screening practice helps contribute to a fair and equitable examination process.

Each applicant will be evaluated based on the following criteria:

• Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions.

Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application and Supplemental Questionnaire Appraisal Examination which evaluates the education, training, experience, skills, knowledge, abilities, and other qualifications that you demonstrate in your application and/or response to the supplemental questionnaire.

Please be aware that resumes and cover letters are not typically evaluated in the Application and Supplemental Questionnaire Appraisal Examination.

Scores may be adjusted based on such factors as the number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates.

Additional Information

Being part of the Sheriff's Office and being expected to keep the public safe requires a thorough background investigation process.

This process includes an assessment of prior work history, verifying educational experiences, court reports, public records searches, and understanding past patterns relating to drug usage, financial patterns, etc.

This entails gathering a significant amount of information from job candidates and speaking to former employers, friends, family members, etc.

Polygraphs, drug tests, and medical and physical examinations are also part of this process. Candidates must be honest and forthcoming about information that may arise during the background process.

Deception during any portion of this process is grounds for disqualification, even after employment. This process can take anywhere from 3-5 months.

Many factors are taken into consideration and one should not assume a credit issue or prior drug use is automatically disqualifying.

Candidates will be given the opportunity to present mitigating information they feel should be considered.

You are encouraged to be as responsive as possible while this process is taking place to help expedite the timeline, and we encourage you to stay patient and interested in this great career opportunity while this process is taking place.

You may also review the Job Classification Screening Schedule to determine the requirements for this position.

Please read the Sheriff's Office Pre-Employment Drug Use Guidelines for further information.

How to Apply

Applications are accepted online at www.yourpath2sonomacounty.org. Paper applications may be submitted by person, fax (707-565-3770), email, or through the mail.

All applications and appropriate supplemental information as outlined in the job bulletin must be received by the time and date specified on the first page of this job announcement.

Applications received after the recruitment closes will not be accepted.

The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging.

We are committed to having a diverse workforce that is representative of the communities we serve.

The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need.

HR Analyst: KK

HR Technician: VH