What are the responsibilities and job description for the Senior Database Administrator position at CARET?
Job Details
Description
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.
Responsibilities
- 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
Qualifications
- 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
Salary : $135,000 - $145,000
