Senior DataOps Engineer

What is EverOps?Some of the world’s most advanced and innovative global enterprise software and tech companies have trouble finding engineering partners that have the ability to perform highly complex deliveries and services that match their rigorous standards. These teams need a partner that can co-own problems from within their own development environment. Enter EverOps – the premier Embedded Service Provider. We partner directly with our customer engineering and operations teams to help them assess and address a variety of delivery and service related issues in the DevOps and DataOps space.The ChallengeEverOps is looking for a Senior DataOps Engineer who combines deep database administration expertise with cloud data platform and pipeline engineering skills. This role sits on a platform team and requires someone who can own the full data operations stack, from SQL Managed Instance performance troubleshooting and Azure Data Factory pipeline monitoring to Azure infrastructure diagnostics, with minimal direction. You will be a critical operational resource and must be comfortable making independent decisions, including during off-hours coverage.Automation-First MindsetA core expectation of this role is a relentless focus on identifying manual processes within the data stack and replacing them with reliable, repeatable automation. Whether it’s a DBA task that requires someone to log in and click buttons, a pipeline restart that gets triggered by a Teams message, or a database refresh that runs off a shared checklist. This engineer sees those as backlogs, not workflows. You will be expected to actively inventory manual toil, prioritize it, and ship automation that eliminates it. This is not a secondary responsibility, it is a core deliverable of the role.The MissionAs a Senior DataOps Engineer at EverOps you will join our U.S.-Based Virtual Operating Center (your home office), working with a team of dynamic engineers embedded on a platform team managing a production Azure data environments. You will not be siloed, the work spans the full data and application platform stack. Our existing team is eager to empower and mentor each new hire to ensure success.On-Call & Off-Hours ExpectationsThis role participates in a rotating on-call schedule that includes off-hours coverage. Operational incidents, pipeline failures, and database issues do not follow business hours, and this team provides extended coverage to ensure continuity for our customers. You will be expected to:Participate in a scheduled off-hours on-call rotation shared across the teamRespond to and resolve incidents, failed pipeline runs, and database alerts outside of standard business hours when on-callPerform planned off-hours maintenance tasks such as database refreshes, certificate renewals, and deployment slot swaps that require low-traffic maintenance windowsProduce clear written shift handoff notes and daily operational reports so the next engineer on rotation has full situational awarenessWhat You’ll DoOwn day-to-day operations of Azure SQL Managed Instance environments including performance monitoring, troubleshooting blocking and long-running queries, index and statistics maintenance, and SQL Agent job managementMonitor, triage, and restart Azure Data Factory pipeline runs; understand ETL dependencies and troubleshoot integration failures between ADF, SQL MI, and Azure StorageManage SSIS package execution and re-runs, including HR/personnel integration processes and common failure pattern diagnosisSupport Azure infrastructure operations including App Services, App Service Environments, deployment slots, WebJobs, Storage Accounts, and certificate lifecycle managementValidate and test database backups, restores, and job chains to ensure recoverabilityContinuously inventory manual operational tasks across the data stack and prioritize them for automationDesign and implement automation solutions using PowerShell, Python, Azure Automation, Logic Apps, or Azure Functions to eliminate repetitive manual workBuild self-healing pipeline patterns in ADF and Azure DevOps – automatic retry logic, alerting, and recovery runbooksBuild and maintain CI/CD pipelines in Azure DevOps for data platform and infrastructure deploymentsParticipate in regular customer and internal EverOps scrumsDiagnose and differentiate between application-layer, data platform, and infrastructure-layer issuesProduce high-quality daily operational reports and documentationParticipate in the off-hours on-call rotation and perform planned off-hours maintenance as requiredRequired Skill SetThis role requires both breadth and depth across Azure and SQL. The work spans application operations, data platform engineering, ETL pipelines, and Azure infrastructure.Automation & Toil EliminationDemonstrated track record of identifying manual operational processes and replacing them with automationScripting proficiency in PowerShell and/or Python sufficient to automate DBA tasks, pipeline operations, and Azure resource management end-to-endExperience building automation with Azure-native tools: Azure Automation Runbooks, Logic Apps, Azure Functions, and Event GridExperience building self-healing patterns – automatic retries, failure notifications, and recovery runbooks for ADF pipelines and SQL Agent jobsAbility to write and maintain automation that others on the team can run, maintain, and extend without the original author presentFamiliarity with source-controlling operational scripts and runbooks so automation is versioned, reviewable, and auditableSQL Managed Instance & SQL ServerStrong SQL performance troubleshooting – blocking, deadlocks, indexing, statistics, and long-running query analysisHands-on experience with SQL Agent jobs, maintenance plans, and automated job chainsDatabase refresh and cloning workflows for dev/staging environment managementBackup and restore validation, point-in-time recovery, and recoverability testingExperience with MSSQL on-premises and Azure SQL Managed Instance (SQLMI)Azure Data FactoryMonitoring and alerting on ADF pipeline runs across complex multi-stage pipelinesRestarting and recovering failed pipelines from the correct activity checkpointsUnderstanding of ETL dependency chains and data lineage within ADFTroubleshooting integration runtime issues, linked service connectivity, and pipeline-to-SQL MI integrationFamiliarity with ADF triggers, scheduling patterns, and data flow debuggingSSISRunning, re-running, and monitoring SSIS packages in productionDiagnosing and resolving common SSIS failure patternsExperience with HR/personnel data integration processes via SSISAzure InfrastructureApp Services and App Service Environments – configuration, scaling, diagnostics, and slot managementDeployment slot swaps – staging-to-production promotion workflowsWebJob management – start/stop operations and log monitoringStorage Accounts – queues, blob containers, and file ingestion pattern troubleshootingCertificate lifecycle management – uploading, binding, and renewal workflowsDiagnosing Azure-side performance degradations and differentiating them from application-layer issuesAzure DevOpsStrong hands-on experience with Azure DevOps Pipelines – authoring and maintaining multi-stage YAML pipelines for data platform and infrastructure deploymentsWork item and backlog management in Azure DevOps BoardsRepo and branch strategy management in Azure ReposApplication OperationsAbility to validate application availability and health across integrated service tiersExperience identifying whether issues are code-related, data-related, or infrastructure-relatedComfort operating within a structured platform team supporting a production application environmentSoft SkillsComfort making decisions independently during overnight and off-hours on-call coverageClear, concise written communication is criticalStrong pattern recognition for troubleshooting across data, application, and infrastructure tiersYou Have5+ years of professional experience as a DBA, DataOps Engineer, or Platform/Site Reliability Engineer with a strong data focusDeep hands-on experience with Microsoft Azure – including SQL Managed Instance, Azure Data Factory, App Services, and Azure StorageStrong MSSQL administration background including performance tuning, backup/restore operations, and SQL Agent job managementExperience working on or directly supporting a platform team in an enterprise environmentHands-on experience with Azure DevOps Pipelines for data platform and infrastructure deploymentsStrong scripting skills in PowerShell, T-SQL, Python, or Bash for operational automationProven experience identifying manual toil in a data or operations environment and shipping automation to replace itHands-on experience with at least one Azure automation tool – Azure Automation Runbooks, Logic Apps, Azure Functions, or Event GridClear, concise written communication capable of producing daily operational reports and shift handoffs that stand on their ownComfort making independent troubleshooting decisions during off-hours on-call coverageStrong pattern recognition for operational troubleshooting across data, application, and infrastructure tiersAbility to balance planned maintenance work with unplanned operational incidentsExtra AwesomeDevOps engineering experience – IaC with Terraform or Bicep, CI/CD pipeline design, and Azure infrastructure automationExperience building event-driven automation using Azure Event Grid, Service Bus, or Logic Apps to react to data platform eventsExperience implementing Azure Monitor alerts wired to automated remediation actions via Azure Automation or Azure FunctionsExperience with Azure Monitor, Log Analytics, and KQL for operational alerting and diagnosticsFamiliarity with Azure Key Vault, RBAC, and Azure AD for secure data platform operationsExperience with Azure Synapse Analytics or Databricks as a data platform extensionIndustry certifications – especially DP-300 (Azure Database Administrator), AZ-104, AZ-400, or DP-203Experience in SaaS or managed services environments supporting multiple concurrent customersFamiliarity with containerization using Docker or AKS for data platform servicesBenefits100% remote workplace – We’ve been remote since Day 1!Unlimited Paid Time OffEquity – If you display ownership of the work you’re doing you’ll become a true owner of the company401K with company contributionCompany sponsored healthcareCompetitive compensation including on-call rotation compensationOpportunities to accelerate professional growth with access to Azure training and certification programs