This is a remote position.
Job Title: Senior SQL Server Database Administrator
Experience: 8+ Years
Location: Remote
Notice Period: Immediate Joiners Only
Job Summary
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.