Sql Dba

Tekskills; Faridabad District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Tekskills is seeking a seasoned SQL Server Database Administrator to manage complex SQL Server environments across multiple versions in Haryana, India. The role focuses on design, administration, performance tuning, and upgrade projects, with emphasis on HA configurations and automation.

The ideal candidate will demonstrate strong scripting skills (Shell, Batch, PowerShell) and experience in distributed databases, security, backup/restore, and capacity planning.

Qualifications

• 5+ years of technology experience with 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.

Responsibilities

• Role involves managing SQL Server databases across versions and environments.
• Design, implement, and maintain distributed database architectures.
• Troubleshoot and resolve DB issues, optimize performance, and plan capacity.

Skills

Database design

Database administration

Troubleshooting

Performance tuning

SQL coding

Shell scripting

PowerShell scripting

Batch scripting

Tools

SQL Server

Ansible

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