Database Operations Engineer (SQL Server & Azure DBA)

Role Description

Database Operations Engineer (DB Ops)

Location: Offshore

India Development Centers

Experience: 57 Years

Role Summary

We are seeking a motivated and detail-oriented Database Operations Engineer (DB Ops) to support database administration, monitoring, and operational activities across cloud and hybrid environments.

In this role, you will assist with database maintenance, performance monitoring, backup and recovery operations, incident management, and automation initiatives while collaborating closely with senior database engineers, application teams, and infrastructure teams.

The ideal candidate will have a solid foundation in database administration, Azure cloud technologies, and production support operations, along with a strong willingness to learn automation, DevOps, and cloud-native database technologies.

Key Responsibilities

Database Administration &

Operations

Support administration and maintenance of SQL Server, Azure SQL Database, PostgreSQL, and Azure Cosmos DB environments.Ensure database availability, reliability, and operational stability across Production, UAT, QA, and Development environments.Perform and monitor database backup, restore, and recovery activities.Execute routine database maintenance tasks, including index maintenance, statistics updates, consistency checks, and health assessments.Assist in database patching, upgrades, migrations, and environment refresh activities.Support database security administration, user access management, and compliance requirements.

Performance Monitoring &

Optimization

Monitor database performance and identify performance bottlenecks.Assist in troubleshooting blocking sessions, deadlocks, long-running queries, replication latency, and resource utilization issues.Support basic query tuning, indexing strategies, and performance optimization initiatives.Utilize monitoring and observability tools such as SentryOne, Dynatrace, and native database monitoring solutions to track database health and performance.

High Availability &

Disaster Recovery

Assist in implementing, maintaining, and monitoring High Availability (HA) and Disaster Recovery (DR) solutions.Gain exposure to technologies such as SQL Server Always On Availability Groups, replication, failover strategies, and backup validation processes.Participate in recovery testing and business continuity exercises.

Automation &

DevOps

Support automation of routine operational activities using PowerShell, Python, or similar scripting technologies.Assist with database deployment processes and CI/CD pipelines using Azure DevOps.Contribute to Infrastructure-as-Code (IaC) initiatives using Terraform and related tools.Support release management and deployment automation activities.

Incident &

Production Support

Participate in incident management, troubleshooting, and issue resolution activities.Perform initial root cause analysis (RCA) and escalate issues appropriately when required.Follow operational runbooks, standard operating procedures, and escalation processes.Participate in on-call support rotations and major incident management activities.Collaborate with application, infrastructure, and support teams to resolve production issues efficiently.

Documentation &

Process Improvement

Maintain and enhance operational documentation, knowledge articles, and runbooks.Contribute to continuous improvement initiatives aimed at increasing operational efficiency and reliability.Support implementation of best practices in database operations, monitoring, and automation.

Required Technical Skills

Database Platforms

Hands-on experience with:SQL ServerAzure SQL DatabasePostgreSQLAzure Cosmos DB

Database Administration

Database installation, configuration, and environment setup.Backup, restore, and recovery management.Understanding of High Availability (HA) and Disaster Recovery (DR) concepts.Exposure to SQL Server Always On Availability Groups and replication technologies.Performance tuning fundamentals and query optimization techniques.Indexing, statistics management, and execution plan analysis.Database security, user access control, and permissions management.

Automation &

DevOps

Scripting experience using PowerShell and/or Python.Exposure to Azure DevOps and CI/CD pipelines.Understanding of Terraform and Infrastructure-as-Code (IaC) principles.

Monitoring &

Observability

Experience with database monitoring and performance analysis tools.Exposure to:SentryOneDynatraceSQL Monitoring SolutionsDatabase health monitoring, ing, and reporting.Understanding of blocking, deadlock analysis, and replication monitoring.

Operating Systems &

Cloud Technologies

Windows Server administration fundamentals.Basic Linux administration knowledge.Understanding of Azure infrastructure services, including:Virtual MachinesStorage AccountsNetworkingFirewallsIIS

Troubleshooting

Strong analytical and troubleshooting skills.Ability to perform initial issue analysis and escalation.Basic understanding of application .