Microsoft SQL Server DBA L2

Techvits Solutions; Mumbai; On-site; INR 800,000 - 850,000; Full time

Job summary

Techvits Solutions is seeking a SQL DBA for our Mumbai, Navi-Mumbai, Thane offices. The role requires 4–7 years of experience, a graduation, and hands-on work with SQL Server, performance tuning, and database maintenance.

You will manage database design, schema changes, and high-availability setups, while collaborating with developers to optimize large-scale OLTP systems. Joining period is up to 1 month, with a full-time position in a dynamic team.

Qualifications

• Minimum 4–7 years of SQL Server DBA experience.
• Strong experience in database design, schema changes and performance tuning.
• Experience with DR, replication, log shipping and Always On availability groups.
• Proficient in Windows scripting and job scheduling for maintenance tasks.

Responsibilities

• Responsible for database architecture, design, performance tuning and support of applications from a database perspective.
• Define and implement database standards and best practices.
• Execute schema changes and maintain development, QA, UAT and production environments.
• Collaborate with developers to test, configure and optimize servers for high load databases.
• Conduct T-SQL code reviews to enforce standards and prevent performance issues.
• Create and maintain database scripts and source control integrations.

Skills

T-SQL

SQL Server

Performance tuning

Backup & Recovery

DB Monitoring

Education

Graduation

Tools

SSMS

Replication

Always On

Windows scripting

Job description

No of Years of Experience: 4-7

CTC : 8-8.5 LPA

Joining /Notice Period: 1 month max.

Job Location – Mumbai, Navi-Mumbai & Thane

Full time Graduation is must

Job Description: SQL DBA

• Responsible for physical database architecture and design, development, performance tuning, implementation, and support of the applications from a database perspective
• Define and implement database, SQL standards and best practices
• Execute all changes of db schema and maintain controlled development database environment
• Work closely with application developers to test, configure, and optimize servers based on application demands; work with large volume, heavy load databases
• Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues
• Create database scripts for all objects and integrate them with source control
• Handle database object deployment to Integration, QA, UAT, and Production
• Good in reading and writing complex stored procedures, views, and triggers
• Experience in writing technical documentation
• Good in T- SQL scripts- Has credible experience in supporting production databases
• Backup / Recovery, Data Replication, Distributed databases, Data Migration- worked on replication , cluster , mirroring and log shipping and Always-On
• Experience in resolving blocking and deadlock issues
• Tune the databases- Write Windows Scripts, Planning, Job scheduling, and Monitoring
• Monitoring & Troubleshooting Blocking and Deadlock
• Execution of DBCC Commands , checkdb , shrinkfile , shrinkdatabase , indexdefrag , dbreindex, etc
• Create and update maintenance plan for database maintenance- Monitor and understand the error log and event log Monitor the disk space on the server and take action accordingly (Including Data files, Transaction log files, tempdb database)
• Connecting remote server using QA, EM, and TS) – Managing DB backups. Restoring database from Full/ Differential/ T- log backup
• Provide day to day support of high OLTP HA of SQL Server (2000, 2005, 2008,2012,2016,2019) databases- Identify root causes of production problems and work with developers to circumvent and resolve such problems
• Provide technical services to monitor and maintain environments, (the SQL Server production, development, and test databases) running on firm’s strategic platforms including periodic software upgrades and migration of the SQL Server products
• Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization- Create and maintain Windows and SQL scripts to automate tasks such as setting up and refreshing DEV, QA, and Production database environments
• Log, schedule and track all changes using change management system tools
• Configuring and Replication of SQL Servers to DR Environment
• Participate in DR Drills
• Responsible for all corrections to the database infrastructure and for repairs to the system or database
• SQL Server certified candidate is preferred.