Database Administrator - EXTENDED

Salary : $88,277.40 - $108,570.06 Annually

Location : Madera County, CA

Job Type : Full-Time

Department : Information Technology

Division : Information Technology

Opening Date : 01 / 30 / 2025

Closing Date : 2 / 28 / 2025 11 : 59 PM Pacific

FLSA : Non-Exempt

Bargaining Unit : PROFS

Under direction, designs, implements, and administers database solutions to store and secure the County's data; optimizes database performance; ensures data integrity; and supports data-related projects.

SUPERVISION RECEIVED AND EXERCISED

Receives direction from an Information Technology Manager. Exercises no direct supervision over staff.

Examples of Duties

The job functions listed below are not inclusive or exclusive and are intended only as illustrations or examples of the various types of work that may be performed in various divisions / departments. Types of work performed shall be within the scope and licensure (if required) for the classification. Reasonable accommodation will be made when requested and determined by the County to be appropriate under applicable law.

• Collaborates with stakeholders to design and create efficient and scalable database structures that meet business requirements.
• Implements and configures databases, ensuring proper installation, security settings, and data storage allocation.
• Monitors and maintains data integrity by performing routine data quality checks, identifying inconsistencies, and implementing corrective measures.
• Monitors database performance, identifies bottlenecks, and optimizes queries, indexes, and database configurations to enhance overall system efficiency.
• Plans and executes database backup and recovery strategies to ensure data availability and disaster recovery readiness.
• Implements and maintains database security measures, including access controls, user roles, and encryption, to protect sensitive data.
• Coordinates and performs data migration and data transformation activities as needed, ensuring smooth transitions between database systems.
• Develops and optimizes SQL queries for data retrieval and reporting purposes, ensuring accurate and timely data delivery to stakeholders.
• Diagnoses and resolves database-related issues, collaborates with IT teams to troubleshoot application-database interactions, and provides technical support.
• Creates and maintains comprehensive database documentation, including data dictionaries, schema diagrams, and standard operating procedures.
• Estimates future database storage needs, monitors resource utilization, and recommends adjustments to accommodate growing data requirements.
• Performs other related duties as assigned.

Employment Standards / Minimum Qualifications

Knowledge of :

Ability to :

Education and Experience :

Any combination of training and experience that would provide the required knowledge, skills, and abilities is qualifying. A typical way to obtain the required qualifications would be :

Equivalent to a bachelor's degree in computer science, information systems, or a related field and two (2) years of increasingly responsible experience in performing professional analytical work in database analysis and querying.

Licenses and Certifications :

PHYSICAL DEMANDS

Must possess mobility to work in a standard office setting and use standard office equipment, including a computer; vision to read printed materials and a computer screen; and hearing and speech to communicate in person and over the telephone. Standing in and walking between work areas is frequently required. Finger dexterity is needed to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard office equipment. Positions in this classification frequently bend, stoop, kneel, and reach to perform assigned duties, as well as push and pull drawers open and closed to retrieve and file information. Employees must possess the ability to lift, carry, push, and pull materials and objects up to 15 pounds.

ENVIRONMENTAL CONDITIONS

Employees work in an office environment with moderate noise levels, controlled temperature conditions, and no direct exposure to hazardous physical substances. Employees may interact with upset staff and / or public and private representatives in interpreting and enforcing departmental policies and procedures. May require working overtime, on-call, and weekends, as well as, occasional shift work.

Application Process

The application review process will include screening to ensure applications are complete and meet all minimum qualifications. In addition to the application, the applicant is required to complete the Supplemental Questions to further evaluate their education, training and experience relative to the required knowledge and abilities for the position. Applicants must submit answers that are as complete as possible.

Only qualified applicants, who pass the minimum qualifications review, will be invited to the examination process which may be administered by a written examination, oral interview, or any combination of qualifications appraisal determined by the Department of Human Resources to be appropriate. The Department of Human Resources will make reasonable accommodation in the examination process for disabled applicants. If you have an accommodation request, please indicate such on your application.

Depending upon the number of applicants meeting the minimum qualifications, applicants may be scheduled for the assessment listed below. Passing score is 70% out of 100%.

THE APPRAISAL PANEL (100%) ARE TENTATIVELY SCHEDULED FOR TUESDAY, MARCH 8, 2025.

To move forward in the application process, you must complete an online application through our website Please attach to your application a copy of your unofficial transcripts (indicating when degree was awarded) or your application may be considered incomplete. Resumes may be uploaded but cannot be used in place of a completed application.

Those applicants claiming veteran's preference must submit a copy of their DD-214 form along with the application. Candidates who attain ranking on an eligible list and are involuntarily called to active duty may be considered for eligibility reinstatement upon their return.

Placement on Eligible List :

The Civil Service Commission may limit the number of qualified applicants eligible to participate in the examination process. If two or more candidates have the same total final score on an examination, they shall be ranked in order of their scores in that portion of the examination which has the greatest weight. The names of two or more eligibles having final ratings which are identical shall be grouped on the eligible list as tie names with equal rank for certification and appointment purposes. Candidates who are successful in all phases of the examination process will be placed on an eligible list, in rank order based on a calculation of their total score from the examination process. The eligible list established by this recruitment will be active for a minimum of six (6) months or one (1) year, unless otherwise determined by the Director pursuant to section 6-4 (b) and may be extended for up to an additional year by the Commission.

Benefits of employment with the County of Madera include :

Please indicate below which level of education best describes your college level coursework in computer science, information systems, or a closely related field

Please indicate below how many years of increasingly responsible experience do you possess in in performing professional analytical work in database analysis and querying.

I understand that I must indicate the specific time period and distinct job title in the applications work experience section. I understand that I am required to

Required Question

Salary : $88,277 - $108,570