Data Operations Engineer
Core
Administer and maintain on-premises and cloud SQL Server and Databricks environments, ensuring high availability, performance, and security for enterprise data services.
Role type
Senior Data Operations Engineer
Builds
Reliable, secure, and scalable enterprise data services
Domain
Legal services / Cloud Data Infrastructure
Deliverable
infrastructure
Required skills
Azure SQL administration, Microsoft SQL Server administration, Azure Databricks administration, T-SQL programming, query optimization, backup and recovery strategies, high availability configuration, disaster recovery planning, performance monitoring, PowerShell scripting, Azure CLI, Python scripting, CI/CD pipeline management, incident response, root cause analysis, security compliance
Preferred skills
None stated
Technologies
Azure SQL, Microsoft SQL Server, Azure Databricks, Azure Monitor, Log Analytics, PowerShell, Azure CLI, Python, Azure DevOps, GitHub, T-SQL
Responsibilities
Administer and maintain on-premises Microsoft SQL Server environments, Azure SQL Database, Azure SQL Managed Instance, and Azure Databricks workspaces. Monitor database health, performance, storage, capacity, cloud resource utilization, and Databricks job scheduling. Install, configure, patch, upgrade, and migrate databases. Configure and maintain high availability and disaster recovery solutions, including Always On Availability Groups, failover clustering, backups, and recovery procedures. Analyze and resolve database performance bottlenecks; optimize queries, indexes, execution plans, and configurations. Automate operational, maintenance, monitoring, and reporting tasks using PowerShell, T-SQL, Azure CLI, or Python. Support CI/CD pipelines for database deployments using Azure DevOps or GitHub Actions. Respond to production incidents, troubleshoot issues, and conduct root cause analysis. Apply database security best practices; manage user access, encryption, auditing, and compliance controls.
Seniority
Senior, hands-on IC