SQL Database Administrator

Requirements:

• Database Administration Backup & Recovery:
• Required. 3–5 years - Implement native, cloud-native, and hybrid cross-site
• backup and recovery strategies. Installation & Configuration:
• Required. 3–5 years - Configure SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.

Security & Compliance:

• Required. 3–5 years.
• Enforce data masking, encryption (TDE), and Row-Level
• Security for internal customers.

Database Maintenance:

• Required. 3–5 years. Manage automated indexing, statistics, and integrity checks
• across fragmented environments.

PowerShell / CLI Automation:

• Required. 2–3 years. Automate hybrid environment
• configuration using PowerShell, dba tools, and Cloud CLIs.

Performance Tuning & Monitoring Hybrid Performance Monitoring:

• Required. 2–3 years. Analyze metrics across physical servers, IaaS VMs, and PaaS endpoints.
• Query & Index Optimization: Required. 3–5 years. Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.

Hybrid Infrastructure Management:

• Required. 2–3 years.
• Manage connectivity between on-premises SQL Servers and cloud environments.

Azure SQL / AWS RDS/GCS:

• Required. 2–3 years.
• Configure Azure SQL Database, Managed Instances, or AWS RDS SQL Server.

Cloud Migration:

• Preferred. 1–2 years.
• Move workloads from on premises to cloud using Azure Database Migration Service or AWS SMS.

CI/CD & Database Versioning:

• Preferred. 1–2 years.
• Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.