Human Services Database Administrator



Human Services Database Administrator

Salary

$101,997.55 - $123,974.93 Annually

Location

Santa Rosa, CA

Job Type

Full-Time

Job Number

22/07-0171-O

Department

Human Services Department (HSD)

Opening Date

07/14/2022

Closing Date

8/15/2022 11:59 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 Human Services Database Administrator!

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

The Human Services Database Administrator will plan, develop, and maintain critical data management infrastructure services for the County of Sonoma’s Human Services Department, including maintaining data availability, security, and accessibility, and overseeing the performance and condition of multiple database servers. Additional duties include:

  • Evaluating, selecting, and implementation cloud-based services
  • Data management planning and operations
  • Participating in industry and technology work groups
  • Collaborating with HSD business units on service needs and impact analysis
  • Collaborating with the County IT Department on an as needed basis
  • Maintaining and promoting high levels of data management security and resilience
The ideal candidate for this position 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 working with the following:

  • Microsoft SQL Server Database Administration, Management, and Development
  • ETL programming and management using industry standard programming languages, SSIS, and SSRS
  • Microsoft SQL Database modeling and architecture
  • Enterprise Information Management and Data Governance
  • TSQL, Stored Procedures, Triggers, and Replication
  • Business Analysis, Project Management, Software Testing, and Deployment
  • MySQL and MS Access
  • Azure Data Management and Dev Ops are desired but not required
  • Software/Application Development, Object Oriented Programming, C#, ASP.NET, and Web Technologies are desired but not required
About the Human Services Department 
 

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, and In-Home Supportive Services. 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

When you join HSD, you become part of a strong work family that makes a difference in lives of our community. We offer opportunities for growth, development, and the ability to be a part of a rewarding work environment. You can also look forward to excellent benefits,* including:

  • 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
  • An annual Staff Development/Wellness Benefit allowance of up to $500 and ongoing education/training opportunities
  • 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
  • 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 one full-time Human Services Database Administrator. Additionally, this employment list may be used to fill future full-time, part-time, and 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.

*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. 

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 and should 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 scored using position-specific criteria. Please provide specific and detailed responses of a reasonable length to allow for thorough assessment of your qualifications. Responses which state "See Resume" or "See Application" may be considered insufficient and therefore may not be scored.
 
The selection procedure will consist of the following examination:

An Application & Supplemental Questionnaire Appraisal Examination (weight 100%) will be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria:

  • Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions.
Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application & Supplemental Questionnaire Appraisal Examination. Scores may be adjusted based on such factors as number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates.
 
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 are 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 on-line 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. 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 Technician: RR     

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.

Cash Allowance: In addition to monthly salary, a cash allowance of approximately $600 per month.

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
The minimum qualifications for this position generally includes graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field. Please describe how you meet this requirement by providing the names of relevant courses you completed, the amount of semester or quarter units awarded, and any degrees obtained.
04
The minimum qualifications also generally includes 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 your experience that qualifies you for this position, including your employer(s), job title(s), dates employed (mm/yy-mm/yy) where you gained this experience, and your primary responsibilities.
05
Please describe a project that you worked on that included a large database implementation and/or migration. Detail the situation, your primary goals/duties, any challenges you encountered, how you overcame them, and the outcome.
06
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.
07
Please describe your experience using commercial software tools to support and/or report on database systems, including any experience you have using Enterprise Data Management tools. Include the tools 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