Senior Software Engineer



Senior Software Engineer

Salary

$117,087.43 - $142,341.58 Annually

Location

Santa Rosa, CA

Job Type

Full-Time

Job Number

23/05-0171-OC

Department

Human Services Department (HSD)

Opening Date

05/04/2023

Closing Date

6/5/2023 4:00 PM Pacific

Bargaining Unit

05

Position Information

The County of Sonoma Human Services Department (HSD) is seeking a qualified IT professional to join their team as a Senior Software Engineer!

Starting salary up to $68.20/hour ($142,341/year) 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
*Salary is negotiable within the established range. Benefits described herein do not represent a contract and may be changed without notice. Additional information can be found in the Service Employees International Union Local 1021 Memorandum Of Understanding (SEIU MOU) and our Employee Benefits Directory.

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.

Selection Procedure & Some Helpful Tips When Applying

  • Your application information and your responses to the supplemental questions are evaluated and taken into consideration throughout the entire selection process.
  • You should list all employers and positions held within the last ten years in the work history section of your application. Be as thorough as possible when responding to the supplemental questions.
  • You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, list out each position separately.
  • Failure to follow these instructions may impact your competitiveness in this process or may result in disqualification.
Please visit Getting a Job with the County of Sonoma to review more detailed information about the hiring process, including the application process, examination steps, and department selection process.

APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED.

Responses to supplemental questions will be used in assessing minimum qualifications. Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications. Responses that state "See Resume" or "See Application" may be considered insufficient.

The selection procedure will consist of the following examination:

An Application & Supplemental Questionnaire Appraisal Examination (weight 100%). Each application and supplemental questionnaire will be thoroughly evaluated for satisfaction of minimum qualifications and relevance of educational coursework, training, experience, knowledge, and abilities that relate to this position. Candidates possessing the most appropriate job-related qualifications will be placed on an employment list and referred to the department for selection interviews.

ADDITIONAL INFORMATION

A background investigation is required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants.

Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter. You may also review the Job Classification Screening Schedule to determine the requirements for this position.

HOW TO APPLY

Applications are accepted online at www.yourpath2sonomacounty.org. Paper applications may be submitted by person, fax (707-565-3770), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be RECEIVED by the time and date specified on the first page of this job announcement. Continuous recruitments may close without notice at any time that a sufficient number of qualified applications have been received. Applications received after the recruitment closes will not be accepted.

The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging. We are committed to having a diverse workforce that is representative of the communities we serve. The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need. 

HR Analyst: EP
HR Tech: EV     

IMPORTANT NOTE: Benefits described herein do not apply to Extra Help positions.

COUNTY OF SONOMA BENEFITS: GENERAL*

These are some of the excellent benefits the County offers:
 
Paid Time Off: Competitive vacation and sick leave accruals; 12 paid holidays, and an additional 8 floating holiday hours per year; and may be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment.
 
Health Plan: Choice of five health plans (a PPO, EPO, HMO, and two deductible HMOs) with a County contribution toward the premium (the contribution amount varies by bargaining unit. For specific details, please refer to the applicable MOU). A County contribution to a Health Reimbursement Arrangement is available for some bargaining units.

Retirement: Fully integrated with Social Security. For more information regarding eligibility, retirement contributions, and reciprocity with prior public service, please visit https://scretire.org/active-/-deferred/when-you-are-hired.
 
IRS 457 Plan: Pre-tax employee contribution up to the IRS annual maximum.
 
Retiree Medical: County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits.

Plus excellent dental, vision, disability, life insurance, professional development, and more.

For answers to specific questions regarding the employment process and more details about benefits or retirement, please contact Human Resources at (707) 565-2331. Additional details about benefit and compensation packages can be found in the MOUs located at https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources/divisions-and-units/employee-relations/labor-agreements-and-salary-resolution. For specific information about health and welfare benefits including plan options, coverage, and premium amounts go to https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources or, contact the Human Resources' Risk Management-Benefits Office at benefits@sonoma-county.org or (707) 565-2900.

*IMPORTANT NOTES: Benefits described herein do not represent a contract and may be changed without notice.

01
How did you first learn about this opportunity?
  • Association of Bay Area Governments (ABAG)
  • CalJobs
  • Careers in Government
  • College or University
  • Craigslist
  • Dice.com
  • DiversityJobs
  • Employee of Sonoma County
  • Facebook
  • Glassdoor
  • Google Jobs
  • GovernmentJobs.com
  • Hispanic Chamber of Commerce of Sonoma County
  • Indeed
  • Instagram
  • Job Fair
  • La Voz
  • Latino Service Providers
  • LinkedIn
  • Los Cien
  • Minority Organization or Group
  • Press Democrat
  • sonoma-county.org/www.yourpath2sonomacounty.org
  • Sonoma County Human Resources Office
  • Sonoma County Job Line
  • Start Here!
  • Twitter
  • Veterans Services Office
  • Women's Organization or Group
  • Workplace Diversity
  • ZipRecruiter
  • Other Internet Site
  • Other Publication
02
Please indicate if you would also be interested in future part-time or extra-help (temporary, intermittent, or seasonal employment) positions should they become available. Check all that apply.
  • I would also like to be considered for future part-time positions
  • I would also like to be considered for future extra-help positions
  • I am only interested in full-time positions
03
For this question, and all subsequent questions, provide sufficient information to allow for a thorough evaluation of your qualifications. Responses to supplemental questions may be reviewed by hiring managers.

The minimum qualifications for this position normally includes 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.

Please describe how you meet these requirements by providing the names of the relevant courses you completed, the amount of semester or quarter units awarded, any degrees obtained, your employer(s) name, job title(s), dates employed (mm/yy-mm/yy), and a breakdown of your primary responsibilities.

04
Please describe a large application development and implementation and/or migration project you worked on. Detail the situation, your primary goals/duties, any challenges you encountered, how you overcame them, and the outcome.
05
Please describe a time when you experienced a problem with performance in a Microsoft SQL based application. Include how you researched or troubleshot the issue(s), what solutions you considered, and the final resolution.
06
Please describe your full stack backend and frontend web application development and support experience. Include the programming languages you used and how you utilized them.

Required Question

Agency
County of Sonoma (CA)
Address
575 Administration Drive, Suite 116B

Santa Rosa, California, 95403
Phone
(707) 565-2331