Information Technology Database Administrator I/II

County of Shasta; Redding (CA); On-site; USD 79,000 - 100,000; Full time

Job summary

Shasta County's IT Department seeks skilled Information Technology Database Administrators to manage SQL Server databases, provide expert support, and ensure data integrity. The role emphasizes performance, security, and collaboration with developers in a dynamic government environment.

Ideal candidates bring strong DBA experience, backup/recovery expertise, and the ability to communicate clearly. A valid CA driver's license may be required for some assignments.

Qualifications

• Three years of database administrator experience for I.
• bachelor’s degree equivalent for II with three years of database experience.
• SQL Server certification is preferred.

Responsibilities

• Provide administration and support for SQL Server databases.
• Develop backup, recovery, and business continuity procedures.
• Monitor performance and optimize database operations.
• Collaborate with development teams on DB design and integration.

Skills

SQL Server DBA

Database performance

Backup and recovery

Security and integrity

Data modeling

ETL design

Troubleshooting

Communication skills

Education

Bachelor's degree in CS or related field

Tools

Transact-SQL

SSIS/SSRS

SQL Server Management Studio

Visual Studio

Job description

THE CURRENT VACANCY IS IN THE SHASTA COUNTY

DEPARTMENT OF INFORMATION TECHNOLOGY

ORAL EXAM ISTENTATIVELY SCHEDULED FOR NOVEMBER 2026

SEE SPECIAL REQUIREMENTS SECTION REGARDING

POSSESSION OF A VALID DRIVER’S LICENSE

RESPONSES TO SUPPLEMENTAL QUESTIONS REQUIRED

FINAL FILING DATE: OCTOBER 26, 2026, AT 5:00 PM

SALARY INFORMATION

Information Technology Database Administrator I:$6,273 - $8,007 APPROXIMATE MONTHLY* / $36.19 - $46.19 APPROXIMATE HOURLY*

Information Technology Database Administrator II:$7,052 - $9,001 APPROXIMATE MONTHLY* / $40.68 - $51.93 APPROXIMATE HOURLY*

This position is in the UPEC – General bargaining unit. Please refer to the applicable bargaining unit labor agreement (Memorandum of Understanding) for potential future salary increases: Shasta County Labor Agreements

The salary range consists of six (6) salary steps, with approximately 5% between each step. Newly hired employees are appointed at Step A of the assigned salary range. Employees are eligible for a merit-based salary increase from Step A to Step B after six months of satisfactory service. Thereafter, employees may be eligible for annual merit-based step increases, beginning one year from the Step B effective date, until they reach the top step of the salary range.

ABOUT SHASTA COUNTY

Shasta County offers all the amenities of the big city while retaining a comfortable small-town atmosphere. With its natural beauty, affordable housing, excellent educational system, abundance of recreational opportunities, and excellent quality of life, Shasta County is a great place to live, work, and raise a family.

ABOUT THE DEPARTMENT

The Information Technology Department delivers secure, innovative, and reliable technology solutions that power government operations. Our team manages IT infrastructure, cybersecurity, software development, GIS, telecommunications, desktop services, and digital transformation initiatives to enhance efficiency and service delivery. We ensure the seamless operation of critical systems, provide responsive technical support, and implement forward-thinking solutions that drive government excellence. Join a dynamic team dedicated to leveraging technology to empower county departments and enhance services for our community.

ABOUT THE POSITION

Information Technology Database Administrator I:Under supervision, to provide administration, technical support for, and management of SQL Server databases and related systems at Shasta County; to provide excellent customer service; and to perform related work as required.

Information Technology Database Administrator II:Under general direction, provide administration, planning, technical support for, and management of SQL Server databases and related systems at Shasta County; to provide excellent customer service; and to perform related work as required.

DISTINGUISHING CHARACTERISTICS

Information Technology Database Administrator I:This is the entry-level class for SQL Server database administration classification. Incumbents are expected to develop a variety of database skills and abilities and are gradually given more responsible assignments required for promotion to the next higher class of IT Database Administrator II. The IT Database Administrator I is capable of learning the skills necessary to be proficient in all aspects of SQL Server database management and administration and will have strong interpersonal and communication skills; is capable of explaining procedures in writing or verbally; and possesses good phone skills.

Information Technology Database Administrator II:The IT Database Administrator II is expected to work under general direction to carry out complex assignments and projects and to perform technical support for SQL Server database instances and related databases. The IT Database Administrator II performs independently and is proficient in all aspects of SQL Server database management and administration. The IT Database Administrator II will have strong interpersonal and communication skills, is capable of explaining procedures in writing or verbally, and possesses good phone skills.

IDEAL CANDIDATE

The ideal candidate will have a proven track record demonstrating the following:

