Senior SQL Server Database Administrator

This is a remote position.

Job Title: Senior SQL Server Database Administrator

Experience: 8+ Years

We are looking for a highly skilled Senior SQL Server Database Administrator (DBA) to manage and maintain enterprise-level database systems in a 24x7 environment. The ideal candidate will be responsible for database design, performance tuning, security, and high availability while collaborating closely with cross-functional teams.

Key Responsibilities

• Install, configure, and maintain SQL Server databases across development, staging, and production environments.
  


• Monitor database performance, apply patches, and upgrade SQL Server versions as needed.
  


• Perform performance tuning and optimization (indexing, query tuning, execution plans).
  


• Implement and manage High Availability (HA) and Disaster Recovery (DR) solutions such as:
  




• Always On Availability Groups
  


• Log Shipping
  


• Database Mirroring
  


• Clustering
  




• Ensure database security, integrity, and availability.
  


• Collaborate with developers to optimize database structures and queries for performance and scalability.
  


• Troubleshoot and resolve database-related issues efficiently.
  


• Conduct regular health checks, audits, and capacity planning.
  


• Automate routine database tasks using T-SQL, PowerShell, and scripting tools.
  


• Maintain documentation for database processes, standards, and best practices.
  


• Participate in on-call rotation and provide off-hours support when required.
  

Required Qualifications

• 8+ years of hands-on experience as a SQL Server DBA in production environments.
  


• Strong expertise in SQL Server 2016 and above.
  


• Deep knowledge of:  
  




• Query optimization
  


• Indexing strategies
  


• Performance tuning
  




• Experience with HA/DR solutions (Always On, Log Shipping, Mirroring, Clustering).
  


• Strong experience in backup and recovery strategies.
  


• Advanced proficiency in:
  




• T-SQL
  


• Stored Procedures, Functions, Views, Triggers
  




• Experience with monitoring tools such as:
  




• SQL Server Profiler
  


• Performance Monitor
  


• Third-party monitoring tools
  




• Strong understanding of database security and user access management.
  


• Exposure to cloud platforms like Azure SQL or AWS RDS is a plus.
  


• Excellent communication and stakeholder management skills.
  


• Ability to work independently in a remote setup and manage multiple priorities.
  

Preferred Qualifications

• Microsoft Certification such as Azure Database Administrator Associate or equivalent.
  


• Experience with DevOps tools and CI/CD pipelines for database deployments.
  


• Familiarity with Agile/Scrum methodologies.