SQL Server Database Administrator Walkin Interview@ Greater Noida

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

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

Key Responsibilities:

\n
• Provide end-to-end administration and operational support for Microsoft SQL Server instances across development, test, staging, and production environments.
\n
• Install, configure, patch, upgrade, and maintain SQL Server database engines and related components, including SSRS, SSIS, and SSAS.
\n
• Design, configure, monitor, test, and troubleshoot High Availability and Disaster Recovery solutions, including Always On Availability Groups, Failover Clustering, and Log Shipping.
\n
• 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.
\n
• Monitor and tune database and instance performance through query analysis, execution plans, indexing, statistics maintenance, wait analysis, blocking and deadlock resolution, and resource optimization.
\n
• Manage database capacity, storage utilization, file growth, tempdb, maintenance plans, jobs, alerts, and housekeeping activities to maintain service stability and availability.
\n
• Administer database security and access, including logins, users, roles, permissions, service accounts, encryption, auditing, vulnerability remediation, and compliance evidence.
\n
• Plan and execute database migrations, consolidations, platform upgrades, decommissioning, and lifecycle management activities while minimizing downtime and operational risk.
\n
• Deliver proactive monitoring, incident and problem resolution, root cause analysis, change implementation, automation, documentation, stakeholder communication, and continual service optimization.
\n

15 years of Continuous Education.