Job Posting: Database Architect

State Water Resources Control Board

JC-530880
-
Database Architect
INFORMATION TECHNOLOGY SPECIALIST II

$8,625.00 - $11,557.00 per Month
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

Final Filing Date: 9/15/2026

Job Description and Duties

Please note, the Water Boards do not participate in E-Verify.

The State Water Resources Control Board’s Division of Information Technology is seeking an Information Technology Specialist II (ITS II) to work in the Data Management Unit.

Apply today and join our dedicated and driven team, focused on supporting business applications and the latest technologies. The position is located at 1001 I Street, 8th Floor, Sacramento, CA 95814, right in the heart of downtown, next to light rail stations and other public transportation.

Duties: Applicants can review the attached Duty Statement.

Under the direction of the Information Technology Manager I (ITM I) of the Business Operations Support Branch in the Division of Information Technology (DIT) and consistent with good customer service practice and the goals of the State and Regional Board’s Strategic Plan, the incumbent provides expert-level data architecture strategic leadership and development functions in support of the agency’s diverse enterprise data needs, including on-prem and in the cloud architecture using MS SQL Server, Snowflake, and transforming tools such as but not limited to FiveTran and Data Bricks. The ITS II will have an advanced understanding of data modeling to establish an enterprise data architecture that streamlines data collection and reporting.

The ITS II works independently on the enterprise and departmental databases and applications, maintains the Microsoft SQL Server Database, and is responsible for planning, directing, coordinating, implementing, and monitoring system functions. The ITS II will be responsible for the SQL Server database software used in shared VMware and cloud-based virtual environments. This position requires the ITS III to communicate effectively and professionally (verbally and in writing) with team members and customers.

The incumbent will provide services from IT domains, including Software Engineering, System Engineering, Information Security Engineering, Information Technology Project Management, and Business Technology Management.

Additional information:

Candidates must possess essential personal qualifications including integrity, initiative, dependability, good judgment, the ability to work cooperatively with others, and the ability to perform the assigned duties of the class.

If the position requires driving, you must possess a current and valid driver’s license. Please Do Not include full Social Security Number, method of eligibility, and LEAP information in your application package.

Please let us know how you heard about this position by taking this brief survey: Recruitment Survey.

You will find additional information about the job in the Duty Statement.

Working Conditions

Positions at the Water Boards may be eligible for telework with in-person attendance based on the operational needs of the position.

In accordance with the Statewide Telework Policy and GC 14200, the successful candidate must reside in California upon appointment.  Proof of residency may be required.

Salary Information - CalHR salary rules allow appointment at the entrance rate (Cal. Code Regs., tit. 2, § 599.673) of a classification. For classes with alternate ranges, placement is based on education/experience. Employees appointed to the Attorney or Water Resource Control Engineer classification will receive Recruitment Higher Above Minimum (HAM) rate in accordance with the approved Civil Service Pay Scales.

In addition, note: 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.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-530880
Position #(s):
880-280-1414-XXX
Working Title:
Database Architect
Classification:
INFORMATION TECHNOLOGY SPECIALIST II
$8,625.00 - $11,557.00 A
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.
# of Positions:
2
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Facility:
State Water Resources Control Board

Department Information

The State Water Resources Control Board (SWRCB) and the nine (9) Regional Water Quality Control Boards (RWQCB) (collectively the Water Boards) work to preserve, enhance, and restore the quality of California’s water resources and drinking water for the protection of the environment, public health, and all beneficial uses, and to ensure proper water resource allocation and efficient use, for the benefit of present and future generations.

The Water Boards value diversity, equity, and inclusion throughout the organization. We foster an environment where employees from a variety of backgrounds, cultures, and personal experiences are welcomed and can thrive. We believe the diversity of our employees is essential to inspiring innovative solutions. Together we further our mission to preserve, enhance, and restore the quality of California’s water resources and drinking water for the protection of the environment, public health, and all beneficial uses, and to ensure proper water resource allocation and efficient use, for the benefit of present and future generations. Join the Water Boards to improve the lives of all Californians.

Department Website: https://www.waterboards.ca.gov/

Special Requirements

In order to be considered for this position, you must include the following:

  • RPA# 26-280-017 & 26-280-023 in the “Examination or Job Title(s)” section of the State application when submitting a hardcopy application.
  • Photocopies of degree and official transcripts (if needed to establish eligibility)

Must have Information Technology Specialist II list, transfer, or reinstatement eligibility and be reachable on the certification list. Here is the link to the exam:  https://calcareers.ca.gov/CalHrPublic/Exams/ExamBulletin.aspx?ExamControlId=1751

An applicant with a college degree obtained outside the United States that does meet accreditation standards must have education records evaluated by a credentials evaluation service. Evaluation of education records will be due during final minimum qualification evaluation of candidate(s). A link of accepted evaluation agencies can be found here: https://www.naces.org/members.

