Note: The job is a remote job and is open to candidates in USA. Algotale Group is seeking a highly skilled and experienced MS SQL Database Developer with over 8 years of hands-on experience. The role involves designing, developing, and optimizing SQL Server databases while ensuring stability, integrity, and performance of database systems.
Responsibilities
• Design, develop, and maintain high-performing SQL Server databases, tables, stored procedures, functions, and views
• Analyze, troubleshoot, and optimize slow-running queries and stored procedures using execution plans and SQL Profiler
• Monitor and fine-tune database performance (indexing, partitioning, statistics updates, etc.) to ensure optimal response time and resource usage
• Perform root cause analysis of database issues and proactively prevent performance bottlenecks and outages
• Collaborate with application developers and infrastructure teams to design efficient data models and support application needs
• Develop and enforce database standards, best practices, and procedures
• Implement and maintain ETL processes and data transformation scripts
• Support database deployments, migrations, and patching with minimal downtime
• Create and maintain documentation on database architecture, configurations, and procedures
Skills
• 8 years of experience working as a SQL Server Developer (MS SQL Server 2016 and above)
• Strong proficiency in writing and optimizing complex T-SQL queries, stored procedures, triggers, and functions
• Extensive experience with performance tuning and troubleshooting tools such as: Execution Plans, SQL Profiler, Extended Events, Dynamic Management Views (DMVs)
• Strong knowledge of indexing strategies, query optimization techniques, and database locking behavior
• Experience with backup/restore, log shipping, replication, and high availability configurations
• Familiarity with SSIS for ETL workflows and data integration
• Understanding of database security, role-based access, and auditing
• Proficient in source control tools (e.g., Git) and CI/CD processes for database deployments
• Microsoft Certified: Azure Database Administrator Associate or similar certifications
• Experience with Power BI or other reporting tools
• Exposure to Azure SQL, Synapse, or other cloud-based data solutions
• Strong communication and documentation skills
• Experience working in Agile/Scrum environments
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/.