MS SQL Database Support Engineer

Department: Cloud & Infrastructure Services (CIS)
Reports To: Database Lead / Infrastructure Manager
Location: Bangalore / Hybrid
Experience: 4-8 Years
Shift: 24x7 Support (Rotational On-call as required)

Job Summary

We are seeking a skilled Microsoft SQL Database Support Engineer (L2/L3) to manage, administer, monitor, troubleshoot, and optimize enterprise SQL Server environments. The candidate will be responsible for ensuring high availability, performance, security, backup and recovery of SQL databases while supporting business-critical applications and infrastructure.

Key Responsibilities

Database Administration & Support

• Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments.
• Manage SQL Server instances, databases, and storage allocation.
• Monitor database health, performance, availability, and capacity utilization.
• Perform database backup, restore, recovery, and disaster recovery testing.
• Manage SQL Agent Jobs, maintenance plans, DB mail, linked servers, and scheduled tasks.
• Troubleshoot database connectivity, performance degradation, blocking, deadlocks, and job failures.
• Provide L2/L3 support for incidents, problems, and service requests.

Performance & Availability

• Perform query tuning and SQL performance optimization.
• Monitor and optimize database resource utilization.
• Implement and support High Availability solutions including:
  • Always On Availability Groups
  • Log Shipping
  • Database Mirroring
  • Replication
  • SQL Clustering
• Conduct root cause analysis (RCA) and implement preventive actions.

Security & Compliance

• Manage database security, logins, roles, users, permissions, and auditing.
• Implement database hardening and security best practices.
• Ensure compliance with organizational security and data protection standards.
• Support vulnerability remediation and security audits.

Operations & Automation

• Automate routine DBA activities using PowerShell, T-SQL, or SQL Automation tools.
• Develop and maintain monitoring alerts and health-check reports.
• Participate in change, release, and problem management processes.
• Maintain operational documentation, SOPs, and Knowledge Base articles.

Collaboration

• Work closely with Application, Infrastructure, Cloud, and Service Desk teams.
• Support database migration and upgrade projects.
• Participate in major incident bridges and customer discussions when required.

Technical Skills Required

Must Have

• Microsoft SQL Server 2016/2019/2022 Administration.
• Strong T-SQL scripting and troubleshooting skills.
• Backup & Recovery strategies.
• SQL Performance Tuning and Query Optimization.
• Database Security and Access Management.
• SQL Agent, Maintenance Plans, Linked Servers.
• Windows Server administration fundamentals.
• High Availability & Disaster Recovery concepts.

Good to Have

• SSIS, SSRS, SSAS.
• Azure SQL Database / Managed Instance.
• PowerShell Scripting.
• Azure/AWS database migration experience.
• Monitoring tools such as LogicMonitor, SolarWinds, Datadog, SCOM, etc.
• DevOps tools such as Azure DevOps, Git, CI/CD pipelines.

Qualification

• Bachelors degree in Computer Science, IT, or related field.
• Microsoft SQL Server Certifications preferred.

Azure Database Administration certification is an added advantage

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.