Sonoma County Public Infrastructure · 11 hours ago
Senior Programmer Analyst - Promotional
Santa Rosa, CA
Full-time
Onsite
Mid, Senior Level
2+ years expSonoma County Public Infrastructure is seeking a Senior Programmer Analyst to manage complex systems and programs for the Sheriff's Office. The role involves designing, developing, and maintaining applications, websites, databases, and reporting solutions while collaborating with stakeholders throughout the development lifecycle.
Government Administration
Responsibilities
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
Qualification
Required
Currently a full or part-time regular or probationary County of Sonoma, Community Development Commission, Sonoma County Fairgrounds, or Sonoma County Water Agency employee
Two years of technical professional experience involving systems analysis and programming in a multi-platform information systems environment
Graduation from a four-year college with major coursework in computer science, information systems, or a closely related field
Possession of a valid driver's license at the appropriate level including necessary special endorsements, as required by the State of California
Preferred
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
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)
Company
Sonoma County Public Infrastructure
The Department of Public Infrastructure is dedicated to planning, building, and maintaining the County’s investment in infrastructure through innovations in engineering that improve residents’ lives and enhance community well-being.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase