SQL Server Database Developer

Virtusa; New York (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Virtusa in New York, NY is seeking an experienced SQL Server database developer to design, implement, and optimize robust data solutions. You will work with large transactional and data warehouse environments, crafting efficient T-SQL, stored procedures, and ETL workflows while supporting BI reporting needs.

Ideal candidates bring 5–8 years of hands-on SQL Server experience, familiarity with SSIS/SSRS/Power BI, and a strong grasp of security and source control practices.

Qualifications

• 5-8 years hands-on SQL Server development and support.
• Design, develop, and optimize complex T-SQL queries, stored procedures, functions, views, and triggers.
• Experience with large-scale transactional databases and data warehouse environments.
• Familiarity with SSIS, SSRS, and Power BI.
• Knowledge of security, permissions, and RBAC; source control familiarity (Git/Azure DevOps).

Responsibilities

• Design, develop, test, and maintain SQL Server database solutions.
• Develop and optimize stored procedures, functions, views, and ETL processes.
• Investigate and resolve database performance issues.
• Support application development teams with database-related enhancements and troubleshooting.
• Participate in database migrations, upgrades, and modernization initiatives.
• Create technical documentation and support production deployments.
• Collaborate with business analysts, developers, QA teams, and stakeholders to deliver solutions.

Skills

SQL Server

T-SQL

ETL processes

Performance tuning

SSIS

SSRS

Power BI

Data modeling

RBAC

Azure DevOps

Git

Tools

Git

Azure DevOps

SSIS

SSRS

Power BI

SQL Server versions

Job description

Required Experience

5-8 years of hands-on experience in SQL Server database development and support.

Required Experience

• 5-8 years of hands-on experience in SQL Server database development and support.
• Strong experience in designing, developing, and optimizing complex T-SQL queries, stored procedures, functions, views, and triggers.
• Experience working with large-scale transactional databases and data warehouse environments.

Technical Skills

• Microsoft SQL Server 2016/2019/2022.
• Advanced T-SQL programming and query optimization.
• Database performance tuning, indexing, and execution plan analysis.
• Experience with SQL Server Integration Services (SSIS) and ETL processes.
• Knowledge of SQL Server Agent jobs, scheduling, and automation.
• Familiarity with data modeling, normalization, and database design principles.
• Experience creating and maintaining SSRS reports and/or Power BI reports.
• Understanding of SQL Server security, permissions, and role-based access controls.
• Experience with source control tools such as Git/Azure DevOps.

Preferred Skills

• Experience with Azure Data Factory, Microsoft Fabric, or cloud-based data platforms.
• Exposure to Python and modern data processing frameworks.
• Experience supporting data integrations, APIs, and file-based interfaces.
• Knowledge of DevOps, CI/CD pipelines, and automated deployment processes.

  Responsibilities

  • Design, develop, test, and maintain SQL Server database solutions.
  • Develop and optimize stored procedures, functions, views, and ETL processes.
  • Investigate and resolve database performance issues.
  • Support application development teams with database-related enhancements and troubleshooting.
  • Participate in database migrations, upgrades, and modernization initiatives.
  • Create technical documentation and support production deployments.
  • Collaborate with business analysts, developers, QA teams, and stakeholders to deliver solutions.

  Soft Skills

  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration abilities.
  • Ability to work independently and manage multiple priorities.
  • Strong attention to detail and commitment to delivering high-quality solutions.