Lead Database Reliability Engineer (SQL DBA) at Zenoti

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

05 Jul, 26

Salary

0.0

Posted On

06 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, AWS, Azure, SQL Server, Performance Tuning, Query Optimization, Transact-SQL, PowerShell, Cloud Architecture, Backup and Recovery, Disaster Recovery, SQL Sentry, Redgate, SolarWinds, New Relic, Troubleshooting

Industry

Software Development

Description

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 The Lead Database Administrator will work in the product Engineering team of Zenoti. We are seeking a highly skilled Database Administrator (DBA) with experience in both AWS & Azure Cloud environments to manage and optimize database instances. Looking for an expertise in cloud database architecture, performance tuning, security, backups, and troubleshooting within our cloud infrastructure. This role involves supporting critical database systems, ensuring high availability, and maintaining optimal performance for various database technologies hosted in the cloud. What will I be doing? Analyze and troubleshoot database performance issues, including slow-running queries, blocking, deadlocks, and resource contention. Implement proactive performance monitoring and alerting for critical thresholds. Perform query optimization, index analysis, and execution plan reviews to improve application performance. Monitor and fine-tune SQL Server instances for optimal resource utilization (CPU, memory, I/O, tempdb). Work with developers and architects to design efficient database structures and review SQL code for performance impacts. Proactively monitor performance using tools such as SQL Server Profiler, Extended Events, DMVs, and Performance Monitor. Tune and optimize SQL Server configurations (MAXDOP, cost threshold, memory settings, etc.) based on workload analysis. Perform periodic health checks and provide recommendations for performance improvements across environments. Collaborate with cross-functional teams to support production deployments, resolve performance incidents, and maintain SLAs. Strong working experience in both AWS and Azure Cloud environments Configure instances in the Cloud and monitoring the systems to ensure high levels of performance, availability, and security. Independently analyse, solve, and correct issues in real time providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes Support scheduled maintenance and release deployment activities Set up and manage monitoring tools (e.g., SQL Sentry, Redgate, SolarWinds, New Relic) and develop custom scripts/dashboards if necessary. What skills do I need? 8+ years of experience in database Administration, including at least 2-3 years in AWS or Azure cloud environments. Proficiency in performance tuning, query optimization, and troubleshooting skills. Strong proficiency in Transact-SQL (T-SQL) for scripting, automation, and troubleshooting. Exposure to third party tools to analyse and perform the database benchmarking Expertise in PowerShell scripting for Windows-based automation tasks. Exposure with SQL Server versions (2019+), Azure SQL Database, and Azure SQL Managed Instance is an added advantage Administer, configure, and maintain database Instances in Production environments Monitor database performance, identify bottlenecks, and optimize code to enhance performance in the cloud environment. Design backup and recovery strategies for databases, ensuring disaster recovery plans are in place and regularly tested in the cloud infrastructure. Manage the critical patch installations by ensuring minimal disruption and compatibility with cloud-based systems. Use various monitoring tools and third-party solutions to monitor Instance health checks, resolve issues, and respond to alerts in a timely manner. Create and maintain comprehensive documentation for database configurations, procedures, policies, and best practices in the Cloud environment. 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.

Responsibilities

The Lead Database Administrator will manage and optimize database instances within AWS and Azure cloud environments to ensure high availability and performance. Responsibilities include troubleshooting performance issues, implementing proactive monitoring, and collaborating with developers to design efficient database structures.