Senior Programmer Analyst - Promotional

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/Web Forms 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 Git Hub

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

Application submissions require the Supplemental Questionnaire to be completed.

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…