Senior Database Administrator

5 - 7 years

7 - 9 Lacs

Posted:1 day ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

  • Install, configure, patch, and harden Microsoft SQL Server across on prem, Azure (Azure SQL Database, Azure SQL Managed Instance), and AWS (SQL Server on EC2, Amazon RDS for SQL Server).
  • Manage and monitor database performance, integrity, capacity, and security; execute routine maintenance (backups/restores, index and statistics maintenance).
  • Drive T SQL tuning and workload optimization (execution plans, indexing strategies, Query Store, wait statistics, Extended Events); partner with developers to improve schema and SQL patterns.
  • Design, implement, and regularly test HA/DR solutions: Always On availability groups, Log Shipping, Azure Geo Replication; leverage AWS Multi AZ for RDS and EC2 based failover patterns; document automated runbooks aligned to RPO/RTO targets.
  • Plan and execute migrations on prem Azure AWS with minimal downtime using DMA/Azure Migrate, AWS Database Migration Service (DMS), and Schema Conversion Tool (SCT).
  • Implement secure, durable backup/restore and retention strategies using Azure Backup/Blob Storage and AWS S3/AWS Backup; apply encryption and lifecycle policies for long term archives.
  • Automate administrative tasks and guardrails with PowerShell, SQL Agent, Azure Automation, AWS Systems Manager (SSM), and Lambda; codify infrastructure with Terraform/CloudFormation.
  • Establish proactive observability and alerting using Azure Monitor/Log Analytics and AWS CloudWatch/CloudTrail, plus third party suites (Splunk, SolarWinds/SentryOne, ScienceLogic or similar).
  • Ensure compliance with governance and security standards: RBAC/least privilege, TDE/Always Encrypted, Auditing, data masking; integrate with IAM/Azure AD, KMS/Key Vault, Secrets Manager/Key Vault.
  • Participate in 24 7 operations/on call rotation, respond to incidents, perform RCA, implement preventive improvements; maintain up to date documentation (architecture, SOPs, runbooks).
  • Contribute to capacity planning and cost optimization across Azure and AWS (instance/storage rightsizing, IOPS tiers, storage auto scaling, licensing posture, environment scheduling).

Qualifications

Required:

  • 5+ years of experience as a SQL Server DBA in production environments.
  • Deep knowledge of SQL Server architecture and internals; hands on with versions 2016 2022 (or later).
  • Proven experience with both on prem SQL Server and cloud platforms: Azure (Azure SQL Database, Managed Instance) and AWS (SQL Server on EC2, Amazon RDS for SQL Server).
  • Expertise in backup/restore, HA/DR design and testing (Always On, Log Shipping, Azure Geo Replication; Multi AZ patterns on AWS).
  • Strong T SQL scripting and performance tuning skills (execution plans, indexing strategies, Query Store, wait statistics, Extended Events).
  • Operational proficiency with Azure Portal/Monitor and AWS Console/CloudWatch; experience with automation tools (PowerShell, Azure Automation, AWS Systems Manager, Lambda).
  • Working knowledge of security controls: RBAC/least privilege, encryption at rest/in transit (TDE, Always Encrypted), auditing; practical use of IAM/Azure AD, KMS/Key Vault, Secrets Manager.
  • Hands on with cloud and platform migrations (DMA, Azure Migrate, AWS DMS/SCT) and version upgrades.
  • Familiarity with monitoring/administration toolsets such as Splunk, SolarWinds/SentryOne, or similar.
  • Clear communication, documentation discipline, and collaboration with cross functional teams; comfort with ITIL aligned incident/request/problem processes and on call support.

Nice to Have:

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Endava logo
Endava

Information Technology and Services

London

RecommendedJobs for You

sector-1 greater noida po, noida, uttar pradesh

hyderabad, telangana, india