Senior DataOps Engineer

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.

Automation & Toil Elimination:

• 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.

Required Skills:

• Strong SQL performance troubleshooting – blocking, deadlocks, indexing, statistics, and long-running query analysis.
• Hands-on experience with Azure Data Factory monitoring, alerting, and pipeline recovery.
• Experience building automation with Azure-native tools: Azure Automation Runbooks, Logic Apps, Azure Functions, and Event Grid.