Lead - Site Reliability Engineer (DBA)

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

• 9+ years of experience in database Administration, including at least 2-3 years in AWS or Azure cloud environments.
• 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
• Proficiency in performance tuning, query optimization, and troubleshooting skills.
• 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.