Dhruv Bhanushali

About Dhruv Bhanushali

I’m a Data Engineer at Tata Consultancy Services specializing in ELT development using…

Experience

1. Assistant System Engineer

   Tata Consultancy Services

   May 2024 — Present · New Delhi, IN

   As an Assistant System Engineer at Tata Consultancy Services, I am currently working as a SQL Server DBA for Pfizer — one of the world’s leading biopharmaceutical companies known for its innovative research and global healthcare impact. I manage SQL Server operations across development, stage, and production environments; ensuring high-availability, stability, and performance of critical business databases.I have resolved a wide range of database-related incidents, service requests, and RFCs while consistently meeting SLA targets. My work directly supports uninterrupted data access, minimal downtime, and proactive issue prevention, all of which help to maintain a stable and high-performing database environment for the client.Key Responsibilities:• Administration of over 150+ SQL Server databases in a 24x7 production environment.• Installing, configuring, managing, monitoring, and troubleshooting SQL Server 2016 & 2019.• Providing round-the-clock production database support.• Performing performance tuning of SQL queries and optimizing system responsiveness.• Supporting Very Large Databases (VLDBs) and resolving performance bottlenecks.• Conducting database upgrades from legacy versions to SQL Server 2016/2019.• Writing and optimizing T-SQL queries, stored procedures, functions, views, and indexes.• Executing and validating scripts across dev, stage, and prod environments.• Deploying and managing SSIS packages and SSRS reports.• Creating, migrating, and monitoring SQL Server Agent jobs.• Managing backups, restores, user access, roles, and security configurations.• Identifying and addressing potential database issues proactively to prevent incidents.• Collaborating with Pfizer\'s internal IT teams to align with data governance and compliance standards.