S.E. IV - Database Administrator

About the position

Yavapai County is seeking a skilled Database Administrator to join our Information Technology Services team. This position provides technical and analytical support for specific application systems and databases involving the design, development, construction, implementation and ongoing support of systems, processes, and methods. Responsible for performing all database administrator duties, which include general database administration, design, backup and recovery, data security, data access, performance tuning, technical consulting, troubleshooting, development of standards, production support, capacity planning and evaluation of database technology. The Database Administrator is also responsible for organizing data, providing access to data, designing, and reviewing applications that use data, creating and implementing data-naming standards, and providing training in data modeling and design.

Responsibilities

• Defines a strategy for backup and recovery of each database and ensures availability of databases and disaster recovery plans to prevent data loss.
• Monitors and optimizes database performance, ensures data integrity, and maintains database security; implement security measures, manage user permissions, and protect sensitive data from breaches coordinated with the Cybersecurity team.
• Provides senior-level technical database leadership when working with teams; diagnose and resolve database issues, providing support to developers and other stakeholders.
• Creates and implements data element standards and provides for the physical dissemination of the data.
• Performs database administration, including, but not limited to, software installation, optimization, security, patch installation, upgrades, capacity planning, and connectivity with minimal downtime.
• Designs, creates, and maintains database objects to ensure database accuracy, consistency, and compliance with industry regulations.
• Use scripts and automation tools to streamline database management tasks.
• Assists in the configuration and support of cloud-based and in-house environments.
• Analyzes new and existing information systems and provides technology evaluations and recommendations.
• Writes and maintains database documentation; maintain detailed documentation of database structures, policies, and procedures.
• Leads technical project teams in using data modeling concepts for application designs.
• Coordinates with other information technology groups to facilitate development projects, software upgrades and new product implementations.

Requirements

• Bachelor's degree in information systems or closely related field.
• A minimum of seven (7) years of experience in information technology or related field. An equivalent combination of directly related work experience and education may substitute for the degree requirement on a year-per-year basis.
• Must possess a valid Arizona driver's license.

Nice-to-haves

• Knowledge of Geographic Information Systems (GIS) databases.