DATA BASE CONSULTANT - 42001753 1 1

Requisition No: 847350 

Agency: Agriculture and Consumer Services

Working Title: DATA BASE CONSULTANT - 42001753 1 1

 Pay Plan: Career Service

Position Number: 42001753 

Salary:  $52,859.88 - $85,000.24 

Posting Closing Date: 02/27/2025 

Total Compensation Estimator Tool

DATA BASE CONSULTANT

FLORIDA DEPARTMENT OF AGRICULTURE AND CONSUMER SERVICES

OFFICE OF AGRICULTURE TECHNOLOGY SERVICES

***OPEN COMPETITIVE OPPORTUNITY.***

CONTACT:

Shelley Harden, (850) 245-1096

MINIMUM REQUIREMENTS: 

A bachelor's degree from an accredited college or university and five (5) years of experience in computer systems analysis and/or computer programming, three years of which must have been in data base design; or

A master's degree from an accredited college or university in management information systems or in one of the computer sciences and four (4) years of experience in computer systems analysis and/or computer programming, three years of which must have been in data base design; or

A doctorate from an accredited college or university in management information systems or in one of the computer sciences and three (3) years of experience in data base design; or

Seven (7) years of experience in computer systems and analysis and/or computer programming, three years of which must have been in data base design and either (1) completion of a 720-classroom hour program of study from a vocational/technical school or accredited community college in an area of data processing (excluding data entry), or (2) 60 semester or 90 quarter hours of college course work from an accredited institution which includes four courses in computer science or management information systems.  

Experience in computer systems analysis and/or computer programming can substitute on a year-for-year basis for the required college education. 

Completion of a one-year program of study from a vocational/technical school in an area of data processing (excluding data entry) can substitute for one year of computer systems analysis and/or computer programming experience.

EDUCATIONAL NOTE: Graduates utilizing education attained in the United States to meet the minimum requirements of a position will not be appointed until verification of the applicable degree has been obtained. Foreign trained graduates utilizing a degree attained outside of the United States to meet the minimum requirements of a position must be prepared to provide a copy of a credential evaluation conducted by an Approved Credential Evaluation Agency.  A list of approved agencies can be viewed at “Approved Credential Evaluation Agencies, Florida Department of Education.” Approved Credential Evaluation Agencies (fldoe.org) 

***ATTENTION CANDIDATES***

To be considered for a position with the Florida Department of Agriculture and Consumer Services:

• All fields in the Candidate Profile must be completed (an attached resume is not a substitution for the information required on the candidate profile).
• Work history, duties and responsibilities, hours worked, supervisor, and formal education fields, etc. must be filled out to determine qualifications for this position.
• Responses to Qualifying Questions must be verifiable in the Candidate Profile.

The Florida Department of Agriculture and Consumer Services values
and supports employment of individuals with disabilities. Qualified
individuals with disabilities are encouraged to apply.

ADDITIONAL REQUIREMENTS:

Perform on-call duties when assigned.

The position may be activated to support the Emergency Support Function (ESF) and respond to emergencies, including natural disasters or other types of incidents, as needed. 

NOTES:

Successful applicant must pass a background screening, including fingerprinting, as a condition of employment.

JOB DUTIES:

The Data Base Consultant leads the design, development, operation,  maintenance, security, and integrity of the FDACS data base environments. This position serves as a team lead and is responsible for professional and high-level technical oversight and management for planning, designing, modeling, monitoring, testing, operating, maintaining, and securing Microsoft SQL Server and Oracle database management systems. 

Lead the administration, maintenance, and support of the FDACS Microsoft SQL Server and Oracle database environments. This includes assisting users in the analysis, review, coordination, and implementation of new requests.

• Work with the application development teams to ensure that the associated logical data model design adheres to agency standards and is based upon best practices and guidelines.
• Coordinate and deploy all changes to production databases following industry best practices, agency policies, and procedures.  This includes PL/SQL and T-SQL object and data model changes.
• Write T-SQL and/or PL/SQL Stored Procedures, Functions, Packages, and Database Triggers as needed to augment security and performance requirements of application development.
• Assist in bulk data loads, data cleansing, and data migration by writing and utilizing custom scripts and processes.  This includes migrations to and from multiple data sources and types.
• Participate in project meetings, as necessary, to understand application and database requirements.

