Subhankar Mitra

Background

About Subhankar Mitra

Dynamic and results-driven SQL Server DBA with 17+ years of overall experience across Airline, Telecom, and Utility domains. Strong 5+ years of hands on experience in determining SQL Server installation prerequisites, Database server installation/upgradation, Database security, Planning appropriate backup and recovery models, Monthly windows and sql server patching, Automated server & database health check reports. Significant working knowledge with AWS EC2, RDS, S3 and MySQL Aurora. My daily tasks involve: Backups (checking job history) • Full: Complete DB copy • Differential: Changes since last full backup • T-Log: Enables point-in-time recovery Index Maintenance (job scheduled every WE) • Reorganise • Rebuild Statistics Update (job scheduled every WE) • Refresh stats to help the Query Optimizer choose efficient plans DB Integrity (job scheduled every WE) • Run DBCC CHECKDB to detect corruption History Cleanup • Clear old maintenance logs from msdb to reduce bloat Maintenance Cleanup • Delete outdated backups and reports to free space • Checking of active/unused branch- builds in AWS and tearing down as appropriate. Monitoring & Alerts • Track resource usage (CPU, disk, memory, I/O) • Set alerts for failures and critical thresholds - database health check reports Security & Patching • Review user permissions regularly • Apply OS/SQL Server updates and patches Data Management • Archive/Purge old data for performance • Shrink (if needed) cautiously, due to fragmentation risks - log files preferred Proven track record in leading DBA teams, managing complex database infrastructures and driving high availability and disaster recovery strategies. Strong focus on client satisfaction, employee engagement, and business value creation. Adept at stakeholder management, incident resolution, and process optimization in both cloud and on-premises environments. Leadership & Management Skills - Service Delivery Management – Goal setting, SLA monitoring, quality audits - Client Management – Incident handling, escalation point, stakeholder reporting - People Management – Team engagement, career path planning, performance counseling - Delivery Excellence – Trend analysis, productivity planning, compliance audits