CARET Logo

CARET

Senior Database Administrator

Reposted 5 Days Ago
Remote
Hiring Remotely in United States
135K-145K Annually
Senior level
Remote
Hiring Remotely in United States
135K-145K Annually
Senior level
The Senior Database Administrator will manage and optimize SQL databases, ensuring data integrity and security while collaborating with engineering and development teams.
The summary above was generated by AI

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 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

Top Skills

Azure Sql
C#
Microsoft Sql
NoSQL
Powershell
Python
SQL
Ssis

Similar Jobs

Yesterday
Easy Apply
Remote or Hybrid
United States
Easy Apply
110K-146K
Senior level
110K-146K
Senior level
Cloud • Healthtech • Payments • Professional Services • Software • Analytics • Automation
The Senior Elastic Search Engineer will manage and optimize Elasticsearch clusters, design databases, and ensure data security, performance, and recovery protocols.
Top Skills: AWSC++ElasticsearchJavaMongoDBPython
Yesterday
Easy Apply
Remote or Hybrid
United States
Easy Apply
110K-146K
Senior level
110K-146K
Senior level
Cloud • Healthtech • Payments • Professional Services • Software • Analytics • Automation
The Senior Database Administrator will manage databases, ensure data security, optimize performance, monitor systems, and support development teams.
Top Skills: AWSC++JavaMs SqlMySQLOraclePostgresPythonSQLT-Sql
3 Days Ago
In-Office or Remote
Battle Creek, MI, USA
Senior level
Senior level
Information Technology • Consulting
Manage and administer databases, ensuring quality and security. Design and maintain complex database systems while advising users. Requires extensive experience with various database technologies.
Top Skills: JclMs AccessOraclePl SqlSQL Server

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account