Lead - SQL Server

Zenoti provides an all-in-one, cloud-based software solution for the beauty and wellness industry. Our solution allows users to seamlessly manage every aspect of the business in a comprehensive mobile solution : online appointment bookings, POS, CRM, employee management, inventory management, built-in marketing programs and more. Zenoti helps clients streamline their systems and reduce costs, while simultaneously improving customer retention and spending. Our platform is engineered for reliability and scale and harnesses the power of enterprise-level technology for businesses of all sizes

Zenoti powers more than 30,000 salons, spas, medspas and fitness studios in over 50 countries. This includes a vast portfolio of global brands, such as European Wax Center, Hand & Stone, Massage Heights, Rush Hair & Beauty, Sono Bello, Profile by Sanford, Hair Cuttery, CorePower Yoga and TONI&GUY.

Our recent accomplishments include surpassing a $1 billion unicorn valuation, being named Next Tech Titan by GeekWire, raising an $80 million investment from TPG, ranking as the 316th fastest-growing company in North America on Deloitte's 2020 Technology Fast 500™. We are also proud to be recognized as a Great Place to Work CertifiedTM for 2021-2022 as this reaffirms our commitment to empowering people to feel good and find their greatness. To learn more about Zenoti visit : https : / / www.zenoti.com

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

Why Zenoti

Zenoti provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Skills Required

Performance Monitor, Sql Server, Performance Tuning, Capacity Planning, Profiler, Azure, performance benchmarking , Aws