Database Analyst

This is responsible advanced technical work in the management of database services in Alachua County Information & Telecommunication Services Department.
 
An employee assigned to this classification develops, designs, modifies, monitors and maintains database servers and infrastructure.
 
Work is performed under the general direction of a higher level  supervisor and  is reviewed through conferences, reports and  observation of results obtained.

Installs, maintains and configures databases and application data across different database servers.
 
Monitors and reports database functions and overall system health.
 
Develops database applications, stored procedures and SQL statements for various applications.
 
Participates and assists with upgrades and patch management for servers on which the databases are installed and maintained.

 

Maintains and configures overall database security for databases and applications.
 
Works with vendors to install, configure and maintain third party databases and applications.
 
Evaluates existing databases and  makes recommendations for improving operational efficiency for improved productivity.

 

Creates and maintains customized database reports, performs data analysis and works with customers to evaluate database needs.
 
Performs related work as required.
 
NOTE: These  examples are intended only  as illustrations of the various kinds  of work performed in positions allocated to this class. The omission of specific statements of duties does  not exclude them from the position if the work is similar, related or a logical assignment to the position.

 
KNOWLEDGE, SKILLS AND ABILITIES
 
Thorough knowledge of Database structures, theories, principles and practices.
 
Thorough knowledge of principles, practices and  techniques of database systems management.
 
Considerable knowledge of information research techniques and  available resources.
 
Considerable knowledge of Structured Query Language (SQL).
 
Ability to plan, schedule and  coordinate work on a variety of projects.
 
Ability to initiate and  implement administrative procedures.
 
Ability to conduct meetings with users and  determine their information technology needs.
 
Ability to develop and  carry out objectives.
 
Ability to communicate effectively, both verbally and  in writing.
 
Ability to establish and  maintain effective working relationships with fellow employees, constitutional officers and  the general public.
 
PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
 
While performing the duties of this job, the employee is frequently required to talk or hear. The employee is occasionally required to stand; walk; sit; reach with hands and arms; and  use hands  to finger, handle or feel.
 
The employee must occasionally lift and/or move  up to 50 pounds. Specific  vision abilities required by this job include close vision and  the ability to adjust focus.
 
WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while  performing the essential functions of this job. Reasonable accommodations may  be made  to enable  individuals with disabilities to perform the essential functions.
 
While  performing the duties of this job, the employee occasionally works near moving mechanical parts, and  is occasionally exposed to risk of electrical shock.
 
The noise  level  in the work environment is usually moderate.