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 robust 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

Must Have Skill

Microsoft Azure,MS SQL,Azure MSSQL DBA,Iaas - Azure

Good to Have Skill

Other Requirements

Preferred Qualifications

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

📌 SeniorAdministrator - AzureMSSQL DBA, Microsoft Azure (India)
🏢 HCLTech
📍 India