PROFESSIONAL SUMMARY
Senior Database Administrator with 19 years of MS SQL expertise, specializing in performance tuning, high availability, and robust disaster recovery. Proven record of managing large-scale VLDBs (10TB+), optimizing queries, and implementing secure, automated solutions with T-SQL and PowerShell. Experienced in data archiving, replication, and cost-effective Azure cloud migrations while consistently ensuring 99.99% uptime.
KEY SKILLS & EXPERTISE
- Cloud Technologies: Azure SQL
- DevOps & CI/CD Integration: Streamlining deployment processes, reducing errors
- Team Leadership & Mentorship: Managing DBA & Dev Teams, Training
- ETL & Data Warehousing: SSIS, Tableau, Power BI, Large-Scale Data Processing
- Automation & Monitoring: PowerShell, XEvents, SQL Sentry, SolarWinds, T-SQL Scripting
- Database Administration & Certification: MS SQL Database Administration, SQL Server Management Studio (SSMS), MS Certified Azure
- Database Performance Tuning & Optimization: VLDBs, Indexing, Query Optimization, Performance Tuning
- Advanced Query Performance Tuning: Execution Plans, Index Optimization, Partitioning, Parameter Sniffing Reduction
- High Availability & Disaster Recovery: AlwaysOn, Replication, Backup & Recovery, High Availability Configurations, Disaster Recovery Planning, Data Archiving
- Database Security & Compliance: Encryption, PHI Data Protection, Auditing, Database Security Best Practices, User Access Control
LogixHealth Solutions Private Limited Jan 2015 - Feb 2025
DB Architect Bangalore, India
- Optimized query performance, reducing execution times by 40% and improving system response times to under 1 second for 2000+ concurrent users.
- Designed data archiving and partitioning strategies, improving storage efficiency and retrieval speeds.
- Analyzed execution plans and optimized indexes, reducing query costs and enhancing response times.
- Partitioned large tables, significantly enhancing read/write operations and reducing maintenance overhead.
- Developed automation scripts for monitoring server health, deadlocks, and database growth using PowerShell.
- Led a team of 8 DBAs and SQL developers, managing 39 production servers and 100+ non-prod servers.
- Implemented Buffer Pool Extension (BPE), increasing DML performance by 30%.
- Implemented DevOps pipelines, reducing database deployment time by 50% and enhancing release quality.
- Resolved parameter sniffing issues, increasing query performance consistency across production environments.
BLUE STAR INFOTECH Sep 2012 - Dec 2014
SQL Developer Bangalore, India
- Focused on query performance tuning, reducing report generation times by 60%.
- Performed detailed indexing analysis, identifying and removing redundant indexes to optimize storage.
- Refactored complex queries, reducing CPU load and improving execution speeds by 35%.
- Integrated disaster recovery planning, aligning with IT infrastructure standards.
- Assisted in SQL Server upgrades and migrations, ensuring minimal downtime during transitions.
- Adopted Agile methodologies, improving database project management and team productivity by 30%.
SeventyMM PVT Jul 2008 - Aug 2012
Senior Database administrator Bangalore, India
- Created and automated maintenance scripts with SSIS that decreased manual intervention by 50%
- Developed and executed comprehensive indexing strategies that increased query performance by 35%, resulting in faster data retrieval and enhanced overall system efficiency.
- Provided around-the-clock production support to maintain database performance and availability, achieving 99.98% uptime by proactively addressing issues and implementing efficient solutions.
CERTIFICATIONS & EDUCATION
- Microsoft® Azure Data Fundamentals (DP-900): Scored 80%
- Masters – MBA & MCom.
KEY ACHIEVEMENTS
- Scalability & Performance: Optimized Very Large databases (VLDBs) exceeding 10TB, achieving <1 second response times for 2000+ concurrent users
- High-Availability Solutions: Successfully implemented AlwaysOn and Transactional Replication, ensuring 99.99% uptime for mission-critical systems
- Automation Excellence: Automated daily performance and security Reports using PowerShell and XEvents, reducing manual effort by 50%.
- Team Leadership: Mentored and trained 8+ team members, fostering a culture of continuous learning and excellence.
- Agile Methodologies: Championed agile methodologies for database projects, improving delivery timelines by 30%.