Pranay Lanjewar
Senior MSSQL DBA | Performance Tuning | High Availability | Clustering | AlwaysOn | 4 Yrs Exp |
- Role
- Senior Consultant Mssql Dba at LTIMindtree
- Location
- Pune, MH, IN
- LinkedIn followers
- 500 followers
About Pranay Lanjewar
Dynamic Senior MSSQL Database Administrator with 4 years of hands-on experience in installation, configuration, performance tuning, and HA/DR solutions like AlwaysOn, Log Shipping, and Replication.I have worked on large production environments in hybrid setups (cloud/on-prem), providing 24x7 support and optimizing database performance.
Experience
Senior Consultant Mssql Dba
Apr 2025 — Present · Pune, IN
Installed, configured, and upgraded SQL Server instances (2012–2019) and applied service packs, cumulative updates, and hotfixes.• Designed and implemented disaster recovery (DR) strategies, including regular DR drills to ensure business continuity.• Managed Azure SQL databases, including performance monitoring, scaling, and cost optimization.• Resolved blocking, deadlocks, and high CPU usage issues using DMVs, DBCC commands, SQL Profiler, and Performance Monitor.• Conducted proactive health checks and implemented index maintenance strategies (rebuilds, reorgs, statistics updates).• Optimized queries and stored procedures using DTA, execution plans, and custom scripts.• Configured and maintained transactional replication, Always On availability groups, log shipping, and database mirroring.• Ensured high availability and minimal downtime for production systems through clustering and failover strategies.• Developed and maintained SSIS packages, SSRS reports, and SSAS cubes for enterprise reporting and analytics.• Automated routine tasks using PowerShell and T-SQL scripts to improve operational efficiency.• Managed database security by creating logins, users, roles, and permissions; implemented auditing and compliance checks.• Performed database restores and recovery from backups and export dumps.• Led weekly meetings with application teams to address performance issues, resource planning, and production changes.• Coordinated change review meetings and defined project scopes and deliverables in collaboration with stakeholders.• Mentored junior DBAs and facilitated knowledge sharing across teams.
Education
ExcelR
DATA SCIENCE
Dharmaraj high school &Jr College
HSC, Science
2015 — 2017
Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur
Bachelor of Engineering, Expo
2017 — 2021
Baliramji Dakhne High School
SSC, Science
2014 — 2015
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.