Senior Software Engineer

County Of Sonoma Santa Rosa, CA Full-time Information Services / Technology (IT)

Posted on May 5, 2023

Apply Now

Starting salary up to $59.40/hour ($123,974.93/year), a cash allowance of $600/month, and a competitive total compensation package!*

This Senior Software Engineer will plan, develop, and maintain critical application infrastructure services for the County of Sonoma’s Human Services Department, including designing and maintaining application availability, security, and accessibility, and overseeing the performance and condition of multiple application servers. Additional duties include:
Full stack backend and frontend web application development and support

Platform infrastructure design and administration, Internet Information Services (IIS) administration, web application design and architecture, and database architecture
Complex business logic understanding, coding, testing, deployment, and end-user support
Maintaining internal and external web applications
Working with other web developers to ensure consistency and best practices
Collaborating with HSD business units on service needs and impact analysis
Utilizing Business Analysis and Project Management skills
Influencing and planning the underlying architecture and frameworks of application development technologies
Working closely with the Reporting, Applications, and Data (RAD) unit
Maintaining and promoting high levels of data management security and resilience
Acting as a technical lead, on an as needed basis

The ideal candidate will have strong communication skills and the ability to interact with a diverse end-user base and build relationships with all levels of staff. They will also have experience guiding non-technical staff in eliciting business requirements and end-user testing, have the ability to adapt to shifting priorities, stay current with growing technologies and engineering trends, and have experience with the following:

Web application design and architecture

Database architecture and interactions
Visual Studio, C# (or similar object-oriented language), IIS, Azure DevOps, Power Platform, and MS SQL Server
Full staff backend and frontend web application development, Object Oriented Programming (OOP), ASP.NET, and Microsoft Visual Studio
The Software Development Lifecycle (SDLC)
HTML, CSS, JavaScript, and jQuery
Business Analysis, Project Management, and Database modeling/architecture
Enterprise Information Management/Data Governance, i.e., data integration, data quality, master data management, metadata management, data warehousing, enterprise data architecture, database administration, and referential integrity and appropriate indexing

About the Human Services Department (HSD)

HSD fosters a positive work environment, where our commitment to providing opportunities for advancement is strengthened by a robust staff development program. We believe in the merits of work/life balance and enjoy the satisfaction of knowing that our work contributes to the betterment of our community.

As the largest agency in Sonoma County government, our mission is to protect vulnerable children and adults, and to promote maximum independence and well-being for individuals and families. HSD is responsible for child and adult protective services, veteran services, and administration of state and federal programs, including CalFresh, CalWORKs, Medi-Cal, In-Home Supportive Services, and Workforce Innovation and Opportunity Act programs. The department is dedicated to providing high quality, client-focused, cost-effective services and values the diversity, integrity, teamwork, leadership, and accountability of all staff in accomplishing the mission of the department.

The Department works collaboratively at the federal, state, and local level to find creative solutions to support the well-being of individuals, families, and the community. To meet that goal, the department has fostered strong relationships with other public and private sector partners, including other government agencies, community-based organizations, and business leaders. For more information regarding HSD's services please visit http://sonomacounty.ca.gov/Human-Services.

What We Offer

Working at HSD offers expansive opportunities for growth and development, the ability to be a part of a challenging and rewarding work environment, and the satisfaction of knowing your contributions work to better our shared community. You can also look forward to flexible work arrangements and excellent benefits* including:

A hybrid telework schedule that meets the needs of our staff, department operations, and the communities we serve may be available depending on assignment
Eligibility for a salary increase after 1,040 hours (6 months when working full-time) for good work performance; eligibility for a salary increase for good performance every year thereafter, until reaching the top of the salary range
Competitive vacation and sick leave accruals, 12 paid holidays, and an additional 8 floating holiday hours per year
County paid 100% premium contribution for the majority of employee-only and employee + family health plan options
An annual Staff Development/Wellness Benefit allowance of up to $500 and ongoing education/training opportunities
County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits
Retirement fully integrated with Social Security
May be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment

The Human Services Department is currently recruiting to fill a Senior Software Engineer vacancy. This employment list may also be used to fill future full-time, part-time, or extra-help (temporary) positions as they occur during the active status of the list. Qualified County employees who wish to be considered for future positions should consider applying to this recruitment. The Civil Service title for this position is Human Services Database Administrator.

APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED.

Minimum Qualifications

Education and Experience: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, this would include graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field, and four years of related technical professional experience which includes at least two years of database administration in a multi-platform information systems environment and experience installing and maintaining database structures.

Additional highly relevant professional level experience may be substituted for the required education on a year by year basis. Some experience in a government public assistance/social services information technology setting is desirable.

License: Possession of a valid driver’s license at the appropriate level including special endorsements, as required by the State of California, may be required depending upon assignment to perform the essential job functions of the position. Certification in Database Management is desirable.

Knowledge, Skills, and Abilities

Considerable knowledge of: database administration and management, operating systems, web-based applications, software products; principles of database design; advanced enterprise development skills, data collection, and classification procedures; database and systems problem identification, tracking, resolution, and vendor oversight; business analysis and project management methodologies; the inter-relationship of mainframe, database support including data extractions, queries, and reporting, application development and support; principles of systems and procedures analysis and documentation; uses and limitations of associated applications.

Working knowledge of: State social services programs such as CalWIN, CalSAWS, CalHEERS and related information technology systems and Human Services IT operations; technical requirements gathering and the management of Relational Database Management Systems (RDMS), networking and Web servers; structured coding and analysis; application development products; specific programming techniques and languages; mainframe, mid-size, and client-server network systems capabilities and operations; methods and techniques of troubleshooting hardware, software and inter-connectivity problems; principles of data security; methods and techniques of providing support to staff and end users.

Ability to: program ETL jobs using industry standard programming languages and MS SQL Server, manage ETL scheduling, and troubleshoot issues; develop and modify database models based on departmental needs; perform database administration functions including SQL database server oversight; develop standards and methodologies for use of the Human Services database management system; monitor and troubleshoot database performance; write and modify instructions, procedures, manuals, documentation; analyze systems problems, develop effective solutions, prepare scope and work and cost estimates associated with vendor contracts; participate in systems analysis, design and implementation; work cooperatively and effectively with staff, customers, and vendors; create systems specifications; provide technical support related to systems software; perform a variety of tasks in a consistent and accurate manner; plan and manage the migration of databases to new technologies; plan and oversee the installation or reinstallation process and coordinate with specialists in other functional areas to resolve connectivity, compatibility, reliability, security, and related issues.

Apply Now