DATA BASE ANALYST - 42003984

Requisition No: 843648 

Agency: Agriculture and Consumer Services

Working Title: DATA BASE ANALYST - 42003984

 Pay Plan: Career Service

Position Number: 42003984 

Salary:  $44,060.11 - $60,000.20 

Posting Closing Date: 12/30/2024 

Total Compensation Estimator Tool

DATA BASE ANALYST

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 with a major in one of the computer sciences or management information systems and three (3) years of experience in computer systems analysis and/or computer programming, one year of which must have been in data base design; or

A bachelor’s degree from an accredited college or university and four (4) years of experience in computer systems analysis and/or computer programming, one year of which must have been in data base design; or

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

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

Five years of experience in computer systems analysis and/or computer programming, one year 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. 

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.

Requires possession of a valid Class E driver license.

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:

Occasional travel required and on-call.

NOTES:

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

JOB DUTIES:

The Data Base Analyst assists the Senior Data Base Analyst in designing, developing, implementing, and maintaining Microsoft SQL Server and Oracle Database instances. The Data Base Analyst assists in performing database query analysis, performance monitoring, and optimization. They also develop and maintain stored procedures/functions/triggers and maintain the database access layer.  In addition, the Data Base Analyst assists with database backups, replication, reporting, and data confidentiality, integrity, and availability.

Assists with the administration, maintenance, and support of the Microsoft SQL Server or Oracle database environment.

• Perform backup and recovery procedures, restorations, and recoveries as required.
• Assists 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.
• Assists with the deployment of approved changes to production databases following industry best practices, agency policies, and procedures.
• Develop T-SQL or PL/SQL Stored Procedures, Functions, Packages, and Triggers as needed to augment security and performance requirements of applications and processes.
• Assist in bulk data loads, data cleansing, and data migration by writing and utilizing custom scripts and processes. 
• Participate in project meetings, as necessary, to understand application and database requirements.

Perform database software installation, testing, maintenance and performance monitoring.

• Run diagnostic tools to identify database performance bottlenecks and take appropriate corrective actions to improve database performance. Work with development teams to tune performance.
• 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.
• 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.

Collaborate with operational and project teams to deliver database services and support.

• Provide support for 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.
• Troubleshoot problems relating to both hardware and software to determine malfunction causes and to initiate and/or recommend corrective actions. 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 industry trends in database hardware and software to provide supervisory personnel with up-to-date information.
• Assess future information requirements to develop comprehensive database plans.
• Evaluate and make recommendations regarding proposed vendor hardware acquisitions requiring a database, and an online management software interface.

Performs related work as required including, but not limited to, adherence to the policies and procedures of the department’s Information Resource Security Program and allocates time as requested for Disaster Recovery activities.

KNOWLEDGE, SKILLS, AND ABILITIES:

• Experience with database administration and development
• Experience with Microsoft or Oracle database administration, development, or backup and recovery
• Knowledge of the principles, practices, and techniques of SQL software administration, installation, and upgrade
• Knowledge of Windows or Unix scripting.
• Knowledge of database server and storage management.
• Ability to write PL/SQL or 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 professionally.

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.