Apply on Employer Site

County of Sonoma · 1 day ago

Senior Programmer Analyst - Promotional

Santa Rosa, CA

Full-time

Onsite

Mid, Senior Level

2+ years exp

County of Sonoma is seeking a Senior Programmer Analyst to support the Sheriff's Office. The role involves managing complex systems and programs, designing and developing applications, websites, and databases, and collaborating with stakeholders throughout the development lifecycle.

GovernmentNon ProfitSocial

No H1B

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

C#SQLMicrosoft .NET FrameworkDatabase designJavaScriptMicrosoft Visual StudioWeb developmentRESTful APIsCommunication skillsProblem-solvingTeam leadershipProject management

Required

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

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

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 to perform the essential job functions of the position

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

Preferred

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

Experience working with and/or possess knowledge of programming in C#, Visual Basic, and JavaScript (additional languages a plus)

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