Sql Dba

Tekskills; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tekskills in India is seeking an experienced SQL Server DBA to manage and optimize database infrastructure. The role focuses on installations, high availability, performance tuning, and capacity planning across distributed environments.

You will design, administer, and maintain SQL Server databases (2005–2019), build automation scripts, and collaborate with developers to translate requirements into efficient DB solutions.

Qualifications

• 5+ years of technology experience across software and databases.
• Expertise in SQL Server versions 2005–2019.
• Experience with database design, admin, and distributed environments.
• Strong troubleshooting, performance tuning, and capacity planning.

Responsibilities

• Expertise in SQL Server installations and high availability configuration.
• Troubleshoot and resolve database issues with performance tuning.
• Design, administer, and maintain databases in distributed environments.
• Write SQL queries to support developers and automate DB jobs.
• Write Shell, Batch, or PowerShell scripts to automate DB tasks.
• Familiar with Ansible for automating DB operations.

Skills

SQL Server versions 2005-2019

Database design

Performance tuning

High availability

DB upgrades

Scripting (Shell/PowerShell)

Automation (Ansible)

Troubleshooting

Security

SQL coding

Tools

Ansible

PowerShell

Batch scripting

Shell scripting

Job description

Role & responsibilities

• 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