10 Aug
|
Logic Hire Solutions
|
India
10 Aug
Logic Hire Solutions
India
Job Title: Lead SQL Infrastructure Engineer (Remote – US Eastern Time)
Location: 100% Remote (India-based)
Experience: 7+ Years (Minimum 5 years as a dedicated SQL Infra/DBA Lead)
Compensation: ₹10,00,000 – ₹15,00,000 per annum (Fixed, commensurate with skills)
Start Date: Immediate / Maximum 15 Days Notice
Website: www.logichire-ss.com
About LogicHire Staffing Solutions
LogicHire is a global technology staffing and solutions firm, connecting top-tier infrastructure talent with leading enterprises. We are hiring a Lead SQL Infrastructure Engineer on behalf of a prominent North American client. This is a strategic, high-impact role where you will own the entire SQL Server ecosystem and act as a technical authority for database reliability and automation.
Role Overview
This is not a traditional DBA role; it is a SQL Infrastructure Lead position. You will be the go-to expert for designing and maintaining high-availability clusters, troubleshooting the most complex linked server performance problems, and automating away manual toil.
You will work closely with US-based SRE, DevOps, and Engineering teams during Eastern Time hours, ensuring seamless 24x7 operational coverage for mission-critical databases.
Detailed Key Responsibilities
High Availability & Disaster Recovery Architecture (30%)
Architect, deploy, and manage enterprise-grade HA/DR solutions using Always On Availability Groups across multi-subnet, geo-redundant configurations.
Configure and troubleshoot Windows Server Failover Clustering (WSFC) , including quorum models, node evictions, and split-brain scenarios.
Own the disaster recovery strategy: define RPO/RTO objectives, design and execute automated DR drills, and maintain runbooks for regional failovers.
Manage and monitor Log Shipping and Transactional Replication topologies, resolving latency, blocking, and sync issues rapidly.
Linked Servers & Cross-Platform Connectivity (20%)
Architect complex, heterogeneous linked server environments connec
📌 Lead SQL Infrastructure Engineer (India)
🏢 Logic Hire Solutions
📍 India