Database Architect & Performance Lead

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

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