Overview
SQL Server Database Engineer
Key Responsibilities:
Performance Tuning & Optimization: Perform analysis and performance tuning, optimize SQL queries, indexing, and schema designs to ensure efficient database performance.
High Availability & Disaster Recovery (HA DR): Implement robust high availability and disaster recovery solutions such as SQL Server Always On, Log Shipping, Database Mirroring, and Replication.
Backup & Recovery: Implement, maintain, and test backup and recovery strategies to ensure minimal downtime and data loss during disaster recovery scenarios.
Database Security: Implement security measures, including user roles, permissions, encryption, and auditing to ensure databases are secure and compliant with organizational standards and regulations.
Database Migration & Upgrades: Support efforts to migrate and upgrade SQL Server versions, ensuring minimal downtime and data integrity during these processes.
Automation & Scripting: Automate routine database maintenance tasks using T-SQL scripts, PowerShell, or other automation tools to improve efficiency and reduce errors.
Database Monitoring & Maintenance: Monitor the health and performance of production and development databases using tools like SQL Server Profiler, SQL Server Management Studio (SSMS), or third-party monitoring tools, and perform proactive maintenance to avoid performance issues.
Collaboration & Troubleshooting: Work closely with developers, system administrators, and DevOps teams to troubleshoot and resolve database-related issues, including query performance, deadlocks, and locking problems.
Required Skills & Qualifications:
Experience: 5-8 years of experience as a SQL Server Database Engineer.
SQL Server: Experience with SQL Server 2016 and newer versions, including installation, configuration.
Performance Tuning & Query Optimization: knowledge of SQL Server performance tuning, query optimization, indexing strategies, execution plans, and the tools available in SQL Server Management Studio (SSMS).
Security Management: Understanding of database security, including encryption, user authentication, role-based access control, and auditing.
Backup & Recovery: Expertise in creating and managing backup strategies, and testing restoration processes to ensure data integrity.
scripts, and other automation tools to streamline database tasks.
Monitoring & Diagnostics: Experience with SQL Server Profiler, Extended Events, Dynamic Management Views (DMVs), and third-party monitoring tools for diagnosing and troubleshooting database issues.
Tools & Technologies: Familiarity with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services) is a plus.
Version Control: Experience working with version control systems (e.g., Git) to track database changes and deployments.
Preferred Qualifications:
Cloud Experience: Experience with cloud databases (e.g., Azure SQL Database, AWS RDS for SQL Server) and cloud-based high availability solutions.
ETL & Data Warehousing: Experience with ETL processes, data warehousing, and SQL Server Integration Services (SSIS).
About Virtusa
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
- Mumbai, Maharashtra, India
- Chennai, Tamil Nadu, India
- Mumbai, Maharashtra, India
- Chennai, Tamil Nadu, India
- Mumbai, Maharashtra, India
- Mumbai, Maharashtra, India
- Hyderabad, Telangana, India
- Hyderabad, Telangana, India