Kaseya

Staff Database Administrator

Kaseya

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Lead

Tech Stack

SQL

About the role

  • 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.
  • Collaborate with DBA, product development, and infrastructure operations staff to ensure that our software accurately stores and retrieves data.
  • Provide secondary support for each team member including 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.
Benefits
  • 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL Serverquery optimizationlockingblockingdeadlocksperformance tuningcolumnstore indexesrowstore indexesPowershellOLTP
Soft Skills
analytical thinkingclear documentationflexibilitydesire to learncommunication skillsproject managementproblem solvingcreativityteam collaborationchange management