Note: The job is a remote job and is open to candidates in USA. Algotale Group is seeking a technically strong MS SQL Database Engineer. This individual contributor role demands deep expertise in MS SQL Server, T-SQL, performance tuning, and advanced troubleshooting to optimize critical database systems and ensure high availability and performance.
Responsibilities
• Optimize complex T-SQL queries and database performance
• Troubleshoot and resolve database issues (blocking, deadlocks, IO bottlenecks)
• Analyze execution plans and implement indexing/partitioning strategies
• Maintain high availability (Always On, clustering, replication)
• Monitor and improve database health and automation
• Collaborate with development teams for schema and query design
Skills
• 8–12 years with MS SQL Server and T-SQL
• Strong in performance tuning, query optimization, and internals
• Skilled in using SQL Profiler, DMVs, and Extended Events
• Experience with HA/DR setups and large-scale data environments
• Excellent troubleshooting and communication skills
• SSIS/SSRS
• Cloud SQL (Azure/AWS RDS)
• Scripting (PowerShell)
• CI/CD exposure
Company Overview
• Algotale is a premier IT staffing and software solutions provider, delivering top-tier talent and custom-built technology to drive business success. It was founded in 2016, and is headquartered in New Delhi, IN, with a workforce of 201-500 employees. Its website is https://www.algotale.com/.