Sql Dba Consultant

Tekskills; Ghaziabad District; On-site; INR 1,100,000 - 1,700,000; Full time

Job summary

Tekskills in Ghaziabad, Uttar Pradesh, is seeking a senior SQL Server professional to lead database design, implementation and operations across distributed environments. You will drive performance tuning, high availability setups, and scalable backup/restore strategies.

The role requires 5+ years of deep SQL Server experience, strong scripting in PowerShell or Shell, and comfort working in a matrix tech environment.

Qualifications

• 5+ years of technology experience with SQL Server versions.
• Experience in database design, admin and maintenance.
• Strong troubleshooting and performance tuning skills.

Skills

SQL Server

DB design

Performance tuning

High availability

T-SQL scripting

PowerShell

Shell scripting

Ansible

Backup/restore

Replication

Security

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