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