Sql Dba Consultant

Tekskills; Faridabad District; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

Tekskills in India is seeking an experienced SQL Server Database Administrator to manage complex distributed environments. You will design, implement and maintain database systems, optimize performance, and ensure data security and integrity across multiple servers.

The role requires 5+ years of deep DB experience, scripting for automation (PowerShell, Shell), and familiarity with Ansible, HA configurations, patching and upgrades.

Qualifications

• 5+ years of technology experience with increasing scope (e.g. software development, database).
• Expertise in SQL Server versions 2005, 2008, 2012, 2014, 2016, 2019.
• Experience in database design, administration and maintenance in distributed environments.
• Troubleshooting and resolving database issues, including performance tuning and capacity planning.
• Solid understanding of backup/restore, security, and clustering in SQL Server.
• Scripting to automate DB jobs (Shell/PowerShell/Batche s).
• Familiar with Ansible automation.
• SQL Server installations and High Availability configurations.
• SQL Server patching and upgrading.

Skills

Database administration

SQL optimization

Scripting (PowerShell/Batches)

Troubleshooting & performance tuning

Backup/Restore & security

Tools

SQL Server

Shell scripting

PowerShell

Batch scripting

Ansible

HA clustering

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