Senior SQL Server DBA | Remote Position | T-SQL & SolarWinds Expert
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.
Nice to Have:
- Experience with cloud database platforms (Azure SQL, AWS RDS).
- Knowledge of PowerShell scripting for database automation.
- Familiarity with SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
- Experience with data warehousing concepts and implementations.
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or similar.
- Experience in financial, healthcare, or enterprise environments.
- Knowledge of NoSQL databases and data lake architectures.
- Experience with DevOps practices and database CI/CD pipelines.
Why Join Our Team:
Work with a forward-thinking organization that values technical excellence and innovation. Enjoy the flexibility of remote work while collaborating with talented professionals. We offer competitive compensation, opportunities for professional development, and the chance to work on challenging projects that will enhance your SQL Server expertise. Join us to make a significant impact on our data infrastructure while advancing your career as a database professional.
The position is available for immediate start, and we look forward to welcoming a skilled SQL Server Database Administrator to our team.