Database Engineer

Dhruv Technology Solutions; Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Dhruv Technology Solutions is seeking a Database Engineer/SRE to manage self-hosted SQL Server Always On clusters, ensure high availability, and lead DR strategies across AWS and on-premises setups.

The role focuses on automation via PowerShell, Python, and Terraform, plus documentation and runbooks to ensure reliability and performance. Strong scripting and AWS familiarity are essential.

Qualifications

• 3–5 years in Database Engineering, SRE, or similar hybrid ops role.
• Deep understanding of self-hosted MS SQL Server Always On Clusters.
• DR concepts: switchover, failover, restoration activities.

Responsibilities

• Administer self-hosted Microsoft SQL Server Always On Clusters.
• Perform server-level DDL/DML, query tuning, and proactive maintenance to prevent outages.
• Design, plan, and execute high availability and DR across AWS RDS, Aurora, and self-hosted environments.
• Manage switchovers, failovers, and disaster recovery rebuilds with target RTO/RPO.
• Implement and oversee backup/recovery strategies for data integrity and continuity.
• Develop automation scripts using PowerShell and Python.
• Maintain Terraform scripts for cloud infra provisioning (EC2, VPC, S3).
• Implement and manage authentication and access controls using Active Directory and AWS IAM.
• Create and maintain comprehensive technical documentation, SOPs, and runbooks.
• Establish SLOs/SLIs for database performance and uptime.

Skills

Database engineering

Site Reliability Engineering

Automation

Scripting

Tools

Terraform

PowerShell

Python

AWS (RDS, Aurora, EC2, S3, IAM)

Job description

Key Responsibilities

Database Administration & Performance Optimization

• Administer self-hosted Microsoft SQL Server Always On Clusters.
• Execute advanced SQL concepts, including server-level DDL/DML operations, query performance tuning, and proactive maintenance to prevent outages.

High Availability & Disaster Recovery (HA/DR)

• Design, plan, and execute robust HA/DR strategies across RDS, Aurora, and self-hosted.
• Manage switchovers, failovers, and disaster recovery rebuilds with minimal recovery time objectives (RTO/RPO).

Backup & Recovery

• Implement and oversee bulletproof backup/recovery strategies to ensure data integrity and business continuity.

Automation & Infrastructure as Code (IaC)

• Develop and maintain automation scripts utilizing PowerShell and Python.
• Write, review, and maintain Terraform scripts for cloud infrastructure provisioning (EC2, VPC, S3, etc.).

Security & Access Management

• Implement and manage database authentication and access controls utilizing Active Directory (AD) and AWS IAM.

Observability & Documentation

• Author and maintain comprehensive technical documentation, Standard Operating Procedures (SOPs), and operational runbooks.
• Establish SLOs/SLIs for database performance and uptime.

Baseline Requirements

• Experience: 3 to 5 years in Database Engineering, Site Reliability Engineering, or a similar hybrid operations role.
• Database Expertise: Deep understanding of self-hosted Microsoft SQL Server Always On Clusters.
• Disaster Recovery: Proven experience with advanced DR concepts, including switchover, failover, and restoration activities.
• AWS Ecosystem: Strong working knowledge of RDS, Aurora, EC2, VPC, S3, Lambda, Step Functions, Systems Manager (SSM), Route 53, CloudWatch, and IAM.
• Scripting & Automation: Strong proficiency in PowerShell and Python.
• IaC: Solid experience writing and maintaining Terraform scripts.
• Security: Solid grasp of Active Directory (AD)-based authentication and access management concepts.

Preferred Qualifications

• Proven track record of supporting mission-critical production database environments.
• Hands-on exposure to broader automation and Infrastructure-as-Code (IaC) practices.
• Excellent troubleshooting and analytical problem-solving skills under pressure.
• Strong communication skills with the ability to collaborate across infrastructure, application, and