SQL Server Database Administrator Walkin Interview@ Greater Noida

Tata Consultancy Services; Dadri; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services in Greater Noida is seeking an experienced SQL Server Database Administrator for a walk-in interview. The role covers end-to-end SQL Server administration across development, test, staging, and production environments with a strong emphasis on reliability and performance.

You will configure and maintain Always On Availability Groups, Failover Clustering, backups/restores, security, SSRS/SSIS/SSAS, and proactive monitoring, while collaborating with stakeholders to ensure

Qualifications

• Hands-on experience administering Microsoft SQL Server in enterprise production environments.
• Expertise in installing, configuring, patching, upgrading, and maintaining SQL Server instances.
• Experience with Always On Availability Groups, Windows Server Failover Clustering, and Log Shipping.
• Strong knowledge of backup, restore, recovery, and point-in-time recovery.
• Experience with SSRS, SSIS, and SSAS.
• Proficiency in performance tuning, indexing, and wait analysis.
• Experience with capacity planning, storage management, and resource optimization.
• Strong knowledge of SQL Server security and compliance controls.
• Experience planning migrations, consolidations, and upgrades with minimal downtime.
• Proficiency with T-SQL, PowerShell, and automation.
• Familiarity with ITIL processes and incident/change management.
• Ability to produce operational documentation and reports.
• Strong communication and cross-functional collaboration skills.

Responsibilities

• Provide end-to-end administration and operational support for SQL Server instances across development, test, staging, and production environments.
• Install, configure, patch, upgrade, and maintain SQL Server engines and related components (SSRS/SSIS/SSAS).
• Design and manage HA/DR solutions (Always On, Failover Clustering, Log Shipping).
• Define backup/recovery strategies; perform restore validation and DR drills.
• Monitor and tune performance through queries, indexing, and wait analysis.
• Manage capacity, storage, file growth, tempdb, and maintenance jobs.
• Administer security, logins, roles, and encryption; ensure compliance evidence.
• Plan migrations, consolidations, and lifecycle activities with minimal downtime.
• Deliver proactive monitoring, incident resolution, root-cause analysis, and continual service optimization.

Skills

SQL Server administration

HA/DR design

Performance tuning

Backup and recovery

SSRS/SSIS/SSAS

PowerShell automation

ITIL processes

Documentation

Tools

SSRS

SSIS

SSAS

Always On Availability Groups

Job description

SQL Server Database Administrator Walkin Interview@ Greater Noida

SQL Server Database Administrator

Location: Greater Noida

Experience: 6 years to 11 years

Interview Mode: Walk In Drive

Interview Date: 22nd Aug 2025 (Saturday)

Interview Time: 10: 00 AM to 1: 00 PM

Must-Have:

• 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.

Key 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.