SeniorAdministrator - AzureMSSQL DBA, Microsoft Azure
Join Our Community
Required Skills
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
- *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
Similar Jobs
- C
FBS Agile Dev Team Member II
Capgemini · Pune Division, Maharashtra, India
- C
FBS Sr. Solutions Engineer - Mobile & App Experience (Guidewire - Java - Angular
Capgemini · MH, IN
- G
Sr Product Specialist, GSSO
Gartner · HR, IN
Job Overview
- Job type
- Full-time
- Work mode
- On-site
- Location
- IN
- Posted
- 1d ago
- Source
- Indeed