About the job Intermediate SQL Administrator
Intermediate SQL Administrator
ROLE AND RESPONSIBILITIES
- Database Administration and Maintenance: Overseeing the installation, configuration, and ongoing maintenance of SQL Server instances, including patching, updates, and regular health checks.
- Performance Tuning and Optimization: Monitoring database performance, identifying bottlenecks, and implementing solutions such as index optimization, query tuning, and capacity planning to ensure efficient data flow and application responsiveness.
- High Availability and Disaster Recovery: Designing, implementing, and managing high availability solutions (e.g., AlwaysOn Availability Groups, replication, log shipping) and disaster recovery strategies, including regular backups, restores, and recovery plan testing.
- Security and Compliance: Enforcing database security policies, managing user acce...