Staff Database Administrator

Kaseya® is the leading provider of complete IT infrastructure and security management solutions for Managed Service Providers (MSPs) and internal IT organizations worldwide powered by AI. Kaseya’s best-in-breed technologies allow organizations to efficiently manage and secure IT to drive sustained business success. Kaseya has achieved sustained, strong double-digit growth over the past several years and is backed by Insight Venture Partners www.insightpartners.com), a leading global private equity firm investing in high-growth technology and software companies that drive transformative change in the industries they serve.

Founded in 2000, Kaseya currently serves customers in over 20 countries across a wide variety of industries and manages over 15 million endpoints worldwide. To learn more about our company and our award-winning solutions, go to www.Kaseya.com and for more information on Kaseya’s culture.

Kaseya is not your typical company. We are not afraid to tell you exactly who we are and our expectations. The thousands of people that succeed at Kaseya are prepared to go above and beyond for the betterment of our customers.

The Staff Database Administrator works to ensure that the Autotask product provides its customers with the best user experience possible by ensuring predictability and efficiency of the SQL Server database tier.

This role collaborates with DBA, product development, and infrastructure operations staff to ensure that our software accurately stores and retrieves data.

One of the primary functions of this role will be to provide secondary support for each team member. This would include Operations, software releases, data warehousing, and patching

Requirements:

- Minimum 10 years working with SQL Server

- Hands on experience with modern versions of SQL Server database engine

- Demonstrated understanding locking, blocking, deadlocks including troubleshooting and performance tuning, monitor, and methods to employ on how to avoid them

- Demonstrated understanding of SQL Server's use of CPU, buffer cache, and I/O resources

- Demonstrated understanding of transaction isolation

- Demonstrated experience with query optimization and a variety of contention avoidance techniques

- Demonstrated experience managing columnstore and rowstore indexes

- Proficient with Powershell and scripting

- Demonstrated experience managing OLTP and OLAP workloads

- Ability to document complex tasks in a clear and concise manner

- Understanding and experience with HA solutions, specifically SQL failover clustering

- Ability to create, modify, and troubleshoot SQL agent jobs

- Experience owning and managing large projects and communicating to non-technical consumers

- Willingness to build and maintain a broad understanding of our software product, its data, and schema

- Ability to be flexible and have the desire to learn new technologies and team functions and support them. Stay educated on emerging technologies

- Analytical thinking – Proactive drive to improve team functions, automate repeatable processes, bring creative solutions to solve problems, improve existing processes

- Strong English communication skills allowing communication of complex subject matter in simple terms to mixed audiences

- Experience with change management as well as scheduling and managing maintenance windows

- Ability to support 99.99% (24x7x365) product uptime including an on-call rotation

Desirable (but not required):

- General understanding of networking, storage, DNS, and Kerberos authentication in a Windows environment

- Experience with Windows Server and domain environments

- Experience with large numbers of databases (10k+)

- Experience managing and backing up partitioned data

- Experience with SQL Server Reporting Services

Join the Kaseya growth rocket ship and see how we are #ChangingLives !

Additional information
Kaseya provides equal employment opportunity to all employees and applicants without regard to race, religion, age, ancestry, gender, sex, sexual orientation, national origin, citizenship status, physical or mental disability, veteran status, marital status, or any other characteristic protected by applicable law.