Sr. SQL Server DBA

About the Company -

Come work for a SaaS company that is a leader in the automotive repair industry and has the stability that only a 100+-year-old company can offer. We are Mitchell 1, a division of Snap-on Inc. For over 100 years, Mitchell 1 has been a leader in providing information solutions that simplify everyday tasks for automotive professionals, helping make their jobs easier.

Summary of position

The incumbent is responsible for managing, maintaining, and optimizing the performance of MarkLogic and SQL Server databases, ensuring data integrity, availability, and security by performing tasks like installation, configuration, backup management, performance tuning, troubleshooting, and implementing database security measures, while collaborating with application developers and IT operations to support critical business systems and is supervised by the Manager, IT Database Services.

This position is an in-office full-time role, Monday-Friday, that is located at the Mitchell 1 headquarters in the San Diego office.

Essential Roles/Responsibilities

Provide leadership in creating roadmaps and future state architecture of SQL Server platform, collaborating with stakeholders, product development, and business partners

Ensure performance, security, scalability, and availability of enterprise MarkLogic and SQL Server databases

Perform technical troubleshooting to diagnose, isolate and correct data and database issues

Research emerging trends and new technologies to identify potential improvements, anticipates issues and develops preventive measures

Collaborate with clients, service providers and peers to successfully deliver on business commitments

Design, implement, and monitor disaster recovery plans as it pertains to the production database environment

Identify high-load SQL statements, gather performance-related data, and identify and resolve missing, unused, and indexes that need enhancements

Configure and support high availability for SQL Server, to include clustering, replication, DB mirroring, and Availability Groups.

Create and implement best practices for stored procedures, triggers, packages, tables, and views

Optimize database performance by analyzing and tuning stored procedures, creating indexes and views, etc., as needed under ITIL guidelines.

Create and maintain enterprise ETL processes using various ETL tools, such as SSIS, .NET Scripting, and T-SQL

Support both SQL Reporting Services and SQL Analysis Services

Provide on-call support 24/7 in rotation with other members of the database administrators for production databases

Educational Requirements

B.A. or B.S. in Computer Science, Information Technology, related discipline, or equivalent experience

6+ years of job-related experience

Any Database Administrator certification

Qualifications:

6+ years of experience in MSSQL Server (version 2019) in a clustered enterprise environment

Experience with MarkLogic strongly desired

Experience with Nginix, Oracle, MySQL, MariaDB, PostgreSQL, and MS Access is a plus

Experience in troubleshooting and performance tuning

Experience with PowerShell knowledge; able to write, read, diagnose, and troubleshoot scripts

Experience working in AWS or Azure is a plus

Excellent communication skills

Strong people and thought leadership; ability to develop, mentor, and coach others