Sql Dba

Tekskills; Greater Noida; On-site; INR 1,500,000 - 3,500,000; Full time

Job summary

Tekskills in India seeks a Senior SQL Server DBA with 5+ years of experience to manage SQL Server environments across versions 2005–2019. You will handle database design, administration in distributed setups, and performance tuning to support business applications.

You will troubleshoot issues, implement high availability, and automate DB tasks using PowerShell, Shell, and Ansible, collaborating with developers and operations to ensure reliability and security.

Qualifications

• 5+ years of technology experience with increasing scope and responsibility in software development or databases.
• Deep expertise in SQL Server across versions 2005–2019.
• Experience in distributed environment database design, admin and maintenance.
• Strong troubleshooting, performance tuning, capacity planning and security concepts.
• Proficient in SQL coding to optimize performance for developers.
• Experience writing scripts (PowerShell/Batch) to automate DB jobs; familiarity with Ansible.
• Knowledge of SQL Server HA configurations, patching and upgrades.

Responsibilities

• Manage SQL Server installations and high-availability configurations.
• Troubleshoot database issues and tune performance for capacity planning.
• Design and maintain distributed databases with security and backups.
• Translate requirements to application developers through SQL coding.
• Develop automation scripts to streamline DB-related tasks.
• Leverage Ansible for automation in production environments.

Skills

SQL Server expertise

Database design

Performance tuning

Troubleshooting

High availability

Scripting (PowerShell/Batch)

Automation tools (Ansible)

Patch management

Upgrades

Tools

Ansible

PowerShell

Shell scripting

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