Sr. Database Administrator (DBA) — Tallahassee, FL
Зарплата не указана
ОткликнутьсяThis is an onsite work position based in Tallahassee,FL. Apply only if you are willing to relocate.
Education: Bachelor’s or master’s degree in Computer Science, xXeqeTaKHAK 9SWsTwK, or related field; or equivalent work experience
Certifications: Current Microsoft certifications relevant to Azure Database Administrator, Azure Data Engineer, Azure Solutions Architect, or related database technologies
Required Experience
• 10+ years of experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity
• 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.
• 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.
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.
• Experience with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or other database automation and release-management practices.
Responsibilities
• 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