Senior SQL DBA Associate

Jobtailor; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Jobtailor is seeking an experienced SQL DBA to manage SQL Server environments, implement high availability and disaster recovery, and collaborate with cross-functional teams to ensure data integrity and security. The role emphasizes performance tuning, automation, and proactive monitoring.

Ideal candidates bring 5+ years of SQL Server experience, strong English communication, and a track record of maintaining secure, scalable database systems in a Bengaluru-based setup.

Qualifications

• At least a Bachelor's degree.
• At least 5+ years of experience SQL DBA.
• Oral and written proficiency in English required.

Responsibilities

• Managing and optimizing SQL Server database environments to support seamless business operations.
• Implementing and configuring high availability and disaster recovery solutions to minimize downtime.
• Collaborating with developers and system administrators to enhance data integrity and security.
• Leading performance tuning initiatives using DMVs, execution plan analysis, and query optimization techniques.
• Designing and maintaining enterprise backup strategies and conducting disaster recovery drills.
• Configuring clustering, log shipping, and replication to support database replication and failover processes.
• Developing automation frameworks for indexing, stats updates, and health checks using scripting languages.
• Monitoring infrastructure performance and capacity to forecast growth and optimize resource utilization.
• Implementing security measures such as encryption, data masking, and role-based access control.
• Troubleshooting database incidents and conducting root cause analysis to improve system stability.
• Building and maintaining dashboards to report on database performance and uptime metrics.

Skills

SQL Server Database Management

High Availability Solutions

Disaster Recovery Implementation

Performance Tuning

Data Security Measures

Education

Bachelor's degree

Tools

DMVs

Execution Plan Analysis

Clustering

Log Shipping

Replication

Dashboards

Job description

• Managing and optimizing SQL Server database environments to support seamless business operations
• Implementing and configuring high availability and disaster recovery solutions to minimize downtime
• Collaborating with developers and system administrators to enhance data integrity and security
• Leading performance tuning initiatives using DMVs, execution plan analysis, and query optimization techniques
• Designing and maintaining enterprise backup strategies and conducting disaster recovery drills
• Configuring clustering, log shipping, and replication to support database replication and failover processes
• Developing automation frameworks for indexing, stats updates, and health checks using scripting languages
• Monitoring infrastructure performance and capacity to forecast growth and optimize resource utilization
• Implementing security measures such as encryption, data masking, and role-based access control
• Troubleshooting database incidents and conducting root cause analysis to improve system stability
• Building and maintaining dashboards to report on database performance and uptime metrics

Requirements

• At least a Bachelor's degree
• At least 5+ years of experience SQL DBA
• Oral and written proficiency in English required

Core Competencies

Expertise in managing SQL Server database environments, implementing high availability and disaster recovery solutions, and optimizing performance through advanced tuning techniques. Proficient in developing automation frameworks and ensuring data security while collaborating effectively with cross-functional teams.

Highest-signal resume keywords

• SQL Server Database Management
• High Availability Solutions
• Disaster Recovery Implementation
• Performance Tuning
• Data Security Measures

Hard Skills

• SQL Server
• Performance Tuning
• Disaster Recovery
• Database Replication
• Query Optimization
• Scripting Languages
• Automation Frameworks
• Data Encryption
• Root Cause Analysis
• Health Checks

Soft Skills

• Collaboration
• Communication

Industry Keywords

• Database Integrity
• Capacity Monitoring
• Resource Utilization
• Data Masking
• Role-Based Access Control

Tools & Technologies

• DMVs
• Execution Plan Analysis
• Clustering
• Log Shipping
• Replication
• Dashboards