Experience: 5 – 8 years
Job Type: Full-time
Work Mode: Remote/Hybrid
Role Summary
The SQL Database Administrator will be responsible for managing, optimizing, and securing SQL Server and Azure SQL Database environments across production and non-production systems. This role ensures high availability, performance tuning, monitoring, automation, backups, and compliance with enterprise standards. The DBA will collaborate closely with development, DevOps, data engineering, and application teams to support business-critical systems.
Key Responsibilities
- Manage and maintain Azure SQL Database, SQL Server (on-prem & cloud), and SQL Managed Instances.
- Perform installation, configuration, patching, upgrades, and maintenance of database environments.
- Implement and manage backups, restores, disaster recovery, and high availability (Always On, Geo-replication, Failover Groups).
- Ensure optimal performance through indexing strategies, query tuning, statistics management, and resource optimization.
- Set up and manage monitoring via Azure Monitor, Log Analytics, SQL Profiler, Extended Events, and third-party tools.
- Proactively identify performance bottlenecks, slow queries, deadlocks, and long-running operations.
- Implement automated alerts and performance dashboards.
- Manage role-based access, authentication, encryption (TDE), vulnerability assessments, and auditing.
- Implement and enforce policies and best practices for data security, privacy, access controls, and compliance (e.g., GDPR, HIPAA, SOC2) and conduct periodic security reviews.
- Work with stakeholders to ensure metadata documentation, lineage tracking, data catalog, and data inventories are completed and maintained
- Automate routine DBA tasks using PowerShell, Azure CLI, T-SQL, ARM/Bicep templates, etc.
- Support CI/CD pipelines for database deployments.
- Manage schema migrations and maintain database version control.
- Work closely with developers for query optimization and schema design.
- Support DevOps and cloud engineering teams in database provisioning and infrastructure automation.
Qualifications:
- Strong experience with:
- Azure SQL Database, Azure SQL Managed Instance, SQL Server
- Query tuning and execution plan analysis
- Backup/Restore, HA/DR configurations
- PowerShell / scripting for automation
- Security configuration — encryption, audit, access control
- Database monitoring tools
- Understanding of Azure services: Azure Monitor, Key Vault, Storage Accounts, VNet Integration.
- Familiarity with DevOps practices (Azure DevOps, Git, pipelines).
- Excellent analytical and troubleshooting skills.
- Strong communication, documentation, and stakeholder coordination.