Job Description/Responsibilities

· Excellent understanding of SQL Server Technology (builds, upgrades, patching, migrations, troubleshooting multiple versions of SQL Server)

· Experience with automation using PowerShell or a scripting language is a must.

· Experience of SQL Server database administration in versions ranging from 2008 to current versions.

· Experience of configuring and administering log shipping, mirroring, clustering and Always On availability groups.

· Experience with SQL Transaction replication in complex environments.

· Performance Tuning: Deep understanding of query optimization, indexing strategies, and execution plans.

· Schema Design: Experience in logical and physical database design for enterprise applications.

· Monitoring & Troubleshooting: Hands-on experience with tools like OEM, SQL Profiler, pgAdmin, etc.

· Experience with SQL Performance Tuning and identifying the bottleneck.

· Experience in migrating server databases from on-premises environments to the public/private cloud.

· Excellent understanding of VMware and awareness of Cloud technology

· Excellent technical awareness of IT server infrastructure

· Working knowledge of tools, Ansible, Ivanti, Python.

· Must have excellent communication skills since working directly with the client is a significant requirement of this position.

· Must have deep understanding of AWS & Azure technologies related to SQL Server.

Skills

• Administration
• Communication
• Database
• Database Administration
• Database Design
• Monitoring
• SQL
• SQL Server
• Tools
• Troubleshooting