Sql Database Administrator

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

Job summary

Tekskills in India is seeking an experienced Database Engineer to manage SQL Server environments across versions 2005–2019. The role requires 5+ years of technology experience with increasing scope and responsibility in distributed database administration, design and performance tuning.

Responsibilities include troubleshooting database issues, capacity planning, high availability configurations, patching and upgradation.

Qualifications

• 5+ years of technology experience with increasing scope and responsibility
• Expertise in SQL Server versions 2005–2019
• Experience with database design, administration and maintenance in distributed environments
• Troubleshooting and resolving database issues, including performance tuning and capacity planning
• Solid understanding of programming languages, clustering, backup/restore technologies, replication and security
• SQL coding to translate requirements to application developers
• Writing scripts to automate DB tasks (Shell, Batch, PowerShell)
• Familiar with automation tool Ansible
• SQL Server installations and High availability configuration
• SQL Server patching and troubleshooting
• SQL Server Upgradation

Responsibilities

• Experience with database design, administration and maintenance in distributed environments
• Troubleshooting and resolving database issues, including performance tuning and capacity planning
• Expertise in database design with understanding of clustering, backup/restore, replication and security
• Proficient in SQL coding to translate requirements to developers
• Write scripts to automate DB tasks (Shell, Batch, PowerShell)
• Familiar with Ansible and automation tools
• SQL Server installations and High availability configuration
• SQL Server patching and troubleshooting
• SQL Server Upgradation

Skills

SQL Server

Database design

Performance tuning

Troubleshooting

Shell scripting

PowerShell

Ansible

High availability

Upgradation

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