Job Overview: We are looking for an experienced Senior SQL Server Database Administrator (DBA). The role involves managing enterprise SQL Server environments, ensuring database availability and performance, handling production incidents, and maintaining database security, backup, and recovery processes. The selected candidate will also take ownership of existing PowerShell automation scripts, troubleshoot and enhance automation workflows, and document solutions to support knowledge transfer and operational continuity.

Key Responsibilities
• Manage and support enterprise SQL Server environments (2016–2025).
• Perform SQL Server installation, configuration, upgrades, patching, migration, backup, and recovery.
• Administer Always On Availability Groups and Windows Server Failover Clustering (WSFC).
• Troubleshoot database performance issues and optimize T-SQL queries and workloads.
• Manage database security, access controls, and routine maintenance activities.
• Take ownership of existing PowerShell automation scripts, troubleshoot issues, and enhance scripts to improve operational efficiency.
• Develop and maintain production-grade PowerShell scripts using functions, parameters, error handling, logging, and remoting.
• Build and maintain Grafana dashboards, monitoring panels, and alert rules.
• Develop Power BI reports and dashboards for operational monitoring and management reporting.
• Handle production incidents, service requests, changes, and maintenance activities within defined SLAs.
• Participate in major incident management, communicate status updates, and coordinate with cross-functional teams.
• Maintain technical documentation, standard operating procedures (SOPs), and runbooks, and conduct knowledge transfer sessions.
• Provide operational cover during planned absences of the client's DBA team to ensure service continuity. Required Skills 1.



Microsoft SQL Server
• Hands-on experience with SQL Server 2016, 2017, 2019, 2022 and 2025.
• Installation, configuration, administration, and maintenance.
• SQL Server upgrade, migration and patching.
• Database security and access management.
• Backup, recovery, and disaster recovery fundamentals.
• Performance tuning, query optimization, and troubleshooting.
• Strong T-SQL development and troubleshooting skills.
• Always On Availability Groups.
• Windows Server Failover Clustering (WSFC) and high-availability solutions. 2. PowerShell Scripting
• Hands-on experience developing and maintaining PowerShell scripts for database administration and automation.
• Strong understanding of functions, parameters, error handling, and logging.
• Experience with PowerShell remoting.
• Hands-on experience with the SqlServer PowerShell module or dbatools module.
• Ability to read, troubleshoot, maintain, and enhance scripts developed by other team members.
• Experience documenting scripts, dependencies, execution procedures, and error-handling processes. 3. Monitoring and Reporting
• Grafana dashboard and panel development.
• Configuration of monitoring alerts and alert rules.
• Power BI report and dashboard development.
• Basic knowledge of data modelling and DAX.
• Experience configuring and troubleshooting scheduled dataset refreshes. 4. Production Support




• Experience in enterprise database operations or managed services environments.
• Incident, change, and problem management.
• Database patching and planned maintenance.
• Root cause analysis and production troubleshooting.
• Working within defined service-level agreements (SLAs).
• Major incident coordination and stakeholder communication. Candidate Requirements
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written English communication skills.
• Ability to explain technical issues clearly to technical teams and non-technical stakeholders.
• Confidence in client-facing meetings and critical incident calls.
• Ability to work independently and take ownership of operational responsibilities.
• Strong documentation, collaboration, and knowledge-sharing skills.
• Ability to work effectively with distributed teams and across time zones. Good-to-Have Skills
• Exposure to Azure SQL Database or Azure SQL Managed Instance.
• Experience with Python, Bash, or other scripting languages.
• Familiarity with Azure DevOps.
• Familiarity with ServiceNow for incident, problem, and change management.
• Experience with Tenable for vulnerabilities management.
• Microsoft Certified: Azure Database Administrator Associate (DP-300). Key Expectations The successful candidate will independently manage day-to-day SQL Server operations, take ownership of existing PowerShell automation, support high-availability environments, and contribute to monitoring, reporting, and continuous improvement. The candidate must be comfortable working in a client-facing production support workplace and maintaining service continuity within agreed SLAs.

Location:
Bengaluru, India

Experience:
8-10 Years Joining: Immediate joiners or candidates with a notice period of up to 30 days

📌 Senior Sql Database Administrator (Bengaluru)
🏢 Crimsonlogic
📍 Bengaluru