AVP SQL Server DBA - High-Availability & Performance

LPL Financial; Fort Mill (SC); On-site; USD 113,712 - 189,520; Full time

Benefits offered by this job

401(k) matching

Health benefits

Employee stock options

Paid time off

Job summary

LPL Financial is seeking an AVP – Database Administrator to install, configure, monitor, and maintain highly available MSSQL environments (2000‑2025) in support of critical corporate applications. The role requires deep SQL Server performance tuning, security auditing, backup/DR, and change control across environments.

The ideal candidate will lead disaster recovery exercises, optimize procedures, and provide on‑call production support, collaborating with teams to ensure reliable data services

Qualifications

• 7+ years direct experience managing and supporting Microsoft SQL Server (2000‑2025).
• 7+ years experience in database performance, tuning, and optimization.
• Bachelor’s degree in computer science/engineering or 5+ years’ equivalent work experience with SQL Server administration and/or development.
• 7+ years hands‑on experience with database security, auditing, backup/restore, DR, and high availability.
• 7+ years experience with DTS and SSIS packages.

Responsibilities

• Design, install, configure, secure, and maintain highly available enterprise database systems.
• Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios.
• Participate in on‑call after‑hours support rotation, responding to calls after hours, weekends, and holidays.
• Establish and maintain database policies and standards.
• Generate database schema definitions and modifications as required.
• Plan and coordinate data refreshes from one environment to another.
• Monitor database system details, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize, and allocate physical data storage for database systems.
• Develop, implement, and maintain change control and testing processes for database modifications.
• Create or support creation of required reports in response to business user needs.
• Perform database transaction and security audits.
• Follow and maintain in‑house documentation for repeatable processes, including feature installation, disaster recovery, and common problem resolution.
• Establish appropriate end‑user database access control levels.
• Develop routines for end users to facilitate best‑practice database use.
• Apply ITIL practices for Change Management

Skills

SQL Server performance tuning

Enterprise database administration

On‑call production support

Strong communication

Education

Bachelor’s degree in computer science/engineering

Tools

PowerShell

SolarWinds Monitoring

DPA (Ignite)

SSIS

DTS

Job description

LPL Financial is seeking an AVP – Database Administrator to install, configure, monitor, and maintain highly available MSSQL environments (2000‑2025) in support of critical corporate applications. The role requires deep SQL Server performance tuning, security auditing, backup/DR, and change control across environments.

The ideal candidate will lead disaster recovery exercises, optimize procedures, and provide on‑call production support, collaborating with teams to ensure reliable data services