MS SQL DBA

Must Have Technical/Functional Skills

• Install, configure, upgrade, and maintain MS SQL Server instances.
• Monitor database performance and optimize queries, indexes, and execution plans.
• Implement and manage backup, restore, and disaster recovery strategies.
• Configure and maintain high availability (HA) and disaster recovery (DR) solutions

(Always On, Clustering, Log Shipping, Replication).

• Troubleshoot and resolve database issues, performance bottlenecks, and outages.
• Manage database security, access controls, and compliance with regulatory policies.
• Automate routine database administration tasks using T-SQL, PowerShell, or other scripting languages.
• Conduct database migrations, version upgrades, and patching with minimal downtime.
• Monitor system health, capacity planning, and resource utilization using SQL Server tools

and third-party monitoring solutions.

• Collaborate with developers and IT teams for query optimization, application performance,  

and database design improvements.

• Maintain database documentation, performance reports, and operational runbooks.