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 connecting SQL Server to Oracle, PostgreSQL, MySQL, and cloud-based data warehouses. Deeply troubleshoot sluggish cross-platform queries by analyzing distributed query execution plans, OLEDB/ODBC driver behaviors, and network latency. Harden linked server security through constrained delegation, Kerberos authentication, and principle of least privilege on outbound connections.

Maintain a stable catalog of linked servers, retiring unused links, standardizing provider strings, and documenting dependencies.

Performance

Tuning & Troubleshooting (25%)

Lead major incident response for database performance degradation; perform real-time RCA using DMVs, Query Store, Extended Events, and third-party monitors (Redgate, SolarWinds DPA, SentryOne). Analyze and refactor complex, slow-running queries, implement missing indexes, and resolve parameter sniffing/plan regression issues using Query Store plan forcing.



Conduct deep-dive Wait Statistics analysis to identify systemic bottlenecks (PAGELATCH, CXPACKET, THREADPOOL) and collaborate with storage/virtualization teams to resolve them.

Define and implement a proactive baseline for key metrics (Batch Requests/sec, Page Life Expectancy, CPU queue length) and alert before thresholds are breached. Automation, IaC & DevOps Enablement (15%)

Own the automation roadmap: remove all manual DBA tasks through PowerShell scripting, including instance builds, patching, configuration drift remediation, and backups health reporting.

Implement

Infrastructure-as-Code (IaC) patterns for database deployments using Terraform, Azure DevOps CI/CD pipelines, and database migration tools (Redgate Deploy, DbUp, or Flyway). Automate daily health reports using Brent Ozar’s First Responder Kit and native DMV queries, pushing results into monitoring dashboards. Drive self-service capabilities for development teams—automated environment refreshes, permission grants, and schema change deployments.

Security, Compliance & Lifecycle Management (10%)

Implement and manage database security controls: Transparent Data Encryption (TDE), Always Encrypted, column-level encryption, and robust auditing via SQL Server Audit and Extended Events. Lead version upgrades and migrations (SQL Server 2016 to 2019/2022) and lift-and-shift migrations to Azure SQL Managed Instance with minimal cutover windows.

Perform rigorous capacity planning: forecast storage, CPU, and memory growth; recommend right-sizing of instances and compute tiers.

Mandatory Technical

Stack &

• Tools TechnologiesSQL Platforms: SQL Server 2016, 2019, 2022 (Enterprise Edition)

• Azure SQL Managed Instance High Availability: Always On Availability Groups (multi-subnet), WSFC, Log Shipping, Replication Interoperability :Linked Servers (SQL-to-SQL, SQL-to-Oracle, SQL-to-PostgreSQL), OLEDB/ODBC providers, Kerberos delegation Scripting &

• AutomationPowerShell: (advanced: modules, DSC, dbatools, Invoke-SqlCmd), T-SQL, SQL Agent Jobs, Terraform Monitoring &

• Observability: Redgate SQL Monitor, SolarWinds DPA, Idera Diagnostic Manager, SentryOne, Brent Ozar First Responder Kit, PagerDuty/ServiceNow integration Performance Tuning: DMVs, Query Store, Extended Events, Execution Plan Analysis, sp_whoisactive, Ola Hallengren Maintenance Solution, Glenn Berry Diagnostic Scripts DevOps &

• CI/CD: Git, Azure DevOps (Repos/Pipelines), Octopus Deploy, Redgate SQL Change Automation, DbUpCloud &

• OS:



Windows Server 2019/2022 Core &

• GUI

• Azure Fundamentals (Compute, Storage, Networking, Azure AD) Storage &

• Networking: SAN/NAS concepts (Pure Storage, NetApp ONTAP), iSCSI, MPIO, network latency diagnosis (ping, tcping, Wireshark basics)Candidate Profile &

Requirements Essential Qualifications 7+ years of total IT experience, with at least 5 years focused exclusively on SQL Server Infrastructure/DBA. 2+ years in a Lead or Senior-most DBA role, serving as the final technical escalation point. Mastery of PowerShell for SQL Server automation—you must have scripts or modules you have authored and can discuss in detail. Proven, hands-on experience resolving a major linked server outage or performance meltdown in production.

Exceptional

English communication skills (C1/C2 proficiency level): you will be speaking on technical bridge calls, writing RCAs, and presenting architectural decisions to US-based stakeholders daily.

Work Overlap Commitment: Must be willing to work core hours overlapping with US Eastern Time Zone (typically 6:30 PM to 3:30 AM IST, exact schedule can be refined).

Ideal Candidate Traits Calm under Pressure: You have led war rooms during P1 outages and can clearly articulate the problem and path to resolution while coordinating across multiple teams.

Documentation Obsessed: You believe in runbooks, architecture diagrams, and leaving every system better documented than you found it.

Mentorship Mindset: You will indirectly guide junior DBAs and developers, reviewing their query designs and teaching performance tuning best practices. Multi-Platform Awareness: Experience administering PostgreSQL or MySQL is a strong plus, as the client's ecosystem is expanding.

Compensation & Benefits CTC: ₹10,00,000 – ₹15,00,000 per annum (All-inclusive Fixed).

Work Mode: 100% Remote (Permanent Work-from-Home from anywhere in India).

Equipment: Company-provided laptop/workstation.

Leaves: Standard Indian holidays plus a adaptable paid time off policy.

Growth: Direct mentorship from a US-based Principal Architect and opportunities to lead enterprise-scale cloud migration projects.

How to Apply If you are available to start immediately and meet the above criteria, we would love to hear from you. ? Website: www.logichire-ss.com

Subject Line: Application: Lead SQL Infrastructure Engineer – Attachments: Updated CV in PDF format. Please include a short summary in the body of your email detailing: Your total years of SQL Server Infrastructure experience. Your current PowerShell automation proficiency level (Beginner/Intermediate/Expert). Your earliest possible joining date. Your availability to work US Eastern Time Zone hours. LogicHire is an equal opportunity employer and values diversity in the workplace.

Skills: infrastructure,database,powershell,azure,sql server,sql,automation,devops

📌 Lead SQL Infrastructure Engineer (India)
🏢 Logic Hire Solutions
📍 India