Database Administrator

The Department of Financial Protection and Innovation (DFPI) is recruiting for a Permanent Full-time Information Technology Specialist I (ITS I) position within the Information Technology Services Division (ITSD). This position is to be located in one of DFPI's California office locations: Sacramento, San Francisco, Los Angeles, or San Diego. The recruitment may also be used to fill subsequent vacancies in this position within the next 180 days.

Under the general direction and guidance of the Chief Technology Officer (CTO), the Information Technology Specialist I will serve as a Database Administrator within ITSD's Enterprise Architecture Unit (EAU). The ITS I will have multi-faceted responsibilities, including the management and support of DFPI's Microsoft SQL server, SharePoint, and ServiceNow database systems. Additionally, the ITS I will manage and support data analytical reporting dashboard and data visualization tools such as Power BI.

This position is eligible for a hybrid telework option within California based on departmental guidelines and operational need. DFPI has a minimum in-office requirement of two days per week for all positions including those that are eligible for telework.

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

Working Conditions

Sacramento Location:
The Sacramento office will be relocating from our current Arena Blvd. location to the brand new state-of-the-art May Lee State Office Complex in Sacramento's River District by Spring of 2025.

San Francisco Location:
The San Francisco office is located in the heart of the financial district within walking distance to BART and restaurants.

Los Angeles Location:
The Los Angeles office is located in the heart of the downtown financial district within walking distance to restaurants, transit, multiple parking options.

San Diego Location:
The San Diego office is located in the heart of Mission Valley, within walking distance to many shops and restaurants.

Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST I

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC-442525

Position #(s):
410-113-1402-021

Working Title:
Database Administrator

Classification:
INFORMATION TECHNOLOGY SPECIALIST I $6,323.00 - $8,475.00 A
$6,954.00 - $9,319.00 B
$7,635.00 - $10,230.00 C

# of Positions:
1

Work Location:
United States

Telework:
Hybrid

Job Type:
Permanent, Full Time

Department Information
The Department of Financial Protection and Innovation (DFPI) protects consumers and oversees financial service providers and products. The DFPI supervises the operations of state-licensed financial institutions, including banks, credit unions and money transmitters. Additionally, the DFPI licenses and regulates a variety of financial service providers, including securities brokers and dealers, investment advisers, payday lenders and other consumer finance lenders. The DFPI offers benefit packages, competitive salary, a robust training program and opportunities for advancement.

Department Website: https://dfpi.ca.gov/

Special Requirements

CONFLICT OF INTEREST
This position is subject to Title 10, § 250.30 of the California Code of Regulations, the Department of Financial Protection and Innovation's Conflict of Interest Regulations, the incumbent is required to submit a Statements of Economic Interests (Form 700) within 30 days of assuming office, annually by April 1st and within 30 days of leaving office.

Interested applicants must include a copy of their complete transcripts showing completion of required coursework. Foreign Degrees must provide Degree Evaluation to verify U.S. equivalency. Foreign education credential evaluation services can be found at at NACES | National Association of Credential Evaluation Services .

• You are encouraged to apply electronically through your CalCareers account.
• If applying with a hard copy application, please reference "JC-442525/RPA#ITSD 25-017" in the Job Title section of your State application in order to be considered for this vacancy.
• Hard copy applications not received or postmarked by 5:00 pm on the final filing date will not be accepted.
• Emailed and faxed applications will not be accepted.

We may consider a Training & Development assignment (if applicable)

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/8/2024
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:

Department of Financial Protection and Innovation
Attn: Ashley Johnson
Human Resources Office
2101 Arena Blvd.
Sacramento , CA 95834

Address for Drop-Off Application Packages

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

Department of Financial Protection and Innovation
Ashley Johnson
Human Resources Office
2101 Arena Blvd.
Sacramento , CA 95834

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 -
  A Statement of Qualifications is REQUIRED and must be submitted with your Employment Application (STD. 678). Applications received without an appropriate Statement of Qualifications based on the instructions below will be rejected for being incomplete and will not be considered. Resumes, cover letters, and other documents will not be considered as a response to the Statement of Qualifications. Please refer to the "Statement of Qualifications" section 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:

• Experience working with Relational Database Management Systems.
• Experience with troubleshooting, analyzing, and diagnosing issues related to Databases.
• Experience with administrating databases, including backups, performance, and monitoring.
• Experience working with data reporting analytic dashboard tools such as Power BI.
• Experience working with scripting languages such as Bash, Python, or Powershell.
• Experience working with SQL.
• Knowledge of Software Development Life Cycle.
• Passion for process improvement.
• Ability to communicate effectively both verbally and in writing to all levels of management and staff.

Benefits
State employees may be eligible for health, dental, vision and leave benefits, as well as retirement programs and other benefits. Benefit eligibility may depend on length of service and may be subject to collective bargaining agreements, which are contracts negotiated between the State of California and employee organizations that define employees' wages, hours and conditions of employment. Other possible benefits include:

• Alternate Work Schedules
• Telework
• Reimbursement Accounts

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

Contact Information
The Human Resources Contact is available to answer questions regarding the position or application process.
Department Website: https://dfpi.ca.gov/
Human Resources Contact:
Ashley Johnson
(916) 268-8267

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:
Angelina Endsley
(916) 576-4938
eeo@dfpi.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 QUALFICATIONS

APPLICATIONS RECIVED WITHOUT A STATEMENT OF QUALIFICATIONS (SOQ) WILL NOT BE CONSIDERED. NOTE : Resumes, cover letters, and other materials will not be accepted in place of the required SOQ.

• To be considered for this position, applicants must submit a Statement of Qualifications (SOQ). The SOQ must be no more than two pages in length, single-spaced, using Arial 12-point font, and must have the applicant's first and last name and Statement of Qualifications in the upper left corner. The SOQ must be completed and numbered in the exact order presented and provide responses to each of the following questions

Please explain your experience as it relates to the following questions below:

In the Statement of Qualifications, please answer the following questions:

Describe your experience in managing SQL Server, SharePoint, or similar on-premise or cloud-based databases? Include specific examples of how you've designed, coded, tested, and implemented database procedures, packages, and triggers.

Explain your experience with the full life-cycle management of databases, including operations, encryption, backup and recovery, performance tuning, maintenance, and patching.

Can you provide examples of methods you used to prevent data loss as a database administrator?

Can you provide your experience and/or knowledge of managing and supporting data analytical reporting dashboard tools such as Power BI?

EXAMINATION INFORMATION

To obtain list eligibility for the Information Technology Specialist ll before applying for the position(s), you must first take and pass the Information Technology Specialist l examination.

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.