What are the responsibilities and job description for the Database Administrator position at County of Madera?
SUPERVISION RECEIVED AND EXERCISED
Receives direction from an Information Technology Manager. Exercises no direct supervision over staff.
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.
- Database management systems and concepts, including data normalization, table relationships, and SQL querying.
- Database administration tasks, such as backup and recovery, performance tuning, and security management.
- Database design patterns, entity-relationship diagrams, and normalization techniques.
- Data modeling tools and methodologies, including conceptual, logical, and physical data modeling.
- Database security practices, including authentication, authorization, encryption, and compliance with data protection regulations.
- Applicable federal, state, and local laws, codes, and ordinances relevant to the area(s) of responsibility.
- Techniques for providing a high level of customer service by effectively dealing with the public, vendors, contractors, and County staff.
- The structure and content of the English language, including the meaning and spelling of words, rules of composition, and grammar.
- Modern equipment and communication tools used for business functions and program, project, and task coordination, including computers and software programs relevant to work performed.
- Optimize SQL queries for performance, employing techniques such as indexing, query rewriting, and execution plan analysis.
- Diagnose and resolve complex database-related issues efficiently.
- Stay updated on emerging database technologies, trends, and best practices to enhance database management skills.
- Understand, interpret, and apply all pertinent laws, codes, regulations, policies and procedures, and standards relevant to the work performed.
- Effectively use computer systems, software applications relevant to work performed, and modern business equipment to perform a variety of work tasks.
- Communicate clearly and concisely, both orally and in writing, using appropriate English grammar and syntax.
- Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.
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:
- Possession of, or ability to obtain by the time of appointment, an appropriate California driver’s license.
- Possession of, or ability to obtain, nationally recognized industry specific technical certification(s) pertinent to the assigned areas of responsibility, as determined by the Chief Information Officer.
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.
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 MONDAY, MARCH 3, 2025.
To move forward in the application process, you must complete an online application through our website https://www.governmentjobs.com/careers/maderacountyca. 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.
Salary : $88,277 - $108,570
