DBA Key Responsibilities:

•⁠ ⁠Database Administration

•⁠ ⁠Administer and maintain Microsoft SQL Server databases in production environments.

•⁠ ⁠Configure, manage, and monitor database backups, including:

•⁠ ⁠Full Backups

•⁠ ⁠Differential Backups

•⁠ ⁠Transaction Log Backups

•⁠ ⁠Create and maintain SQL Server Maintenance Plans.

•⁠ ⁠Ensure database availability, integrity, and optimal performance.

•⁠ ⁠High Availability & Disaster Recovery

•⁠ ⁠Configure and administer SQL Server Always On Availability Groups.

•⁠ ⁠Monitor and troubleshoot high availability environments.

•⁠ ⁠Support disaster recovery strategies, including Log Shipping.

•⁠ ⁠Resolve replication and synchronization issues.

•⁠ ⁠Performance Monitoring & Optimization

•⁠ ⁠Monitor database health and performance using tools such as Redgate SQL Monitor/Dashboard.

•⁠ ⁠Identify and resolve:

•⁠ ⁠Long-running queries

•⁠ ⁠Deadlocks

•⁠ ⁠Blocking sessions

•⁠ ⁠Analyze and optimize query execution plans.

•⁠ ⁠Troubleshoot performance bottlenecks, including:

•⁠ ⁠Parameter Sniffing

•⁠ ⁠Query Optimization

•⁠ ⁠Execution Plan Analysis

•⁠ ⁠Index Optimization

•⁠ ⁠Database Maintenance

•⁠ ⁠Perform routine database maintenance activities, including:

•⁠ ⁠Updating Statistics

•⁠ ⁠Rebuilding/Reorganizing Indexes

•⁠ ⁠Database Integrity Checks

•⁠ ⁠Implement proactive maintenance strategies to maximize database performance and reliability.

•⁠ ⁠Security & Administration

•⁠ ⁠Manage database security and user access.

•⁠ ⁠Configure and maintain:

•⁠ ⁠User Permissions

•⁠ ⁠Roles

•⁠ ⁠Linked Servers

•⁠ ⁠Ensure adherence to database security best practices.

•⁠ ⁠Replication & Data Movement

•⁠ ⁠Configure and troubleshoot SQL Server Replication.

•⁠ ⁠Support Log Shipping implementations.

•⁠ ⁠Resolve replication failures and synchronization issues.

Skills & Qualifications:

•⁠ ⁠Strong experience as a Microsoft SQL Server Database Administrator.

•⁠ ⁠Extensive experience with:

 SQL Server Backup & Recovery

 SQL Server Maintenance Plans

 Always On Availability Groups

 SQL Server Replication

 Log Shipping

 Performance Monitoring & Tuning

 Query Optimization

 Execution Plan Analysis

 Parameter Sniffing

 Deadlock Analysis

 Index Management

 Statistics Maintenance

•⁠ ⁠Experience with Redgate SQL Monitor/Dashboard or similar database monitoring tools.