Archived listing. The details below describe a past opening.
Job Description and Duties The salary ranges listed in this Job Control may not reflect reductions in pay in accordance with the 2025 Personal Leave Program. Please follow the link for more information regarding the 2025 Personal Leave program. http://hrmanual.calhr.ca.gov/Home/ManualItem/1/2113 The DB2 and Oracle Team manages FTB’s enterprise-scale databases - busy, mission-critical systems that keep the Franchise Tax Board’s departments running smoothly. We focus on stability, performance, and thoughtful modernization, from monitoring and tuning to major platform migrations. We’re looking for someone who enjoys solving technical problems, learning through documentation and safe testing, and working with tools like SQL, Linux, and vendor guides to understand new environments without risking production. If you’ve worked with DB2 or other relational databases, can troubleshoot issues using logs and metrics, and communicate clearly with teammates, you’ll feel right at home here. An interest in automation or building repeatable workflows is also helpful, as our team increasingly looks for ways to streamline deployment and maintenance processes. We appreciate people who document their work, escalate appropriately, and help foster an inclusive team culture. It’s a great role for someone early in their DBA path who wants hands-on experience with large systems - and a team that values learning, collaboration, and doing things the right way. Additional positions may become available (eRPA 2627-00089). Please complete this optional survey letting us know how you heard about this position by clicking here. You will find additional information about the job in the Duty Statement. Working Conditions
- Interviews will be conducted in person
- This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for a visa sponsorship, now or in the future.
- This position requires 4 or more days in the office per week. It is designated office-centered and may be eligible for some remote work based on departmental guidelines and operational need. This is subject to change. About the Technology Services Division (TSD) The mission of TSD is to securely deliver and support information technology solutions and services essential to the success of the FTB’s mission. By acting on our TSD mission, we will realize our vision of a collaborative and diverse team of IT experts who further innovation and empower our business partners to accomplish their goals. Read more about FTB. Learn more about other FTB technical roles at this FTB microsite. Need help understanding the hiring process or have questions about FTB? We'd love to talk to you! Before applying, read through these step by step instructions to apply, or contact us at IT.Recruit@ftb.ca.gov. Please include the job control (JC) number and the position title in the subject line. Minimum Requirements You will find the Minimum Requirements in the Class Specification.
- INFORMATION TECHNOLOGY SPECIALIST I Additional Documents
- Job Application Package Checklist
- Duty Statement Department Information Our mission is to help taxpayers file timely and accurate tax returns and pay the correct amount to fund services important to Californians. FTB fosters an environment of equity and inclusion for all, and we welcome everyone to be part of our diverse workforce.
Department Website:
http://www.ftb.ca.gov Special Requirements • The position(s) require(s) a Background Investigation be cleared prior to being hired. This business uses E-Verify in its hiring practices to achieve a lawful workforce. E-Verify is a web-based system that allows enrolled employers to confirm the eligibility of their employees to work in the United States. For more information about E-Verify, please go to www.dhs.gov/e-verify. CALIFORNIA CODE OF REGULATIONS, TITLE 2, SECTION 172: All candidates for, appointees to, and employees in the state civil service shall possess the general qualifications of integrity, honesty, sobriety, dependability, industry, thoroughness, accuracy, good judgment, initiative, resourcefulness, courtesy, ability to work cooperatively with others, willingness and ability to assume the responsibilities and to conform to the conditions of work characteristic of the employment, and a state of health, consistent with the ability to perform the assigned duties of the class. Where the position requires the driving of an automobile, the employee must have a valid state driver's license, a good driving record and is expected to drive the car safely. The foregoing general qualifications shall be deemed to be a part of the personal characteristics of the minimum qualifications of each class specification and need not be specifically set forth therein. **IMPORTANT NOTICE** As required by the department's rules of conduct, all employees of the Franchise Tax Board (FTB) must be in compliance with the California Revenue and Taxation Code. During the background investigation portion of the hiring process, FTB will review return information to verify California state income tax compliance. Any failure to comply with the California Revenue and Taxation Code may prevent you from being hired at FTB. You must verify your filing status by calling 1-800-852-5711 to resolve any potential tax compliance issues, prior to submitting your application and seeking employment with FTB. All applicants not currently employed with the Franchise Tax Board will be subject to a pre-employment background investigation. The investigation will consist of completion of a pre-employment questionnaire, fingerprinting, and an inquiry to the Department of Justice to disclose criminal records. We comply with the Americans with Disabilities Act. Persons with hearing or speech impairments, call TTY/TDD (800) 735-2929. 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: All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to clearly demonstrate how you meet the Minimum Qualifications and Alternate Range Placement for the position on your State Application (STD Form 678). The application should also clearly demonstrate the candidate’s ability to meet the Desirable Qualifications identified in this job advertisement. The Classification Specification is located on this Job Announcement Posting under "Minimum Requirements. We encourage applications regardless of whether you think you meet 100% of these skills below. Please highlight your knowledge, skills, and experience related to the below desirable qualifications in your application package.
- Experience working with major RDBMS platforms, including DB2, SQL Server, or Oracle
- Ability to analyze database logs, alerts, and performance metrics to troubleshoot issues
- Experience performing basic DBA tasks such as creating schemas, users, roles, and privileges
- Ability to troubleshoot access issues using logs, privilege checks, and approved procedures
- Familiarity with SQL and Linux/Unix environments for analysis and operational support
- Experience using vendor documentation and runbooks to learn environments safely and avoid production risk
- Familiarity with scripting languages such as Bash, KSH, or Perl
- Experience reviewing health dashboards, error codes, and stability indicators
- Ability to escalate issues with clear notes, logs, and context when reaching authority limits
- Experience collaborating with technical teams to resolve issues and support shared systems
- Ability to provide and receive constructive feedback to strengthen team effectiveness
- Ability to communicate clearly across tools such as MS Teams and Outlook
- Commitment to safe, disciplined operational practices in an enterprise database environment
- Experience using database monitoring or administrative tools to review database health, logs, or performance metrics
- Experience working within a change management process to apply database updates, configuration changes, or script deployments
- Experience working with IBM DB2 in an administrative, diagnostic, or configuration capacity
- Experience using automation or configuration management tools such as Ansible and scheduling tools such as cron to support database operations
- Experience working in Red Hat Enterprise Linux (RHEL) environments for system or database administration tasks
- Experience with database replication or data movement technologies such as Confluent/Kafka, Change Data Capture (CDC), or IBM Q Replication
- Experience performing SQL or database performance tuning using explain plans, access path analysis, or other optimization techniques
- Experience managing database security, including database users, roles, permissions, or authentication configurations in any major RDBMS
- Experience collaborating with team members and stakeholders as part of assigned work tasks, including sharing information or supporting technical activities
Benefits
Benefit information can be found on the CalHR website and the CalPERS website.
In addition, Franchise Tax Board offers the following:
- Convenient transportation and commuting options include: Light Rail stop, bicycle lockers, free parking, and carpool/vanpool opportunities Additional Application Instructions A complete application package must be received in the Classification & Hiring Unit or postmarked by the final filing date and must include:
- Completed employment information on the STD. 678, including the “From” and “To” dates, “Hours Per Week,” and “Duties Performed" fields for all jobs listed in the “Employment History” fields (resumes do not take the place of these fields on the STD. 678)
- All of the required documents listed in the “Required Application Package Documents” section
- The position number and job control number in the job title line of the STD. 678, if submitting a paper application package (these numbers will auto-populate in the job title line of the STD. 678 if submitting an electronic application through your CalCareer Account)
- A signature, if submitting a paper application package Candidates who do not follow all of the listed application instructions may be eliminated from the selection process. All submitted information will be screened and the most qualified candidates will be invited to an interview. Electronic applications submitted through your CalCareer Account are highly recommended. If you are unable to apply electronically through your CalCareer account, please mail a completed and signed STD. 678 and application package to the mailing address provided above in the “Application Instructions” section. Do not include full Social Security Number, method of eligibility, and LEAP information in your application package. Examination Information To apply for the Information Technology Specialist I position(s) as a list candidate, you must first take the online Information Technology Specialist I exam.