SQL Server DBA

Overview

Remote
Depends on Experience
Contract - W2
Contract - Independent

Skills

DBA
SQL
T-SQL

Job Details

SQL Server DBA Remote
1. Core SQL Server Administration 20%
- Installation & Configuration
- Maintenance Plans
- Database Properties & Options
2. T-SQL Development 20%
- Complex Stored Procedures
- Window Functions
- Dynamic SQL
- Error Handling
3. Performance Tuning & Optimization 20%
- Index Tuning
- Execution Plans
- Query Rewrites
- Extended Events
4. Backup / Restore / DR Planning 15%
- Backup strategies
- Restore scenarios
- Point-in-time recovery
5. Monitoring & Alerting 10%
- DMVs
- RedGate / Quest / SolarWinds
- Custom monitoring scripts
6. PowerShell / Automation 10%
- PowerShell scripting
- Automating maintenance / monitoring
- Integrating with SQL Agent jobs
7. DevOps / CI/CD Awareness 5%
- Experience with Flyway / Liquibase
- Schema versioning
- Git integration for DB code
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.