Job Description

Job Summary

We are seeking a skilled and proactive Sr Production Support Engineer (Azure + SQL) to manage, maintain, and optimize our production support operations. The ideal candidate will have strong experience in Azure, SQL Server and SSIS, with a focus on active monitoring, trouble shooting, performance tuning, and automation.

Key Responsibilities

• Provide Production Support (US Hours): Ensure timely monitoring, troubleshooting, and resolution of production issues during US business hours.
• Ensure Production Environment Stability: Maintain a reliable, secure, and high-performing production environment through proactive support and governance.
• Monitor and Optimize Performance: Continuously track system, application, and data pipeline performance, identifying and implementing optimization opportunities.
• Manage Incidents and Problem Resolution: Lead incident triage, root cause analysis (RCA), issue resolution, and preventive actions to minimize business impact.
• Support Data Pipelines and Integrations: Ensure seamless operation of data ingestion, transformation, and integration processes across platforms and applications.
• Drive Automation and Operational Excellence: Improve operational efficiency through automation, standardization, and continuous process improvement initiatives.
• Engage with Stakeholders: Collaborate with business and technical stakeholders to understand requirements, align data solutions, and ensure successful delivery.
• Collaborate Across Teams: Follow SDLC best practices and work effectively with cross-functional teams using Agile, DevOps, and CI/CD methodologies across development, testing, QA, and production environments.

Skill Requirements

• Azure Cloud Platform
• Azure Data Factory (ADF) for pipeline monitoring, troubleshooting, and optimization
• Azure Synapse Analytics (Dedicated SQL Pool, Serverless SQL, Pipelines)
• Azure SQL Database and Azure Managed Instance
• Azure Storage Accounts (Blob Storage, ADLS Gen2)
• Azure Key Vault for secrets and credential management
• Azure Functions and Logic Apps (basic support and troubleshooting)
• SQL & Database Management
• Advanced T-SQL development and troubleshooting
• Query tuning and performance optimization
• Indexing strategies and database maintenance
• Stored procedures, views, functions, and triggers
• SQL Agent jobs and scheduling
• Data quality validation and reconciliation
• Data Engineering & Integration Support
• ETL/ELT process monitoring and support
• Pipeline failure analysis and recovery
• Data ingestion and transformation troubleshooting
• File-based integrations (CSV, JSON, Parquet, XML)
• Data warehouse and dimensional modeling fundamentals

Other Requirements

Preferred Qualifications

• BE/BTech in IT/CS
• Azure Certifications – Fundamental, Developer and Data Engineer