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, Information Systems, 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:
1. 10+ years of experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity
2. Experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure.
3. Experience with database installation, configuration, patching, upgrades, security administration, monitoring, performance tuning, capacity planning, backup, recovery, and high availability.
4. Strong experience with T-SQL, schema and physical database design, indexing, stored procedures, views, functions, execution plans, and query optimization.
5. Experience designing and supporting data transformation and integration processes, including ETL/ELT, data mapping, validation, scheduling, and error handling.
6. Experience supporting or troubleshooting Windows Services and scheduled processes that interact with Microsoft SQL Server, Azure SQL, Power BI, or enterprise applications.
Preferred Experience:
1. Experience with Azure services that support database, integration, monitoring, security, storage, automation, or data processing workloads.
2. Experience eliciting, analyzing, documenting, and validating business and technical requirements with stakeholders.
3. Experience supporting regulated or government environments and implementing role-based access, auditing, encryption, least privilege, and data protection practices.
4. 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
