Database Administrator (Information Technology Specialist I)

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 As a key member of the Database Admin Services Section, the Database Administrator serves as a technical expert in the System Engineering domain and performs a wide range of complex database administration, systems engineering, and software support functions. Responsibilities include the installation, configuration, maintenance, testing, monitoring, troubleshooting, and performance tuning of Database Management Systems (DBMS), related software, utilities, and supporting infrastructure. Provides expert-level support for development, testing, and production database environments and ensures the reliability, availability, integrity, security, and performance of enterprise database systems. Duties include implementing database software upgrades, releases, patches, and maintenance activities; diagnosing and resolving complex system, application, and performance issues; and developing and maintaining backup and recovery solutions to protect business data from hardware, software, or operational failures. The Database Administrator serves as a consultant and technical primary point of contact throughout all phases of the system development life cycle, collaborating with customers, project teams, application developers, business units, and technical staff to implement new database solutions and enhance existing systems. May serve as a project lead or backup team lead, assisting with planning, prioritizing, assigning, and monitoring workload, maintaining performance metrics, and providing management with input regarding team productivity and project status. Performs advanced database performance analysis and tuning activities, develops recommendations, and implements improvements that optimize DBMS performance and system efficiency. Responsibilities include ensuring database integrity and security, promoting and implementing DBMS best practices and standards, and providing technical guidance to support organizational goals and operational requirements. Serves as the lead technical resource for complex production incidents and database-related problems by coordinating with affected stakeholders, implementing corrective actions, validating solutions, and ensuring effective communication with customers, management, and impacted teams. Responsibilities also include documenting lessons learned, contributing to incident reviews, maintaining technical documentation, and providing status updates to management and operational support teams. The Database Administrator applies advanced knowledge of data architecture, data modeling, database design principles, and related tools to support enterprise data management initiatives. Influences, motivates, and leads individuals and groups in resolving complex technical challenges, demonstrates strong presentation and communication skills, and effectively communicates technical concepts to audiences of varying technical backgrounds. The Database Administrator is expected to remain current with evolving technologies, industry trends, and best practices through continuous learning and professional development. Responsibilities include mentoring and training staff on database monitoring, troubleshooting, performance tuning, and operational support procedures to strengthen team capabilities and technical expertise. All duties are performed in support of the department's mission, values, and service objectives, with a strong focus on customer service, collaboration, innovation, and operational excellence. Please see duty statement for more details. Additional positions may become available (eRPA 2627-00160). 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. 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 administering and supporting Microsoft SQL Server databases in enterprise production environments, including installation, configuration, maintenance, monitoring, and upgrades • Experience managing SQL Server databases hosted in Windows-based environments, including integration with supporting infrastructure and operating system services • Experience performing database performance analysis, optimization, troubleshooting, and tuning to ensure database availability, reliability, and scalability • Experience implementing and maintaining SQL Server high availability and disaster recovery solutions, including clustering, replication, backups, restores, and recovery planning • Experience developing scripts and automation solutions using tools and languages such as PowerShell, Python, Transact-SQL (T-SQL), or similar technologies • Knowledge of database migration strategies, database lifecycle management, and the deployment of database changes across development, test, and production environments • Experience administering database systems in Linux, Unix, or mixed-platform environments and supporting enterprise database infrastructure • Experience working with cloud platforms and database services, including Microsoft Azure and other cloud technologies that support enterprise database workloads • Knowledge of IT service management principles, change management processes, incident management practices, and software development life cycle (SDLC) methodologies • Demonstrated ability to communicate effectively with technical and non-technical stakeholders, prepare clear technical documentation, provide presentations, and deliver excellent customer service