The County of Sonoma Information Systems Department (ISD) seeks a talented Programmer Analyst to support a wide range of activities involving all aspects of the software development lifecycle (SDLC), including developing and testing code, troubleshooting application incidents, assisting in defect resolution, and data fixes.
Requirements
- One or more years experience with the software development life cycle (SDLC), related methodologies (Agile, Waterfall) data integration, and production support for an enterprise system
- Experience working with relational databases including SQL Server and Oracle
- The ability to develop complex SQL, stored procedures, and use of triggers
- Experience with MS Access including SQL, Visual Basic, and debugging
- Experience with Net, C-Sharp, JavaScript, and SQL
- Experience with Microsoft technologies, Net Framework, Visual Studio, SSIS, SSRS Web Services (SOAP, REST), Windows Services, MS365, Power Suite of tools (Power BI, Power Apps, Power Automate)
- 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
Responsibilities
- Developing and testing code
- Troubleshooting application incidents
- Assisting in defect resolution
- Data fixes
- Supporting clients, web based third party applications suites, and custom applications
- Working directly with Senior Programmer Analysts who provide mentoring around professional development and growth opportunities
- Supporting a wide range of activities involving all aspects of the software development lifecycle (SDLC)
Other
- Any combination of training and experience which would provide an opportunity to acquire the knowledge and abilities listed
- 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
- 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
- A background investigation is required prior to employment
