Senior Sql Database Administrator

7 years

0 Lacs

Posted:7 hours ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title: Senior SQL Server Database Administrator

Location: Patna, Bihar

Experience: 7+ Years

Employment Type: Full-Time

Work Mode: On-site


Role Overview


We are seeking a highly skilled and experienced SQL Server DBA to manage and optimize our database infrastructure. The ideal candidate will have deep expertise in backup strategies, failover mechanisms, transaction log management, performance tuning, replication, and disaster recovery, with hands-on experience in advanced SQL Server operations.


Key Responsibilities


  • Backup & Recovery: Design and maintain full, differential, and transaction log backups; ensure disaster recovery readiness.
  • Failover & High Availability: Configure and manage Always On Availability Groups, Log Shipping, and Failover Clustering.
  • Transaction Log Management: Monitor and troubleshoot log growth, VLFs, and reuse waits.
  • Advanced Operations: Handle VLDBs, automate tasks using PowerShell, and manage performance using DMVs and Query Store.
  • Deadlock Detection & Resolution: Capture deadlocks using Extended Events and resolve using indexing and query optimization.
  • Query Optimization: Analyze execution plans, tune slow queries, and implement indexing strategies.
  • Database Migration: Plan and execute migrations across versions and environments (on-prem to cloud).
  • Replication: Set up and maintain Transactional Replication, monitor agents, and troubleshoot sync issues.
  • Standby Server Management: Configure read-only standby environments using Log Shipping with WITH STANDBY.
  • Index Maintenance: Perform regular index rebuilds/reorganizations and update statistics.



Required Skills


  • Strong hands-on experience with SQL Server 2012/2016/2019/2022
  • Proficiency in T-SQL, SSMS, SQL Profiler, Extended Events
  • Experience with Always On AG, Log Shipping, Replication
  • Knowledge of PowerShell scripting and Azure SQL (preferred)
  • Familiarity with monitoring tools, alerts, and performance baselining
  • Excellent troubleshooting and documentation skills


Qualifications
  • Bachelor’s degree in Computer Science, Information Technology, or related field
  • Microsoft certifications (e.g., DP-300, MCSA SQL Server) preferred



What We Offer
  • Competitive salary and benefits
  • Opportunity to work on enterprise-grade systems
  • Growth path into cloud DBA and database architecture roles
  • Collaborative and learning-focused environment


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

RecommendedJobs for You

Mumbai Suburban, Navi Mumbai, Mumbai (All Areas)