Overview
Job Title: Senior MS SQL Data Engineer
Company: Rovista
Location: Remote (India)
Work Hours: 10:00 AM – 7:00 PM IST
Job Type: Full-Time
Experience Required: 5+ Years
About Rovista
Rovista is a dynamic IT services company specializing in custom web development, mobile apps, SaaS solutions, and enterprise software systems. We are looking for highly skilled professionals to join our growing remote team and contribute to high-impact projects.
Role Overview
We are seeking a Senior MS SQL Data Engineer who brings deep technical expertise in MS SQL Server, including strong capabilities in performance tuning, query optimization, and architectural design. You will play a crucial role in designing, maintaining, and optimizing high-performance, scalable database solutions.
Key Responsibilities
- Leverage expert-level proficiency in MS SQL Server (2016 and above) to manage and optimize database environments
- Develop and optimize complex T-SQL queries, stored procedures, views, and functions
- Analyze and improve query execution plans, index strategies, and database performance
- Design well-structured, normalized databases ensuring scalability and maintainability
- Troubleshoot and resolve performance bottlenecks and complex database issues
- Utilize monitoring and troubleshooting tools for proactive database health checks
- Support ETL processes and integrations, especially using SSIS or SSRS (preferred)
- Work with cloud SQL services such as Azure SQL or Amazon RDS (a plus)
Required Skills
- 5+ years of experience working with MS SQL Server in a production environment
- Deep understanding of SQL Server internals, architecture, and optimization techniques
- Strong knowledge of T-SQL, indexing, query tuning, and transaction handling
- Experience with performance tuning, profiling, and analyzing execution plans
- Familiarity with database monitoring tools and proactive performance management
- Ability to work independently in a remote setup, with strong communication skills
Nice to Have
- Experience with SSIS, SSRS, and data integration workflows
- Hands-on experience with Azure SQL or AWS RDS
How to Apply
Interested candidates may email their updated resume to info@rovista.in with the subject line: “Application for Senior MS SQL Data Engineer – [Your Name]”
Job Type: Full-time
Pay: ₹500,617.60 - ₹1,842,298.86 per year
Benefits:
- Cell phone reimbursement
- Flexible schedule
- Paid sick time
- Paid time off
- Work from home
Work Location: Remote