Sql Database Administrator

Siro Clinpharm; Dadri, Hyderabad, Gurugram District; On-site; INR 1,400,000 - 2,600,000; Full time

Job summary

Siro Clinpharm is seeking an experienced Microsoft SQL Server Database Administrator to manage end-to-end SQL Server environments in enterprise settings. You will handle availability, security, performance tuning, migrations, backups, and production support across development, testing, and production databases.

The role requires deep expertise with Always On Availability Groups, Log Shipping, SSRS/SSIS/SSAS, and strong scripting with T-SQL and PowerShell.

Qualifications

• 8+ years of hands-on experience administering Microsoft SQL Server in enterprise production environments.
• Strong expertise in installing, configuring, patching, upgrading, and maintaining SQL Server instances.
• Hands-on experience with SQL Server Always On Availability Groups, Windows Server Failover Clustering, and Log Shipping.
• Strong knowledge of backup, restore, recovery, point-in-time recovery, and database consistency validation.
• Experience administering and supporting SQL Server Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
• Proficiency in performance monitoring and tuning, including query optimization, execution plans, indexing, statistics, blocking, deadlocks, and wait analysis.
• Experience with capacity planning, storage management, database growth forecasting, and resource optimization.
• Strong knowledge of SQL Server security, authentication, authorization, role-based access, encryption, auditing, and compliance controls.
• Experience planning and executing database migrations, consolidations, version upgrades, and lifecycle activities with minimal business disruption.
• Proficiency with SQL Server Agent, T-SQL, PowerShell, and automation of routine database administration activities.
• Experience with proactive monitoring, alerting, incident, problem, change, and service management processes in an ITIL-aligned environment.
• Ability to produce and maintain operational documentation, standard operating procedures, recovery runbooks, and technical reports.
• Strong troubleshooting, analytical, stakeholder communication, and cross-functional collaboration skills.

Responsibilities

• Provide end-to-end administration and operational support for Microsoft SQL Server instances across development, test, staging, and production environments.
• Install, configure, patch, upgrade, and maintain SQL Server database engines and related components, including SSRS, SSIS, and SSAS.
• Design, configure, monitor, test, and troubleshoot High Availability and Disaster Recovery solutions, including Always On Availability Groups, Failover Clustering, and Log Shipping.
• Define and manage backup and recovery strategies; perform restore validation, point-in-time recovery, disaster recovery drills, and recovery readiness reviews in line with agreed RPO and RTO targets.
• Monitor and tune database and instance performance through query analysis, execution plans, indexing, statistics maintenance, wait analysis, blocking and deadlock resolution, and resource optimization.
• Manage database capacity, storage utilization, file growth, tempdb, maintenance plans, jobs, alerts, and housekeeping activities to maintain service stability and availability.
• Administer database security and access, including logins, users, roles, permissions, service accounts, encryption, auditing, vulnerability remediation, and compliance evidence.
• Plan and execute database migrations, consolidations, platform upgrades, decommissioning, and lifecycle management activities while minimizing downtime and operational risk.
• Deliver proactive monitoring, incident and problem resolution, root cause analysis, change implementation, automation, documentation, stakeholder communication and continual service optimization.

Skills

SQL Server

Always On Availability Groups

Log Shipping

SSRS

SSIS

SSAS

Backup and Recovery

Performance Tuning

T-SQL

PowerShell

ITIL/Service Management

Documentation

Tools

PowerShell

SQL Server Agent

Windows Server

Job description

Job Description - Microsoft SQL Server Database Administrator

Required Technical Skill Set

We are looking for an experienced Microsoft SQL Server Database Administrator responsible for end-to-end administration, availability, security, performance, and operational support of enterprise SQL Server environments. The ideal candidate will have strong hands-on expertise in SQL Server instances, Always On Availability Groups, Log Shipping, SSRS, SSIS, SSAS, backup and recovery, performance tuning, migrations, monitoring, and production support.

Desired Experience Range - 8+ Years Experience

Location of Requirement - Noida/Gurgaon/Hyderabad

Desired Competencies (Technical / Behavioral Competency)

Must-Have

Microsoft SQL Server Database Administrator

• 8+ years of hands-on experience administering Microsoft SQL Server in enterprise production environments.
• Strong expertise in installing, configuring, patching, upgrading, and maintaining SQL Server instances.
• Hands-on experience with SQL Server Always On Availability Groups, Windows Server Failover Clustering, and Log Shipping.
• Strong knowledge of backup, restore, recovery, point-in-time recovery, and database consistency validation.
• Experience administering and supporting SQL Server Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
• Proficiency in performance monitoring and tuning, including query optimization, execution plans, indexing, statistics, blocking, deadlocks, and wait analysis.
• Experience with capacity planning, storage management, database growth forecasting, and resource optimization.
• Strong knowledge of SQL Server security, authentication, authorization, role-based access, encryption, auditing, and compliance controls.
• Experience planning and executing database migrations, consolidations, version upgrades, and lifecycle activities with minimal business disruption.
• Proficiency with SQL Server Agent, T-SQL, PowerShell, and automation of routine database administration activities.
• Experience with proactive monitoring, alerting, incident, problem, change, and service management processes in an ITIL-aligned environment.
• Ability to produce and maintain operational documentation, standard operating procedures, recovery runbooks, and technical reports.
• Strong troubleshooting, analytical, stakeholder communication, and cross-functional collaboration skills.

SN

Responsibility of / Expectations from the Role

1. Provide end-to-end administration and operational support for Microsoft SQL Server instances across development, test, staging, and production environments.
2. Install, configure, patch, upgrade, and maintain SQL Server database engines and related components, including SSRS, SSIS, and SSAS.
3. Design, configure, monitor, test, and troubleshoot High Availability and Disaster Recovery solutions, including Always On Availability Groups, Failover Clustering, and Log Shipping.
4. Define and manage backup and recovery strategies; perform restore validation, point-in-time recovery, disaster recovery drills, and recovery readiness reviews in line with agreed RPO and RTO targets.
5. Monitor and tune database and instance performance through query analysis, execution plans, indexing, statistics maintenance, wait analysis, blocking and deadlock resolution, and resource optimization.
6. Manage database capacity, storage utilization, file growth, tempdb, maintenance plans, jobs, alerts, and housekeeping activities to maintain service stability and availability.
7. Administer database security and access, including logins, users, roles, permissions, service accounts, encryption, auditing, vulnerability remediation, and compliance evidence.
8. Plan and execute database migrations, consolidations, platform upgrades, decommissioning, and lifecycle management activities while minimizing downtime and operational risk.
9. Deliver proactive monitoring, incident and problem resolution, root cause analysis, change implementation, automation, documentation, stakeholder communication and continual service optimization.