SeniorAdministrator - AzureMSSQL DBA, Microsoft Azure
Posted Updated
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
Skills
- Agile
- Analytics
- Automation
- Azure
- Azure Data Factory
- Azure Functions
- Azure Logic Apps
- Azure Synapse
- CI/CD
- Cloud
- Data Engineering
- Data Ingestion
- Data Pipelines
- Data Quality
- Data Warehousing
- DevOps
- Dimensional Modeling
- ELT
- ETL
- JSON
- Parquet
- Process Improvement
- Root Cause Analysis
- SDLC
- Serverless
- SQL
- SQL Server
- SSIS
- Vault
- XML
Sign in to read and join the discussion.