Senior Database Administrator

CARET brings the latest in technology and automation to over 10,000 legal and accounting firms, empowering highly skilled professionals to refocus their expertise on what truly matters. CARET harnesses powerful and secure practice management, document automation, and payment processing to take firms, professionals, and their clients further.

Our team-defined values guide how we show up for each other, for our partners, and for our customers:

·       We succeed together.

·       We embrace progress.

·       We care big.

·       We create space.

Senior Database Administrator:

This is a remote position working for Caret Legal in the Cloud Engineering group supporting multiple RDBMS and NoSQL applications in the cloud and on premise.

As the Sr. DBA you will shape the direction of multiple products working closely with infrastructure, engineering and product teams. You will be responsible for providing and insuring data availability, data integrity and data security. Performing and automating routine database administration functions including database capacity planning, pro-active performance monitoring and tuning, executing security procedures and backup and recovery processes.

Requirements

This role is for a Sr. Database Administrator managing Microsoft SQL Databases and requires hands on MSSQL management, maintenance, performance tuning, and working closely with infrastructure and engineering teams. 

·       Monitor database, identify bottlenecks and implement optimization strategies to ensure optimal performance 

·       Develop and implement stored producers and functions 

·       Collaborate with development teams to optimize SQL queries, database code, and stored procedures 

·       Perform database design, data modeling and schema management to support application requirements and performance goals

·       Perform database maintenance and management

·       Identify, design, and develop data archiving strategies 

·       Develop and/or publish key performance metrics to track data archiving progress of activate initiatives 

·       Assist in educating developers on the finer points of database development 

·       Familiar with programming languages like SSIS, C# or other object-oriented languages, Powershell, Python, SQL, and NoSQL databases 

Required Skills/Abilities:

·       Bachelor’s degree in Computer Science or equivalent knowledge and experience of database concepts

·       7+ years of SQL Server DBA experience

·       Expert level skills in SQL Development with ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, constraints)

·       Expert knowledge in creating complex SQL queries, performance tuning and optimization, using native monitoring and troubleshooting tools

·       Expert knowledge of indexes, index management and statistics

·       Proficient with Query Store or equivalent tools

·       Knowledge of troubleshooting and resolving database integrity, blocking and deadlocking, performance, connectivity, and security issues

·       Ability to detect and troubleshoot SQL Server related I/O, memory, disk space, CPU, and other resource issues

·       Experience with Azure SQL/Azure Elastic Pools in a multi-tenancy environment

·       Understanding of monitoring concepts and tooling

·       Strong analytical and problem-solving ability

·       Understanding of DevOps concepts including Azure DevOps framework and tools

·       PowerShell scripting skills

·       Excellent verbal and written communication skills

·       Ability to excel in a fast-paced environment

Benefits

· Flexible PTO 

· Summer Fridays 

· No meeting Fridays 

· Medical, Dental, Paid Sick Days, Vision, and Supplemental Coverage 

· Flexible Spending Account 

· Health Savings Account 

· 401(k) match 

Equal Employment Opportunity: CARET is an Equal Opportunity, Affirmative Action Employer. 

The compensation information below is provided in compliance with job posting disclosure requirements. 

Pay range: $135,000 - $145,000 Actual base pay will depend on varying circumstances, including the position, location, individual qualifications, market finances, and other operations business needs. 

Depending on the position, compensation may also include commission, bonuses, etc. Potential for bonuses is based on company performance and potential for merit increases is based on performance.

#LI-Remote

#LI-ST1

#ProductsTech