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