15002 – Senior Database Administrator – SQL Server/Azure (onsite, remote option) – Tallahassee, FL
Start Date : ASAP
Type: Temporary Project
Estimated Duration :12 months with possible extensions
Work Setting: Candidates located within the Tallahassee area are preferred; however, telework may be authorized for highly qualified candidates at the discretion of the Department.
Required:
- Experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity. (5+ years)
- Experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure.
- Experience with database installation, configuration, patching, upgrades, security administration, monitoring, performance tuning, capacity planning, backup, recovery, and high availability.
- 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.
Preferred:
- 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.
- Experience 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, Azure Solutions Architect, or related database technologies or SQL Server.
Responsibilities include but are not limited to the following:
- 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.