Principal SQL Server Engineer - High Availability & Query Optimization
We are seeking an experienced Senior SQL Server Database Administrator to join our growing technology team. As our SQL Server DBA, you'll be responsible for managing, optimizing, and securing our critical database infrastructure. This remote position offers the opportunity to work with cutting-edge database technologies while maintaining high-performance OLTP and OLAP environments using your advanced T-SQL skills.
Key Responsibilities:
- Design, implement, and maintain SQL Server database systems (SQL Server 2019/2022) with a focus on performance, security, and reliability.
- Manage and optimize both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) database environments.
- Monitor database performance using SolarWinds and other enterprise monitoring tools to identify and resolve bottlenecks.
- Implement and maintain high availability solutions including Always On Availability Groups, database mirroring, and clustering.
- Develop and execute comprehensive disaster recovery plans and regular backup strategies.
- Perform routine database maintenance activities including index optimization, statistics updates, and integrity checks.
- Troubleshoot complex database issues and provide timely resolution to minimize system downtime.
- Design and optimize T-SQL queries and stored procedures for maximum efficiency.
- Collaborate with development teams to implement database changes and improvements.
- Ensure data security compliance and implement appropriate protection measures.
- Document database architecture, configurations, and standard operating procedures.
Required Skills:
- 5+ years of experience as a SQL Server Database Administrator with demonstrated expertise in T-SQL.
- Advanced knowledge of SQL Server (2016 through 2022) administration, configuration, and optimization.
- Proven experience with both OLTP and OLAP database architectures.
- Proficiency with SolarWinds Database Performance Analyzer or similar monitoring tools.
- Experience implementing and managing high availability solutions (Always On, Clustering, Mirroring).
- Strong understanding of database security best practices and compliance requirements.
- Experience with performance tuning, query optimization, and index management.
- Knowledge of backup and recovery strategies and disaster recovery planning.
- Ability to work independently in a remote environment with minimal supervision.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills for collaboration with cross-functional teams.