Logic Hire Solutions LTD
Website:
logichire-ss.com
Job details:
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,
DbUp
Cloud & 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 flexible 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
Click on Apply to know more.
