Database Administrator (C. Advanced)

Lancesoft; Tallahassee (FL); Vor Ort; USD 115.000 - 155.000; Vollzeit

Zusammenfassung

Florida Department of Agriculture and Consumer Services (FDACS) seeks a Senior Database Administrator to manage and optimize enterprise SQL Server and Azure SQL environments, including design, security, and data integration. The role emphasizes collaboration with OATS and other FDACS staff to support mission-critical data platforms.

The candidate will perform installation, monitoring, performance tuning, backup/recovery, and high availability strategies, while translating business requirements

Qualifikationen

• 5+ years of experience administering enterprise Microsoft SQL Server environments (production and non-production).
• Hands-on Azure SQL Database, Azure SQL Managed Instance, or SQL Server in Azure.
• Experience with installation, configuration, patching, upgrades, security, monitoring, and high availability.

Aufgaben

• Manage, monitor, and support enterprise SQL Server and Azure SQL databases in production and non-production environments.
• Install, configure, patch, upgrade, and administer database platforms, storage, access, and security.
• Perform performance monitoring and tuning: query analysis, indexing, and execution plans.

Kenntnisse

T-SQL

Query optimization

Performance tuning

Security administration

Stakeholder elicitation

Regulated environment experience

Data transformation

Windows Services knowledge

Ausbildung

Bachelor’s or Master’s degree in Computer Science/Information Systems

Equivalent work experience

Microsoft certifications: Azure Data Engineer / Azure Solutions Architect

Tools

Microsoft SQL Server

Azure SQL Database

Azure SQL Managed Instance

Azure DevOps

PowerShell

Jobbeschreibung

Job Description

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

Qualification Requirements For Contractor’s Candidate

Minimum Qualifications

• 5+ years of recent experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity.
• Hands-on experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure.
• Demonstrated experience with database installation, configuration, patching, upgrades, security administration, monitoring, performance tuning, capacity planning, backup, recovery, and high availability.
• Strong experience with T-SQL, schema and physical database design, indexing, stored procedures, views, functions, execution plans, and query optimization.
• Experience designing and supporting data transformation and integration processes, including ETL/ELT, data mapping, validation, scheduling, and error handling.
• Experience supporting or troubleshooting Windows Services and scheduled processes that interact with Microsoft SQL Server, Azure SQL, Power BI, or enterprise applications.
• Experience eliciting, analyzing, documenting, and validating business and technical requirements with stakeholders.
• Experience supporting regulated or government environments and implementing role-based access, auditing, encryption, least privilege, and data protection practices.
• Familiarity with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or other database automation and release-management practices.
• Current Microsoft certifications relevant to Azure database administration, Azure data services, or SQL Server are preferred.
• Educational qualifications meeting at least one of the following levels: Bachelor’s or master’s degree in Computer Science, Information Systems, or related field;or equivalent work experience.
• Bachelor’s or master’s degree in Computer Science, Information Systems, or a related field;or equivalent work experience.
• Current Microsoft certifications relevant to Azure Data Engineer, Azure Solutions Architect, or related database technologies are preferred.

Preferred Experience

• Experience with Azure services that support database, integration, monitoring, security, storage, automation, or data processing workloads.
• Experience eliciting, analyzing, documenting, and validating business and technical requirements with stakeholders.
• Experience supporting regulated or government environments and implementing role-based access, auditing, encryption, least privilege, and data protection practices.
• Familiarity with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or other database automation and release-management practices.
• Current Microsoft certifications relevant to Azure database administration, Azure data services, or SQL Server are preferred.
• Current Microsoft certifications relevant to Azure Database Administrator, Azure Data Engineer, Azure Solutions Architect, or related database technologies are preferred.