MS SQL Server Administration
Teksands.ai
- Location
- India
- Job type
- Full-time
Required skills
- Python
- AWS
- Ansible
- Azure
- Bash
- capacity planning
- CI
- communication skills
- compliance
- configuration management
- containerization
- data modeling
- database
- Docker
- Kubernetes
- Root Cause Analysis
- server administration
- Splunk
- SQL
- PowerShell
About the role
Teksands.ai
Website:
teksands.ai
Job details:
What You’ll Do:
- Design, implement, and administer enterprise-grade database architectures for transactional and analytical workloads.
- Provide full lifecycle MS SQL Server administration, including installation, configuration, patching, version upgrades, and decommissioning.
- Support and automate database provisioning, schema management, configuration management, and upgrades through CI/CD pipelines across on-premises and cloud-native environments.
- Design, implement, and support High Availability and Disaster Recovery (HA/DR) solutions using Always On Availability Groups, Failover Cluster Instances, Log Shipping, and Replication.
- Implement and maintain backup, recovery, and data protection strategies, ensuring alignment with defined RPO/RTO and compliance standards.
- Support cloud database platforms such as Azure SQL Database, Azure SQL Managed Instances, and AWS RDS for SQL Server.
- Monitor and optimize database performance through query tuning, indexing strategies, execution plan analysis, and capacity planning.
- Implement observability, monitoring, and alerting for database health, performance, and availability using industry-standard tools.
- Troubleshoot complex database issues and perform root cause analysis to improve reliability and resilience.
- Participate in 24/7 on-call support rotation and contribute to operational excellence initiatives.
What You’ll Bring:
- Bachelor’s or master’s degree in computer science, Information Systems, or a related technical field.
- 4+ years of experience in database engineering and MS SQL Server administration in enterprise environments.
- Strong expertise in MS SQL Server full lifecycle support, including HA/DR, performance tuning, and security best practices.
- Hands-on experience with cloud database services (Azure and/or AWS).
- Working knowledge in scripting and automation using PowerShell, Python, and Ansible.
- Strong understanding of data modeling, indexing, partitioning, replication, and scalability concepts.
- Familiarity with containerization technologies (Docker, Kubernetes).
- Excellent analytical, troubleshooting, and communication skills.
Preferred Skills:
- Experience with Infrastructure as Code (IaC) practices and tools. Proficiency in Scripting language- Python/Bash/Shell.
- Exposure to observability platforms such as Prometheus, Grafana, Splunk, and Open Telemetry.
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.