Database Administrator - Open Until Filled

About the position

County of Madera is establishing a list of qualified applicants for this position. Applications will be accepted continuously until otherwise noted and the list will be used to fill current vacancies in this classification. 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.

Responsibilities

• 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.

Requirements

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

Nice-to-haves

• 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.