Senior Database Administrator

CARET; United States; Remote; USD 135,000 - 145,000; Full time

Job summary

A leading technology company is seeking a Senior Database Administrator to manage Microsoft SQL Databases in a remote setting. The role involves ensuring data availability, integrity, and security while collaborating with engineering teams. Ideal candidates will have extensive SQL DBA experience and strong problem-solving skills. Benefits include flexible PTO and comprehensive health coverage.

Benefits

Flexible PTO

Summer Fridays

No meeting Fridays

Medical, Dental, Vision, and Supplemental Coverage

401(k) match

Qualifications

• 7+ years of SQL Server DBA experience.
• Expertise in SQL development and troubleshooting.

Responsibilities

• Monitor database performance and implement optimization strategies.
• Develop and implement stored procedures and functions.
• Collaborate with development teams to optimize SQL queries.

Skills

SQL development

Performance tuning

Problem-solving

Communication

PowerShell scripting

Education

Bachelor’s degree in Computer Science

Tools

Azure SQL

SSIS

C#

Python

NoSQL

Job description

Description

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 ensuring data availability, integrity, and security. Your duties include routine database administration functions such as capacity planning, performance monitoring and tuning, security procedures, and backup and recovery processes.

Requirements

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

• Monitor database performance, identify bottlenecks, and implement optimization strategies
• Develop and implement stored procedures and functions
• Collaborate with development teams to optimize SQL queries and stored procedures
• Perform database design, data modeling, and schema management
• Conduct database maintenance and management
• Design and develop data archiving strategies
• Develop key performance metrics to track data archiving progress
• Educate developers on database development best practices
• Familiarity with programming languages like SSIS, C#, PowerShell, Python, SQL, and NoSQL databases

Required Skills/Abilities:

• Bachelor’s degree in Computer Science or equivalent experience
• 7+ years of SQL Server DBA experience
• Expertise in SQL development, troubleshooting, and performance tuning
• Knowledge of indexing, index management, and statistics
• Proficiency with Query Store or equivalent tools
• Experience with Azure SQL/Azure Elastic Pools in multi-tenancy environments
• Strong analytical and problem-solving skills
• Understanding of DevOps, including Azure DevOps
• PowerShell scripting skills
• Excellent communication skills
• Ability to thrive in a fast-paced environment

Benefits

• Flexible PTO
• Summer Fridays
• No meeting Fridays
• Medical, Dental, Vision, and Supplemental Coverage
• Flexible Spending and Health Savings Accounts
• 401(k) match

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

The compensation range is $135,000 - $145,000, depending on qualifications and market conditions. Compensation may include bonuses and merit increases based on performance.

#LI-Remote

#LI-ST1

#ProductsTech