MSSQL DBA
Certifications & Skills:ITIL Certified
SQL Server Database Administration (Versions 2012, 2014, 2016, 2019)
Hands-on experience with Azure Foundational Services, Data Management Services (Optional), and Cloud Awareness
PowerShell, Shell Scripting, Python (Optional)
Responsibilities:
MSSQL DBA (L2 Level):
End-to-end Physical Database Administration duties
Backup & Restore Management
Database Lifecycle Management (SQL Server Build, Version Upgrades, Patch Management, Decommissioning Activities)
Experience in writing T-SQL (Stored Procedures, Views, Tables, Triggers, User-Defined Functions)
Hands-on experience with business continuity solutions such as Log Shipping, Database Mirroring, and SQL Always-On
Support Disaster Recovery (DR) Drills
Database Migrations (On-Premise, Azure Cloud)
Database Maintenance (Index Management, Statistics Management, Database Refresh, Cloning)
SQL Server Agent Management
Experience in handling performance issues related to capacity management, performance tuning (Locking, Blocking, Deadlocks)
Trend Analysis, Reporting & Auditing
Security Implementation: Database Encryption (TDE / Always-Encrypted), Role-Based Access Control, Linked Servers
Keyskills: Ms Sql Server Administration SQL Server Ms Sql Database Backup Dba Skills ITIL