Lead Database Reliability Engineer (SQL DBA)

Zenoti is seeking a highly skilled Lead Database Reliability Engineer (SQL DBA) to manage and optimize database instances in their cloud infrastructure. The role involves troubleshooting performance issues, implementing proactive performance monitoring, and collaborating with cross-functional teams to support production deployments and maintain SLAs.

Requirements

• 8+ years of experience in database Administration
• Proficiency in performance tuning, query optimization, and troubleshooting skills
• Strong proficiency in Transact-SQL (T-SQL) for scripting, automation, and troubleshooting
• Expertise in PowerShell scripting for Windows-based automation tasks
• 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