Electronic submittal of applications and attachments through jobs.ca.gov is preferred. Emailed or faxed applications will not be accepted. You are required to complete employment history on the application form (STD. 678), including work experience, dates, hours worked, contact names and phone numbers of supervisors on the state application. Applicants who fail to submit a completed STD. 678 may be disqualified.

In the hiring interview, the panel will consider education, experience, personal development, personal traits and fitness for the job. In appraising experience, more weight may be given to the breadth of pertinent experience and evidence of the candidate's ability to accept and fulfill increasing responsibilities than to the length of his/her experience. For additional information, you may refer to the class specification.

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: 9/15/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.

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply

Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

State Water Resources Control Board
Attn: Human Resources Branch- Rebecca Ramirez
1001 I Street, 18th Floor
Sacramento, CA 95814

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

State Water Resources Control Board
Attn: Human Resources Branch- Rebecca Ramirez
1001 I Street, 18th Floor
Sacramento, CA 95814
08:00 AM - 05:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

  • Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
  • Resume is required and must be included.
  • Statement of Qualifications - Please see below for specific requirements.
Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

Desirable Qualifications

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:

• Possess advanced knowledge and experience supporting all aspects of SQL Server database systems, data warehouses, Snowflake, and application server system administration.

• Possess advanced knowledge of systems integration, logical and physical database design, data table generation, data modeling, database schema administration, data migration best practices, performance tuning, data conversion, migration, integration, security practices and procedures.

• Experience in serving as a subject matter expert on operational service activities for system administration of database environments, including monitoring, optimizing, tuning, and troubleshooting complex technical SQL Server database and systems problems.

• Possess knowledge and experience supporting application servers using Red Hat Linux (VMWare hardware) administration tools.

• Knowledge of and experience designing and developing complex Extract-Transform-Load (ETL) and Extract-Load-Transform (ETL) processes.

• Possess knowledge of and experience with large relational and NoSQL database management systems, including Snowflake, Oracle, MySQL, Microsoft SQL Server, PostgreSQL, MS Access, MongoDB or equivalent, Rubrik, Transact-SQL, PL/SQL, SSIS, SSRS, JSON, XML, jQuery, Power BI, and data modeling tools.

• Knowledge of cloud-based technical architectures and web solutions development in a virtual and cloud-based environment.

• Knowledge of and experience with database application server software configuration, maintenance, and troubleshooting, including Windows, IIS, Red Hat Linux (RHL), Apache, AWS, and Azure cloud architectures or equivalent.

• Ability to communicate effectively and professionally (verbal and in writing) with team members and customers and provide timely responses to internal/external customers.

• Prepare and make presentations to diverse customers and stakeholder audiences.

• Possess strong knowledge of PowerShell and Linux shell scripting.

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

Water Board employees may be eligible for benefits. Health benefits and leave programs are available for most permanent, full-time employees, and some permanent, part-time employees. Benefit eligibility may depend on length of service and may be subject to collective bargaining agreements negotiated between the State of California and employee organizations that define wages, hours, and terms and conditions of employment. https://www.calhr.ca.gov/Pages/California-State-Civil-Service-Employee-Benefits-Summary.aspx and Health Benefits | CalPERS

Contact Information

The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.

Department Website: https://www.waterboards.ca.gov/
Human Resources Contact:
Rebecca Ramirez
(916) 552-8754
rebecca.ramirez@waterboards.ca.gov
Hiring Unit Contact:
Aries Valdez
(916) 341-5200
aries.valdez@waterboards.ca.gov

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

EEO Contact:
Shyla Hoffman
(916) 341-5881
shyla.hoffman@waterboards.ca.gov
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Statement of Qualifications

A Statement of Qualifications (SOQ) must be submitted along with the State Application and serves as documentation of candidate’s ability to present information clearly and concisely in writing. It should be typed, no more than two (2) pages in length, using Arial 12 font, and normal margins.

Indicate your total years of experience when answering the following statements/questions:

  1. Describe your role and experience working in a role where you supported enterprise databases. In your response, include:
  • The scope of your responsibilities (e.g., planning, administration, troubleshooting, performance tuning, or security).
  • The types of databases and environments you have worked with (such as Microsoft SQL Server, Snowflake, Oracle, or cloud-based platforms).
  •  Examples of projects or initiatives where your contributions made a measurable impact.
  1. Describe your experience designing or implementing enterprise-level data ingestion pipelines using ETL or ELT tools. Include examples of platforms such as FiveTran, Snowflake, or SQL Server Integration Services. Explain how your work improved data quality, reporting, or system performance.

Applications received without the SOQ addressed as stated will not be considered.

For guidance on writing effective SOQs, visit: Work4CA: How to Write a Statement of Qualifications. Artificial Intelligence (AI) tools can be useful in the development of written responses; however, it is important to use these tools responsibly and ethically. Failure to comply may result in disqualification.

Note: Resumes, letters, and other materials will not be evaluated or considered as a response to the SOQ.

Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail
Drop-off
Print Job