Posted:7 hours ago
Job Summary : \"We are looking for an experienced Senior Microsoft SQL Server Database Administrator with 10+ years of hands-on experience managing large-scale, business-critical SQL Server environments. The ideal candidate will have strong expertise in SQL Server administration, Always On Availability Groups, clustering, performance tuning, backup and recovery, database security, migrations, automation, troubleshooting, and high availability/disaster recovery solutions. Experience with Microsoft Azure and hybrid database environments is highly desirable.
Job Description : \\\\\\\"• 10+ years of hands-on Microsoft SQL Server database administration experience.\\\\r\\\\n• Strong experience supporting enterprise production SQL Server environments.\\\\r\\\\n• Experience administering multiple versions of SQL Server in large or complex environments.\\\\r\\\\n• Strong hands-on experience with Always On Availability Groups and HA/DR technologies.\\\\r\\\\n• Proven expertise in database performance troubleshooting and tuning.\\\\r\\\\n• Experience managing large databases and high-transaction workloads.\\\\r\\\\n• Experience planning and executing SQL Server migrations and upgrades.\\\\r\\\\n• Strong understanding of database security, access management, and auditing.\\\\r\\\\n• Experience handling critical production incidents and performing RCA.
Job Responsibilities : \"SQL Server Administration • Install, configure, patch, upgrade, and administer Microsoft SQL Server environments. • Manage SQL Server instances and databases across Development, UAT, Staging, and Production environments. • Perform database refreshes, restores, migrations, upgrades, and server consolidation activities. • Manage database files, filegroups, storage capacity, SQL Server Agent jobs, linked servers, and database configurations. • Maintain database standards, documentation, operational procedures, and runbooks. High Availability & Disaster Recovery • Design, implement, administer, and troubleshoot SQL Server Always On Availability Groups. • Manage Windows Server Failover Clustering (WSFC) and SQL Server Failover Cluster Instances where applicable. • Support synchronous and asynchronous replicas, automatic/manual failover, listener configuration, and read-only routing. • Work with clusterless/read-scale Availability Group architectures where appropriate. • Design and maintain backup, recovery, DR, RPO, and RTO strategies. • Participate in scheduled DR drills and validate database recoverability. Performance Monitoring & Tuning • Troubleshoot complex performance issues involving CPU, memory, disk I/O, blocking, deadlocks, waits, and query execution. • Analyze execution plans and optimize poorly performing SQL queries. • Perform index analysis, statistics maintenance, fragmentation management, and database health checks. • Use tools such as Query Store, Extended Events, Dynamic Management Views (DMVs), Performance Monitor, and SQL Server execution plans. • Identify database performance bottlenecks and provide long-term remediation rather than temporary fixes. Backup, Recovery & Maintenance • Design and manage Full, Differential, and Transaction Log backup strategies. • Perform point-in-time database recovery when required. • Regularly test database backups and recovery procedures. • Configure and monitor integrity checks using DBCC CHECKDB. • Design and maintain database maintenance and housekeeping processes. Security & Compliance • Administer SQL Server logins, database users, roles, permissions, and schemas. • Implement the principle of least privilege and role-based access controls. • Manage Windows/Active Directory authentication and SQL authentication. • Support encryption technologies such as Transparent Data Encryption (TDE) and TLS where required. • Conduct database access and permission reviews. • Assist security and audit teams with database compliance requirements and remediation. Migration & Upgrades • Plan and execute SQL Server version upgrades and database migrations with minimal downtime. • Perform compatibility assessments and post-migration validation. • Support migrations between physical, virtual, cloud, and hybrid SQL Server environments. • Participate in on-premises to Microsoft Azure migration initiatives. • Support Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure Virtual Machines where applicable. Automation & Scripting • Automate recurring database administration activities using: o T-SQL o PowerShell o SQL Server Agent • Develop scripts for monitoring, health checks, database deployment, backup validation, capacity management, and operational reporting. • Reduce manual DBA activities through standardization and automation. Production Support • Provide Level 3 support for critical database incidents. • Diagnose and resolve production database outages and performance degradation. • Participate in an on-call support rotation where required. • Perform root cause analysis for Sev-1/Sev-2 incidents and implement permanent corrective actions. • Coordinate with application, infrastructure, Windows, storage, network, security, and cloud teams during major incidents and changes.
Skill Requirement : \"Technology / Skill Expected Expertise Microsoft SQL Server Expert SQL Server Administration Expert Always On Availability Groups Expert WSFC / Failover Clustering Advanced T-SQL Advanced Performance Tuning Expert Execution Plan Analysis Advanced Backup & Recovery Expert Database Security & Permissions Advanced SQL Server Agent Advanced Query Store / DMVs / Extended Events Advanced PowerShell Automation Intermediate to Advanced Database Migration & Upgrades Advanced Azure SQL Desirable Azure SQL Managed Instance Desirable SQL Server on Azure VM Desirable
Other Requirement : \"• 10+ years of hands-on Microsoft SQL Server database administration experience. • Strong experience supporting enterprise production SQL Server environments. • Experience administering multiple versions of SQL Server in large or complex environments. • Strong hands-on experience with Always On Availability Groups and HA/DR technologies. • Proven expertise in database performance troubleshooting and tuning. • Experience managing large databases and high-transaction workloads. • Experience planning and executing SQL Server migrations and upgrades. • Strong understanding of database security, access management, and auditing. • Experience handling critical production incidents and performing RCA.
Free courses, interview questions and practice for each skill.
HCLTech
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Salary: Not disclosed
Salary: Not disclosed
AI Job Matching Summary