OBJECTIVE
The Florida Department of Agriculture and Consumer Services (FDACS or Department) seeks quotes from qualified vendors to provide a full-time Senior Database Administrator. The selected candidate will work with the Office of Agriculture Technology Services (OATS) and other FDACS staff to support and maintain the Department’s enterprise Microsoft SQL Server and Azure SQL environments. The candidate will provide database administration, data design, data transformation, Windows Services support, Azure integration, business requirements elicitation, troubleshooting, performance optimization, security administration, backup and recovery, documentation, and knowledge transfer for production and non-production systems.
BACKGROUND
FDACS requires senior-level database administration services to operate and enhance mission-critical enterprise data platforms. The environment includes Microsoft SQL Server and Azure SQL databases, related Azure services, Windows Services, data interfaces, data transformation processes, and applications that rely on secure, reliable, and high-performing database services. The selected candidate must demonstrate success supporting complex production and non-production database environments and translating business needs into maintainable technical solutions.
SCOPE
The Contractor will provide an experienced Senior Database Administrator to:
• Manage, monitor, maintain, and support enterprise Microsoft SQL Server and Azure SQL databases in production and non-production environments.
• Install, configure, patch, upgrade, and administer database platforms, instances, databases, storage, access, and security in accordance with Department standards.
• Perform performance monitoring and tuning, including query analysis, indexing, execution plan review, capacity planning, and resource allocation.
• Design, implement, test, maintain, backup, restore, high-availability, disaster recovery, and database integrity processes.
• Develop and maintain logical and physical data designs, database schemas, data dictionaries, stored procedures, views, functions, and related database objects.
• Design, develop, support, and troubleshoot data transformation and integration processes using SQL Server, Azure services, ETL/ELT tools, APIs, files, and other approved technologies.
• Support and troubleshoot Windows Services and scheduled processes that interact with databases, integrations, and enterprise applications.
• Collaborate with business and technical stakeholders to elicit, analyze, document, validate, and translate business requirements into database and data solutions.
• Ensure database availability, performance, security, integrity, accessibility, and compliance with Department policies
and applicable regulatory standards.
• The Contractor, through its selected candidate, must perform all tasks and complete the deliverables identified in this Statement of Work (SOW).
CONTRACTOR RESPONSIBILITIES
The Senior Database Administrator will be responsible for the following tasks:
• Administer, maintain, monitor, and support enterprise Microsoft SQL Server and Azure SQL databases across development, test, staging, and production environments.
• Configure and maintain instances, databases, storage, access controls, service accounts, encryption, auditing, database mail, jobs, alerts, and monitoring.
• Plan, implement, test, and document backup, restore, high availability, disaster recovery, database integrity, and continuity procedures.
• Monitor and tune database performance through query analysis, execution plans, indexing, statistics, configuration, capacity planning, and resource optimization.
• Design and maintain logical and physical data models, schemas, data dictionaries, tables, views, stored procedures, functions, and related database objects.
• Design, build, maintain, and troubleshoot data transformation and integration processes, including ETL/ELT workflows, data mapping, validation, scheduling, and error handling.
• Support and troubleshoot Windows Services, scheduled tasks, and application components that depend on database connectivity, data processing, or integration services.
• Support approved Azure services and hybrid connectivity used by Azure SQL, SQL Server, data integration, monitoring, security, storage, and automation solutions.
• Elicit, analyze, document, validate, and translate business requirements into secure, supportable database and data solutions.
• Perform incident response, root-cause analysis, remediation, change implementation, and knowledge transfer for database-related issues.
• Create and maintain technical documentation, operational procedures, architecture diagrams, runbooks, and Standard Operating Procedures (SOPs).
• Attend project and operational meetings, provide regular status updates, and submit weekly project reports and time sheets.
• Coach, mentor, training, and provide knowledge transfer to OATS staff and project teams. Note: Contractor personnel with access to the Department’s network are required to complete the Department’s security awareness training.
This training must be completed within seven (7) calendar days of the Contractor personnel’s start date. SECURITY REQUIREMENTS
The contractor and contractor’s personnel must comply with the following security and non-disclosure requirements:
1. Must undergo a level 2 background check paid for by the Department.
2. Must sign and comply with confidentiality and data use agreements.
3. Must successfully pass the Department’s ethics and security awareness online training.
4. Must obtain CJIS Certification.
