DATA BASE CONSULTANT - 42001753

Florida; Tallahassee (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

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.

Qualifications

• Requires 9 years in computer systems analysis or programming with 3 years in database design, or equivalent substitutions.
• Educational note: foreign degrees require credential evaluation.
• Occasional travel and on-call duties may be required.

Responsibilities

• Lead design, development, operation, and security of FDACS databases.
• Lead administration and support of MS SQL Server and Oracle environments.
• Collaborate with development teams to ensure data model adherence to standards.
• Deploy changes to production databases following best practices.

Skills

Microsoft SQL Server administration

Oracle database administration

PL/SQL

T-SQL

Database security

Windows/Unix scripting

Performance tuning

Problem solving

Education

Bachelor's degree in Computer Science, MIS, or related field

Master's degree in MIS or Computer Science

Tools

SSIS

SQL Server Management Studio (SSMS)

Oracle SQL Developer

Job description

Select how often (in days) to receive an alert:

The State Personnel System is an E-Verify employer. For more information click on our E-Verify Website .

Requisition No:885654

Agency: Agriculture and Consumer Services

Working Title: DATA BASE CONSULTANT - 42001753

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)

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

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

• 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, 32316 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32399 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32317

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.