Senior Software Engineer - SQL

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?

• Design, develop, test, tune, release and maintain database components of Zenoti
• Monitor the production databases and fine tune the problematic queries/stored procedures
• Collaborate with a team of product managers, developers, and quality assurance engineers to release features
• Work in a team following agile development practices (SCRUM)
• Build usable software, released at high quality, runs at scale and is adopted by customers
• Learn to scale your features to handle 2x ~ 4x growth every year and manage code that has to deal with millions of records, and terabytes of data
• Be proud of what you work on, obsess about the quality of the work you produce

What skills do I need?

• 4+ years working experience with SQL Server 2012, 2014,2016 or 2019 in developing, implementing, tuning and supporting SQL server databases
• Expert knowledge of T-SQL in developing medium to complex SQL Scripts and database objects like Stored Procedures, triggers, functions, indexes, and views.
• Experience in solving performance problems, query tuning, and optimization.
• Experience in using Dynamic management Views and functions when troubleshooting database problems.
• knowledge of understanding SQL Execution Plans, Execution statistics.
• Strong logical, analytical and problem solving skills
• Excellent communication skills
• Can work in a fast paced, ever-changing environment.

Benefits

• Best in industry salary
• Comprehensive medical coverage for yourself and your immediate family
• An environment where wellbeing is high on priority – access to regular yoga, meditation, breathwork, nutrition counseling, stress management, inclusion of family for most benefit awareness building sessions
• Unlimited vacation
• Opportunities to be a part of a community and give back: Social activities are part of our culture; You can look forward to regular engagement, social work, community give-back initiatives

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.