Sr. SQL Server DBA

About This Role

Manage, maintain, and optimize MarkLogic and SQL Server databases for a SaaS company in the automotive repair industry. This role ensures data integrity, availability, and security through various database administration tasks and collaborates with development and IT teams.

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

Requirements

• 6+ years of experience in MSSQL Server (version 2019) in a clustered enterprise environment
• Experience in troubleshooting and performance tuning
• Experience with PowerShell knowledge; able to write, read, diagnose, and troubleshoot scripts
• Excellent communication skills
• Strong people and thought leadership; ability to develop, mentor, and coach others

Qualifications

• B.A. or B.S. in Computer Science, Information Technology, related discipline, or equivalent experience
• 6+ years of job-related experience in MSSQL Server (version 2019) in a clustered enterprise environment

Nice to Have

• Experience with MarkLogic
• Experience with Nginx, Oracle, MySQL, MariaDB, PostgreSQL, and MS Access
• Experience working in AWS or Azure

Skills

* Required skills

Certifications