Senior Database Administrator

CARET; San Diego (CA); Remote; USD 135,000 - 145,000; Full time

Job summary

An innovative firm is seeking a Senior Database Administrator to join their dynamic Cloud Engineering group. This remote position offers the chance to work with cutting-edge technology to support multiple RDBMS and NoSQL applications. You will play a pivotal role in ensuring data availability, integrity, and security while collaborating with cross-functional teams. The ideal candidate will have extensive experience in SQL Server management, performance tuning, and a strong understanding of database concepts. If you are looking to make a significant impact in a fast-paced environment, this opportunity is perfect for you.

Benefits

Flexible PTO

Summer Fridays

No meeting Fridays

Medical, Dental, Vision Coverage

Flexible Spending Account

Health Savings Account

401(k) match

Qualifications

• 7+ years of SQL Server DBA experience required.
• Expert in SQL Development and performance tuning.
• Familiar with Azure SQL and DevOps concepts.

Responsibilities

• Manage and optimize Microsoft SQL Databases.
• Collaborate with teams to enhance database performance.
• Automate routine database administration tasks.

Skills

SQL Development

Performance Tuning

Database Security

Data Integrity

C#

PowerShell

Python

NoSQL Databases

Data Modeling

Analytical Skills

Education

Bachelor's degree in Computer Science

Tools

Azure SQL

Query Store

Job description

Direct message the job poster from CARET

Recruitment Manager @ CARET | Talent Acquisition Leader, HR

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 ensuring data availability, data integrity and data security. Performing and automating routine database administration functions including database capacity planning, proactive 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 procedures 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 active 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.

Seniority level

• Associate

Employment type

• Full-time

Job function

• Information Technology
• Software Development

Referrals increase your chances of interviewing at CARET by 2x