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.

Examples of Duties

This is an emergency essential classification. Upon declaration of a disaster and/or emergency, all employees in this classification are required to work.

Exudes a positive customer service focus.

Advocates building organizational culture through aligning decisions with the County’s core values. 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.

Performs Extract, Transform, Load (ETL) operations to migrate data between systems.

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 the duties listed, as well as those assigned, with professionalism and a sense of urgency. 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

Bachelor’s degree in computer science, computer information systems or a directly related field and two years of progressively responsible database experience; or any equivalent combination of directly related education, training and/or experience. Applicants within six months of meeting the minimum education/experience requirement may be considered for trainee status. Successful completion of all applicable background checks pre-hire and ongoing are required., 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.

An organization is only as good as the people it employs. To attract and retain the best team possible, the Alachua County Board of County Commissioners offers a competitive benefit program. We believe that if we expect our employees to support the County, we must first support the health and financial well-being of our employees and their families, now and as they plan for their future. BoCC-Contributed Benefits

• Medical/Health Insurance
• Employee Life Insurance
• Florida Retirement System
• Employee Assistance Program

Optional Benefits

• Dental Insurance
• Vision Insurance
• Supplemental & Dependent Life Insurance
• Deferred Retirement Program
• Flexible Spending Accounts
• Roth IRA
• Tuition Assistance Program

NOTE: For detailed information regarding available benefits click here.

You may also view Frequently Asked Questions (FAQs) regarding benefits.

• FLORIDA RETIREMENT SYSTEM (FRS) The Florida Retirement System is a retirement plan designed to provide an income to a vested employee and his/her family when the employee retires, becomes partially or totally disabled, or dies prior to retirement. A defined benefit or defined contribution option may be chosen by the employee.
• TUITION ASSISTANCE PROGRAM Permanent, full-time employees are eligible for educational assistance funds. Contact the Human Resources Office for program details.
• HOLIDAYS Holidays are as follows:

1. New Years Day
2. Martin Luther King Day
3. Memorial Day
4. Juneteenth
5. Independence Day
6. Labor Day
7. Veterans’ Day
8. Thanksgiving Day
9. Friday following Thanksgiving
10. Christmas Eve (IAFF*)
11. Christmas Day
12. Additional Christmas Holiday (All non-IAFF employees)
13. 2 Floating Holidays (All non- IAFF employees)

*IAFF - International Association of Firefighters Pay periods are every two weeks, Monday through Sunday. Payday is Friday. International Association of Firefighters follow the General Contract 7k regarding holidays.

Vacation Leave - Generous vacation accrual rates with payout of unused accrued leave, with some restrictions. For more detailed information regarding vacation leave refer to Employee Policy Manual, Section 7-2.