• Knowledge and experience of database administration and software installation using Microsoft SQL Server
• Creating, monitoring, and supporting SQL Server databases; performance optimization; resizing and restructuring; index maintenance; backup, restoration, and recovery
• Supporting and enhancing SQL Server processes
• Establishing procedures for database operation, control, and recovery
• Developing, implementing, administering, and maintaining policies and procedures ensuring the security and integrity of databases
• Configuration and maintenance of databases; disaster recovery design
• Data modeling, schema design, ETL architecture, development, documentation, optimization, and collaboration with different teams

Characteristics of the ideal candidate:

• Good interpersonal skills; excellent oral and written communication skills
• Willingness to learn and work with a highly technical, dedicated team
• Able to troubleshoot database performance and respond to system problems

Duties may include, but are not limited to, the following:

Information Technology Database Administrator I:

This position requires the ability to: learn and perform a variety of tasks related to SQL Server database administration; research and respond to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participate in the evaluation of available database hardware and software and facilitates adoption discussions; provide input on hardware, software, and other costs; participate in DBMS upgrades; develop, implement and maintains database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepare and implement business continuity and disaster recovery planning as it relates to SQL Server databases; develop, acquire, install, and maintain database performance measuring and reporting systems; analyze performance data to determine need for modification or addition to system configuration to meet current and future needs; confer and consult with management and other technical staff and vendors as required; create and maintain database documentation; participate in database security and security strategies; consider security at each phase of planning and design; participate in capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represent database support at meetings; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assist with interface implementation to other systems; confer with IT management to ensure that proposed solutions are appropriate; perform other related projects and tasks as required/assigned.

Examples of specific duties: primary support of databases for specified vendor applications; to include administration, implementation, maintenance and ongoing support of production SQL Server database environments; work with leads in other functional areas to troubleshoot system problems when SQL Server databases are involved; install, patch, upgrade and test custom and vendor SQL Server software and databases; ad-hoc reporting and incident tracking; develop and debug SQL queries, stored procedures, and triggers; work with vendors and or developers to tune existing queries and configuration to improve performance or resolve performance issues; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; review proposed changes to databases to advise on performance impacts; provide support and suggestions for improving departmental processes; assist in the research and evaluation of support tools and methodologies.

Information Technology Database Administrator II:

This position requires the ability to: perform a variety of complex tasks related to SQL Server database administration; research and respond to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participate in the evaluation of available database hardware and software and facilitates adoption discussions; provide input on hardware, software, training and other costs; participate in DBMS upgrades; provide project and or team leadership for SQL Server implementations; develop, implement and maintain database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepare and implement business continuity and disaster recovery planning as it relates to SQL Server databases; develop, acquire, install and maintain database performance measuring and reporting systems; analyze performance data to determine need for modification or addition to system configuration to meet current and future needs; confer and consult with management and other technical staff and vendors as required; create and maintain database documentation; understand and implement database security and security strategies; consider security at each phase of planning and design; conduct capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represent database support at meetings; provide technical database training as required; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assist with interface implementation to other systems; confer with IT Supervisor (in charge of databases) to ensure that proposed solutions are appropriate; perform other related projects and tasks as required/assigned.

Examples of specific duties: Primary support of databases for specified vendor applications; to include administration, implementation, maintenance and ongoing support of production SQL Server database environments; work with leads in other functional areas to troubleshoot system problems when SQL Server databases are involved; install, patch, upgrade and test custom and vendor SQL Server software and databases; ad-hoc reporting and incident tracking; develop and debug SQL queries, stored procedures, and triggers; work with vendors and or developers to tune existing queries and configuration to improve performance or resolve performance issues; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; review proposed changes to databases to advise on performance impacts; advise developers in database design and lead in the area of development and design standards; develop and ensure standardization of SQL coding practices and adherence to coding standards, change control, and SQL best practices; coach and mentor development team members on best practices for database technologies; provide support and suggestions for improving departmental processes; assist in the research and evaluation of support tools and methodologies; secondary support for custom databases.

Any combination of education and experience sufficient to directly demonstrate possession and application of the following:

Information Technology Database Administrator I:

Knowledge of: Relational databases, database design, and normalization; relational DBMS architecture; Microsoft SQL Server product family; security, system and object level privileges, roles and an understanding of how OS security options relate to the database environment; windows operating systems and networking; SQL Server administration and configuration; database performance management and monitoring tools and methods; SQL Profiler, Execution Plans; Transact-SQL; Data Transformation Services (DTS) and SQL Server Integration Services (SSIS); reporting tools; SQL Server Reporting Services (SSRS), Crystal Reports.

Ability to: Perform database problem resolution and cause analysis as well as recommend and implement preventative techniques; design, develop and maintain database and data transformation packages; create and update technical documentation; understand, translate and coordinate requirements into efficient usage of software and hardware products; demonstrate good time management skills by organizing work and desk space, managing priorities, meeting critical deadlines, and follow-up on assignments with a minimal of direction; adhere to and suggest improvements for standards in place at Shasta County for Database Management Systems; plan and implement changes to database systems; learn how to independently problem-solve; assess causes of database failures and initiate corrective action; establish and maintain effective working relationships with department staff, other County departments, other agencies, and the public; communicate clearly and concisely, both orally and in writing; handle multiple tasks with shifting priorities.

