SQL Server Database Administrator Walkin Interview@ Greater Noida

SQL Server Database Administrator

Location: Greater Noida

Tata Consultancy Services Ltd, Yamuna Tower VI, Plot No. 22, Greater Noida, Sector135, Noida - 201301

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:

Microsoft SQL Server Database Administrator

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

15 years of Continuous Education.

📌 SQL Server Database Administrator Walkin Interview@ Greater Noida
🏢 Tata Consultancy Services
📍 Noida