Human Services Database Administrator

County Of Sonoma   Santa Rosa, CA   Full-time     Information Services / Technology (IT)
Posted on July 15, 2022
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!* 


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.