Senior leader in database platform engineering driving enterprise data solutions at LPL Financial. Lead infrastructure transformation and establish data architecture strategy for on - prem and hybrid - cloud.
About the role
- Manage Azure SQL and on-premises database infrastructure. Responsible for performance tuning, security, and supporting business requirements in a hybrid working environment.
Responsibilities
- Manage database infrastructure and development across Azure SQL and on-premises environments
- Balance traditional DBA responsibilities with SQL development work supporting business requirements and operational needs
- Administer and maintain Azure SQL databases and SQL Server instances (Azure VM)
- Monitor database health, performance, and security using SQL Monitor and native Azure tools
- Manage database maintenance jobs including index fragmentation, statistics updates, and backup management
- Design and implement indexing strategies with compression and appropriate fill factors
- Write and optimize T-SQL stored procedures, functions, views, and dynamic SQL
- Perform data migrations, mass updates, and data cleanup projects
- Enforce database standards: naming conventions, surrogate primary keys, audit triggers, schema design
- Manage database security using Entra ID, SQL authentication, MFA, and Azure firewall rules
- Support application developers with query optimization and database design consultation
- Archive historical data from transactional systems to maintain optimal performance
- Troubleshoot production database issues and participate in on-call rotation if needed
- Collaborate with Data Engineering team on ETL impacts from schema changes
- Participate in code reviews and maintain version control using Git and Redgate Source Control
- Assist with data engineering projects as capacity allows
Requirements
- 3+ years of SQL Server administration and T-SQL development experience
- Strong understanding of database performance tuning, indexing, and query optimization
- Experience with Azure SQL Database administration
- Proficiency with backup/recovery strategies and disaster recovery planning
- Knowledge of database security principles and implementation
- Solid T-SQL programming skills including stored procedures, triggers, and dynamic SQL
- Ability to work with business stakeholders to understand data requirements
- Experience with database monitoring and alerting tools
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Principal Database Administrator providing DBA support for Oracle, SQL Server and Snowflake data warehouses. Working closely with business units for onboarding data into the Enterprise Datawarehouse Snowflake DB platform.
Senior Database Administrator managing PostgreSQL and Oracle databases at Marsh McLennan. Leading complex database migrations and optimizing performance in cloud environments.
Database Administrator managing database environments for Northrop Grumman. Collaborating with a team to achieve high availability and security at Ohio's NASIC facility.
Principal Database Administrator for Northrop Grumman managing databases and supporting modernization efforts at NASIC in Ohio. Requires citizenship and technical expertise in various database systems.
Database Administrator handling database systems for the Teachers’ Retirement System of Illinois. Supporting software development life cycle and providing database administration tasks primarily on SQL Server.
Senior Oracle Database Administrator managing and optimizing mission - critical Oracle database environments. Focusing on performance, resilience, and collaboration with teams in disaster recovery operations.
Database Administrator managing Oracle Primavera P6 databases at Westinghouse. Ensuring data integrity and system availability for project management in the energy sector.
Database Administrator supporting high - visibility mission critical customer at MetroStar. Developing applications and managing database systems with a highly qualified technical team.
Database Administrator managing Oracle Primavera P6 databases, focusing on installation, security, and user support for effective project management solutions at Westinghouse.