Job Summary

We are looking for an experienced Microsoft SQL Database Administrator (SQL DBA) with strong hands-on expertise in managing, troubleshooting, and optimizing Microsoft SQL Server environments. Approximately 90% of the environment is Microsoft SQL Server, with a significant number of databases running on SQL Server 2012, SQL Server 2014, and newer versions, across Windows Server 2012 R2, Windows Server 2016, and newer versions.

The immediate priority for this role is to assess the health and stability of the existing database environment, identify risks and performance gaps, and provide actionable recommendations.

The DBA will also provide hands-on emergency production support for critical database issues.

This role requires someone who can quickly understand an existing environment, independently diagnose database issues, prioritize risks, and recommend practical remediation, upgrade, migration, or modernization actions.

Key Responsibilities

Database Health Assessment

- Conduct comprehensive health checks across Microsoft SQL Server databases and their underlying Windows Server environments.
- Assess database performance, availability, configuration, capacity, security, and overall operational health.
- Identify performance bottlenecks, configuration issues, capacity risks, backup/recovery gaps, and potential points of failure.
- Review databases running on SQL Server 2012, SQL Server 2014, and newer versions, across Windows Server 2012 R2, Windows Server 2016, and newer versions.
- Identify risks associated with unsupported or older SQL Server and Windows Server versions and recommend appropriate upgrade, migration, or modernization paths.
- Provide a prioritized health assessment and remediation roadmap covering immediate, medium-term,



and long-term recommendations.

Production Support Troubleshooting

- Provide L2/L3 production support for Microsoft SQL Server environments.
- Respond to critical and emergency database incidents and troubleshoot issues related to:
- Database availability
- Performance degradation
- Blocking and deadlocks
- High CPU / memory utilization
- Query performance
- Connectivity issues
- Backup and restore failures
- Database corruption
- Storage and capacity issues
- SQL Agent jobs and maintenance failures

- Perform root-cause analysis and recommend preventive and corrective actions.
- Support emergency troubleshooting and resolution of database issues within defined SLAs.

Requirements

- Strong hands-on expertise in managing, troubleshooting, and optimizing Microsoft SQL Server environments.
- Experience with SQL Server 2012, SQL Server 2014, and newer versions.
- Experience with Windows Server 2012 R2, Windows Server 2016, and newer versions.
- Ability to assess health and stability, identify risks, and provide actionable remediation and upgrade/migration recommendations.
- Ability to provide hands-on emergency production support for critical database issues.
- Ability to quickly understand an existing setting, independently diagnose database issues, prioritize risks, and recommend practical remediation, upgrade, migration, or modernization actions.

Skills

- Microsoft SQL Server
- SQL Server 2012
- SQL Server 2014
- Windows Server
- Production support
- Performance tuning
- Backup and restore
- Root-cause analysis
- SQL Agent jobs

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.

📌 Senior Microsoft SQL DBA professional (Jaipur)
🏢 Bot Consulting
📍 Jaipur