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.