Ensure that the testing and installation of all database hardware and software products are coordinated to ensure their compatibility with all existing products.  Monitor and troubleshoot problems with the Oracle and/or SQL databases.

• Run diagnostic tools to identify database performance bottlenecks and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
• Work with the infrastructure team to ensure that the associated hardware resources are allocated to the databases and to ensure high availability and optimum performance.
• Design, implement, and maintain database maintenance scripts, including replication and monitoring.
• Day-to-day database-related operational duties, including monitoring, statistical analysis, and troubleshooting.
• Participate in 24/7 on-call support for database environments when required.
• Design and maintain automated processes including SSIS, SQL Agent, DBA jobs, DBA scheduler.
• Conduct capacity planning and configuration management studies to forecast future software and hardware requirements.  Develop and maintain technical standards, procedures, and techniques for the guidance of Data Center personnel.

Consult management, application developers, and database administrators on all aspects of the database management system development and maintenance including storage and backups.

• Provide support on all the stages of database implementation and/or database-related deployments.
• Implement and enforce database security based on best practices, Federal and State regulations, and agency policies.
• Conduct performance measurement studies and recommend system reconfiguration to affect improved performance. 
• Function as a technical specialist in troubleshooting problems relating to both hardware and software to determine malfunction causes and to initiate and/or recommend corrective actions.  Responsible for working with vendor technical personnel in notifying vendors and/or correcting vendor-supplied software.
• Review systems, operational procedures, and standards within the Data Center and recommend means to improve efficiency and quality of services to users. 
• Research and review computer technical development in hardware and software to provide supervisory personnel with up-to-date information in this field.
• Assess future information requirements to develop long-range, comprehensive database plans.
• Evaluate and make recommendations regarding proposed vendor hardware acquisitions requiring a database, and an online management software interface.

Perform related work as required, which will include, but not be limited to, adherence to the policies and procedures of the Department’s information resource security program (chapter 8 – Department’s Supervisory Manual) and allocate time as requested for disaster recovery activities.

KNOWLEDGE, SKILLS, AND ABILITIES:

• Experience in Microsoft SQL Server 2016 or higher database administration.
• Experience in Oracle 12c or higher database administration.
• Experience with Microsoft and/or Oracle database backup and recovery.
• Knowledge of the principles, practices, and techniques of database software administration, installation, and upgrade
• Knowledge of database structures and theories.
• Knowledge of Windows or Unix scripting.
• Knowledge of database server and storage management.
• Ability to write PL/SQL, T-SQL, stored procedures, functions, packages, and database triggers.
• Operational support skills, including experience with system installations, migrations, and upgrades.
• Ability to process information logically and solve problems.
• Ability to monitor and resolve problems with database system components.
• Ability to effectively communicate technical data processing information verbally and in writing.
• Ability to work well in a team environment, and to establish and maintain effective working relationships with others.
• Ability to receive and give constructive criticism and maintain effective working relationships with others.
• Strong interpersonal skills to resolve problems in a professional manner.

The Benefits of Working for the State of Florida

Working for the State of Florida is more than a paycheck.  The State’s total compensation package for employees features a highly competitive set of employee benefits including:

• Annual and Sick Leave benefits;
• Nine paid holidays and one Personal holiday each year;
• State Group Insurance coverage options, including health, life, dental, vision and other supplemental insurance options;
• Retirement plan options, including employer contributions (For more information, please visit www.myfrs.com;)
• Flexible Spending Accounts;
• Tuition waivers;
• And more!

For a complete list of benefits, visit www.mybenefits.myflorida.com.

For an estimate of the total compensation package for this position, please visit the “Total Compensation Estimator Tool” located above under the “Posting Closing Date.”

SPECIAL NOTES:

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

VETERANS’ PREFERENCE.  Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans’ Preference will receive preference in employment for Career Service vacancies and are encouraged to apply.  Certain service members may be eligible to receive waivers for postsecondary educational requirements.  Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code.  Veterans’ Preference documentation requirements are available by clicking here.  All documentation is due by the close of the vacancy announcement.