Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in hyderabad
>
Zenoti
>
Lead - SQL Server

Lead - SQL Server

Zenoti

5 - 9 years

7 - 11 Lacs

hyderabad

Posted:3 weeks ago| Platform:

Apply

Skills Required

performance tuning jquery linux coding application development windows sql android crm python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Our products are built on Windows .NET and SQL Server and managed in AWS. Our web Ux stack is built on jQuery, and we use AngularJS. Our middle tier is in C#, and we build our infrastructure on an extensive set of Restful APIs. We build native iOS and Android apps using Flutter and Dart. Our platform infrastructure is built in .NET Core and deployed on RHEL Enterprise Linux using Docker and Kubernetes. We use Python extensively for data processing workloads and Tableau for analytics dashboards for select infrastructure components. We use Redshift, Aurora, Redis Elasticache, Lambda, and other AWS products to build and manage our complete service, moving towards serverless components. We deal with billions of API calls, millions of records in databases, and terabytes of data to be managed with all services we build that have to run 24x7 at 99.99% availability.

What will I be doing

Analyze, troubleshoot, and resolve complex performance issues across SQL Server instances.
Conduct query optimization and index tuning using execution plans, statistics, partitioning, and advanced performance techniques.
Design and maintain efficient indexing strategies (clustered, non-clustered, filtered, covering, and columnstore indexes).
Monitor, maintain, and fine-tune SQL Server instances for high availability and scalability.
Leverage SQL Server 2019 features.
Lead efforts on capacity planning, performance benchmarking, and stress testing.
Collaborate with application development teams to review queries and ensure performance-oriented coding standards.
Work with DBA teams to design high-performance backup, restore, replication, and disaster recovery solutions.
Leverage tools such as Profiler, Extended Events, DMVs, Query Store, and Performance Monitor to identify bottlenecks.
Stay current with new SQL Server features, cloud database offerings (Azure SQL, AWS RDS), and industry trends.

What skills do I need

7+ years of experience in managing SQL Server Database instances
Very Strong experience in SQL Server 2019
Experience in developing highly available, massively scalable, distributed database systems (preferably on AWS/Azure)
Very strong in Performance Tuning
Can work in a fast-paced, ever-changing, start-up environments
Strong logical, Analytical, and problem-solving skills
Excellent communication skills

More Jobs at Zenoti

Lead Motion Graphics Designer

Hyderabad, Telangana, India

5 - 8 yrs

Salary: Not disclosed

Senior Software Engineer

Hyderabad

4 - 9 yrs

INR 45 - 50 Lacs

Senior Software Engineer - QA Automation

Hyderabad

5 - 9 yrs

INR 10 - 15 Lacs

Product Specialist | Zenoti | Hyderabad

Hyderabad

1 - 6 yrs

INR 10 - 20 Lacs

Implementation Consultant | Zenoti - Hyderabad

Hyderabad

1.0 - 6.0 yrs

INR 8 - 18 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Zenoti

Technology / Software

Austin

Login to

Please Verify Your Phone or Email

Confirm Action

Lead - SQL Server