Information Technology Database Administrator II:

Knowledge of: Relational databases, database design, and normalization; relational DBMS architecture; Microsoft SQL Server product family; security, system and object level privileges, roles and an understanding of how operating system security options relate to the database environment; Windows operating systems and networking; SQL Server administration and configuration; database performance management and monitoring tools and methods; SQL Profiler, Execution Plans; Transact SQL; Visual Studio, Object Oriented Programming and XML; Data Transformation Services (DTS) and SQL Server Integration Services (SSIS); replication and mirroring; reporting tools; SQL Server Reporting Services (SSRS), Crystal Reports.

Ability to: Perform database problem resolution and cause analysis as well as recommend and implement preventative techniques; design, develop and maintain database and data transformation packages; create and update technical documentation; understand, translate and coordinate requirements into efficient usage of software and hardware products; demonstrate good time management skills by organizing work and desk space, managing priorities, meeting critical deadlines, and follow-up on assignments with a minimal of direction; adhere to and suggest improvements for standards in place at Shasta County for Database Management Systems; plan and implement changes to database systems; independently problem-solve; assess causes of database failures and initiate corrective action; establish and maintain effective working relationships with department staff, other County departments, other agencies, and the public; communicate clearly and concisely, both orally and in writing; handle multiple tasks with shifting priorities.

MINIMUM QUALIFICATIONS

It is the responsibility of applicants to identify in their application materials how they meet the minimum qualifications listed below.

Information Technology Database Administrator I:

Three (3) years of database administrator experience.

Successful completion of each thirty (30) semester units in an accredited college or university with an emphasis in programming, database, or related course work may be substituted for each one (1) year of total experience.

Information Technology Database Administrator II:

The equivalent of a bachelor’s degree from an accredited college or university in computer science or a related field of study, AND three (3) years of database experience.

One (1) year of database application development desired.

Any combination of relevant education and work experience may be substituted for the required education on a year-for-year basis.

SQL Server certification is preferred.

SPECIAL REQUIREMENTS

Information Technology Database Administrator I/II:

Possession of a valid California driver’s license. Depending upon assignment, an incumbent may need to regularly have access to and utilize a suitable personal vehicle in the course of business (mileage is reimbursed at the IRS rate). Proof of adequate insurance for the vehicle may be required.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle or feel objects, tools, or controls; and talk or hear. The employee occasionally is required to stand; walk; reach with hands and arms; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and /or move up to 25 pounds. Specific vision abilities required by this job include close vision and color vision.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee occasionally works in outside weather conditions. The noise level in the work environment is usually moderate.

OTHER CONSIDERATIONS

• All new employees are required to have their paycheck directly deposited to a bank account.
• Some positions may require a valid California driver's license and acceptable driving record according to County policy.
• Reasonable accommodations may be made for those persons who are disabled under the Americans with Disabilities Act to perform the essential functions of the position.
• As part of the selection process, all individuals provided with a preliminary offer of employment with Shasta County will be subject to a background investigation, including a criminal history check (primarily completed through the taking of fingerprints). An image of your fingerprints will be captured and sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history, (if any), will evaluated along with the other information received in connection with your application. Except as otherwise required by law, a criminal conviction will not necessarily disqualify you from the position. The nature of the offense, the date of the offense, the surrounding circumstances, and the relevance of the offense to the position applied for may, however, be considered.
• Based on the results of the background investigation and criminal history check, applicants may then be provided with an offer of employment conditioned on the results of a medical examination, which includes drug/alcohol testing.
• Shasta County participates in E-Verify. For more information visit DOJ Right to Work Poster. If you do not have internet access, contact Personnel at [phone] to request a flyer.
• In accordance with Government Code Section 3100, County employees, in the event of a disaster are considered disaster workers and may be asked to respond accordingly.
• Positions in this classification are covered by a collective bargaining agreement between the County and the United Public Employees of California – UPEC General.
• Employees in this classification are covered under the CalPERS retirement program. Depending on the provisions of the California Public Employees’ Pension Reform Act (PEPRA) and other applicable laws, an employee in this classification will be covered under one of the following CalPERS retirement formulas: (1) 2% at 55, (2) 2% at 60, or (3) 2% at 62. An employee in this classification will also contribute up to 9.5% of their pay to this plan or will contribute such other amount to the plan as authorized by PEPRA and other applicable laws. Please visit our employees benefit page at Shasta County Employee Benefits for additional information regarding benefits and CalPERS coverage information. The provisions in this flyer and on the County website are for information purposes only. To the extent the provisions of the flyer or the County website are inconsistent with PEPRA and other applicable laws, PEPRA and other applicable laws shall govern.

SHASTA COUNTY IS AN EQUAL OPPORTUNITY EMPLOYER

Shasta County Personnel

1450 Court Street, Suite 348; Redding, CA 96001; [phone]