AVP- SQL Server Database Administrator

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

Job Overview

Build a career that matches all your initiative with an impressive dose of innovation. From cutting‑edge resources and a collaborative environment to the freedom to make an impact, you’ll find the ingredients you need at LPL Financial to shape your success while helping clients pursue their financial goals.

The AVP – Database Administrator will be responsible for the installation, configuration, maintenance, monitoring, upgrading, and performance of critical database systems to ensure high availability and consistent performance of our corporate applications. This is a hands‑on position requiring solid technical skills with advanced expertise in SQL Server performance, as well as excellent interpersonal and communication skills for production support of financial applications using MSSQL 2005‑2025.

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

Requirements

• 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

Core Competencies

• Good written and oral communication skills
• Strong technical documentation skills
• Good interpersonal skills
• Ability to conduct research into database issues, standards, and products as required
• Ability to present ideas in user‑friendly language

Preferences

• Excellent knowledge of system views and stored procedures using T‑SQL
• Experience with data partitioning, indexing best practices, resource governor, and extended events
• Experience in installation and configuration of SQL Server in virtualized environments
• Experience with PowerShell
• Experience with SolarWinds Monitoring and DPA (Ignite)
• Experience in financial services
• Knowledge of applicable data privacy practices and laws
• Knowledge of Incident/Problem Management and familiarity with ITIL processes in a critical production environment

Pay Range

$113,712.00 – $189,520.00

Actual base salary varies based on factors such as relevant skill, prior experience, education, internal peer base salary, demonstrated performance, and geographic location. Additionally, LPL Total Rewards package is highly competitive and designed to support your success at work, at home, and at play – including 401(k) matching, health benefits, employee stock options, paid time off, volunteer time off, and more.

Company Overview

LPL Financial Holdings Inc. (Nasdaq: LPLA) is among the fastest growing wealth management firms in the U.S. It supports over 32,000 financial advisors and the wealth management practices of approximately 1,100 financial institutions, servicing and custodying approximately \$2.3 trillion in brokerage and advisory assets on behalf of about 8 million Americans. LPL provides a wide range of advisor affiliation models, investment solutions, fintech tools, and practice management services, ensuring advisors and institutions can choose the business model, services, and technology resources they need to run thriving businesses.

At LPL, independence means advisors and institutional leaders have the freedom to choose the business model, services, and technology resources that allow them to run a thriving business. They can manage client relationships in the way that best serves their clients. Principals only. EOE.