Shreemahathma H D

MSSQL Database Administrator with 4.6+ years of experience in Microsoft SQL Server administration. Proficient in database migrations, backup and recovery, High Availability and Disaster Recovery (HA/DR), database security, performance monitoring, Ansible automation, and Azure SQL Managed Instance migrations. Skilled in performance tuning, troubleshooting, SOX compliance, vulnerability remediation, and incident and change management.

Worked with application, infrastructure, and support teams to maintain database availability, stability, and SLA compliance.

System Engineer | MSSQL Database Administrator at Tata Consultancy Services Limited (2022-01 – Present)

• Administer Microsoft SQL Server 2012, 2016, 2017, 2019, and 2022 production environments.
• Install, configure, upgrade, patch, and maintain SQL Server instances supporting Always On Availability Groups, backup and recovery, and disaster recovery solutions.
• Perform SQL Server version upgrades, edition upgrades, server refresh activities, and on-premises to Azure SQL Managed Instance migrations, including planning, validation, cutover, and post-migration support.
• Manage database security, including logins, users, roles, permissions, Transparent Data Encryption (TDE), Change Data Capture (CDC), and database triggers for audit, privileged access monitoring, SOX compliance, and organizational security standards.
• Apply Service Packs, Cumulative Updates, security patches, and vulnerability remediation based on Tenable reports and approved change management processes.
• Configure and maintain SQL Server Agent Jobs, Database Mail, Alerts, Maintenance Plans, backups, restores, DBCC CHECKDB, statistics updates, and routine database health checks.
• Monitor SQL Server performance using SolarWinds DPA, DX UIM, Dynamic Management Views (DMVs), and native SQL Server tools to identify performance bottlenecks and optimize resource utilization.
• Troubleshoot blocking, deadlocks, TempDB utilization, query performance, index fragmentation, backup and restore failures, SQL Server Agent job failures, SSIS/SSRS issues, and disk space alerts.
• Perform query optimization, execution plan analysis, indexing, and database performance tuning to maintain database availability and performance.
• Automate routine DBA activities, health checks, password resets, service management, and pre- and post-patching validation using Ansible, PowerShell, T-SQL, YAML playbooks, Linux CLI, and Automation Controller.
• Support production incidents, change requests (CRQs), scheduled maintenance, root cause analysis (RCA), and on-call support following ITIL practices.
• Create SOPs, operational documentation, knowledge articles, database health check procedures, and migration runbooks to support production operations.

Bachelor's degree in Electronics and Communication Engineering – Don Bosco Institute of Technology, Bengaluru (2017-08 – 2021-08)