DATA BASE CONSULTANT - 42001753 1

Florida; Tallahassee (FL); On-site; USD 80,000 - 120,000; Full time

Job summary

FLORIDA DEPARTMENT OF AGRICULTURE AND CONSUMER SERVICES, OFFICE OF AGRICULTURE TECHNOLOGY SERVICES, is seeking a Data Base Consultant to work on the design, deployment, and maintenance of production databases. The role includes implementing stored procedures, monitoring performance, and coordinating data migrations.

The position requires extensive experience in database design and administration, with emphasis on SQL Server and Oracle environments, plus strong scripting and problem-solving

Qualifications

• A high school diploma or its equivalent and nine (9) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design.
• A high school diploma or its equivalent and 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.
• A high school diploma or its equivalent and seven (7) years of experience in computer systems and analysis and/or computer programming, three (3) 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.
• A bachelor's degree (4 years) from an accredited college or university and five (5) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design.
• A master's degree (6 years) 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 (3) years of which must have been in data base design.
• A doctorate (8 years) 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.

Responsibilities

• 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.
• Participate in project meetings, as necessary, to understand application and database requirements.
• 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.
• 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.

Education

Bachelor's degree

Master's degree

Doctorate

Tools

Microsoft SQL Server

Oracle 12c

Backup and recovery

Windows scripting

Unix scripting

Database triggers

Job description

Data Base Consultant

FLORIDA DEPARTMENT OF AGRICULTURE AND CONSUMER SERVICES

OFFICE OF AGRICULTURE TECHNOLOGY SERVICES

Contact: Ashtin Brownell 850-617-7699

MINIMUM REQUIREMENTS: A high school diploma or its equivalent and nine (9) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design; or A high school diploma or its equivalent and 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; or A high school diploma or its equivalent and seven (7) years of experience in computer systems and analysis and/or computer programming, three (3) 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; or A bachelor's degree (4 years) from an accredited college or university and five (5) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design; or A master's degree (6 years) 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 (3) years of which must have been in data base design; or A doctorate (8 years) 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.

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)

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. 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: To maintain fairness and integrity, applicants are required to provide honest and authentic responses during all stages of the evaluation and selection process. Applicants must rely on their own personal knowledge, thoughts, and impressions. A candidate’s use of Artificial Intelligence (AI) tools to answer qualifying questions or participate in interviews will be taken into consideration when determining qualification for the position. Successful applicant must pass a background screening, including fingerprinting, as a condition of employment.

JOB DUTIES

• 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.
• 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.
• 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

• Skills in Microsoft SQL Server 2016 or higher database administration.
• Skills in Oracle 12c or higher database administration.
• Skills in 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 ;)

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.”

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.

Location

TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32317 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32399 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32305

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.