Sql Dba Consultant

Tekskills; New Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tekskills is seeking an experienced Database Administrator specialized in SQL Server to manage distributed environments, ensure high availability, and drive performance improvements. The role involves designing databases, tuning queries, and scripting automated tasks to support enterprise applications.

The ideal candidate will bring 5+ years of SQL Server experience across multiple versions, strong troubleshooting skills, and a solid understanding of security and backup/restore strategies.

Qualifications

• Minimum 5+ years of technology experience with SQL Server across versions.
• Experience in database design, administration, and maintenance in distributed environments.
• Proven ability to troubleshoot DB issues, including performance tuning and capacity planning.
• Strong understanding of database design with knowledge of clustering, back-up/restore, replication, and security.
• Expertise in SQL coding to optimize performance and collaborate with developers.
• Experience scripting with Shell, Batch, or PowerShell and writing SQL queries to automate DB jobs.
• Familiarity with automation tools like Ansible.
• Expertise in SQL Server installations and high availability configurations.
• Experience patching and upgrading SQL Server versions.

Skills

SQL Server expertise

Database design

Performance tuning

Troubleshooting

High availability

SQL scripting

Ansible

Security

Backup/Restore

Tools

Ansible

Job description

Role & responsibilities

Required Qualifications

• 5+ years of technology experience of increasing scope and responsibility (e.g. software development, database) expertise in SQL Server 2005, 2008, 2012,2014,2016,2019
• Experience with database design, administration and maintenance in distributed environments
• Experience in troubleshooting and resolving database issues, including performance tuning and capacity planning.
• Proven expertise in database design, to include solid understanding of related programming languages, clustering, back-up/restore technologies, replication and security
• Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.
• Expertise in writing scripts such as Shell, batch, or PowerShell scripts, writing SQL queries to automate DB related jobs.
• Familiar with the automation tools like Ansible.
• Expertise in SQL Server installations and High availability configuration
• Expertise in SQL Server patching and troubleshooting
• Expertise in SQL Server Upgradation

Preferred Qualification

• Strong working knowledge of industry-standards database management tools.
• Demonstrated, successful experience working in a matrixed, multi-vendor technology environment.
• Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
• Strong written and verbal communication skills.

Preferred candidate profile