INFORMATION TECHNOLOGY SPECIALIST II

California State Personnel Board
Solano County, CA, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$103,500.0 - $138,684.0
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Application Services Cluster Analysis Information Systems Databases Data Recovery Data Security Disaster Recovery Failover Microsoft SQL Server Performance Tuning Windows PowerShell
+9 more
Software Engineering SQL Databases SQL Server Integration Services Transact-SQL Alwayson Information Technology Performance Monitor Data Management GPT

Job description

Are you a bright and passionate IT Administrator? Are you looking for an opportunity to apply your advanced experience? Come join us at State Fund! California’s State Compensation Insurance Fund is seeking a self-starter interested in contributing to our high performance Data Management teams. Under general supervision, the SQL DBA will perform a full range of Database Administration functions for all Microsoft SQL Server database in support of the company’s application systems. Role & Responsibilities: SQL DBA is responsible for performing proactive database maintenance tasks, ensuring database systems are optimized for maximum performance and implementing HA solution in meeting the systems up-time SLA. This position will also work collaboratively with software architects and application developers to provide high standard DB services to our application development needs. Task performs by the MS SQL Server DBA will including, but no limited to the following:

  • On-going maintenance of Microsoft SQL Server databases. Daily operational tasks like:
  • Perform Database cloning and database recovery as needed
  • Proactively monitoring the health of all SQL Server Services
  • Monitoring SQL Server audit and error logs
  • Performance monitoring and tuning as needed
  • Setup of database systems for new software installations
  • Administer backup, clustering, mirroring, replication and failover as needed
  • Maintain and monitor High-Availability of SQL Server Database between production clusters and disaster recovery (DR) environments.
  • Develop and implement proactive monitoring for a multi-server Microsoft SQL Server environment.
  • Provide advice/recommendations on SQL Server architecture, design, and implementation.
  • Provide documentation for knowledge transfer to other SQL Server Support Team members, and communicate both to non-technical users and to technical personnel on SQL Server Support Team and application team with whom one works.
  • Evaluate and recommend emerging database technologies for adoption.
  • Production support of Microsoft SQL Server database issues, this may include after hours or weekend or both on-call support.

Working Conditions

The successful candidate must reside in California upon appointment.

Selected candidate(s) hired may be required to attend in-person Onboarding at our Vacaville office with expenses for attendance paid by State Fund., Our culture centers on our purpose and values. We exist to provide fairly priced workers’ compensation insurance, make workplaces safe, and restore injured workers. To fully represent California, we are committed to our employees by embracing and celebrating our diverse workforce and fostering inclusion to make the workplace a dynamic environment for all. We recognize and reward high performance yet value a healthy work/life balance.

Department Website: http://www.statefundca.com

Special Requirements

Effective July 1, 2025, the State of California implemented the Personal Leave Program 2025 (PLP 2025) which reduces an employee’s monthly salary in exchange for leave credits. Employees appointed to this classification will have their monthly salary reduced and will accrue hours of PLP 2025 on the first day of each pay period in accordance with the applicable bargaining contract. The salary range(s) included on this job posting do not reflect the reduction in pay.

To be considered, you must provide a fully completed STD 678 application, resume, and statement of qualifications. Alternative documents submitted in lieu of required Application, Resume, or Statement of Qualifications will not be accepted. Completed STD 678 must include duties performed, start and end dates, and hours worked per week for each position held.

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, have LEAP eligibility, or have SROA and/or Surplus eligibility may be considered.

Artificial intelligence (AI) tools such as ChatGPT, website searches, and third-party reviewers can be helpful in researching responses to the SOQ; however, by submitting your application for this position, you understand and acknowledge the SOQ you submit is your own work, in your own words, and accurately reflects your knowledge, skills, abilities, and experiences. Submitting an SOQ that is not your own may be cause for disqualification from the hiring process.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application. Final Filing Date: 5/29/2026

Who May Apply Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.

Requirements

Do you have experience in Technical documentation?, Do you have a Bachelor’s degree?, In addition to evaluating each candidate’s relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

  • Bachelor’s degree in Computer Science or equivalent experience
  • 3+ years practical technical experience in MS SQL server database administration
  • Demonstrated knowledge and skills in database management in a complex enterprise environment
  • Proven ability to maintain leading edge skills in a rapidly changing information system environment
  • Experience with T-SQL and PowerShell development
  • Experience working in fast paced application development environment
  • Effective verbal and written communication skills in both business and technical areas
  • Experience in Database Disaster recovery planning & solution
  • Experience with SQL Server Always-On Availability groups
  • Experience in data security and privilege management at the enterprise level is a plus
  • Experience building/deploying SSIS packages is a plus

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • 401(k)
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Employee assistance program
  • Leadership training provided, State Fund employees are eligible for a number of benefits. Our benefit package includes: Health Benefits Program (CalPERS) Retirement (CalPERS) Employer Health and Consolidated Benefits Contributions Dental, Vision 401(k) and 457 Deferred Compensation Plans Employee Assistance Program Group Legal Services Insurance Holidays, Vacation/Sick/Other Paid Leave Flex Elect Reimbursement Program Wellness and Recognition Alternate Work Schedules Transit Pass Program Tuition Reimbursement Dependent Scholarship Program Leadership Training Mentoring Program https://www.statefundca.com//Home/StaticIndex?id=https://content.statefundca.com//careers/Index.asp

About the company

State Fund is California’s largest provider of workers’ compensation insurance. Established in 1914 by the state legislature, we offer diverse and comprehensive products and services that provide a strong and stable option for employers and injured employees with fast, reliable claims service and medical and indemnity benefits.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:59 min

Scaling clusters and handling automated replica failover

Jürgen Pilz · WWC 2023

40 sec

Generative pre-trained transformer models powering code completions

lgonta lgonta +1 · WWC 2024

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

5:25 min

Implementing redundancy, failover, and architectural load balancing patterns

Mihaela-Roxana Ghidersa · LIVE

51 sec

Assessing GPT-4o performance for pull request feedback

Merrill Lutsky Merrill Lutsky · WWC 2025

3:24 min

Evaluating remote software roles and compensation structures

Nacho Iacovino · WWC 2021

Videos

See all

Related articles

See all