Senior DataOps Engineer

About this role

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 CHALLENGE

EverOps 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 MINDSET

A 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 MISSION

As 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 EXPECTATIONS

This 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 team

- Respond to and resolve incidents, failed pipeline runs, and database alerts outside of standard business hours when on-call

- Perform planned off-hours maintenance tasks such as database refreshes, certificate renewals, and deployment slot swaps that require low-traffic maintenance windows

- Produce clear written shift handoff notes and daily operational reports so the next engineer on rotation has full situational awareness

WHAT YOU’LL DO

- Own 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 management

- Monitor, triage, and restart Azure Data Factory pipeline runs; understand ETL dependencies and troubleshoot integration failures between ADF, SQL MI, and Azure Storage

- Manage SSIS package execution and re-runs, including HR/personnel integration processes and common failure pattern diagnosis

- Support Azure infrastructure operations including App Services, App Service Environments, deployment slots, WebJobs, Storage Accounts, and certificate lifecycle management

- Validate and test database backups, restores, and job chains to ensure recoverability

- Continuously inventory manual operational tasks across the data stack and prioritize them for automation

- Design and implement automation solutions using PowerShell, Python, Azure Automation, Logic Apps, or Azure Functions to eliminate repetitive manual work

- Build self-healing pipeline patterns in ADF and Azure DevOps – automatic retry logic, alerting, and recovery runbooks

- Build and maintain CI/CD pipelines in Azure DevOps for data platform and infrastructure deployments

- Participate in regular customer and internal EverOps scrums

- Diagnose and differentiate between application-layer, data platform, and infrastructure-layer issues

- Produce high-quality daily operational reports and documentation

- Participate in the off-hours on-call rotation and perform planned off-hours maintenance as required

REQUIRED SKILL SET

This 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 ELIMINATION

- Demonstrated track record of identifying manual operational processes and replacing them with automation

- Scripting proficiency in PowerShell and/or Python sufficient to automate DBA tasks, pipeline operations, and Azure resource management end-to-end

- Experience building automation with Azure-native tools: Azure Automation Runbooks, Logic Apps, Azure Functions, and Event Grid

- Experience building self-healing patterns – automatic retries, failure notifications, and recovery runbooks for ADF pipelines and SQL Agent jobs

- Ability to write and maintain automation that others on the team can run, maintain, and extend without the original author present

- Familiarity with source-controlling operational scripts and runbooks so automation is versioned, reviewable, and auditable

SQL MANAGED INSTANCE & SQL SERVER

- Strong SQL performance troubleshooting – blocking, deadlocks, indexing, statistics, and long-running query analysis

- Hands-on experience with SQL Agent jobs, maintenance plans, and automated job chains

- Database refresh and cloning workf

Similar jobs

• Senior Data Engineer — Polymarket · New York
• Senior Data Engineer — Metropolis · Seattle, Washington, United States
• Senior Data Engineer — Collectivehealth · Plano, TX
• Senior Data Engineer — Beamimpact · Remote
• Senior Data Engineer — Aircapture · Berkeley, CA
• Senior Data Engineer — Thetradedesk · Bellevue; Seattle
• Senior Data Engineer — Themotleyfool · Remote
• Senior Data Engineer — Range · McLean, VA