Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
We are seeking an experienced Senior Database Administrator (Level 3 Support) with a specialization in Microsoft SQL Server. This role is crucial for managing, optimizing, and troubleshooting our SQL Server environments across development, test, UAT, and production stages.
Your responsibilities will include ensuring high availability, implementing robust disaster recovery solutions, and leading complex projects such as migrations and upgrades. You will also be instrumental in performance tuning, security compliance, and capacity planning to maintain optimal database operations.
Administer and maintain Microsoft SQL Server databases, including installation, configuration, patching, and upgrades. Ensure database availability, integrity, security, and optimal performance through proactive monitoring and tuning. Implement and manage high availability and disaster recovery solutions like Always On Availability Groups, FCI, Replication, and Log Shipping. Configure and monitor backup strategies, performing regular restore tests to meet RTO/RPO objectives. Enforce database security best practices, manage access controls, and ensure compliance with security standards. Handle critical production incidents, conduct root cause analysis, and provide permanent solutions. Lead database migration projects, execute upgrades, and plan consolidation initiatives. Develop T-SQL and PowerShell scripts to automate routine DBA tasks. Create and maintain operational documentation and collaborate effectively with cross-functional teams, adhering to ITIL processes.
Proven experience of 10+ years as a Microsoft SQL Server DBA. Expertise in SQL Server 2012 through 2022, including Always On Availability Groups, performance tuning, backup/recovery, and replication. Proficiency in T-SQL and PowerShell scripting for automation. Solid understanding of database security, auditing, and troubleshooting methodologies. Experience with monitoring tools and basic to intermediate Windows Server administration. Strong analytical, problem-solving, and communication skills are essential. Ability to work under pressure and collaborate effectively within a team environment.
HCLTech
IT Consulting