Sr Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Seeking a seasoned MS SQL DBA to serve as a Senior Subject Matter Expert in Support & Operations. This role involves deep technical expertise in managing and optimizing MS SQL environments.
Key areas of focus include ensuring robust backup and recovery strategies, performing seamless installations and patching, and executing efficient migrations and upgrades. The position also demands proficiency in performance tuning, data modeling, and architectural planning.
Further responsibilities encompass re-engineering activities for enhanced efficiency and implementing high availability solutions like Always-ON Availability Groups and AWS RDS SQL Instances. This is a critical role for maintaining the integrity and performance of our SQL infrastructure.
Manage and execute comprehensive backup and recovery procedures for MS SQL databases.
Oversee and perform installations, patching, and upgrades of SQL Server instances.
Conduct performance tuning and optimization to ensure database efficiency.
Engage in data modeling and architectural design activities for SQL solutions.
Lead re-engineering efforts to improve existing database systems.
Implement and maintain high availability technologies, including Always-ON Availability Groups and AWS RDS SQL Instances.
Extensive experience as an MS SQL DBA is essential.
Proven track record in handling backups and recovery, installations, and patching.
Demonstrated ability in database migrations, upgrades, and performance tuning.
Expertise in data modeling, architectural activities, and re-engineering database systems.
Strong understanding and practical experience with High Availability Technologies, specifically Always-ON Availability Groups and AWS RDS SQL Instances.
This role is based in India and requires on-site presence.
HCLTech
IT Consulting