Logo of Huzzle

Home

Matches

Explore

Manage

MS SQL DBA

image

Virtusa

2mo ago

  • Job
    Full-time
    Mid & Senior Level
  • Software Engineering
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You should have experience in MS SQL database management, backup strategies, performance monitoring, SQL scripting, security management, and routine maintenance tasks.
  • You will manage database installations, backups, performance monitoring, log shipping, user permissions, and routine maintenance tasks while ensuring data integrity and recovery plans.

Requirements

  • MS SQL DBA profile with following roles & Responsibilities as Per MIS.
  • Software installation and maintenance (Mostly Database configurations)
  • Implement and manage database backup strategies, ensuring data recovery and disaster recovery plans are in place.
  • Perform regular backup testing, restore processes, and verification of data integrity.
  • Monitoring performance( Based on Performance enhancement of PROD Server/Space issue/Slowness)
  • Data handling
  • Log shipping configuration and management in SQL Instances.
  • Basic SQL script ex: table alters, updates and data loads from base to Target tables.
  • Assigning roles, Permission to folder(read/write) and user creation on SQL SERVER based on MIS tickets.
  • Server hardening and patching activities
  • Schedule and perform routine database maintenance tasks, including index rebuilding, statistics updates, and database shrinking.
  • Manage and monitor disk space, logs, and database growth.

Responsibilities

  • Software installation and maintenance ( Mostly Database configurations)
  • Implement and manage database backup strategies, ensuring data recovery and disaster recovery plans are in place.
  • Perform regular backup testing, restore processes, and verification of data integrity.
  • Monitoring performance( Based on Performance enhancement of PROD Server/Space issue/Slowness)
  • Data handling
  • Log shipping configuration and management in SQL Instances.
  • Basic SQL script ex: table alters, updates and data loads from base to Target tables.
  • Assigning roles, Permission to folder(read/write) and user creation on SQL SERVER based on MIS tickets.
  • Server hardening and patching activities
  • Schedule and perform routine database maintenance tasks, including index rebuilding, statistics updates, and database shrinking.
  • Manage and monitor disk space, logs, and database growth.

FAQs

What are the primary responsibilities of the MS SQL DBA role?

The primary responsibilities include software installation and maintenance, implementing and managing database backup strategies, performing regular backup testing, monitoring performance, managing log shipping configurations, handling data, and performing routine database maintenance tasks.

What does the backup strategy involve for this position?

The backup strategy involves implementing and managing database backup processes, ensuring data recovery, disaster recovery plans are in place, and performing regular backup testing and restore processes to verify data integrity.

Is experience with SQL scripting required for this position?

Yes, basic SQL scripting skills are required, including tasks such as table alterations, updates, and data loads from base to target tables.

What type of monitoring is expected in this role?

The role requires monitoring performance based on enhancements of the production server, addressing space issues, and troubleshooting any slowness.

Will there be responsibilities related to security and user permissions?

Yes, responsibilities include assigning roles, managing permissions to folders, and creating users on SQL Server based on MIS tickets.

Are there any specific maintenance tasks that need to be scheduled regularly?

Yes, routine database maintenance tasks such as index rebuilding, statistics updates, and database shrinking need to be scheduled and performed regularly.

What is the company culture like at Virtusa?

Virtusa values teamwork, quality of life, and professional and personal development, fostering a collaborative environment that encourages new ideas and excellence.

Does Virtusa promote equal opportunity in employment?

Yes, Virtusa was founded on principles of equal opportunity and does not discriminate based on race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.

What is the team size at Virtusa?

The team consists of approximately 30,000 people globally, emphasizing collaboration and growth.

image

Virtusa

Business transformation that lasts starts with Engineering First.

Technology
Industry
10,001+
Employees
1996
Founded Year

Mission & Purpose

Virtusa Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.