Sql Dba Consultant

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

Job summary

Tekskills in Gurugram, India seeks a skilled SQL Server DBA with 5+ years of relevant experience. You will handle database design, performance tuning, and HA configurations, while automating DB tasks with Shell/PowerShell and Ansible.

The role requires strong troubleshooting, security awareness, and the ability to coordinate across distributed environments. Join a team that values proactive optimization and reliable data infrastructure, with opportunities to lead improvements in backup,

Qualifications

• 5+ years of technology experience with increasing scope in software or database roles.
• Expertise in SQL Server across versions 2005–2019.
• Experience in database design, administration and maintenance in distributed environments.
• Strong troubleshooting, performance tuning and capacity planning for databases.
• Solid understanding of programming languages, clustering, backup/restore, replication and security.
• Ability to translate requirements into optimized SQL code for developers.
• Shell, batch, or PowerShell scripting to automate DB tasks.
• Familiar with Ansible for automation.
• SQL Server installations and high availability configurations.
• SQL Server patching, troubleshooting and upgrades.

Skills

SQL Server

Database design

Performance tuning

Troubleshooting

Scripting (Shell/PowerShell)

Automation with Ansible

High availability

Backup/Restore

Security

Tools

Shell scripting

PowerShell

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