SQL DBA
Key Responsibilities:
Install, configure, and maintain SQL Server instances (2012/2016/2019/2022)
Monitor and optimize database performance, including tuning queries, indexes, and resource utilization
Ensure database availability, reliability, and disaster recovery readiness
Manage database backups, restores, and recovery procedures using tools like SQL Server Agent and third-party solutions
Implement and maintain high availability solutions (e.g., Always On Availability Groups, Log Shipping, Replication, Failover Clustering)
Plan and execute database upgrades, patches, and migrations
Ensure database security, including roles, permissions, encryption, and auditing
Develop and maintain automation scripts for database management using T-SQL, PowerShell, or SQLCMD
Collaborate with application developers, data analysts, and infrastructure teams
Document database environments, policies, and procedures