Sql Dba Consultant

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

Job summary

Tekskills is seeking a Senior Database Engineer with 5+ years of technology experience encompassing software development and database domains. You will work with SQL Server across versions 2005 through 2019, lead database design, administration, and maintenance in distributed environments, and drive performance improvements.

Responsibilities include troubleshooting, capacity planning, clustering, backup/restore, replication, and security.

Qualifications

• 5+ years of technology experience with increasing scope (software, database).
• Expertise in SQL Server across versions 2005-2019.
• Experience in distributed database design, admin and maintenance.
• Ability to troubleshoot performance issues and capacity planning.
• Understanding of clustering, backup/restore, replication and security.
• SQL coding to translate requirements to developers.
• Automation using scripting and SQL queries.
• Experience with Ansible and SQL Server HA/configuration.
• Experience in SQL Server patching, troubleshooting and upgrades.

Skills

SQL Server Expertise

Database design

Performance tuning

Troubleshooting

Tools

PowerShell

Shell scripting

Batch scripting

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