SQL Database Admin
Remote-friendly work environment based in India.ContractMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- Microsoft SQL ServerCI/CD
Requirements
- 5+ years of hands-on experience as a SQL Server DBA in enterprise environments.
- Strong expertise in SQL Server 2016/2019/2022 administration and optimization.
- Deep knowledge of Always On Availability Groups and Windows Server Failover Clustering (WSFC).
- Advanced T-SQL skills including development, tuning, and performance optimization.
- Experience with database partitioning, archiving strategies, and large-scale data management.
- Strong understanding of backup/recovery, disaster recovery planning, and point-in-time restoration.
- Knowledge of SQL Server security features including encryption, RBAC, auditing, and access control.
- Experience working with CI/CD pipelines for database deployments (e.g., Flyway, Liquibase, SSDT).
- Strong analytical and troubleshooting skills with ability to resolve complex performance issues.
- Excellent communication skills and ability to collaborate with development and infrastructure teams.
Responsibilities
- Design, configure, and maintain SQL Server Always On Availability Groups to ensure high availability and disaster recovery readiness.
- Manage Windows Server Failover Clustering (WSFC), quorum settings, and multi-subnet failover configurations.
- Monitor and optimize replication, failover performance, and overall database health across production systems.
- Develop and maintain backup and recovery strategies, including full, differential, log, and automated validation processes.
- Design, implement, and optimize T-SQL scripts, stored procedures, indexing strategies, and query performance tuning.
- Lead database performance optimization efforts by analyzing execution plans, statistics, and resolving bottlenecks.
- Implement database archiving, retention policies, and automated purge frameworks for large-scale datasets.
- Design and manage table partitioning strategies including sliding windows and partition switching for high-volume systems.
- Perform capacity planning, maintenance tasks, and optimization of storage, indexing, and filegroups.
- Ensure database security through roles, permissions, encryption, auditing, and compliance enforcement.
View Full Description & ApplyYou'll be redirected to the employer's site
