prasanna kumar

• Led SQL Server upgrades (2014 → 2016/2019/2022) and Azure cloud migrations, reducing
infrastructure costs by 18% through optimized resource allocation.
• Designed and implemented HA/DR architectures including AlwaysOn Availability Groups and
Azure SQL Active Geo-Replication, ensuring 99.99% uptime.
• Administered multi-terabyte OLTP databases, performing performance tuning, query
optimization.
• Migrated 30+ on-premises databases to Azure using DMS and bacpac files, enhancing
scalability and reducing latency by 25%.
• Implemented Transparent Data Encryption (TDE) and role-based security across 50+ SQL
instances in compliance with corporate IT security guidelines.
• Automated DB maintenance tasks (index rebuilds, statistics updates, backups) using
PowerShell and SQL Agent jobs.
• Provided 24×7 production support, resolving critical incidents (ServiceNow) with 98% SLA
compliance.
• Mentored junior DBAs on SQL Server internals, disaster recovery, and performance
troubleshooting.

• Administered SQL Server environments (2012-2019) covering installation, patching, upgrades,
performance tuning, and security.
• Executed database refreshes (Prod → Dev/QA) and maintained replication and log shipping for
high availability.
• Developed and maintained backup/recovery strategies using EMC DD Boost, ensuring 100%
data recoverability.
• Monitored and optimized database performance through index maintenance, statistics updates,
and proactive capacity planning.
• Implemented authentication, permissions, and role-based access control aligned with IT
security standards.
• Supported and validated disaster recovery procedures through regular DR drills.
• Authored SOPs for database operations, troubleshooting, and recovery documentation.
• Configured and maintained network components (firewalls, routers, load balancers, DNS) to
support database and ERP operations.
• Participated in DR drills and validated pre/post-patch server configurations for ERP and
database environments.