Lead Site Reliability Engineer - DBA

3 Months ago • 9 Years + • Devops

Job Summary

Job Description

The Lead Database Administrator will work in the product Engineering team of Zenoti. This role involves managing and optimizing database instances in AWS & Azure Cloud environments, supporting critical database systems, and ensuring high availability and optimal performance. Responsibilities include managing MSSQL, MongoDB and PostgreSQL database instances, configuring database servers, performance tuning, security implementation, backup and recovery strategies, and providing 24x7 on-call support. The role also involves working with development teams, creating documentation, and ensuring effective communication across teams. The candidate is expected to resolve issues in real-time.
Must have:
  • 9+ years of SQL Server Administration experience, including cloud environments.
  • Experience with SQL Server versions (2019+), Azure SQL Database, and Azure SQL Managed Instance.
  • Proficiency in SQL Server performance tuning, query optimization, and troubleshooting.
  • Expertise of MongoDB, PostgreSQL and Linux systems hosted in Production environments
  • Administer, configure, and maintain SQL Server Instances in Production environments
  • Monitor database performance, identify bottlenecks, and optimize code to enhance performance in the cloud environment.
  • Implement security policies and best practices to ensure data protection, encryption, access controls, and compliance.
  • Design backup and recovery strategies for SQL Server databases.
  • Set up high availability solutions including Always On Availability Groups, Failover Clustering, and Cloud-native services
  • Manage SQL Server updates and patches ensuring minimal disruption and compatibility with cloud-based systems.
  • Work with various services in both AWS and Azure cloud environments to manage and automate database operations.
  • Develop and implement automation scripts for regular maintenance tasks, performance monitoring, backups, and reporting.
  • Use various monitoring tools and third-party solutions to monitor Instance health checks, resolve issues, and respond to alerts in a timely manner.
  • Work closely with development teams to troubleshoot issues and ensure effective communication across teams.
  • Create and maintain comprehensive documentation for database configurations, procedures, policies, and best practices.
Good to have:
  • Expertise in setting up and managing high availability solutions like Always On Availability Groups and SQL Server Failover Clustering.
  • In-depth knowledge of various cloud services and tools (AWS Cloud watch, CloudTrail, S3, Azure Monitor, Azure Security Center, etc.).
  • Scripting skills in PowerShell, T-SQL, or Azure Automation for managing and automating tasks.
  • Familiarity with compliance, security standards (GDPR, HIPAA, etc.), and data privacy regulations.
  • Experience in working with Windows server and any relevant certifications will be an added advantage
  • Experience in database migration and hybrid cloud environments.

Job Details

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

 

 

What's the opportunity?

The Lead Database Administrator will work in the product Engineering team of Zenoti. We are seeking a highly skilled SQL Server 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?

  • Work in multi-technology environments managing MSSQL, MongoDB and PostgreSQL database instances in our mission-critical Production systems.
  • Configure database servers and monitoring of system performance 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
  • Assist developers with complex query tuning and schema refinement.
  • Provide 24x7 on-call support for critical production systems during outages.
  • Support scheduled maintenance and release deployment activities
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

 

What skills do I need?

 

  • 9+ years of experience in SQL Server Administration, including at least 2-3 years in AWS or Azure cloud environments.
  • Strong experience with SQL Server versions (2019+), Azure SQL Database, and Azure SQL Managed Instance.
  • Proficiency in SQL Server performance tuning, query optimization, and troubleshooting.
  • Expertise of MongoDB, PostgreSQL and Linux systems hosted in Production environments2
  • Administer, configure, and maintain SQL Server Instances in Production environments
  • Monitor database performance, identify bottlenecks, and optimize code to enhance performance in the cloud environment.
  • Implement security policies and best practices to ensure data protection, encryption, access controls, and compliance with organizational and regulatory standards.
  • Design backup and recovery strategies for SQL Server databases, ensuring disaster recovery plans are in place and regularly tested in the cloud infrastructure.
  • Set up high availability solutions including Always On Availability Groups, Failover Clustering, and Cloud-native services
  • Manage SQL Server updates and patches ensuring minimal disruption and compatibility with cloud-based systems.
  • Work with various services in both AWS and Azure cloud environments to manage and automate database operations.
  • Develop and implement automation scripts for regular maintenance tasks, performance monitoring, backups, and reporting using PowerShell, T-SQL, and Cloud infrastructure Automation.
  • Use various monitoring tools and third-party solutions to monitor Instance health checks, resolve issues, and respond to alerts in a timely manner.
  • Work closely with development teams to troubleshoot issues and ensure effective communication across teams.
  • Create and maintain comprehensive documentation for database configurations, procedures, policies, and best practices in the Cloud environment.
  • Expertise in setting up and managing high availability solutions like Always On Availability Groups and SQL Server Failover Clustering.
  • In-depth knowledge of various cloud services and tools (AWS Cloud watch, CloudTrail, S3, Azure Monitor, Azure Security Center, etc.).
  • Scripting skills in PowerShell, T-SQL, or Azure Automation for managing and automating tasks.
  • Familiarity with compliance, security standards (GDPR, HIPAA, etc.), and data privacy regulations.
  • Experience in working with Windows server and any relevant certifications will be an added advantage
  • Experience in database migration and hybrid cloud environments.

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.

Similar Jobs

Hawkeye Innovations - Match Operations Assistant

Hawkeye Innovations

Cologne, North Rhine-Westphalia, Germany (On-Site)
3 Months ago
Mindtickle - Manager, Tax and Compliance

Mindtickle

