All applicants will be considered, however SROA/Surplus candidates will be given priority.

Are you interested in making life better for Californians? Are you looking for a career and not just a job? Do you want to create a meaningful impact in your community? If you answered yes to any of these questions, then the California Department of Tax and Fee Administration (CDTFA) has a career opportunity waiting for you! California not only needs you, it wants you as part of the growing workforce. New employees, new ideas, and new creative perspectives are needed in all areas at the CDTFA. We value staff and are dedicated to employee career development. Our agency supports the development of staff by offering training to flourish in their position and programs to promote and explore upward mobility. To learn more about us, please see CDTFA Gateway to New Opportunities video

Under the general direction of the Information Technology Manager I (IT Manager I), the Information Technology Specialist I (IT Specialist I) will act as the journey-level technical expert for the design, implementation, maintenance, and performance of the organization's SQL Server databases. The position will include database tuning and optimization and building data pipelines. Our SQL server databases are currently hosted in Azure cloud environment. The IT Specialist I will work directly with application developers and data analysts in support of business operations.

Here is the link to the Information Technology Specialist I examination bulletin.
This recruitment has been posted for more vacancies than currently exist as it may be used to fill additional identical vacancies which occur within 180 days of the closing date of this bulletin.

Under Government Code 14200, this position may be eligible for full or part-time telework for eligible candidates residing in California.

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

Working Conditions

• Position located in a high-rise building.
• Standard office environment.
• Requires being in a stationary position, consistent with office work, for extended periods of time.
• Daily use of a personal computer, office equipment, and/or telephone.
• Telework is available up to fifty percent (50%) of the time.

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-427408

Position #(s):
291-381-1402-075

Working Title:
Database Administrator

Classification:
INFORMATION TECHNOLOGY SPECIALIST I $6,139.00 - $8,228.00 A
$6,751.00 - $9,048.00 B
$7,413.00 - $9,932.00 C

# of Positions:
Multiple

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Department Information
California not only needs you; it wants you as part of the growing workforce. The California Department of Tax and Fee Administration (CDTFA) makes life better for Californians by fairly and efficiently collecting the revenue that supports our essential public services, with CDTFA administered programs accounting for over 25 percent of all state revenue. Tax programs administered by the CDTFA are concentrated in two general areas - sales and use tax, and special taxes and fees. New employees, new ideas, and new creative perspectives are needed in all areas at CDTFA. CDTFA offers employees reliable income, stable benefits, work-life balance, paid holidays, advancement opportunities, and the personal fulfillment of knowing that your work is personally impacting the lives of others.

To take a look at CDTFA as a destination employer please click the link ( https://youtu.be/Q-r18e_EIBg )

Department Website: http://www.cdtfa.ca.gov

Special Requirements

This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.; for more information about E-Verify, please go to www.dhs.gov/e-verify

Position requires employee to be fingerprinted and successfully pass a background investigation.

Education : For classifications where the Minimum Qualifications (MQs) are based on meeting education requirements only: If education is required to meet the MQs please attach a copy of all of your transcripts that show the completion of the required education. Applicants who completed their education outside the United States (with foreign degrees/transcripts) must obtain and submit verification of United States course/degree equivalency by the time of appointment. Foreign education credential evaluation services can be found at https://www.naces.org .

Application Instructions
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: Until Filled
Who May Apply
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, 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. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

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:

CA Department of Tax and Fee Administration
Attn: Certification Section - JC-427408
Human Resources Bureau
450 N Street, MIC: 00
Sacramento , CA 95814

Address for Drop-Off Application Packages

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

CA Department of Tax and Fee Administration
Certification Section - JC-427408
Human Resources Bureau
450 N Street, MIC: 00
Sacramento , CA 95814
Monday - Friday (Excluding Holidays)
08:00 AM - 04: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 completed Statement of Qualifications (SOQ) must be submitted with your STD. 678 in order to be considered for this position. Please see the Statement of Qualifications section of this job posting for additional information.
  

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:

• Database design and modeling.

• Business Intelligence (BI) solutions development in collaboration with business customers and other technical domain experts using Microsoft or other reporting and analysis software.

• Microsoft SQL Server database administration.

• Microsoft SQL Server databases, capacity planning, performance tuning, backup/restore, troubleshooting, and maintaining high availability in complex environments and mission critical applications.

• Creating scripts using VB Script, Batch Language, and Microsoft PowerShell.

• Building/deploying/maintaining and supporting SSIS packages and SSRS reports.

• Building/deploying SQL jobs, including database maintenance packages.

• Microsoft SQL Server DBA hands-on skills in supporting a production databases in all operations, such as troubleshooting daily operational issues.

• Complex data analysis and integration using Microsoft SSIS.

• Writing SQL with complex joins, stored procedures, and database functions.

• Data extraction from SQL.

• Planning, designing and implementing data models, DataMart, and data warehouses.

• ETL tools and processes.

• Working experience in integrating and extracting relevant information from large amounts of structured and unstructured data (internal and external) to enable analytical solutions.

Benefits
CDTFA appreciates and proudly celebrates diversity with an emphasis of an inclusive atmosphere in all levels of the organization. CDTFA is a participant in The Government Alliance on Race and Equity (GARE) Capitol Cohort to advance racial equality and advance opportunities for all in California. Employees of different races, ethnicities, genders, ages, religions, disabilities, gender orientations and personal experiences are welcomed to contribute to the success of CDTFA.

The CDTFA was presented with the Large State Employer of the Year Award for 2018 from The Association of California State Employees with Disabilities (ACSED); showcasing CDTFA's support of employment, promotion, and fair treatment of persons with disabilities.

CDTFA values its staff and is dedicated to employee career development. Our agency supports the development of staff by offering training to flourish in their position and programs to promote and explore upward mobility.

Working for the State offers great opportunities, generous benefits, and career development. In addition, you can look forward to:

• Nearby (third-party) parking.
• Convenient to public transportation.
• Located near downtown, multiple eateries, freeway access.

For more information about the outstanding benefits offered to State Employees https://www.calhr.ca.gov/employees/Pages/salary-and-benefits.aspx

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

Contact Information
The Hiring Unit Contact is available to answer questions regarding the position or application process.
Department Website: http://www.cdtfa.ca.gov
Hiring Unit Contact:
Fiona Renton
(916) 309-1496

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:
EEO Contact
(916) 309-8400
EqualEmployment.Opportunity@cdtfa.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

Applicants must include a Statement of Qualifications (SOQ) for this recruitment. The SOQ is a narrative discussion prepared by the applicant describing how the applicant's skills, knowledge, abilities, education, training, and experience, qualify them for the position. The SOQ serves as documentation of each candidate's ability to present information clearly and concisely in writing. The CDTFA will not consider applicants who fail to provide an SOQ with their application. Resumes do not take the place of the SOQ.

Additionally, your SOQ must include:

• Name on SOQ.
• Job Control number on SOQ.
• SOQ must be no more than two pages in length, double-spaced.

A Statement of Qualifications (SOQ) is REQUIRED. The SOQ will be considered the first phase of the hiring process for this position. If your qualifications are competitive, you will be invited to an interview.

The SOQ should be typed and not more than two pages in length, 12 point font, double-spaced, with margins not less than one inch, including your first and last name and the JC at the top of the page.

Describe your background, experience, and training as a SQL Server database administrator. Please provide details of how long you have worked as a lead DB and how you ensure that database are secure.

Describe in detail your experience, knowledge, education, and skills that qualify you for this position.

Additional Instructions for Applicants

Using the online application system as specified in the announcement is the preferred method of applying for civil service job opportunities; however, applicants may instead apply by way of U.S. mail, parcel delivery or courier service, or in person, as set forth in this announcement.

Paper applications must include a signature. Dates printed on envelopes by mobile barcodes or equivalent mobile print technology are not acceptable proof of the date the application and any other required documents or materials were filed.

A completed state application (STD. 678) and any documents list under "Required Application Documents" must be submitted with your application package. Applicants who are relying on additional documentation (e.g. transcripts, copy of degrees, certifications, licenses, etc.) in order to prove that they meet the minimum qualifications listed in the Classification Specification (located on the right under "Additional Documentation) must submit those documents with their application package. Failure to submit these documents may result in your application being disqualified. Applications must include a description of the duties performed for each position held; reference to a resume in place of a description of the duties performed will not be accepted.

Applicants must state their basis of eligibility (List Eligibility, Lateral Transfer, Reinstatement, T&D, or Surplus/SROA), and the Job Control (JC) number and/or position number in the "Examination(s) or Job Title(s), For Which You Are Applying" section on the STD. 678. Surplus/SROA candidates should submit a copy of their letter with their application . Please remove any confidential information (i.e. social security number, date of birth, etc.) as well as any information regarding your LEAP eligibility and/or exam scores from your documents prior to submission.

Here is the link to the Information Technology Specialist I examination bulletin.

If applying electronically, please note that CalCareers no longer allows applicants to withdraw their applications. If you need assistance to withdraw your application, please contact the Certification Section at certific@cdtfa.ca.gov

For all other questions regarding your CalCareer account, please contact CalHR's CalCareers Unit at (866) 844-8671 or CalCareer@calhr.ca.gov .

For more information on the recruitment process please email Recruitment@cdtfa.ca.gov

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.