JOB RESPONSIBILITIES

Requires:
strong technical skills in database management.

Ability to: work independently as well as be a strong team member; handle multiple projects and tasks simultaneously; understand and carry out complex oral and written instructions; handle a high level of computational efficiency and systems knowledge; design and analyze data information.

Database Administration
• Maintains responsibility for planning, design, installation, tuning, maintenance, troubleshooting, and repair of county-owned databases and related support tools.
• Regularly performs capacity planning and optimization of database instances to ensure efficient use of resources.
• Routinely performs upgrades and applies patches to stay current with the latest releases to reduce vulnerabilities and avoid databases becoming obsolete.
• Implements security measures and database hardening to safeguard sensitive information and prevent data loss.
• Deploys and regularly reviews monitoring and logging of database performance and transactions for suspicious activities.
• Analyzes and resolves database issues using technical tools and following best practices.
• Plans, monitors, tests, and documents the results of database backup and recovery processes on a regular basis.
• Follows the internal Change Control processes when implementing database changes.
• Develops and maintains formal documented processes and procedures for ongoing management and maintenance of the database environment. Technical Consulting
• Works closely with project teams, software developers, technical support groups, external vendors, and the client to ensure a smooth implementation and operations of database services.
• Develops and maintains a technical roadmap to ensure the currency of the database environment.
• Supports the transition to cloud computing databases and Software as a Service technology.
• Assists application developers with scripting, data analysis, and report development as needed. Technical Support
• Serves as an expert within a technical area and educates others on technical issues.
• Administers tools related to business intelligence and reporting services.
• Provides technical support after-hours on an as-needed basis. Other Job Duties
• Participates in meetings, in-service training, workshops, etc. for the purpose of gathering information required to perform job functions.
• Performs other duties as assigned.

REQUIRED EXPERIENCE

Three (3) years of database analysis and design experience; AND Three (3) years of database administration experience, which may be concurrent with #2; OR Any satisfactory equivalent combination of education, training, and/or experience relevant to the position.

REQUIRED EDUCATION

Associate degree in Science, Technology, Engineering or Math (STEM) related field of study from an accredited institution; AND 2. Three (3) years of database analysis and design experience; AND 3. Three (3) years of database administration experience, which may be concurrent with #2; OR 4. Any satisfactory equivalent combination of education, training and/or experience relevant to the position.