Pune, Maharashtra, India (Hybrid)
5 Months ago
lifechruh - Contracts Coordinator

lifechruh

Edmond, Oklahoma, United States (On-Site)
3 Months ago
Qube Cinema - Executive - Operations

Qube Cinema

Hyderabad, Telangana, India (On-Site)
2 Months ago
Tide - Partnerships Associate

Tide

Delhi, India (On-Site)
3 Weeks ago
InMobiInMobi - SDE III - Devops

InMobiInMobi

Bengaluru, Karnataka, India (On-Site)
10 Months ago
Electronic Arts - DevOps Engineer - CI Automation

Electronic Arts

Vancouver, British Columbia, Canada (Hybrid)
1 Month ago
Palo Alto Networks - Senior DevOps Engineer

Palo Alto Networks

Santa Clara, California, United States (On-Site)
2 Weeks ago
Amazon games  - Senior Solutions Architect

Amazon games

Seattle, Washington, United States (On-Site)
1 Month ago
bytedance - Software Engineer, SRE - Platform Services

bytedance

Seattle, Washington, United States (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

HCL Tech - Sr design lead emi/emc design, ams verif

HCL Tech

California, United States (On-Site)
2 Months ago
Xentrix studios - Animation – Junior Artist

Xentrix studios

India (On-Site)
9 Months ago
NBC Universal - Executive Producer

NBC Universal

Fort Worth, Texas, United States (On-Site)
2 Months ago
Epic Games - QA Engineer

Epic Games

(On-Site)
6 Months ago
Playtika - Games R&D-Production Support Team Leader

Playtika

Poland (Hybrid)
8 Months ago
world relief - Director of US External Engagement

world relief

Towson, Maryland, United States (Remote)
1 Month ago
PwC - Audit Senior Associate / Assistant Manager  - Trade, Industries & Services / US GAAP

PwC

Zürich, Zurich, Switzerland (On-Site)
10 Months ago
Maliyo Games - Development Lead

Maliyo Games

Nigeria (On-Site)
9 Months ago
Interactive Brokers - SIPP Senior Product Specialist

Interactive Brokers

London, England, United Kingdom (Hybrid)
2 Months ago
gitlab - Senior Developer Advocate

gitlab

India (Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

Mindtickle - Learning Consultant

Mindtickle

Pune, Maharashtra, India (Hybrid)
9 Months ago
Globalization Partners - Sr Manager, Software Engineering ( AI Domain)

Globalization Partners

India (Remote)
2 Months ago
frames store - TRACKER

frames store

Mumbai, Maharashtra, India (On-Site)
1 Year ago
Scanline VFX - Environment Supervisor

Scanline VFX

Hyderabad, Telangana, India (Hybrid)
1 Month ago
Paytm - Senior Associate - Talent Acquisition

Paytm

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Survay Monkey - Senior Software Engineer in Test I

Survay Monkey

Bengaluru, Karnataka, India (Hybrid)
3 Months ago
Nice - Specialist Cloud Devops Engineer

Nice

Pune, Maharashtra, India (Hybrid)
1 Month ago
NetBrain - Network Automation Engineer, POC Team

NetBrain

Hyderabad, Telangana, India (Hybrid)
1 Month ago
Mobiloitte - Android, Kotlin Tech Lead

Mobiloitte

New Delhi, Delhi, India (Remote)
2 Months ago
T systems - System Engineer

T systems

Bengaluru, Karnataka, India (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Devops Jobs

Grab - Lead Solution Engineer, Voice Systems

Grab

Pasig, Metro Manila, Philippines (On-Site)
2 Months ago
Mendix - Senior Presales Solution Architect

Mendix

Tokyo, Japan (On-Site)
2 Years ago
bytedance - Senior Software Engineer - Compute Infrastructure (Orchestration & Scheduling)

bytedance

Seattle, Washington, United States (On-Site)
3 Months ago
Pulse Point - Sr. K8s/Platform Engineer

Pulse Point

Navi Mumbai, Maharashtra, India (Remote)
5 Months ago
altoros - Senior DevOps Engineer

altoros

Portugal (Remote)
1 Year ago
datcroft - DEVOPS ENGINEER

datcroft

Voronezh, Voronezh Oblast, Russia (On-Site)
3 Months ago
Rackspace Technology - Azure Cloud Engineer II

Rackspace Technology

Gurugram, Haryana, India (Remote)
2 Months ago
Contentstack - Senior Engineer I - DevOps

Contentstack

Chennai, Tamil Nadu, India (Hybrid)
3 Months ago
velotio technologies  - Senior Automation Engineer

velotio technologies

Maharashtra, India (Remote)
3 Months ago
Salesforce - Lead Solution Engineer

Salesforce

London, England, United Kingdom (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Zenoti is a leading cloud-based, business software used by spas, salons and medi-spas. With our all-in-one solution, spa and salon managers are more easily able to manage all aspects of their business from managing their appointment book, billing through a POS, CRM, employee schedules and payroll, inventory, running marketing promotions, enabling online booking and online sales and more. Zenoti clients are also able to drive real business results, things like increasing the customer retention, customer spend and cutting down on cost.

Seattle, Washington, United States (On-Site)

Seattle, Washington, United States (On-Site)

Hyderabad, Telangana, India (On-Site)

Seattle, Washington, United States (On-Site)

Hyderabad, Telangana, India (On-Site)

Seattle, Washington, United States (On-Site)

Vancouver, British Columbia, Canada (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

View All Jobs

Get notified when new jobs are added by Zenoti

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug